More in Virtualization

  • Nov 2, 2011

    11 Glorious Sessions on Storage and Virtualization

    In this 11 session class we will learn all about enterprise storage and virtualization so that as the DBA we can make intelligent decisions about how to configure storage and when to virtualize servers as well as how to monitor and troubleshoot when using enterprise storage and/or virtualization....More
  • Sep 27, 2011

    What is tiered storage and how can I use it in my environment?

    Tiered storage (which you may have seen me talk about at the SQL PASS summit, SSWUG, user groups, SQL Saturday's, etc.) is a technique that storage administrators use which in a nutshell puts the most needed data on the fastest (and most expensive) storage available while data which doesn't need such high response times is put on to slower (and cheaper) storage....More
  • Sep 13, 2011

    Making a Large Virtual Lab Using Minimal Hard Drive Space

    As a presenter and author one of the biggest problems that I come across is running out of hard drive space when building virtual machines (VMs) for demos and screenshots. Up until very recently I was using a brand new virtual machine for each virtual machine that I needed and space was very tight....More
  • Apr 14, 2011

    Introducing SQLContinuitySIM

    In my previous post, I outlined the importance of SQL Server RTOs and RPOs. I also explained why regularly testing Disaster Recovery (DR) and High Availability (HA) solutions is essential to ensuring that you can actually meet business goals and needs when it comes to overall continuity. Therefore, to help make regular continuity testing that much easier, I’m happy to officially announce Version 1.0 of SQLContinuitySIM – a totally free tool that DBAs and IT Pros can use to help verify that their HA and DR solutions are meeting RPOs/RTOs by making it easier to test and evaluate gaps in continuity. How SQLContinuitySIM Works SQLContinuitySIM is a very simple application. Point it at a SQL Server and database, have it create a ‘logging’ table, tell it how frequently you want it to log entries to that table, configure the maximum number of errors you will allow it to encounter before terminating, and then turn it on. Once it’s logging, it will attempt to add a new, very simple, logging message to a special logging table at the interval specified. You can then test or simulate failures, failovers, and other disaster recovery scenarios while SQLContinuitySIM is still doing its best to log regular, timed, entries into your system and then, once your HA or DR solution is successfully back online, you can then stop SQLContinuitySIM, and then query the logging table it created to get a feeling for what kind of down-time you incurred during your test. Comparing this downtime, or gap in overall continuity, can then be compared with your RTOs and RPOs to ensure that you’re able to meet stated goals and react accordingly when you’re not. How to Use SQLContinuitySIM Once you open SQLContinuitySIM, you’ll need to Specify the SQL Server and database that you wish to connect to for logging purposes. After you’ve specified connection details, SQLContinuitySIM will turn those into a connection string – which the the connection string that it uses for testing (mea...More
Upcoming Conferences

Register now to get the best rate available!

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.


From the Blogs
Sep 12, 2014

Managing a Healthy SQL Server Database: Three Principles We Overlook

In managing a database or sometimes numerous databases, we often get caught up in the day-to-day maintenance and lose sight of the other principles we know are critical to ensuring optimal performance. Here’s a quick refresher....More
Exclamation marke on yellow road sign
Sep 9, 2014

AlwaysOn Availability Groups and SQL Server Jobs, Part 5: Setting Up Failover Alerts

Alerts represent a great way to take a proactive stance on being notified or alerted when something ugly, potentially ugly, or important happens on a SQL Server. On most servers that I manage, I typically deploy a whole bevy of different alerts....More
synchronize key on computer keyboard
Sep 5, 2014

AlwaysOn Availability Groups and SQL Server Jobs, Part 4: Synchronizing Server-Level Details

When setting up HA or HA+DR solutions with SQL Server AlwaysOn Availability Groups, it's critical to remember that the basic unit of failover in these scenarios is the availability group (or the group of user-defined databases)....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×