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,543 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,197 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,085 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,309 reads
Blogs
Quick Tip: Check Most DTU Expensive Queries in Azure SQL Database
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
PowerShell Newbie – Variables
By gbargsley
This is Week 2 of PowerShell Strikes Back – a four-week May series for...
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
Forums
SSRS Is Dead. Here Are Your Real Options
Comments posted to this topic are about the item SSRS Is Dead. Here Are...
The Distance Metric
Comments posted to this topic are about the item The Distance Metric
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
Question of the Day
The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers