A tale of updating a legacy system bug
Even simple changes that don't look like they will affect anything often do.
Great Writers Get Hired
Steve thinks one of the ways you can stand out with your resume or CV is by writing well and attracting the attention of hiring managers.
Verify your SQL Server database backups
Introduction A popular joke about DBAs and database backups goes like this. There are two types of DBAs: DBAs that do backups DBAs that will do backups The joke is only stating the obvious – lack of database backups might be the end of a DBA career and/or the supported business. Unfortunately, that joke fails […]
SQL Server Security Best Practices for an Application Installed on SQL Server
In this article we look at the steps you can follow to create a secure and locked down instance of SQL Server to only be used by the intended application on the same machine.
Quick Security Mistakes
Steve reminds you to be careful of taking shortcuts, as these can compromise security. Automation and DevOps might help you avoid mistakes.
Setting up Management Studio for remote SQL Server
Learn how to configure SQL Server and Windows to allow others to connect to an instance remotely.
ASP.NET Core with GitOps: Orchestrating Your Containers with Kubernetes
Kubernetes can be used to deploy, scale, and manage containers. In this article, Mircea Oprea builds on the previous example in the series to show you how deploy your contains in the Elastic Kubernetes Service in AWS.
The Art of Commenting
This week Steve talks about the ways in which comments are important in our code.
SQL Server Unit Testing in Visual Studio
Unit test stored procedures in Visual Studio using an existing database or new SQL scripts
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers