SQL Server 2008 R2 SP3 Install Errors
Whenever it is time to install a service pack every DBA silently hopes that nothing will go wrong. I would...
2015-05-28
2,085 reads
John Morehouse | Sqlrus.com
Why not jump in and help?
If you know me, you know it is in my nature to help. Whether it’s helping a friend move, helping...
2015-05-21
394 reads
Database Growth
Last week I got into a conversation with a colleague about how SQL Server grows the database. We were both fairly...
2015-05-14
1,006 reads
Free Your Mind. Release Your Inner Developer
I have always liked the drawings done by MC Escher. Looking at his drawings has always forced me to look...
2015-05-07
418 reads
SQL Saturday 392 – Atlanta, GA
Have you been to Atlanta, Georgia ? Nope? Well it’s time you plan that trip and come see me speak May...
2015-04-30
962 reads
Quick Script: Finding Database Owners & Security Admins
Security Is Everybody’s Responsibility
Recently, while diagnosing a permissions issue on a Production database, I realized that I didn’t really have...
2015-04-23
354 reads
2015 Program Committee
Last year, I was very much honored to be selected to deliver a pre-con with my friend brother Chris Shaw (B|T). I...
2015-04-16
410 reads
T-SQL Tuesday #65 – Failing Over with PowerShell
This month’s T-SQL Tuesday topic is being hosted by Mike Donnelly (B|T). The topic of choice is a fantastic one,...
2015-04-14
660 reads
Detaching a Database – File Security Gotcha
I’ll admit it, there are times where detaching a database is the best way to get something accomplished, but it...
2015-04-09
667 reads
Procedure Creation – Correct Syntax, Wrong Database
Recently, on a Friday evening, we released an update to one of our core applications. As expected, it went smoothly...
2015-04-02
426 reads
Blogs
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
dataMinds Connect 2025 – Slides & Scripts
You can find all the session materials for the presentation “Indexing for Dummies” that...
Forums
Technological Dinosaurs or Social Dinosaurs?
Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?
DBCC CHECKIDENT
Comments posted to this topic are about the item DBCC CHECKIDENT
Distributed Availability Group Health: T-SQL and Zabbix
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
Question of the Day
DBCC CHECKIDENT
What is returned as a result set when I run this command without a new seed value?
See possible answers