AD Authentication and Azure SQL Database

Setting up AD authentication with Azure SQL Database sounds simple, it is assuming you plan carefully. I did run into...

Employees, encourage work from home

The discussion around the last article I wrote on work from home (WFH) has been wonderful, but there is one...

General Notes on Security in Azure SQL Data Warehouse

I’m still learning about Azure SQL Data Warehouse (ADW, cause I’m lazy). ADW is a deceptively deep topic. Initially you...

I Finally Get Cross Apply!

For years I’ve looked at various queries online in sample code, diagnostic queries using DMVs, and the like and seen CROSS APPLY in the FROM clauses. But I’ve never...

Introduction To SQL Server Statistics

SQL Server statistics are often thought of as a bit of a black box, this is completely not the case...

Monday Coffee 2017-05-22

I hope everyone had a good weekend. I spent mine watching probably the most dismal performance of rugby I’ve seen...

SQL Azure Databases - Active Secondary - How to configure? - Part 1

Dear all,

I have taken the azure dive at last 🙂
In case if you are new to azure, azure is the Microsoft...

SSRS Custom Shared Schedule

Reporting Services is a pretty feature rich tool for delivering reports to various consumers. Unfortunately, the scheduling capability within SSRS is fairly weak.
Related Posts:

CRM Data Source Connection Error January...

Tracking Lookup Operations in SQL Server

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...

What’s in a partition?

In my last post on partitioning I used the $Partition command in passing. I’ve been thinking it deserves a bit...