IndyPASS November

15027705_1316663855018534_372375365204117190_n 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.

Data Science Webinar

15027783_1315867098431543_2865450064893849223_nAre 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.

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/

Get Started with Query Store

2308-img123One 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,

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.

 

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.

Data Platform Evolution

24

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!

SQL Encryption Virtual Conference

Captur44  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.