Tag Archives: administration

Your Security Checkup

Posted on December 8, 2025 by way0utwest

Recently I saw an article on Simple Talk, 15 Practical Tips for Securing SQL Server, and I thought that many of these are fairly simple things. Turn off unused features, disable sa, etc. These are things that a lot of … Continue reading →

Posted in Editorial | Tagged , | Leave a comment

Creating a Striped Backup Set with AI

Posted on October 22, 2025 by way0utwest

I needed to test a striped backup, so I decided to ask the AI’s for help. This is part of a series of experiments with AI systems. The Problem A customer wanted to know if we could handle a large … Continue reading →

Posted in Blog | Tagged , , , , | 2 Comments

Sparse Columns Can Use More Space: #SQLNewBlogger

Posted on September 10, 2025 by way0utwest

I saw this as a question submitted at SQL Server Central, and wasn’t sure it was correct, but when I checked, I was surprised. If you choose to designate columns as sparse, but you have a lot of data, you … Continue reading →

Posted in Blog | Tagged , | 3 Comments

Guidelines and Requirements

Posted on September 5, 2025 by way0utwest

I saw a post from Brent that Microsoft had changed the default memory guidance. At first glance I read this as they’d changed the default values, which would be interesting. However, this is a guideline, set to 75%. I also … Continue reading →

Posted in Editorial | Tagged | Comments Off on Guidelines and Requirements