SQL Server Window Functions in Action

SQL Server Window Functions were introduced in SQL Server 2005 with a basic set of operators and massively upgraded in...

A Busy Few Years

Last week on Twitter, a friend mentioned they were submitting to the PASS Summit and went through their previous speaking...

Technology Gender Gap By State

This is my first ever guest blog post. Take it away Hazel Garcia.
Though the gender gap narrows by the year,...

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

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

SSRS Custom Shared Schedule

Reporting Services
 

Reporting Services is a pretty feature rich tool for delivering reports to various consumers. There is plenty of power...

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

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

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

Fischer’s Exact Test – with T-SQL and R

This post is a long overdue second part to the post on Chi Square Test that I did a few months...