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

SSRS 2016 – Part 3 Mobile Reports

This is the final post of 3 on SSRS 2016. This time I’m looking at the new SSRS 2016 mobile reports.
Post 1 covered...

A first look at SQL Server 2016–String_split

I’ve been developing T-SQL for about 20 years now and almost since day one there has been functionality that , IMO,...