With all the focus on data science I felt it would be a good idea to revisit a little used Query Language called MDX in SSAS ( analysis Services). Why? Because despite the usage of Hadoop and Polybase and all the enhancements in Columnstore indexes there is still a good use case for Analysis… Read More »
Every once in a while I take a moment to think about something other than work. Often these thoughts are governed by the hot topics of the day and while there has been no shortage of such topics; a conversation I was having on LinkedIn recently is the one for this post (It is also… Read More »
Those of us who work with hybrid environments such as public facing data warehouse systems or Hybrid cloud infra will appreciate the ability to manage Certificates used by SQL Server in a more familiar environment. Previously we would import the certificates via certificate manager in the OS and then bind the same to the… Read More »
Every few weeks I am approached by someone on LinkedIn on how to go about starting the business or improving the way they work etc. To be honest I won’t claim to be an expert in this field (by any measure) but the fact that people ask me these question tells me that I must… Read More »
I am a bit confused about this feature so I thought I would post about it to get feedback on its usage in SQL 2016. With SQL 2016 there is a feature called Live Query Stats being introduced. As its name suggests it provides details on the actual tasks being executed in real time. What… Read More »
Had some spare time today so I used it to finally get around to a small project I had in mind. The intention is just to do it and not really to achieve a purpose if that makes sense. The project I had in mind was to write a T-SQL code that would plot the… Read More »
Hurray L1 DBAs you now have an easier way to query active expensive queries. A new tab is added in activity monitor to show DBAs currently active queries. However I would still hope that everybody is familiar with using sys.dm_exec_requests Plenty of new option popping up all over Management Studio get exploring.
So SQL 2016 comes with updatable non clustered columnstore index. Are you wondering why this is a big deal. It is and here’s why In SQL 2012 the Non clustered Columnstore index was introduced but was severely handicapped by the fact that once implemented the table was read only. In SQL 2014 the Clustered Columnstore… Read More »