Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Day 4 of 31 Days of Disaster Recovery: Back That Thang Up

Day 4 of 31 Days of Disaster Recovery: Back That Thang Up

31 Days of Disaster Recovery

Here we are at day 4 in my series focusing on disaster recovery. It’s Friday, so this will be a quick one for today. I want to talk about the importance backing up… Read more

Day 3 of 31 Days of Disaster Recovery: Determining Files to Restore Database

Day 3 of 31 Days of Disaster Recovery: Determining Files to Restore Database

31 Days of Disaster Recovery

Welcome back for day 3 of my month-long series on Disaster Recovery. For today’s post, I want to address something that, in my experience, has really flummoxed a lot of people who… Read more

Day 2 of 31 Days of Disaster Recovery: Protection From Restoring a Backup of a Contained Database

Day 2 of 31 Days of Disaster Recovery: Protection From Restoring a Backup of a Contained Database

31 Days of Disaster Recovery

Welcome to day 2 of my month-long series on Disaster Recovery. For today’s post, I want to talk a little bit about restoring backups of contained databases. In… Read more

SQLBits XI: Need Your Vote

SQLBits XI: Need Your Vote

SQL Bits XI

SQLBits XI is in Nottingham, U.K., May 2 – 4, 2013, and I am attending. Hopefully, I will be presenting a regular session as well. To do that, I need your vote. The sessions are now open for public voting. Please go… Read more

Day 1 of 31 Days of Disaster Recovery: Does DBCC Automatically Use Existing Snapshot?

Day 1 of 31 Days of Disaster Recovery: Does DBCC Automatically Use Existing Snapshot?

31 Days of Disaster Recovery

Welcome to my series on Disaster Recovery. I will spend the entire month of January focusing on all things related to disaster recovery including topics like corruption, data integrity, data loss,… Read more

Tempdb Contention That Can’t be Soothed

Tempdb Contention That Can’t be Soothed By Adding Files

Tempdb Contention via Idera diagnostic manager

I’ve talked a lot in the past about tempdb contention and how to monitor for and identify it in blog posts, a whitepaper, webcasts, and live presentations. Okay, so I tend to… Read more

Cross-database Queries by Contained Users

Cross-database Queries by Contained Users

http://www.necromaticmedia.com/2007/11/containment/


I presented to the Pacific Northwest SQL Server User Group / PASS Chapter (PNWSQL) last night on the subject of contained databases. The slide deck and demo code from my presentation, Implementing Contained Databases, can be downloaded below or will be uploaded to the… Read more

Recent Presentation Session Files

Recent Presentation Session Files

Session Files – A Little Behind


I’ve been a little tardy about getting my session files posted, and I’m a little behind. So I’m going to try to catch up in one blog post. So here are my session files for SQL PASS Summit 2012, various… Read more

T-SQL Tuesday #36 – SQL Community

T-SQL Tuesday #36 – SQL Community

T-SQL Tuesday #36 - SQL Community


This blog entry is participating in T-SQL Tuesday #36, hosted this month by Chris Yates(Blog|@YatesSQL). You are invited to visit his blog to join the blog party. You are welcome to write your… Read more

Don’t Be That PASS Summit Guy

Don’t Be That PASS Summit Guy

PASS Summit 2012 Speaker

The SQL PASS Summit 2012 is just around the corner. Every year there are lots of first-timers attending. So many that PASS started a first-timers program linking new attendees with veterans who can mentor them in the PASS Summit experience.… Read more

Man Vs Machine

Man Vs Machine

Man Vs Machine


Are you a fan of the television show Man Vs Food starring foodie Adam Richman? In this show, host and title subject “Man” Adam Richman travels the United States taking on food challenges where he finds them. Sometimes these challenges entail eating more… Read more

Why Attending a Monday Pre-con Will Be Awesome

Why Attending a Monday Pre-con Will Be Awesome

PASS Summit 2012 Speaker


The SQL PASS Summit 2012 is coming up in a few months. It’s time to make your plans to attend. One of the things that many of you may be considering is attending a pre-con. There are two… Read more

Performing Fast Searches of Query Plans

Performing Fast Searches of Query Plans

XML: Fast as a Turtle


I've made blog posts in the past on using the exist() method to search for query plans with specific attributes (e.g., Find Cached Query Plans By Index Name). Another good aspect of the exist() method is that it… Read more

Is SELECT Identity() … INTO Minimally Logged in Simple Recovery?

Is SELECT Identity() … INTO Minimally Logged in Simple Recovery?

Extreme Logging


I was having a discussion with Idera (@idera_software) dev lead Vicky Harp (blog|@vickyharp) about minimizing log impact when performing schema changes on really large tables. One option discussed was using SELECT INTO Read more

Troubleshooting Database Mirroring Error 1418 Updated

Troubleshooting Database Mirroring Error 1418 Updated

Last night I was helping someone with a database mirroring setup problem via email. It has been a long time since I came across a new cause for the infamous 1418 error for database mirroring. This time the error was accompanied by an error… Read more

5 Second Rule Doesn’t Apply to Dropped Databases or Does It?

5 Second Rule Doesn’t Apply to Dropped Databases or Does It?

5 Second Rule Doesn't Apply to Dropped Databases or Does It?


Imagine you get a frantic call from someone, we’ll call him George, who just dropped a busy production database, and if he can’t get it back up ASAP,… Read more

T-SQL Tuesday #31 – Bulk-Logged Recovery Model and Point-in-time Restore

T-SQL Tuesday #31 – Bulk-Logged Recovery Model and Point-in-time Restore


This blog entry is participating in T-SQL Tuesday #31, hosted this month by Aaron Nelson (Blog|@SQLVariant). You are invited to visit his blog to join the blog party. You are welcome to write your own… Read more

SQL Rally 2012 Recap and Session Files

SQL Rally 2012 Recap and Session Files

Dallas Convention Center


SQL Rally 2012 was hosted by the North Texas SQL Server User Group. More tha anything, it was nice to be back in the area where I grew up. I was born in Houston, but I grew up in… Read more

Session Files from SQL Saturday #107 Houston

Session Files from SQL Saturday #107 Houston

Houston Skyline


SQL Saturday Houston was a great event hosted by the Houston Area SQL Server Users Group. The event did not have a very large attendence, but those who traded in a beautiful Saturday for some free training were very engaged… Read more

SQL Saturday #107 in Houston, TX

SQL Saturday #107 in Houston, TX

Houston Skyline


SQL Saturday #107 in Houston, TX is almost here. I will be leaving for Houston on Friday, April 13, and I’ll be spending the entire week preceeding SQL Saturday #107 in Houston visiting the headquarters of my new employer, Idera. One… Read more

Newer posts

Older posts