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

How to deploy your SQL Server database to a remote server

CASE 1: you have direct access to both the SQL Server where the source database is and the SQL Server where the target database is.

First time deployment

Backup / restore...

How to deploy your SQL Server database to a remote server

CASE 1: you have direct access to both the SQL Server where the source database is and the SQL Server...

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

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

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. [crayon-5e81b52eda1f0195410103/] Even simple, this query was causing troubles on our production...

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