In last week's post, I talked about the steps required to backup a Azure SQL Database. That post leaves us asking what's the use of having a backup of a database, if you aren't going to restore it somewhere. And more importantly, if you can't restore a database, or don't know how, then the backup … Continue reading Restoring Azure SQL Database to a Local Server
When I first started working with Azure SQL Databases, I wasn't sure what it would take to backup a database. In fact, I wasn't even sure if this concept was appropriate when it came to databases hosted in "the cloud". What I found was that the concept of backing up databases in the Azure cloud … Continue reading Backing Up Azure SQL Database to the Cloud
Each release of SQL Server is chalk full of new features and an assorted amount of bells and whistles. Some of these, like Availability Groups and ColumnStore, are great additions and their introduction includes much fanfare. Among all of those new features, is the occasional little bell which offers us a chance to change how we investigate SQL … Continue reading A Replacement for DBCC IND in SQL Server 2012
After lunch, I led the session "What Are You Waiting For?" at SQL Saturday Chicago #211. It was another well-received session and the attendees definitely learned a lot about the value in wait stat analysis. The only downside, was my snap decision to add an extended event demo to show the connection between looking at wait stats … Continue reading Presentation Materials “What Are You Waiting For?” #SQLSat211
Just got done with my morning session, titled "Discovering the Plan Cache", for SQL Saturday Chicago #211 and wanted to get out my session deck and scripts for people. The session got pretty high marks from the attendees and people seemed to get a lot of good information and humor out of it. Probably the best … Continue reading Presentation Materials “Discovering the Plan Cache” #SQLSat211
A tweet from Ted Krueger (Blog | @Onpnt) this morning... inspired a little creativity...
In a previous post, I discussed running SQLIO against multiple files. The purpose in using multiple files is being able to test not just a single volume's capability to deliver data from storage, but to test the storage as a whole. Doing so is important since, what ever application, in my case SQL Server, is running … Continue reading Staggering SQLIO Sessions Across Multiple Volumes
This month, Bob Pusateri (Blog | @SQLBob) is running T-SQL Tuesday on presenting. T-SQL Tuesday is a monthly blogging event where a number of us in the SQL Server community gets together to blog on a central topic. The topic that was chosen for this month is presenting, or more specifically: "How did you come to love … Continue reading T-SQL Tuesday – Love For Presenting – #TSQL2sDay
This past weekend, I took a quick trek into the land of beer and cheese for the second annual Madison SQL Saturday event. The event was a great success, but can you expect less when one of the organizers is wielding a light saber. For a change this time, instead of bringing Sarah Strate (Blog | … Continue reading Presentation Materials “Discovering the Plan Cache” #SQLSat206
The Chicago SQL Saturday is coming up this weekend on Saturday, April 13th. If you are waiting until the last minute to register to join in on the training, better stop waiting because the last open slots may be filling up. I'll be there (with the unicorn somewhere near by) to join with friends to learn … Continue reading Chicago SQL Saturday (#SQLSat211) Is This Weekend
Strate SQL 