Feb 072018
 

I’m so proud to be speaking at SQLBits – Europe’s largest SQL Server conference!

It took me several years of abstract submission before I was accepted to speak at PASS Summit. Once I spoke there, I set my sights on presenting internationally. After some more attempts, I now have the amazing opportunity to present in London and deliver not one but TWO sessions! They are:

VLDBs: Lessons Learned

Whoever coined the term “one size fits all” was not a DBA. Very large databases (VLDBs) have different needs from their smaller counterparts, and the techniques for effectively managing them need to grow along with their contents. In this session, join Microsoft Certified Master Bob Pusateri as he shares lessons learned over years of maintaining databases over 20TB in size. This talk will include techniques for speeding up maintenance operations before they start running unacceptably long, and methods for minimizing user impact for critical administrative processes. You’ll also see how generally-accepted best practices aren’t always the best idea for VLDB environments, and how, when, and why deviating from them can be appropriate. Just because databases are huge doesn’t mean they aren’t manageable, attend this session and see for yourself!

SQL Server Administration on Linux

Times are certainly changing with Microsoft’s recent announcement to adopt the Linux operating system with the SQL Server 2017 release, and you should be prepared to support it. But, what is Linux? Why run your critical databases on an unfamiliar operating system? How do I do the basics, such as backing up to a network share or add additional drives for data, logs, and tempdb files?

This introductory session will help seasoned SQL Server DBAs understand the basics of Linux and how it differs from Windows, all the way from basic management to performance monitoring. By the end of the session, you will be able to launch your own Linux-based SQL Server instance on a production ready VM.

 

I can’t wait to experience this incredible event I’ve been hearing about from other people for years, and am very interested to compare it to my previous experiences at PASS Summit. Expect a full write-up once I return!

May 112017
 

Thank you to all who attended my session on “Passive Security for Hostile Environments” back on the 3rd of this month. I consider it an honor to be part of such a wonderful lineup. I just received my evaluations and comments, and am very happy to report that the results were extremely positive. Thank you very much to the people who took the time to rate my presentation and offer feedback, which I will include below.

I was also very surprised to hear that my session had 193 attendees, which puts it in the top five in terms of attendance – wow!

If you weren’t able to attend but would like to check it out, a recording is now available.

My slide deck is available for download on the 24 Hours of PASS site.

Demo scripts and other resources are available here.

Feedback

Sessions were evaluated based on four questions, and I received 78 total responses.

  1. How would you rate this session overall?
    Excellent: 60    Good: 18     Average: 0     Fair: 0     Poor: 0
  2. How would you rate the speakers’ presentation skills?
    Excellent: 64     Good: 13     Average: 0     Fair: 0     Poor: 0
  3. How would you rate the speakers’ knowledge of the subject?
    Excellent: 71      Good: 6      Average: 0     Fair: 0     Poor: 0
  4. Did you learn what you expected to learn from this session?
    Agree: 67     Somewhat Agree: 7     Neutral: 3     Somewhat Disagree: 0     Disagree: 0

I also received the following comments:

  • excellent demos and real deep dive into the details of each area he covered.
  • Your demo scenarios were very effective in showing the strengths and weaknesses of each option. Well done.
  • great use of demos!
  • Thank you!
  • Great presentation. Good demos – be great to get a copy of the scripts.
  • I had a lot of familiarity with DDL/DML triggers and Event Notifications. There were some new aspects you showed that I had not considered. Impersonation, for instance. Policy based management is something I haven’t used, but have read about. The session helped reinforce what I’ve learned in the past. Slide decks are great. But I prefer live demos and the code. You had a good, complementary mix of both.
  • Wow, this was incredibly good! So well organized. You covered a lot of territory.
  • Great overview of the different tech
  • Very clear explanations and demos, great pace for a webinar. Packed full of useful examples for real projects. Thank you!

 

Apr 242017
 

I’m extremely proud to be speaking at the upcoming 24 Hours of PASS: Data Security and Data Quality webinar on May 3-4 2017. For years now I’ve been wanting to present for 24 Hours of PASS, and I’m very excited and grateful for the opportunity!

If you’re not familiar, 24 Hours of PASS is a series of 24 free webcasts delivered over 24 hours. My presentation, “Passive Security for Hostile Environments” is on May 3rd at 15:00 GMT!

Here’s the abstract:

Ideal database security settings usually exist in books, but rarely in reality. Is your CIO a member of the sysadmin role because they demanded it? Or maybe some users have rights for purely political reasons? Just because you can’t enforce security through typical means doesn’t mean you’re powerless. Attend this session to learn about the features SQL Server provides that will allow you to keep track of what your users are up to at all times and sleep a little easier. Through various scenarios and demos, see how technologies such as event notifications, auditing, and extended events can help ensure nothing happens on your system without you knowing about it. Even in optimally secured environments these techniques can still come in handy. The best security is often that which cannot be seen.

Sound interesting? Sign up today! Registration is open, and you can sign up for my session along with all of the others here.

 

Apr 042017
 

Spring is upon us! It’s slowly getting warmer outside (with a few final insults of snow and freezing temperatures mixed in) and that can only mean one thing: SQL Saturday in Madison, Wisconsin is fast approaching – it’s actually this Saturday! I’m very proud to once again be on the schedule to present at one of my favorite SQL Saturdays. Not only is it relatively close to home for me, but the University of Wisconsin-Madison makes for a wonderful venue!

My presentation is entitled “Supercharging Your Backups and Restores For Fun and Profit”, and covers the various methods that can be used to increase the speed of SQL Server database backups. You may be familiar with query tuning, but did you know that backups and restores can be tuned in a similar way? This demo-intensive session will discuss the different phases of the backup and restore processes, how to determine which of them are the slowest, and which are the easiest to speed up. Cutting backup and restore times by 75% or more is entirely possible by using the methods covered in this session.

I hope to see you there!

Nov 092016
 

I’m very happy to be presenting for the PASS Security Virtual Chapter on Thursday, November 17, 2016 at 10:00am Pacific!

I’ll be presenting my session entitled SQL Server Encryption Basics. This is an introductory-level session on the encryption capabilities of SQL Server, how they work, and when and where you may want or need to deploy them.

High-profile attacks by hackers have made the news more and more the past few years, and your database is a prized target! Fortunately SQL Server offers many possible layers of protection, one of which is encryption. This session will cover SQL Server’s encryption capabilities, how they work, and what they have to offer. Topics discussed will include certificates, encryption algorithms, backup encryption, transparent database encryption, and column-level encryption. Attend this session and learn how SQL Server can help you hide your data in plain sight!

I’m really happy to be delivering this session, and look forward to seeing you there! You can register at this link:

https://attendee.gotowebinar.com/register/1806816841365466115