R is one of the most popular, powerful data analytics languages and environments in use by data scientists. Actionable business data is often stored in Relational Database Management Systems (RDBMS), and one of the most widely used RDBMS is Microsoft SQL Server. Find out more with the availability of a new…
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…
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…
I am deeply honored and extremely humbled to be joining the MVP community. This is not something you earn on your own and there are so many people to thank, which I will do individually when I see them. It is always nice to know that my passion for learning…
Session Recordings are now available from the 24 Hours of PASS. You can also check out all the speakers at the upcoming PASS Summit.
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…
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,…
Whenever I am teaching a database class it seems I always get the question of what is the most popular Relational Database Management Systems (RDBMS). I always refer to the DB-Engine Ranking monthly trend website. The problem is I keep forgetting where the website is located. So for myself and for…
We had three times as many speaker submissions as we had actual open speakers slots for the upcoming SQL Saturday Indianapolis. It was very difficult to select from so many excellent individuals. However, we have finalized the sessions and Here is our schedule for the August 13th event. We’ve done our best to…
The folks over at Channel 9 have a great series of videos to get you started with what is new in SQL Server 2016. Join in as Scott Klein and Joey D’Antoni provide an overview of the SQL Server 2016 features and enhancements,