PowerShell 101 for the DBA: Querying Your Servers with PowerShell
In my last blog post, I discussed how to get PowerShell and SQLPS up and running on your machine(s). And...
Windows Internal Database
This past Friday I received a call from our systems team stating that they were running low on Disk Space...
Part 2: Why you should be using the Full Recovery Model
Part 2 of the SQL Server Essentials Series looks at why you should be using the Full Recovery Model to protect your data assets.
There's No Such Species as a DBA
Phil ponders whether the term 'DBA' is still really meaningful, or if it's just a blunt instrument used to bash a diverse population into a mis-conceived niche. Is it worth the trouble of being typecast, just to have those 3 letters on your CV?
Best Practice - Increasing the Number of SQL Server Error Logs
By default, there are six achieved SQL Server Error Logs along with the ERRORLOG which is currently used. However, it is a Best Practice to increase the number of SQL Server Error Logs from the default value of six. In this tip, you will see the steps which you need to follow to increase the number of SQL Server Error Logs.
Best Practice - Increasing the Number of SQL Server Error Logs
By default, there are six achieved SQL Server Error Logs along with the ERRORLOG which is currently used. However, it is a Best Practice to increase the number of SQL Server Error Logs from the default value of six. In this tip, you will see the steps which you need to follow to increase the number of SQL Server Error Logs.
Getting Into the Biz, Part 3
In a couple of previous posts (Part One and Part Two), I shared some thoughts about starting a career path...
Lockdown or Let Them Free
Do we take security too far? Are we creating unnecessary rules for those that need to use the resources we support? Steve Jones talks today about security and how we might want to approach it when handling rights for developers.
Lockdown or Let Them Free
Do we take security too far? Are we creating unnecessary rules for those that need to use the resources we support? Steve Jones talks today about security and how we might want to approach it when handling rights for developers.
Lockdown or Let Them Free
Do we take security too far? Are we creating unnecessary rules for those that need to use the resources we support? Steve Jones talks today about security and how we might want to approach it when handling rights for developers.
Blogs
Monday Monitor Tips: Intelligent Alert Thresholds
By Steve Jones
At the recent Redgate Summit in Chicago, I demo’d (lightly) the ML based Alert...
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
Forums
String_agg not working as needed
I'm trying to get this string_agg to put all the 'comments' into one result...
Vectors in SQL Server 2025
Comments posted to this topic are about the item Vectors in SQL Server 2025
Odd Sequences
Comments posted to this topic are about the item Odd Sequences
Question of the Day
Odd Sequences
What values are returned from this code?
CREATE SEQUENCE NumericSequence
AS NUMERIC(5,1)
START WITH 1.0
INCREMENT BY 0.1;
GO
SELECT NEXT VALUE FOR NumericSequence
GO
SELECT NEXT VALUE FOR NumericSequence
GO See possible answers