Renewed as Microsoft MVP for 2020-2021
I have been fortunate enough to be renewed as a Microsoft Data Platform MVP for the calendar year July 2020 to June 2021. I’m honored, humbled, and thrilled that...
2020-07-17
39 reads
Technobabble by Klee from @kleegeek
VM firmware matters for Windows Secure Boot
The Register is reporting that future versions of Windows Server OS is going to require the TPM 2.0 chip and Secure boot enabled by default. Secure boot is quite...
2020-07-02 (first published: 2020-06-23)
200 reads
Podcast recording with Dallas DBAs
I’m thrilled to have recently recorded a podcast with Kevin3NF of Dallas DBAs called Data Bits. I had an absolute blast with it, and we laughed for over an...
2020-06-18
9 reads
Packet Pushers Podcast released
I am thrilled to have recently recorded a podcast with our friends over at PacketPushers. The podcast, “How an IT Specialist Chooses Adjacent Competencies“, talks about how adjacencies in...
2020-05-26
11 reads
What are you tuning for?
People want to make things faster. It’s in our nature as IT professionals. What are you tuning for? I’ve been asking that a lot later. I have to sit...
2020-06-04 (first published: 2020-05-22)
334 reads
PASS Summit 2020 Precon Announcement
I am thrilled to announce that I have been accepted to deliver a preconference boot camp called ‘Amplify Your Virtual SQL Server Performance‘ at this year’s PASS Summit conference,...
2020-05-18
21 reads
Clumio’s Rapid Recovery is amazing for SQL Server
Clumio’s Rapid Recovery is amazing, and you should know more about it. You might not have heard of Clumio before. Clumio is an upstart SaaS-based backup solution for both...
2020-05-15 (first published: 2020-04-30)
374 reads
Upcoming Webinar – SQL Server Business Continuity – May 21
I’m proud to announce a new webinar that I’ll be presenting at 1pm Eastern on Thursday, May 21st, in conjunction with MSSQLTips and SIOS called “SQL Server Business Continuity...
2020-05-12 (first published: 2020-04-29)
126 reads
Presenting at Global Azure Virtual Day 2020 Omaha
I’m thrilled to be presenting along side of some industry greats at the upcoming Global Azure Virtual Day on April 25th as part of the Omaha users group. The...
2020-04-16
10 reads
SQL Server and CPU Hyper-Threading in Virtual Environments
I recommend leaving the hyper-threaded logical cores enabled in the host BIOS, but not depending on them for performance gains. Hyperthreaded CPU cores, or logical cores, should not be...
2020-04-21 (first published: 2020-04-10)
1,586 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