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,
The SQL Server SOS_SCHEDULER_YIELD is a fairly common wait type and it could indicate one of two things: SQL Server CPU scheduler is utilized properly and is working efficiently or There is a pressure on CPU. Read more at the SQL Shack from Nikola Dimitrijevic..
Startup options designate certain file locations needed during startup, and specify some server wide conditions. Most users do not need to specify startup options unless you are troubleshooting the Database Engine. It might also be useful to add trace flags to a startup options. Trace flags are used to temporarily set…
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…
SQL Server databases consist of two physical files types; the data file in which the data and the database objects such as tables and indexes are stored, and the transaction log file in which SQL Server stores records for all transactions performed on that database. SQL Server transaction log contains…
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.