Creating a Database Audit Specification can create new users & schemas in the background
I love database audits. They are simple, easy to use, effective, not overly resource intensive, and can be turned on ... Continue reading
2022-06-28
34 reads
Blog Posts
Daily Coping 28 Jun 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-06-28
14 reads
Tools I Use on My Jump Box
Having recently taken a new job and introducing a number of new tools to my new coworker I thought I’d share how I setup my jump box to and...
2022-06-28
27 reads
Alert Filtering in SQL Monitor
SQL Monitor has improved a lot over the last couple of years. We have multiple teams building features and addressing issues, and each month when we have a readout...
2022-06-27
44 reads
Daily Coping 27 Jun 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-06-27
18 reads
dbatools - Exceptions
Who doesn’t like a good red and verbose exception? At PowerShell community we often call it a “sea of red” which we found as something that can be intimidating....
2022-06-27 (first published: 2022-06-07)
364 reads
How To Create A SQL Server 2022 Learning Sandbox In Few Easy Steps
Microsoft has recently released the public preview of SQL Server 2022. You can find info here. Microsoft peddles SQL Server 2022 as “the most cloud enabled version Microsoft has...
2022-06-27 (first published: 2022-06-08)
928 reads
A Few Thoughts on SQL Saturday Jacksonville
I was lucky to attend SQSQL Saturday Jacksonville 2022L Saturday Jacksonville 2022 a couple of weeks ago. This was the first SQL Saturday of 2022 for me, and the...
2022-06-24 (first published: 2022-05-25)
175 reads
Daily Coping 24 Jun 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-06-24
18 reads
TSQL Tuesday #150: Your first technical job. Rollup.
This months subject for T-SQL Tuesday was Your first technical job. I have to say I really really enjoyed reading ... Continue reading
2022-06-24 (first published: 2022-05-24)
251 reads
Blogs
Voice of the DBA | Writings from Steve Jones, the Voice of the DBA
By Steve Jones
Houston AI-Lytics 2026–Powerpoint Slides Thanks to everyone for attending my session on running a...
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Forums
Warning: Could not open global shared memory to communicate with performance DLL
Hi everyone I am getting below warning when I run SSIS: Warning: 0x80049304 at...
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers