How Can the SQL Server Resource Governor Help You?

February 10, 2017 by Leave a Comment

MANAGING ‘NOISY NEIGHBORS’ IN SQL SERVER If you've been managing databases for any length of time, you've probably had to contend with the "noisy neighbors" scenario. In this scenario, you have several applications, each with their own database residing on a single instance of SQL Server, which don't share the resources of the server nicely. To deal with this issue, you might want to investigate Resource Governor as an alternative. READ MORE... Originally Posted in DBTA Magazine in June 09, 2015 … [Read more...]

Filed Under: Administration, Databases, DBA, DBTA, Performance, SQL Server, SQLMag Tagged With: , ,

My Best Blog Posts from 2015

January 31, 2016 by Leave a Comment

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

Filed Under: Challenges, Databases, DBA, IO, PASS, Performance, Presentations, SQL Server, SQLMag, Video Tagged With: , , , , , ,

The Top 10 Mistakes Made by SQL Server DBAs

August 10, 2015 by Leave a Comment

THE TOP 10 MISTAKES MADE BY SQL SERVER DBAS The SQL Server world has its own set of challenges when it comes to database administration. One of the biggest challenges is that there are never enough skilled DBAs. Consequently, many people who are not true DBAs are pressed into service, perhaps a Windows SysAdmin or the lead developer on an application using a SQL Server back end, so-called "accidental DBAs." That means that people doing DBA work on SQL Server frequently do not know the fundamental technical details or the processes and practices commonly used by experienced enterprise DBAs. … [Read more...]

Filed Under: Administration, DBA, DBTA Tagged With: , , ,

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

April 6, 2015 by 2 Comments

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

Filed Under: Performance, SQL Server, SQLMag, Transact-SQL Programming Tagged With: , ,

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

March 9, 2015 by 2 Comments

Aaron Bertrand (b | t) is on a roll this month's SQL Server performance highlights with more great articles from SQLPerformance.com.   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...]

Filed Under: SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post, Transact-SQL Programming Tagged With: , ,

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

March 2, 2015 by 2 Comments

Don't miss these great articles on SQLPerformance.com 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...]

Filed Under: IO, Performance, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post, Transact-SQL Programming Tagged With: , ,

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

February 26, 2015 by 4 Comments

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

Filed Under: Performance, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post, Transact-SQL Programming Tagged With: , ,

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

February 23, 2015 by 2 Comments

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

Filed Under: Hardware, IO, Performance, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post, Transact-SQL Programming Tagged With: , , , ,

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

January 26, 2015 by 1 Comment

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

Filed Under: Administration, DBTA, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post Tagged With: , ,

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

January 19, 2015 by 2 Comments

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

Filed Under: Cloud, Coding, Databases, DBTA, IT Horror Stories, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post Tagged With: , , , ,
« Previous Page
Next Page »