50 Things All SQL Server Developers Need to Know with Kevin Kline

The Charlotte BI Group is a technical user group focused on business intelligence, analytics, data science, data warehousing, and big data.Our meetings will approach learning in a casual, fun and social way. Join us to learn and get to know fellow professionals in the area.

Charlotte BI Group

<IMG SRC="https://cdn.evbuc.com/eventlogos/44139050/sqlsat806web28329.png"> <A HREF="http://www.sqlsaturday.com/560" TARGET="_blank" TITLE="SQL Saturday Charlotte 2016" DATA-MSYS-CLICKTRACK="0" REL="nofollow noopener noreferrer"></A>
<A HREF="http://www.sqlsaturday.com/806" TARGET="_blank" TITLE="SQL Saturday Charlotte 2018" DATA-MSYS-CLICKTRACK="0" REL="nofollow noopener noreferrer">SQL Saturday Charlotte</A> and the Charlotte BI Group are pleased to offer this full day workshop with Kevin Kline. 
<H3 CLASS="MsoNormal">50 Things All SQL Server Developers Need to Know </H3>
What are the most problematic patterns and anti-patterns that trip up SQL Server developers on a daily basis? What sort of SQL and Transact-SQL challenges does every SQL Server developer encounter at some point in their career? This full-day, pre-conference seminar takes a tour of the most common and challenging issues that database developers face. Learn how to conquer them in the lab today so that they won’t take you surprise in the future. Loaded with live demonstrations and useful techniques, this session will teach you how to take your SQL Server queries mundane to masterful.
In this session, you’ll learn:
1. Internal operations of the SQL Server query optimizer and caching mechanisms and their impact on T-SQL code performance, including ways to shortcut default behavior using trace flags. 2. Tricks, techniques, and metadata analysis needed to make T-SQL code, including queries and stored procedures, achieve top performance and maximum reliability. 3. A variety of patterns and anti-patterns in T-SQL coding that are common challenges for all but the most advanced database developers. 
Prerequisites: Intermediate competence in SQL and Transact-SQL syntax, such as coding with DML, DDL, and DCL transactions, using cursors and variables, and invoking functions and procedures. Basic familiarity with reading execution plans.
About Kevin Kline
<IMG SRC="https://cdn.evbuc.com/eventlogos/44139050/kevink.jpg">
Kevin Kline is a database expert and Principal Program Manager at SentryOne, the industry leading SQL Server database tools vendor. A Microsoft SQL Server MVP since 2003, he is a founder and former president of PASS. Kevin is an author of many books, blogger, columnist, and popular international speaker. Kevin’s best known book is the best-selling SQL in a Nutshell and contributes monthly to Database Trends & Applications magazine. He tweets at @kekline and blogs at http://Blogs.SQLSentry.com/Authors/KevinKline.

CPCC Harris Campus

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

50 Things All SQL Server Developers Need to Know with Kevin Kline

More events from Charlotte BI Group

Discover more events from Charlotte BI Group, from Science & Tech to other experiences you might love.

Still looking for the right event?

Explore all events in Charlotte and filter by date, category, and more to find the perfect fit.

50 Things All SQL Server Developers Need to Know with Kevin Kline

More events from Charlotte BI Group

Discover more events from Charlotte BI Group, from Science & Tech to other experiences you might love.

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.

Still looking for the right event?

Explore all events in Charlotte and filter by date, category, and more to find the perfect fit.