Feb 292016
 

Thank you so much to the wonderful organizing committee of SQL Saturday Madison 2016 for selecting me to present!

I’m a huge fan of Madison – it’s a great city that’s not-too-terribly far from my house. I’ve had amazing times at their previous SQL Saturdays in 2012, 2013, and 2015, and I can only assume it will be just as awesome this year. They’ve put together a wonderful schedule with amazing presenters both local and from afar.

The presentation I’ll be giving is an introduction to SQL Server Encryption. Security is only getting more important as time goes on, and encryption continues to play an increasing role across the board. While it was once seen as necessary only at the client level, the calls for databases to be encrypted as well are becoming more and more frequent. This session will cover SQL Server’s encryption capabilities and what they have to offer, including certificates, encryption algorithms, backup encryption, transparent database encryption, and column-level encryption.

Registration for SQL Saturday Madison is still open right now, so if you’d like to see a day’s worth of amazing presenters cover Microsoft’s Data Platform technologies, sign up today!

Jul 212015
 

I’m extremely honored to once again be part of the speaker lineup for PASS Summit. This will be my 4th year in attendance and my 3rd year speaking, and the joy of being there never gets old. It’s an incredible gathering of people from all over the world who are passionate about data, and returning each year feels like a family reunion.

This time around I will be presenting about security, a topic near and dear to the hearts of many, especially with the number of newsworthy security breaches that have occurred the past few years. I’ve always wanted to present a beginner-level topic, and this year I got my wish. I’ll be talking about the basics of security in SQL Server: how to make sure everyone requiring access to data gets exactly what they need and nothing more, and that people with no business seeing certain data have no ability to. Here’s the abstract:

SQL Server Security Basics
The past few years seem to have had more than their fair share of high-profile data breaches, not all of which were caused by sophisticated hacking attempts. This session explains basic methods for securing your SQL Server by making sure you’re not leaving the proverbial front door unlocked (or in some cases, wide open). We will discuss the different levels and methods that can be used for granting and restricting rights, as well as the pros and cons of each. You learn steps you can take to design databases with securability in mind from the beginning, so that you can better protect your data later. We also demonstrate scripts that can help audit user rights and make sure logins don’t have any more permissions than they need. Security doesn’t need to be scary! Attend this session and gain a solid foundation on which to build your DBA career.

If you haven’t signed up for PASS Summit yet, register today! There’s still time to negotiate with your employer and see if they can help cover some or all of the cost. It’s an incredible investment in your career. If you want to learn from some of the best in the world, this is where you go to do it. I really hope to see you there!

Jun 242015
 

I’ve been to nearly all the SQL Saturday locations in the Midwest at one point or another, but Indy has been one of the very few that’s evaded me. (Minnesota, you’re next!) I’m very happy to be presenting in The Circle City this year at SQL Saturday Indianapolis on August 8 2015! I’m really looking forward to being part of the tremendous group of presenters put together by the organizing committee.

My presentation is all about the wonderful new features in SQL Server 2014 other than In-Memory OLTP, more commonly known as “Hekaton”, which was it’s feature codename. In-Memory OLTP is arguably the most significant feature in 2014 and tends to get the most love, but SQL Server 2014 offers plenty of other awesomeness that far more environments can benefit from. This session gives those other features some much-deserved attention, and shows attendees how they can take advantage of all the new improvements.

If you haven’t already signed up for SQL Saturday Indianapolis, register now! I hope to see you there!

Feb 242015
 

I’m definitely a fan of Wisconsin. I never really developed a taste for beer, but I do love Culver’s and cheese curds, so that counts, right? I’m also very happy to be presenting at SQL Saturday #387 in Madison on April 11 2015!

I had a blast at SQL Saturday Madison in 2012 and 2013. Last year I missed it, but with good reason – I was speaking at SQL Saturday Boston instead. I’m very happy to be heading back, though, and am looking forward to seeing friends and sitting in on some sessions by the other speakers in their amazing lineup.

My presentation this time around talks about all the wonderful new features in SQL Server 2014 other than In-Memory OLTP, more commonly known as “Hekaton”, which was it’s feature codename. Whenever SQL Server 2014 is brought up, Hekaton is usually one of the first things that comes to mind. It’s even got it’s own Wikipedia Page. It’s a neat feature, but SQL Server 2014 offers plenty of other awesomeness that far more people will benefit from. This session gives those other features some much-deserved love, and shows attendees how they can take advantage of all the new improvements.

If you haven’t already signed up for SQL Saturday Madison, do it soon – spots are filling up fast! Registration is still open as of right now. I hope to see you there!

May 212013
 

Tomorrow I am making the trek up to Madison to speak at MADPASS! I had a great time there last year and am looking forward to heading back.MADPASS Logo

I’ll be giving my talk on SQL Server’s data compression feature entitled “The Skinny on Data Compression.” I’ll be explaining how data compression works and sharing some of the things I’ve learned about when and where to deploy data compression that I’ve accumulated over the past 2 years of using it.

Greg Kramer will also be presenting tips and tricks regarding DAX that both Excel and SQL professionals should find useful.

WHERE: 2310 Crossroads Drive, Madison, WI 53718

WHEN: Wednesday 22 May 2013, 5:30PM

Hope to see you there!