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

Stored Procedures Are Not Faster Than Views

A performance tuning tip I saw recently said, “Views don’t perform as well as stored procedures.”
<sigh>
Let’s break this down, just...

The ROI of SQLSaturday

Following up on my notes about the 2016 SQLSaturday Roundtable I wanted to write more about the ROI of SQLSaturday....