T-SQL Tuesday #101. CMS – Effortlessly run queries against multiple SQL Servers at once

This month for T-SQL Tuesday #101 Jens Vestergaard asks us to blog about the essential tools in our SQL Toolbelt.
http://t-sql.dk/?p=1947
The...

How to change the TFS Agent _work folder

This blog post is about how to change the default work folder _work that TFS agents use when building a...

Processing SQL Saturday Raffle Tickets with PowerShell

Every year, I spend the Sunday after SQL Saturday Rochester scanning & processing raffle tickets for our wonderful sponsors. Here’s how the system works:
Attendees get tickets (one ticket per...

Why Doesn’t CONTEXT_INFO() Return the Exact Value Set by SET CONTEXT_INFO?

(last updated: 2019-01-05 @ 23:15 EST / 2019-01-06 @ 04:15 UTC )
Let’s say that you execute the following T-SQL:

SET CONTEXT_INFO 1234;
SELECT CONVERT(INT, CONTEXT_INFO());
The...

Code Snippet Cove on the #SQLPrompt Treasure Map

I’ve been away a bit in the last week with personal and family commitments. As a result, I feel a...

GDPR, Database Backups, and the Right to be Forgotten

I’ve said it before, but it bears repeating, there is no cause for any kind of panic when it comes...

Azure SQL Database and Columnstore Indexes

I have come to understand the importance of using columnstore indexes when my queries are aggregating and scanning across many...

# Not the GDPR News -t minus 10 days

# Not the GDPR News -t minus 10 days

There is ten days to go and there are still some seats left for...

What’s in a Name?: Inside the Wacky World of T-SQL Identifiers

(last updated: 2018-04-28)
Today we are going to take a look into an area that you probably are thinking has very...

How to Check SQL Server View Utilization

If you are working on SQL Server optimization delicately, you may get often queries that how to find if any...