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,020 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
355 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
The fundamental requirements of a reporting system
By ChrisJenkins
There are some fundamental boxes that your reporting system must tick. ✅ The figures...
Seeing the Bigger Picture: How A Monitoring Tool Changed My Approach to Estate Management
By Chris Yates
When it comes to managing complex database environments, having the right monitoring solution is...
Check Power BI report interactions with Semantic Link Labs
It can be tedious to check what visual interactions have been configured in a...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
The Last Good DBCC Run
Comments posted to this topic are about the item The Last Good DBCC Run
count the number of NULLs in a row
Hi everyone I have a SP that finds the average based on 3 tables. ...
Question of the Day
The Last Good DBCC Run
I want to check when DBCC CHECKDB was last run on my Baseball database. What code should I use?
See possible answers