Voice of the DBA

Category: Presentations

  • Your First Week as a DBA

    Summary: There are many accidental DBAs as well as people new to SQL Server who are assigned the responsibility of managing a database system. Learn about the most important things for you to examine on your first week.

    Abstract: Developers, system administrators, junior DBAs, and even managers often find themselves responsible for a new SQL Server system without knowing what things they need to worry about. Since a SQL Server instance can run for months without issues, these accidental DBAs don’t realize that they are neglecting maintenance and other operations that will ensure their systems are protected and running smoothly. This session will teach you the most important things you should do on your first week with a new instance.

    Length: 60 minutes

    Slides: (coming soon)

    Code: (coming soon)

  • Maintaining High Performance When Using Encryption

    Summary: Encryption is becoming required in more and more environments, but implementing encryption can dramatically affect performance. Learn how you can maintain high performance while using encryption in your database.

    Abstract: Encryption is becoming required in more and more environments, but implementing encryption can dramatically affect performance. Learn how you can maintain high performance while still protecting your data with encryption. This session will examine communications, Transparent Data Encryption and a technique for using Symmetric Key encryption without a high performance penalty.

    Length: 75 minutes

    Slides: (coming soon)

    Code: (coming soon)

  • Common Problems with Backup and Recovery and How to Handle Them

    The basic concepts behind taking a backup are well understood, but people are frequently surprised by the many ways backups can go wrong. First, we’ll explore the most common problems around SQL Server backup and recovery, so that you can spot any issues in your own environment. Then, we’ll talk about how to prevent these issues in the first place. The foundation of disaster recovery is having a verified backup in place, so the knowledge you’ll gain from this session could help to save your business.

    We will look at issues with:

    • file backups
    • disk space
    • backup chain issues
    • full transaction logs
    • off-site storage
    • more

    Slides:

    SQL in the City – Common Backup Problems SitC_sj.pptx

     

  • Best Practices for Database Deployment

    The easiest part of any deployment is running the deployment script on production. But what have you done to prepare that script for production? Was the script tested? Is the script tightly coupled with the application code?

    The difference between a successful deployment and a failed or problematic deployment is all the preparation work you’ve done to ensure that you’re deploying the right script, the right way to your production environment. This session will explore best practices that you can implement to ensure that your deployments are as successful as they can be.

    Slides: