CHECKDB’s Hidden Snapshot

I am in the middle of some research regarding CHECKDB and learnt something new. From SQL Server 2014 onwards the...

Live 360–SQL in Orlando

I’ll be at the last big SQL Server conference in the US for 2016 this December. VS Live is a...

Reinforcing the Importance of Statistics on Row Estimate

I recently wrote an introductory post about the importance of statistics. I just received a reinforcement on how important they...

SQL Server 2016 - “Number of Rows Read” on Execution plan

One of the coolest things to release with SQL Server 2016 was “Number of Rows Read” information in execution plan....

The PASS Global Alliance Program (GAP)

One of the topics I forgot to mention from the Roundtable was a swell of dissatisfaction with the GAP. Not...

Azure Data Platform Learning Resources

I know that more and more of you are moving more and more resources into the Azure Data Platform. In...

Big Data, Network Security, SQL Programming, PRINCE2, Baby save a little 2 for me

This weeks Learning Tree deals are in. If you want to learn about big data, Network security and with the...

Do you know anything about firebird?

Has anyone in my network or readers my blog have any experience of a database called Firebird?

If you have and...

Drag & Drop Table & Column Names in SSMS

I was working with a developer the other day and he was typing out each table name and all the...

SQL Server: Discuss Execute(SQL) At LinkedServer

Abstract
This article details the use of “Execute AT LinkedServer” clause. It’s best in some ways when you are trying to run...