SQL Server Security Checklist
In this article I will share the Microsoft SQL Server Security Checklist that I have used for many of my clients to help them achieve PCI compliance. This can...
2023-09-11
275 reads
Blog Posts
T-SQL Tuesday #166: Extended Events
When I was put on the list to host September’s T-SQL Tuesday, well, I forgot to put it in my calendar. So I’m late (and in the doghouse with...
2023-09-11
44 reads
A Multitude of Summary Views in SQL Compare 15
A client asked for a summary of changes, so I wrote a post to show where to find this in SQL Compare 15. As I was checking out the...
2023-09-08 (first published: 2023-08-07)
214 reads
A New Word: Vulture Shock
vulture shock – n. the nagging sense that no matter how many days you spend in a foreign country, you never quite manage to step foot in it –...
2023-09-08
25 reads
Focusing on a Different S Curve
At the beginning of the year, I took a step back and looked at how far my career had grown. In large part because of the incredible data community,...
2023-09-08 (first published: 2023-08-16)
139 reads
I don’t blog anymore, but not because I work at Microsoft
Last year I had a health scare that got my blood pressure at 200-and-something over 100-and-something, soon to be wired up to an IV drip, put through a CT...
2023-09-08
47 reads
Raiders of the Lost ADX – dataminds connect 2023
I’m very excited for this year’s edition of dataminds connect. It’s the first time I’m going to co-present a live session. My fellow explorer is the amazing bearded Johan...
2023-09-08
12 reads
Speaking at the Future Data Driven Summit 2023
I’m going to give a lightning talk at the online (free) Future Data Driven Summit. The subject is How I saved 80% on my Azure Data Factory Costs. The...
2023-09-08 (first published: 2023-09-07)
8 reads
Future Data Driven is Coming Sept 27 for FREE
The Future Data Driven 2023 virtual conference is coming on September 27. Register today and save a note in your calendar. I have been honored to speak at this...
2023-09-07
20 reads
Power BI VertiPaq Engine: Optimizing Column Encoding
Power BI encoding is a powerful optimizing option that is often overlooked because it’s not visible in neither the Power BI Desktop tool nor in Power BI Service. Natively,...
2023-09-07 (first published: 2023-09-06)
684 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