Author Archives: opsadmin

Writing MDX the T-SQL way

By | September 15, 2019

  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 »

Make the List and Stick to it

By | July 26, 2019

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 »

SQL 2016- Live Query Stats

By | July 16, 2015

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 »

SQL 2016- Activity monitor – Active Expensive Queries

By | July 13, 2015

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.

SQL 2016 – Updatable Columnstore Index finally OLTP and DW workloads delivered

By | July 13, 2015

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 »