Archives for February 2015

ICYMI: Ten Query Techniques Every SQL Programmer Should Know (Video)

Update 09-Mar-2015: The original PASS links I provided were behind a firewall. Thanks reader MMcDonald, we have a working link on YouTube. One of the benefits of joining PASS is that you get access to their expansive library of conference videos. (Membership is free. So join now. What'dya want, a hand-written invitation?!?) I want to take a moment to point out a good one that I think anybody who writes SQL code on SQL Server should watch. If you know anything about the staff here at SQL Sentry, then you’re probably expecting me and my colleague Microsoft MVP Aaron Bertrand (b | t) to be … [Read more...]

ICYMI: Ten Query Techniques Every SQL Programmer Should Know (Video)

Update 09-Mar-2015: The original PASS links I provided were behind a firewall. Thanks reader MMcDonald, we have a working link on YouTube. One of the benefits of joining PASS is that you get access to their expansive library of conference videos. (Membership is free. So join now. What'dya want, a hand-written invitation?!?) I want to take a moment to point out a good one that I think anybody who writes SQL code on SQL Server should watch. If you know anything about the staff here at SQL Sentry, then you’re probably expecting me and my colleague Microsoft MVP Aaron Bertrand (b | t) to be … [Read more...]

The SQL Sentry forum for SQL Statement Tuning

The SQL Sentry forum for SQL Statement Tuning Have you ever looked at our community site specifically dedicated to helping users tune their SQL queries, http://answers.SQLPerformance.com? You can easily upload an execution plan directly from our free Plan Explorer tool or from good ol' SQL Server Management Studio.  Once uploaded, our internal team and forum members will provide plenty of tips and input on how to improve the plan and/or explain what the plan is actually doing.  The renown SQL execution plan expert, Paul White (b|t), is the moderator of the site. But there are many other … [Read more...]

The SQL Sentry forum for SQL Statement Tuning

The SQL Sentry forum for SQL Statement Tuning Have you ever looked at our community site specifically dedicated to helping users tune their SQL queries, http://answers.SQLPerformance.com? You can easily upload an execution plan directly from our free Plan Explorer tool or from good ol' SQL Server Management Studio to the discussion forum.  Once uploaded, our internal team and forum members will provide plenty of tips and input on how to improve the plan and/or explain what the plan is actually doing.  The renown SQL execution plan expert, Paul White (b|t), is the moderator of the site. But … [Read more...]

Troubleshooting workshop at SQL Saturday Richmond and Configuration workshop at SQL Saturday Huntington Beach

Want to learn more about SQL Server? Now's a good time to get a full day of inexpensive high-quality training on the coast in March and the west coast in April. I hope you'll join me for a full-day troubleshooting and performance tuning workshop on the Friday preceding the Richmond, VA SQL Saturday in March. And in April, I'll be on the west coast presenting a full-day high-performance configuration tuning workshop preceding the Huntington Beach, CA SQL Saturday. As you probably know, I speak at a lot of conferences and events. Here are other upcoming events where I'll be … [Read more...]

Troubleshooting full-day workshop in Richmond (March) and Configuration full-day workshop in Huntington Beach (April)

Want to learn more about SQL Server? Now's a good time to get a full day of inexpensive high-quality training on both the east and west coast, in March and April, respectively. I hope you'll join me for a full-day troubleshooting and performance tuning workshop on the Friday preceding the Richmond, VA SQL Saturday in March. And in April, I'll be on the west coast presenting a full-day high-performance configuration tuning workshop preceding the Huntington Beach, CA SQL Saturday. Here are the other events where I'll be speaking: Mar 04, 2015 - Mar 07, 2015, SQLBits XIV - London, … [Read more...]

ICYMI: Sequences, CPUs, and Trimming T-Logs

Have you read any of the great articles on SQLPerformance.com? The deep-dive technical info comes from the SQL Server industry’s top experts. Here are a few great articles from the early days of the website, January 2013:   Generate a set or sequence without loops Aaron Bertrand (b|t) provides detailed performance information about a variety of methods used to generate sets and sequences in this first in a three part series. Selecting a Processor for SQL Server 2012 Glenn Berry (b|t) of SQLskills.com sheds light on the best CPU to select for your new SQL Server 2012 … [Read more...]

ICYMI: Sequences, CPUs, and Trimming T-Logs – SQL Server Performance Topics

Have you read any of the great articles on SQLPerformance.com? The deep-dive technical info about SQL Server performance issues authored by the SQL Server industry’s top experts. Here are a few great articles from the early days of the website, January 2013:   Generate a set or sequence without loops Aaron Bertrand (b|t) provides detailed performance information about a variety of methods used to generate sets and sequences in this first in a three part series. Selecting a Processor for SQL Server 2012 Glenn Berry (b|t) of SQLskills.com sheds light on the best CPU to select … [Read more...]

Does the Looming Shortage in DBAs Spell Opportunity?

In my last column, available online, I described some of the findings contained in an intriguing new survey sponsored by Ntirety, a remote database administration service provider, and published by Unisphere Research. You can read the full survey with analysis at www.dbta.com/DBTA-Downloads/ResearchReports/The-Vanishing-Database-Administrator-Survey-Of-Data-Professionals-Career-Aspirations-4791.aspx. One of the most startling and significant responses in the survey showed that 41% of data professionals intend to leave the field within the next 10 years. In that article, I also covered some … [Read more...]