Revisiting PASS Summit 2015

PASS SUMMIT 2015: THE AGE OF THE DATA PROFESSIONAL IS NOW The PASS Summit 2015, the largest conference in the Microsoft SQL Server world, was held in October in Seattle, WA. The event provided a look at key initiatives that Microsoft's SQL Server group has been working on and a glimpse of what's ahead for the future. READ MORE... Originally Posted November 09, 2015 … [Read more...]

Major Feature Reconfiguration For SQL Server 2016 Service Pack 1

MAJOR FEATURE RECONFIGURATION FOR SQL SERVER 2016 SERVICE PACK 1 One of the long-standing differentiators between SQL Server's Enterprise Edition (EE) and Standard Edition (SE), besides price, were the large number of features available only in EE. This is also true for other lower editions of SQL Server such as Web Edition and Express Edition. But there's big news in the air! READ MORE... Original Posted January 03, 2017 … [Read more...]

Don’t Miss the Biggest Annual SQL Server Conference, PASS Summit

I'm thrilled to be presenting once again at this year's PASS Summit, coming up in October in Seattle. I've got two regular sessions, one technical and one profession, as well as two community sessions. I hope you can join me. In case you don't know, the PASS Summit connects you with industry experts and THOUSANDS of global data professionals in a unique learning environment that empowers you with the practical knowledge you need to excel in your career. If you've never been before I strongly encourage you to consider attending. It can be a career-altering (and improving) experience! In … [Read more...]

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

Microsoft //Build and Office Events Coming to a City Near You

The //build Tour If you build software using Visual Studio or code against the Microsoft stack, you don't want to miss the //build traveling road show. The Microsoft //build tours bring the Build conference experience to you for in-depth, usable knowledge about Windows 10 and much more. There's coding sessions and lots of new product demos. You'll also get facetime with Microsoft Technical Experts to ask those tough questions, partner showcases, and opportunities to connect with your fellow peers. Register today, it's a FREE event. Two dates are just around the corner: On Wednesday, … [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: Partitioning Advice, Purging Data Bloat, and an example of TVF Misbehavior – SQL Server Performance

Here are some oldies, but goodies that I recommend you read: Two Partitioning Peculiarities and Aggregates and Partitioning Most of us know that partitions are one of the best ways to scale very large databases or very large IO workloads.  However, there are risks, two of which are explored in detail by internals master Paul White (b | t). The Price of Not Purging Holding on to data long after its useful lifespan contributes to bloat and added preventative maintenance headaches. Read this informative post from Erin Stellato (b | t), of SQLSkills.com, where you’ll find a lot of useful … [Read more...]

ICYMI: Query Optimization Phases, Observer Overhead, and Secrets of SP_Updatestats – SQL Server Performance

Do you do a bit of query tuning? Then check out this treasure trove of performance tuning advice! Optimization Phases and Missed Opportunities and Working Around Missed Optimizations Paul White (b | t) writes two fascinating blog posts that go hand-in-hand concerning query optimization.  He goes into some deep details about how the query optimizer works, comparing various versions of SQL Server, and shows you several useful ways to assess query performance. Plus, there’s one handy trace flag too! Observer Overhead and Wait Type Symptoms Joe Sack (b | t) does a deep dive on … [Read more...]

ICYMI: Troubleshooting CPU, Logging Myths, Missing Indexes, and Query Tuning Examples

Great Articles at SQLPerformance.com There are so many good articles from SQLPerformance.com this ICYMI article that it’s hard to know which are best to highlight in the limited space. So, I’ll be arbitrary and simply choose a few of my favorite entries as well look back: Troubleshooting SQL Server CPU Performance Issues This outstanding article from Joe Sack (b | t) of SQLSkills steps you through a methodical and insightful series of DMVs and queries that can pinpoint CPU issues on your SQL Server instances. Don’t just blindly create those “missing” indexes! Aaron Bertrand (b | … [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...]