Friday Reading 2016-11-11

It’s Friday so no releases to Production today (ha!) which means in-between my code reviews, server audits and other tasks...

Linked Server Security

Problem

When creating Linked Servers, security often gets overlooked.  This can lead to accounts on one instance having access, sometimes with...

SQL Server 2016–Live Query Statistics

WOW!!! The next great update to Execution Plans is a way to watch the processing of rows through iterators while...

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