Linked Server Security

Problem

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

Special Index - XML Index

I will be writing this series of articles for the Special Indexes in SQL Server. In this series we will...

What does an Index mean to a Query

This post is about the importance of a right index to a query. The following simple query was considered. [crayon-5e81b52eda1f0195410103/] Even simple, this query was causing troubles on our production...

What does an Index mean to a Query

This post is about the importance of a right index to a query. The following simple query was considered.<?query --SELECT    [GroupBy1].[A1]...

What does an Index mean to a Query

This post is about the importance of a right index to a query. The following simple query was considered. [crayon-5e96566159ca8644006533/] Even simple, this query was causing troubles on our production...

What does an Index mean to a Query

This post is about the importance of a right index to a query. The following simple query was considered.

SELECT
[GroupBy1].[A1] AS...

Why we need a PASS Sponsor Portal

Major sponsors in our space get hundreds of emails from us each year, all asking for money. Those are all...

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

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