Voice of the DBA

way0utwest avatar

  • AI Is Improving Security

    I was updating the SQL Server build lists the other day. I typically get a notification from Microsoft when new builds are released. This is something that happens every month as a new CU appears. For SQL Server 2022, we get a CU every other month since it’s still in mainstream support. Older versions just get these security patches. Since SQL Server 2025 is new, we’re getting a CU a month, which will slow down next year.…


  • Experimenting with CHOOSE: #SQLNewBlogger

    I was looking over the CHOOSE() function while editing an article at SQL Server Central. I realized there isn’t a documentation note on how many parameters can be included. I decided to test. This post looks at the tests and results. Tl;dr It appears 3925 is the most arguments. Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Building a Script Since I want to…


  • A Fun Prize at the PASS Data Community Summit

    I had a briefing for the 2026 PASS Data Community Summit, which is just a couple of weeks away. Amongst a bunch of admin type stuff, there was a slide with a picture of the Redgate Software prize at our booth. It’s a Lego Concorde model. That is very cool. If you’re attending the Summit, swing by and enter for your chance to win. It’s a pricey (to me) set, though I might have to get one…


  • Making an Impression

    It’s a weird time in the job market. Companies are hiring, and I see friends and colleagues starting new positions. At the same time, I have had many more friends reach out, saying they are struggling to find employment, and job searches are dragging on for months. I sympathize, and it certainly seems that lots of people are trying to hold onto their existing positions. Whether you’re looking for a new position or trying to create security…


  • Monday Monitor Tips: Query Recommendations

    We keep adding stuff to Redgate Monitor, and it’s easy to miss some of the improvements. Here’s one that’s been around quite awhile, but while discussing the product with a customer who uses Redgate Monitor, I realized they weren’t aware of this. This is part of a series of posts on Redgate Monitor. Click to see the other posts. The Blue Blob I was looking at a set of queries on the SSC servers with an SE…


Currently Reading

Reshuffle
My current business book recommended by our CEO
The Current Family Book Club book

administration AI Azure Backup/Recovery career career2 car update Cloud Computing coping database design databases Database Weekly DevOps disaster recovery encryption Flyway Friday Poll goals hardware Humor life Microsoft misc PASS powershell Redgate republish sabbatical security software development software development speaking SQL in the City SQLNewBlogger SQL Prompt SQL Saturday sql server syndicated T-SQL T-SQL Tuesday travel vacation windows words work