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
482 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,549 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)
29,250 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
726 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,092 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,674 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,116 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,571 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
685 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,311 reads
Blogs
SQL Server instance metadata inventory with PowerShell and SMO
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
5 SQL Tricks Worth Remembering Before You Close the Laptop
Disclosure: this post may contain links to books as an affiliate link. If you...
Claude Context Window
By Arun Sirpal
Every Claude conversation has a context window. It is the total amount of text...
Forums
Celebrating 30 years of PostgreSQL, A Thank you message
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
provisioning sql server via VMware Cloud Foundation
Hello, has anyone here ever provisioned and actually used an MS SQL Server with...
No More Deadlocks
Comments posted to this topic are about the item No More Deadlocks
Question of the Day
No More Deadlocks
After detecting deadlocks in SQL Server 2025 and lowering the time threshold for detecting future issues, when does the Database Engine return to the 5s default interval?
See possible answers