Professional Microsoft SQL Server 2014 Administration
Hello Dear Reader! Last September I was approached with a tremendous opportunity to become the Managing Author for the Professional...
2014-09-12
2,060 reads
SQLBalls
24 Hours of PASS Preview: Zero to Hero (I'm the Zero)
Hello Dear Reader! We are already away into the 24 Hours of PASS Summit Preview for 2014! I don't know...
2014-09-09
809 reads
Why You Should Go to SQL Saturday
SQL Sat Puerto RicoHello Dear Reader! Soon SQL Saturday #318 in Orlando FL will be here. The SQL Community does...
2014-09-04
872 reads
Deck & Demo's Live & Thank You AZSSUG & OPASS!
Hello Dear Reader! Just a quick post to say Thank You to the Arizona SQL Server User Group and to...
2014-06-27
689 reads
It's not Business, It's Personal
Hello Dear Reader. I find myself at this late hour unable to sleep. Yesterday the slate of speakers for the...
2014-06-26
850 reads
Introducing What_To_Compress V2
Hello Dear Reader! I'm about 32,000 feet in the air leaving St. Louis after a great Performance Tuning Workshop for...
2014-05-29 (first published: 2014-05-22)
2,401 reads
Decks & Demos Live
Hello Dear Reader! Just a quick update. I've been traveling a lot and I'm behind in posting some Decks & Demos....
2014-04-30
1,373 reads
Up Coming Speaking Events
Hello Dear Reader! We are 2 months into 2014 and the New Year is off to a busy start. This...
2014-02-21
733 reads
Windows 2012 for the SQL DBA: .NET 3.5 Fails to Install
Hello Dear Reader! I know it has been a while since last we spoke. Sorry for the long absence. I've...
2014-02-19
841 reads
Tales from the Query Processor: II
Hello Dear Reader! Today is Halloween, October 31st. My Daughter turns a big 15 today! Happy Birthday Ches!!!!!
To celebrate two...
2013-10-31
1,383 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