Working on the Road

I spend a decent amount of time on the road, traveling to events. Last year I think I spent 50...

Consider removing the NON EMPTY key word from the COLUMNS axis

You might have seen error message like this from a SQL job that pulls data from an OLAP cube using...

Excel Tip #30: Excel Services Visual Limitations – Displaying Images

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...

Memory Fundamentals for SQL Server - Buffer Pool, Mem To Leave

In the Previous blogs we saw about SQL server logical tree and the various memory caches.

http://sqlandmorewithkruti.blogspot.in/2016/02/memory-fundamentals-for-sql-server-sql.html
In this blog we shall...

Monday Morning SQL Break – March 14, 2016

It’s time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on twitter...

Multiserver Queries

Setting up registered servers and practical uses of multiserver queries in SSMS.

Multiserver Queries

You can run queries against multiple servers at once, and it’s quite useful for a number of reasons.  I use...

Pulling data from a non-clustered index

This is one of those things that I found very interesting but figured I’d probably never really use. Of course...

Session Based Wait Statistics in SQL Server 2016

As you probably know I am very fond of SQL Server Wait Statistics (shameless book link) and the options they...

SQL Saturday 486: Richmond, VA Precon

Thursday afternoon I am flying to Richmond, VA to deliver my full day Power BI Beginning to End and attend...