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
IT/Dev Connections

Register now to get the best rate available!

From the Blogs
computer keyboard with blue save money key
Apr 15, 2014

Save Thousands in Licensing Costs for SQL Server AlwaysOn Availability Groups 1

Windows Server 2012 or Windows Server 2012 R2 Standard Edition is a great way to save thousands on licensing—and save yourself some serious headaches when deploying SQL Server AlwaysOn Availabiliity Groups....More
Apr 8, 2014

NoSQL: Eventual Consistency Yields Major Flaws 1

While I believe that NoSQL can have some places where it legitimately makes sense, I also believe that NoSQL is also the patently wrong choice for a number of different types of applications or use cases....More
Apr 1, 2014

SQL Server 2014 Now Available—No Joke

Initial word on the street is that SQL Server 2014 has been very stable so far—which is probably why it went to release so quickly and bypassed what would typically have been another pre-release....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) ×