We are solidly in the age of the data breach, and companies are justifiably nervous. But not nearly nervous enough. “As with any security issue, a full review of all companies, systems, third-party applications and related IT solutions must be completed before final determinations can be made.”
3 Important Queries for Testing Your Availability Group Endpoints
Time flies, seasons are flying by and seemingly changing day by day. We have slippery slopes here, there, and everywhere. Every now and again Database professionals need a quick moment to get away from the fray. As luck would have it, it is now time for a fabulous party – to get away from all…
SQL Server Security on the Ground
Today we’re going to hit my top 5 – well, top 6 – boots-on-the-ground security tips for SQL server. First, though… I’m pleased as punch to invite you to our next live webinar on April 21: Jen and Sean’s All-Time 5 Favorite SQL Server Security Tactics! Register: www.tinyURL.com/2022-03-LearnSQL
Work requests: It’s broke. Fix it.
Many years ago I was given a work request that literally just said: It’s broke. Fix it. I’m sure you can see how that is supremely unhelpful. And this isn’t the only time I’ve gotten such great requests. I need full access. Please run this script. (I’ve even gotten this one without an attached script.)…
UNDERSTANDING SQL SERVER SECURITY: Secure xp_cmdshell with the Microsoft Master’s guide (in 4 not-so-easy steps)
Quite a lot of data folks are reasonably concerned with the possible security holes that xp_cmdshell could introduce.
SQL is offline for 10 minutes this week. Meanwhile, this article takes 5 minutes to read.
Data folks talk a lot about uptime and “five nines”…a goal which means that 99.999% of the time, the system must be up. The issue is that many companies don’t bother to define what downtime means to them, and what downtime-causing threats are. Register for “Learn SQL Server: Uptime”,
All triggers have to be able to handle multiple row operations.
Quick post today. Recently I was helping a co-worker write a trigger. Basically there is a table of servers that’s maintained as part of the server creation/decommission process. There is a trigger on the table that is part of an automated process that looks at a flag in the table and does some work if…
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 back and ask some very basic questions to try to see where people’s IT-related pain is at. What is your end goal? In my world, I…
The default filegroup, and why you should care.
You know you can have multiple filegroups right? You might have a separate filegroup for the data (the clustered index & heaps) and another for the indexes (non-clustered indexes). Or maybe you want to separate your data tables from the system tables. There are any number of reasons why you might want to have multiple…
Automate SQL Server error log alerting with Minion Enterprise
Minion Enterprise (ME) is our tool for auditing, managing, and alerting on SQL Server instances and servers. With ME, you can automate custom SQL Server error log searches! One of the features is the error log search alert. The Error Log Search module allows you to set up specific error log search terms