Azure SQL Server 2016 VM

With Windows Server 2016 just been released, now is the perfect time to build an Azure VM with SQL Server...

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

Is it safe to grant Administer Bulk Operations?

First I guess we had best start with definitions right? The permission Administer Bulk Operations and the role bulkadmin are...

Query tuning 101: Problems with IN ()

If you’re a DBA or database developer, chances are you will have to write or rewrite queries from time to...

CHECKDB’s Hidden Snapshot

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

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

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

This Week In Data – Episode 12 (How to Interview a Customer)

Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...

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

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