T-SQL Tuesday #125 – Unit testing databases – we need to do this!!
Welcome to the first April edition of T-SQL Tuesday. I’m honoured to be hosting it and have picked a topic that is near and dear to me. If you...
2020-04-07
54 reads
Blog Posts
COVID-19 - Work & Life Changes, How We're Coping
Settle in folks, this is a long, rambling post.
As this goes live, it’s been about three weeks since my abrupt switch from driving to the office every day to...
2020-04-06
8 reads
Daily Coping 6 Apr 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-04-06
15 reads
Error handling protip: @@Error resets after the next command
The system variable @@ERROR is a quick and easy way to retrieve the error number from the last statement run ... Continue reading
2020-04-06 (first published: 2020-03-30)
381 reads
Getting Your dbatools Version–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I was trying to test something recently and...
2020-04-06
166 reads
SQL Server and VMware Resource Pools
Resource pools are used to hierarchically partition available CPU and memory resources, and are available for use at the VMware host cluster layer. To better prioritize certain VMs over...
2020-04-06
71 reads
T-SQL Tuesday Live–7 Apr 2020
Last week went a little crazy, and I learned something: don’t post a Zoom link on Twitter. My apologies to anyone that wanted to join and had things go...
2020-04-06
12 reads
Understanding Disk Performance and IOPS in cloud platform
In the past many years, apart from working as DBA, I was working with multiple cloud technologies and actively involved in the migration process to cloud infrastructure. In between,...
2020-04-06 (first published: 2020-03-29)
2,900 reads
What Prevents You From Securing Your Servers?
Reading about how hackers are using SQL Server instances that are exposed on the internet AND have weak passwords to work into systems, I’m sitting here wondering why. I...
2020-04-06
75 reads
Disks performance in Azure
In our earliest post, we have discussed in detail about the factors that affect the disk performance and different types of disk offerings in the AWS platform. In this...
2020-04-05
13 reads
Blogs
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
Forums
How Do the Experts Become Experts?
Comments posted to this topic are about the item How Do the Experts Become...
Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Secure Communications
Comments posted to this topic are about the item Secure Communications
Question of the Day
Secure Communications
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers