Apr 122018
 

Next week I am happy to be presenting for the Chicago Suburban SQL Server User Group, which meets in Downers Grove, IL.

I will be delivering my session Locks, Blocks, and Snapshots: Maximizing Database Concurrency. This takes a look at SQL Server’s available isolation levels, what they are, how they differ, and why the default setting of “read committed” may not be appropriate for your workload. It should not only be helpful, but lots of fun as well.

I hope you can join us! The meeting is on Tuesday, April 17, and you can register and find further details here!

Mar 262018
 

I’m very pleased to be returning to Wisconsin in April to speak at SQL Saturday Madison 2018! This has always been one of my favorite events. Not only is it close to home, but it’s in a wonderful location and full of great friends. Thank you so much to the organizing committee for all of the hard work you do!

This year I will be presenting Locks, Blocks, and Snapshots: Maximizing Database Concurrency. This light-hearted and informative session will take a look at SQL Server’s available isolation levels, what they are, how they differ, and why the default setting of “read committed” may not be appropriate for your workload. It should not only be helpful, but lots of fun as well. I hope you will join me!

As of the time of posting, SQL Saturday Madison registration is still open. If you’d like to see some awesome presentations on Microsoft data technologies, register today!

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.