SQL Solutions Group is happy to announce a free community event. The week of PASS Summit, we are pleased to bring a free day of training. This is an event for all data professionals who happen to be in the area the days leading up to Summit but may not be able to attend one of the Summit Precons. Here are the details for the workshops we will be presenting. All ticket sales are final and non-refundable.
We invite you to attend a day of training presented by four of our MCMs. There will be four 1.5hr sessions with a lunch break during the day. While the training is free, we do ask a cover charge for the lunch. The lunch will be $10 per person.
Important: We understand many may not be able to attend an entire day due to meetings or travel or what have you. If you can only attend for half the day or just one session, please don't hesitate to stop in. For those wishing to attend but will not be able to attend the entire day or wish to do something different for lunch, please use NoLunch as a discount code so we know you are coming and we can plan for it.
Again, that code is NoLunch
All (including discounted) ticket sales are non-refundable.
**Light snacks will be provided.
Sessions to be Presented. While these sessions will be presented, the order of appearance may change)
Code Smells for the Consultant
Throughout my career, I’ve seen developers do some pretty crazy things to databases ( I know because I come from a developer background). Come to this session to learn both what I (and SSG) look for and why it’s bad for the database (or your career), and alternatives that can be used. Some of the topics that I will discuss include; how coding mistakes open up the database for SQL Injection attacks, how coding choices can slow down the server, and how design choices keep SQL Server dumb ( if SQL Server was allowed to be smart, it would be faster!). Trust me, your DBA will love you for identifying and fixing these code smells.
A Masters Passport to Extended Events
As is commonly the case, all good things come to an end. And now is as good a time as any for the use of SQL Trace and Profiler to come to an end. Let’s face it, Trace was a good tool and had some wonderful uses. Profiler for that matter was a good tool and was useful at times.
It is time to let those old tools retire gracefully and move into the world of XE. This workshop will provide you the means to let Profiler and Trace be retired from your toolset as you discover all that XE has to offer.
This focused session on Extended Events will help prepare you to put this tool to immediate use as you walk back to your daily duties. This workshop will teach you about Extended Events starting with the basics and moving through to some specific XE sessions that I would use to troubleshoot in a client environment - while doing so with minimal impact.
You will be exposed to advanced troubleshooting techniques as we work through complex issues that are made easier through the use of XE. Take advantage of this opportunity to dive into the world of Extended Events and learn how you can make best use of this tool in your SQL 2008+ environment.
Practical Powershell for the DBA
Think of all the tools you use in managing your SQL Servers. All those SQL Servers being managed by tools and man that is a lot of clicks. We will show practical scripts and techniques to help you get a handle on all those clicks. Whether you are gathering data or statistics from your SQL Servers or deploying an object to all of them. Configuration items are not excluded from the need for good tools. PowerShell is that tool that will let you get away from all those clicks. Reusable scripts that let you manage all those instances with ease. This session will give you a great start on how to think about admin tasks using PowerShell scripts or modules. Many items are already out there to help you and we will take a good look.
Transaction Isolation Levels, Locking and Deadlocking
Managing concurrency is one of the most challenging aspects of working with any enterprise DBMS. There is much confusion out there about locking, blocking, and deadlocks.
In this demo heavy session we will clear up the confusion by defining what each of these items are and what their causes are. We will then dig into each of SQL Server's built in isolation levels and explore how they affect concurrency. Understanding concurrency and how isolation levels impact it is one of the most important things you need to know as a SQL Server developer. But understanding when to use each one can be daunting. Whether you are a developer who needs to understand how isolation works and why NOLOCK is not an appropriate hint in most cases, or a seasoned DBA who needs to understand the less commonly used isolation methods, this session is for you. We will look at each level, how it impacts the engine, and examine appropriate (and inappropriate) use cases for each.
Jason Brimhall has 10+ yrs experience and has worked with SQL Server from 6.5 through SQL 2014. He has experience in performance tuning, high transaction environments, as well as large environments. He is currently a consultant specializing in performance tuning, server analysis and problem resolution. Jason is a Microsoft Certified Master(MCM) and Microsoft MVP in SQL Server. He has also been the VP of the Las Vegas User Group (SSSOLV).
Wayne Sheffield, a Microsoft Certified Master in SQL Server, started working with xBase databases in the late 80's. With over 20 years in IT, he has worked with SQL Server (since 6.5 in the late 90's) in various dev/admin roles, with an emphasis in performance tuning. He is the author of several articles at www.sqlservercentral.com, a co-author of SQL Server 2012 T-SQL Recipes, and enjoys sharing his knowledge by presenting at SQL PASS events and blogging at http://blog.waynesheffield.com/wayne
Randy Knight (MCM), is an IT professional who has worked with Microsoft technology for over 20 years, focusing on SQL Server since 1997. He has worked in a variety of settings, including 6 years as a database architect for Match.com. He is currently the president and principal consultant for SQL Server Solutions Group LLC, a Vegas-based SQL Server consultancy.
Ben Miller has been a member of the SQL Server Community for over 17 years now. He is currently the Director over Database Administration. He is a SQL Server MVP and MCM: SQL 2008 and has spent time in the field using SQL Server since 1997. He has worked at various companies throughout the US as well as at Microsoft for 7 years. He is passionate about SQL Server and automation and integration.
We do databases! Specifically, we are a Microsoft-certified full-service SQL Server consultancy, with four Microsoft Certified Masters on our team of Database Consultants. We are ready to help you tackle even your most complex database issues.
Check us out at http://www.sqlsolutionsgroup.com/
In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.