My Best Blog Posts from 2015

ALWAYS LEARNING About mid-way into August of 2015, I learned some important new factors in Search Engine Optimization (SEO) that caused me to make some big changes to the way in which I blogged. Namely - simply reposting a slight variant of a given blog post could hurt your overall SEO rankings for any of the given posts. Now you might be saying to me "Kevin, those aren't new factors. They've been around for a long time, you idgit". And I would say in response "Ok then. But I had other things on my mind". (Of course, if you have other recommendations for improving one's blog performance, … [Read more...]

ICYMI: Parameter Sniffing, Friends with Partition Benefits, and SELECT INTO Parallelism – SQL Server Performance

Great topics for further reading about tuning SQL Server performance: Exploring SQL Server 2014 SELECT INTO Parallelism Joe Sack (b | t) provides us with a peak into the performance improvements and new behaviors of SQL Server 2014 in the way it can now parallelize large SELECT INTO operations. Parameter Sniffing, Embedding, and the RECOMPILE Options Parameter sniffing is a term used to describe the processes by which SQL Server attempts to reuse execution plans where certain parameters might frequently change. If you’re only familiar in passing with the term, it probably has … [Read more...]

ICYMI: Troubleshooting Availability Groups and the Schema Switcharoo – SQL Server Performance

Aaron Bertrand (b | t) is on a roll this month's SQL Server performance highlights with more great articles from   Troubleshooting AlwaysOn – Sometimes it takes many sets of eyes Aaron Bertrand (b | t) hit some obstacles recently when configuring an Availability Groups lab environment. This post shows how some assistance from the community helped him isolate and solve the issues. Another argument for stored procedures Learn the subtle ways that ad hoc queries can interfere with SQL Server performance by taking up more space in the plan cache than … [Read more...]

ICYMI: the Halloween Problem and DBCC CheckConstraints – SQL Server Performance

Don't miss these great articles on from the industry’s top experts: A Look At DBCC CHECKCONSTRAINTS and I/O Erin Stellato (b | t) of SQLskills takes a deep look into the SQL Server performance impact, especially I/O, of running DBCC CHECKCONSTRAINTS, including explaining why some check methods may consume a lot more I/O than others. The Halloween Problem, Part 1 of a 4-Part Series Paul White (b| t) provides unique insight into a long-standing data modification issue, the infamous Halloween Problem.  Much has been written over the years about understanding and … [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...]

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

Have you read any of the great articles on 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 sheds light on the best CPU to select … [Read more...]

DBTA – 6 Reasons to Think About Upgrading to SQL Server 2014

  If you’re an IT manager, the first thing I’d like to tell you is how invested Microsoft is in SQL Server. While earlier incarnations of executive leadership focused in other areas (anyone remember “Developers! Developers! Developers!”?), Microsoft’s new leadership is very bullish on SQL Server. And, why not? After Microsoft Office and Windows Server, SQL Server is Microsoft’s third biggest money-making product line. Check out the recording of the “Accelerate your insights” webcast, about SQL Server 2014, featuring appearances by CEO Satya Nadella, COO Kevin Turner and CVP Quentin … [Read more...]

SQL Injection – Why the Heck Does this Keep Happening?!

  I'm decidedly old-school in a few of my habits. My morning routine, barring anything out of the ordinary, is one such example. Typically, I'll get up between 6:30 to 7:00 am, grab my first cup of coffee, and then chat with my daughters for a few minutes before seeing them off to school. Next, I make a bowl of oatmeal (a great choice for diabetics like me), pour a second cup of coffee, and browse the local paper, The Tennessean, while I have breakfast. On the morning of August 5, I had the added pleasure of spewing said coffee and oatmeal all over my morning paper when I read the … [Read more...]

DBTA – PowerBI: The Self-Service BI App That Can Change Your Life

Here’s a real-world story: Data collection and analysis is, ironically, for a data management profession, one of the toughest parts of my job. I regularly pull data from our various databases and packaged application reporting systems for CRM, licensing, and user information. If you’ve ever worked with a packaged product, such as a CRM system, that includes reporting and querying features, then you know how inflexible they are. It can be infuriatingly difficult to get data out of these systems, systems for which you paid big money, without losing sleep, hair, and peace of mind. Working with … [Read more...]

IT Pro Events & Free Stuff for the Central USA – Jan 2015

Central USA IT Pro Community News – Jan 2015 There are lots of free, in-person and virtual events happening in the central USA over the next few weeks. Don't miss out on training, ebooks, and other goodies! Upcoming Events Jan 10th – Kansas City – SharePoint Saturday Jan 14th – Online – A lap around Azure Websites Jan 15th – Detroit – BDPA Tech Meetup Jan 17th - Nashville - SQLSaturday #363 I'll be presenting two sessions at this event, along with many of the industry's leading experts. Come join us! Jan 19 – Detroit – Microsoft Web Camp Jan 19 – Chicago – Microsoft … [Read more...]