SQL Server 2005 Modernization Checklist
As Bala Narasimhan from PernixData and I discussed in a webinar last week, SQL Server 2005 hit end of it’s...
2016-05-01
549 reads
Technobabble by Klee from @kleegeek
Upcoming Webinars
Next week I am participating in two exciting webinars that I want to share with you!
Improve App Uptime: Tips from MVP...
2016-04-22
528 reads
VMware CPU Co-Stop and SQL Server Performance (continued)
A number of you sent me some excellent questions about this topic, and my favorite asked me for the query...
2016-04-08
725 reads
VMware CPU Co-Stop and SQL Server Performance
Not too many people know about the intricacies of virtualization CPU scheduling and its impact on the performance of the VMs,...
2016-03-09 (first published: 2016-03-03)
1,328 reads
SQL Saturday Chicago Precon – SQL Server Infrastructure – This Friday
This Friday I will be holding a precon training session at the next SQL Saturday in Chicago called ‘SQL Server Infrastructure...
2016-02-29
838 reads
Flash sale – Discount for Chicago SQL Saturday Precon – This Afternoon Only
I’m running a flash sale discount for my upcoming Chicago SQL Saturday Precon called ‘SQL Server Infrastructure Tuning for Availability...
2016-02-18
459 reads
SQL Cruise 2016 Wrap Up
A few weeks ago a number of us embarked on this year’s SQL Cruise, this time to the Caribbean. It was...
2016-02-16
625 reads
VMware vExpert 2016 Announcement
What an amazing week! VMware has announced the full list of VMware vExperts for the first half of the 2016 cycle, and I’m...
2016-02-09
459 reads
Q&A: Multiple SQL Server Instances on a VM
I recently received a great question through email. It was whether or not it is a good idea to have...
2016-01-18
1,040 reads
SQL Saturday Chicago Precon – SQL Server Infrastructure – March 4
I’m pleased to announce that I’m launching a new all-day precon training session at the next SQL Saturday in Chicago...
2016-01-07
382 reads
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
Dealing with huge heap tables
Recently, our dev teams approach me for advice on improving their huge heap table...
Merge Replication failing with Error converting data type nvarchar to numeric
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
Comments posted to this topic are about the item Why Your Index Isn't Being...
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers