Microsoft Azure Government

I’m sure you are aware of Microsoft Azure, but are you aware there is special version of Azure for U.S....

Query Active Directory from SQL Server

Have you ever had the need to query Active Directory right out of SQL Server using native TSQL?  There are...

Update Your Scripts!

I had an incident today where a colleague was running a Wait Stats Report and the output looked like this:

As...

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...