Speaking at SQL Saturday #445 - Raleigh, NC - October 10
I will be speaking this weekend at SQL Saturday #445 - Raleigh, NC. If you are in the area, please come...
2015-10-07
481 reads
Everyday SQL
PSSDiag Configuration Manager – A Companion for SQLNexus
Have you ever called Microsoft Customer Support for help with a SQL Server performance issue? The engineer will typically send...
2015-07-21
1,542 reads
Use Trace Flag 902 to Recover from a Cumulative Update Failure
Recently, I ran into a critical error while I was helping a customer troubleshoot an issue in SQL Server. That...
2015-07-14 (first published: 2015-07-07)
28,857 reads
Exams 70-457 & 70-458 - Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012
This past week I finally completed the 70-458 exam to upgrade my certification to MSCA: SQL Server 2012. I never...
2015-06-24
725 reads
Use PsPing When Working in Azure IaaS
Recently I’ve been learning more about how Azure functions and how it can help my customers. One of the best...
2015-04-28
1,042 reads
SQL Nexus Might Just Save Your Bacon
The year is 2015, and I’m still surprised by how many people have never heard of SQL Nexus; although it...
2015-03-10
1,667 reads
SQL Cruise Caribbean 2015 Recap
UPDATED: Don't just take my word. Read the feedback from others.
SQL Cruise Caribbean 2015: More Than A Cruise With Classes....
2015-02-24
1,114 reads
Get Out There and Challenge Yourself
It’s been almost five months since I posted my last article, and so much has changed since then. I have...
2015-02-11 (first published: 2015-02-03)
6,569 reads
PowerPoint Slides Available for Download
I promised that I would post the slide decks for my presentations, and now I have finally followed through on...
2015-02-02
683 reads
Monitor the Number of Deleted Rows in a Clustered Columnstore Index
In some of my previous posts, I have talked about how to create Columnstore indexes. Now I’d like to discuss...
2014-08-21
2,290 reads
Blogs
Advice I Like: Art
By Steve Jones
Superheroes and saints never make art. Only imperfect beings can make art because art...
Why Optimize CPU for RDS SQL Server is a game changer
One feature that I have been waiting for years! The new announcement around optimize...
Performance tuning KubeVirt for SQL Server
Following on from my last post about Getting Started With KubeVirt & SQL Server,...
Forums
Think LSNs Are Unique? Think Again - Preventing Data Loss in CDC ETL
Comments posted to this topic are about the item Think LSNs Are Unique? Think...
The AI Bubble and the Weak Foundation Beam
Comments posted to this topic are about the item The AI Bubble and the...
Question of the Day
A Big PK
In SQL Server 2025, how many columns can be included in a Primary Key constraint?
See possible answers