Bonus Session - Jen & Sean McCown

The Midnight DBA (http://midnightdba.com) folks are coming to Cardiff after SQLBits and presenting on designing stored procedure solutions and how you can use regular expressions in your day job.

A great set of sessions for developers and DBAs.

Agenda

6:30 - doors open

7:00 - Designing Stored Procedure Solutions

8:00 - Break

8:15 - Monster Text Manipulation: Regular Expressions for the DBA

Designing Stored Procedure Solutions

In this session, you’ll learn about SQL Server stored procedures (SPs): what they are, when and why you'd use them, and how you'd go about developing a solution with one. We will address common SP myths and learn about planning for performance. Most of all, we’ll walk through examples to explore the process of solution building in SQL Server.

Monster Text Manipulation: Regular Expressions for the DBA

Have you ever needed to refactor dozens of stored procedures or create lots of user accounts from a list given to you by a business unit? If so then you’ve probably spent too much time manually manipulating text. Regular Expressions (regex, for short) is one of the best tools a DBA can have. This powerful text manipulation tool can be used in any number of scripting languages, and can even be leveraged inside of SSMS. The best part? Regex is brilliantly simple--despite what you may have heard to the contrary. In this session you'll learn the basics of regex and the differences you'll encounter when using it in SSMS rather than a scripting tool. Along the way you'll see some really cool tricks; things you'll want to use all of the time once you're aware of them. Next we'll move into Powershell. Here regex gets the full treatment and will help you with powerful and incredible tasks, manipulating hundreds of objects at a time.