My deadline is fast approaching. It seems these days that editors have no patience. On top of that there is this ever-shrinking deadline problem and the constantly shrinking lead-time to publication issue. Oh wait, it’s […]
Tag: SQL Administration
T-SQL Tuesday #45 Follow the Yellow Brick Road
We have the distinct pleasure once again to have a party full of SQL enthusiasts. The best part is that few if any of us are even in the same room or building for this […]
Lost that Single-User Connection?
You have changed your database to single_user mode to do a task. As you go about your business, you lose track of which connection was the single_user connection. You start closing connections and mistakenly close […]
T-SQL Tuesday #040: File and Filegroup Wisdom
Backstory Each month the SQL community comes together for an important party. This is the blog party that was the brain child of Adam Machanic (Twitter) known as T-SQL Tuesday. The party is a very good […]
Is your LOG backed up?
You have been doing a fantastic job of late. You have all of your databases being backed up on a regular schedule. Now you get an alert that your transaction log just keeps growing. Why […]
Audit Configuration Changes
Do you know the last time a Server Property was changed on your instances of SQL Server? Are you wondering when the setting for max degree of parallelism was changed? Do you know who changed […]
Last Time CheckDB was Run
Back in November 2012, I shared a story about checking the last known good checkdb in the boot page of a database. You can read that story here. This is an important enough topic that […]
A Firm Foundation
Last week I sent out an invite for the monthly TSQL Tuesday party. The theme for the party is a take on the words resolve or resolution. I was hoping the theme would encourage some […]
SSRS Subscriptions Report
As a part of my series leading up to Christmas 2012, I shared a script to Report on SSRS Subscriptions. It was soon found to have a bug with SQL Server 2008 R2 SP2. IN […]
On the Twelfth Day…
Bacon wrapped frog legs (twelve of them) for Christmas. No more drumming for these guys!! What could be better than bacon wrapped frog legs? Oh yeah, more Virtual lab setup. We will delve into setting […]