The most recent backup problem
When I first began this blog, back at the beginning of my DBA career, it was purely a place for...
2015-02-03
679 reads
Blog Posts
TSQL Tuesday #63 – How do you manage security?
Come on down! You’re the next contestant on T-SQL Tuesday! I’m your host Kenneth Fisher and this month I’d thought...
2015-02-03
931 reads
Blame it on Connect
Some weeks ago I blogged about the discouraging signals coming from Connect and my post started a discussion that didn’t...
2015-02-02
561 reads
How to Rebuild MSDB database?
I suggest to have regular full backup of your system database along with user database. But if you do not have system database & your MSDB got corrupted then...
2015-02-02
15 reads
How to Rebuild MSDB database?
I suggest to have regular full backup of your system database along with user database. But if you do not...
2015-02-02
10,583 reads
Mentor blog
I have been following a few blogs for a number of years now, and one of the most enjoying blog...
2015-02-02
296 reads
Parsing SQL Saturday Data – Getting the Titles
I wrote about downloading the SQL Saturday data with Powershell, and that has worked well. However, I also need to...
2015-02-02
934 reads
PowerPoint Slides Available for Download
I promised that I would post the slide decks for my presentations, and now I have finally followed through on...
2015-02-02
695 reads
SQL #58–Where are my own templates in SQL Server Management Studio 2012
The secrete SQLFile.sql
We are all so used to clicking on the New Query icon (or the keyboard shortcut Ctrl+N). We know it...
2015-02-02 (first published: 2015-01-27)
13,470 reads
Importance of Best Practices in database programming
For any programming language, just writing the code is not well enough. It should be written using the best practices. This article will try to explain the disadvantages of...
2015-02-01
17 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Forums
SQL Server Storage Optimization: Multiple Files in a Filegroup vs Dedicated File
Hello, I would like to get some feedback regarding the best storage optimization strategy...
Azure SQL Database Event Log Limitations
Hi, Do you know if there is a way to get more detailed logging...
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers