It is time for another SQL Server User Group. This time it is for Chattanooga, Tennessee. I’m getting close to spelling that correctly. I have attached my most recent presentation on SQL Server certifications with the changes that were announced in April. I hope everyone has a great time.
So Kendra Little is starting a SQL Workbooks website where she will be helping people learn SQL Server by solving problems. I have always enjoyed her presentations and hope she is very successful in this new adventure.Visit her website and check out the courses.
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.
I 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.
I couldn’t make it to the PASS Summit this year. But I am watching the highlights on PassTV. So many great sessions so far on the first day, I definitely know how I am spending my weekend.
Are you attending PASS Summit 2016—the world’s largest gathering of SQL Server and business intelligence (BI) professional? It is being held on October 25-28 in Seattle, Washington. If you’ll be there, from Wednesday to Friday look for the Microsoft Learning Lounge, which is on level 4 of the Washington State Convention Center.
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/
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.
I had such a great time at the SQL Saturday in St. Louis. There were about 25 people for my presentation which you can download here. I am thinking of reworking the last portion of it, but you can watch a streamlined version of my presentation here. I really enjoyed George Walkey’s presentation on Using Powershell to Document SQL Server. His scripts from that session are invaluable.
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!
Don’t forget tonight at 11pm, Andy Yun will be presenting hour 16 of the 24 Hours of PASS .http://bit.ly/2boVHxb This session will be moderated by myself, but don’t miss out on the other 23 hours of this PASS Summit Preview.
Meet me in St. Louis where I will be presenting my session on “The PROCESS of Queries“. SQL Saturday is a free training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held on Sep 10 2016 at SLU Center for Workforce & Organizational Developement, 3545 Lindell Blvd , Saint Louis, Missouri, 63103, United States.
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.
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.
If you can’t make it to a SQL Saturday to see my presentation on The PROCESS of Queries? That is OK. Because I made it into a video. Just as a reminder, I will be delivering this presentation at the SQL Saturday in Columbus, Ohio on July 16th and then again in Louisville, KY on August 6th. Or you can just take my 20461 SQL Query Writing class at New Horizons and see the three hour version of this presentation.
Microsoft announced today that New MCSA certifications are out for both Windows Server 2016 http://bit.ly/295AIN0 and SQL Server 2016 http://bit.ly/295AWUG. Upgrade exams are also available for those who already have earned an MCSA on Windows Server 2012 or SQL Server 2012.
SQL Server 2016 is finally here. The quickest way to experience the magic of SQL Server 2016 is to create a test environment using an Azure SQL VM. You can also experience the full features through the free developer edition (you will be prompted to sign in to Visual Studio Dev Essentials before you can download SQL Server 2016 Developer Edition). Visit the SQL Server 2016 webpage to gain insights about new features and download the SQL Server 2016 e-book.
I have previously posted on the differences between DELETE, TRUNCATE, and DROP. However, I found this great article today by SQLdoubleG about some of the misconceptions of the TRUNCATE statement and how it physically deallocates data pages. Read more about it here.