The recordings are now available for the 24 Hours of PASS: Summer 2017 edition. These are the preview sessions for the upcoming PASS Summit. Definitely a must see.
The newly designed PASS website is now live! Come meet us: http://www.pass.org/ PASS is your invitation to a global community of over 250,000 like-minded data professionals who leverage the Microsoft Data Platform. Becoming a member unlocks incredible year-round learning and professional development opportunities, virtual webinars, and in-person networking.
Tomorrow night we have Peter Shore presenting an Introduction to Infrastructure for the DBA. It doesn’t matter if you are a Junior DBA, an accidental DBA or all the way up to a Senior DBA, the infrastructure your SQL Server environment runs on is important. Many among the DBA community came in as developers or perhaps directly into database administration roles it is equally possible that you have been out of the operations world long enough to have fallen out of the loop with what is happening. This session is intended to provide a full stack infrastructure overview so that you can talk shop with your cohorts in operations to resolve issues and maybe even be proactive. We will discuss, in an introductory fashion, hardware, network, storage, virtualization and operating system layers. Additionally, some suggestions as to where to find more information will be provided.
Are you a data scientist that is being asked to speak or is it just part of your work? Do you also use slides for your presentations? If so, join us in this webinar on November 15, 2016. You are about to learn the algorithm that you need to follow in order to be able to create truly effective slides. Slides that will not only help you convey your message better, but slides that will also help you differentiate as a speaker too. No, this is not a talk for designers. This is a talk for you – the data scientist.
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.
Headed back down to Atlanta on December 10th for another SQL Saturday. It is the Business Intelligence Edition, but I will be talking about the new Streamlined Microsoft Certifications and how you can become certifiable.
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/
One of the newest features that everyone is talking about with Azure SQL Database or SQL Server 2016 is the Query Store which provides a mechanism of capturing query performance over time and persisting it with the database. I’m still trying to figure it out myself, but a great place to start is from Grant Fritchey who may be a little obsessed with the Query Store and Plan Forcing,
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.
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.
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.
Are you a SQL PASS member? Check out our SQL Server 2016 resources page to stay on top of Microsoft’s latest release. If you are not a member of PASS, you can always join a Virtual Chapter which features many community driven groups that can fit around your schedule and your skill level.
The SQL Saturday team of Indianapolis would like to introduce the SQL Starter Track. An entire track of FREE sessions geared towards the ABSOLUTE BEGINNER. Be sure to sign up We have also started the #SQLStarter on Twitter. Find out more information on on our Sway Page.
Register now for 24 Hours of PASS: Evolution of the Data Platform! From May 25-26, 2016 starting at 8am EST 24 one-hour webinars will be presented live back-to-back for you to enjoy from the comfort of your home or office! This edition will showcase cutting-edge technologies presented by a diverse mix of community speakers, MVPs, and Microsoft speakers. The areas of focus will include SQL Server 2016, Cortana Intelligence, Azure ML, R, Azure HD Insight, Hadoop and more. Don’t miss this excellent training opportunity. Reserve your spot today!
The next PASS virtual chapter session will be Mon, May 9, 2016 10:30 PM – 11:30 PM EDT where Ben Miller will be talking about how Transparent Database Encryption (TDE) works and how you set it up. This session will go over all the steps and caveats that go with this technology. TDE allows you to have your database encrypted on disk and the same Encryption Hierarchy allows you to back up your database and have it encrypt the contents in the backup file. Ben will discuss the Encryption Hierarchy which is used for encryption in SQL Server and take you through keeping your secrets safe. Master the concepts of SQL Server Encryption when you are done with this session.