Parallel Data Warehouse (PDW) Lesson 1: – Basic Architecture Overview
I’ll begin my coverage of Microsoft’s Parallel Data Warehouse (PDW) architecture / appliance with a brief overview of the Massively Parallel...
2012-07-09
1,118 reads
Writing About SQL Server
I. Introduction I recently submitted my entry for a writing competition as part of my continuing education. While I was...
2012-07-09
1,436 reads
Speaking at SQL Saturday 122 - Louisville
It has been a great couple of months for both me and for Perpetual Technologies (my employer). PTI has been...
2012-07-09
886 reads
Lost in Translation – Deprecated System Tables – sysdatabases
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-07-09
1,337 reads
SQL Server 2012 Diagnostic Information Queries (July 2012)
Here is the latest version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements to...
2012-07-08
1,070 reads
Baton Rouge SQLSaturday #150 & Tech Day–DBA 1 track
August 4th of this year will be the forth annual Baton Rouge SQL Saturday and Tech Day. Patrick LeBlanc got...
2012-07-08
1,480 reads
Securing Database Contents with Transparent Data Encryption (TDE)
Introduction
Microsoft SQL Server has many security features available within the database, but until release of SQL Server 2008 there has...
2012-07-08
7,787 reads
A Pattern for PIVOT
Use of the PIVOT operator in T-SQL has always been tantalizing yet confounding to me. It offers the promise of...
2012-07-08
2,064 reads
Identifying Long Running SQL Agent Jobs Script
I’m usually pretty hesitant to share scripts I write because inevitably it will get torn to pieces, but in this...
2012-07-08
4,081 reads
Lost in Translation – Deprecated System Tables – syscurconfigs
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-07-07
1,186 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Trigger isn't working
Hi, I have a trigger, that works fine elsewhere but is not working at...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers