MCSA: SQL 2016 Development

 Last September I took the BETA exams for 70-761: Querying Data with Transact-SQL and 70-762: Developing SQL Databases. Well it looks like I passed them, because today I received an email saying I have earned my MCSA: SQL Server 2016 Database Development. I always like when I pick up a new certification, but it’s really cool to wake up and earn one you were not expecting. I am just now sure to count it towards my 2016 goals or 2017.

Speaking about SQL

tsql2sday150x150I can’t believe it, I am finally joining the T-SQL Tuesday blog post party started by Adam Machanic (b|t). This month Andy Yun is our TSQL2sDay #84 host who has selected the subject of “Growing New Speakers”. Specifically, to talk about preparing,  presenting, and speaking at local user groups, virtual PASS chapter, SQL Saturdays and/or the PASS Summit. As a Microsoft Certified Trainer(MCT), this topic really hits home. Click here to read more.

October – IndyPass

indypass

Identifying and Fixing Parameter Sniffing
(Tuesday October 18th, 2016 – 6:00 pm)
Presenter: Brent Ozar from Brent Ozar Unlimited

You swear nothing changed – but suddenly your SQL Server has ground to a halt. Queries are slow across the board. You restart the server, rebuild indexes, or update statistics, and magically the problem goes away – but what really happened, and how do you fix it faster and more permanently? http://indypass.org/

September IndyPASS

indypass1

Being able to write functional SQL queries is a useful skill, of course, but functional is only the first step. An understanding of how SQL Server processes your queries is necessary to ensure that what you are writing is handled quickly and efficiently.
In this session, we will cover the basics of SQL Server storage, clustered and non-clustered indexes, the three main join algorithms, scans versus seeks, and other fundamental concepts behind the processing of Transact-SQL queries.

 

FREE Plan Explorer

plan-explorer

SQL Sentry is introducing the new unified Plan Explorer! This edition includes all features of Plan Explorer PRO, plus two new and incredibly powerful features: Index Analysis and Performance Profiling. These new features were originally going to be part of Plan Explorer ULTIMATE at higher price point. However, they ultimately decided to make all features of Plan Explorer freely available to everyone. That is right FREE!

24 Hours of PASS 2016

24 Well it looks like I will be moderating session 16 for the 24 Hours of PASS: Summit Preview 2016 that takes place September 7–8, featuring 24 consecutive one-hour webinars from upcoming PASS Summit 2016 speakers. Whether you have attended Summit before, or are a newcomer who needs to convince your boss, these previews give you a taste of the great content and expert speakers that will be on offer at Summit this year. Best of all, Summit Preview is free thanks to the support of our generous sponsors.

SQL Saturday #531

agu6 Had a great time at the SQL Saturday in Louisville, KY. I always enjoy this one because it is only a two hour drive and I get to see the southern contingent of the #sqlfamily. I delivered my presentation on The PROCESS of Queries which seems to have become my most popular session. You can download the demo scripts and powerpoint presentation here or as always watch the abbreviated video version here.  Really enjoyed the great reviews and even picked up some tweets during the session.

2tweet