Query the status of SQL Agent jobs

I’ve been involved in building a solution on top of SQL Server peer to peer replication (SQL 2014 SP1) and...

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

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

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

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

Leadership Lessons

Not for you, for me.
I’m sure you’ve heard the statement: Praise in public. Criticize in private.
I agree with this approach....

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

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

ETL Logging

If you were to poll data professionals on which tasks they enjoy working on the most, ETL logging would probably...

Multiserver Queries

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