Creating New Database — Standard Settings
Recently I have been able to work with our development teams to not create new databases. There are several reasons for me making this request of the teams. The...
2020-07-21
14 reads
sp_Blitz for All Servers
Are you a Microsoft SQL Server DBA managing one or more servers? Then you should know about the First Responder Kit from Brent Ozar Unlimited. This is a free...
2020-07-14
340 reads
BBQ Time in Texas
My first go at smokin’ a brisket is documented below. It is summertime and we are stuck at home in isolation, might as well find a new hobby. I...
2020-07-09
6 reads
2019 PASS Summit Recap from a First Timer
Heading to PASS Summit… It is Sunday the week of PASS Summit and I am at the airport after a relaxing morning with my wife and son. Unfortunately, I...
2019-12-06
10 reads
NTSSUG Board Elections
It is that time of year again. The NTSSUG has two spots coming open on the board. Last year I decided at the last minute to opt in as...
2019-11-21
6 reads
OLDEST_PAGE Log Reuse Wait type
Do you frequently use the “log_reuse_wait_type_desc” column in the [crayon-5f297eff3d7ff981952735-i/] view? Have you ever seen the type of OLDEST_PAGE? You are not the only one!! Recently I was troubleshooting...
2019-09-24
1,449 reads
NO RDPing!!! dbatools to the Rescue
So you hear this spread across the Twitterverse and Blogosphere. You should not RDP your SQL Servers to do administrative work. My nature has always been to troubleshoot issues...
2019-09-12
13 reads
Installing Microsoft MDS on SQL Server Standard Edition
HaHa, tricked you. You can’t install SQL MDS on Standard Edition. You must first upgrade to SQL Enterprise Edition before you can proceed with an MDS installation. Upgrading SQL...
2019-08-15
104 reads
Blogs
Houston AI-Lytics 2026–Powerpoint Slides
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
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...
GenAI vs Dashboards: Not the Same (And Never Will Be)
By James Serra
There’s a question I’ve been hearing more and more lately, especially as Copilot, Fabric,...
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