Month: June 2012

Five Things That Fix Bad SQL Server Performance

Last Updated April 2, 2017

Is your SQL Server slowing you down? Are bad queries giving your application a case of the blues? Before you go looking for help with SQL Server, make sure that you’ve done everything you can to solve the problems on your own. Many of SQL Server’s ills can be solved with some easy preventative maintenance,…

The Use and Abuse of RECOMPILE in SQL Server (Video)

Last Updated June 26, 2012

Kendra Little

What are the costs when you ask SQL Server to recompile a statement or a stored procedure each time it runs? In this 30 minute talk Kendra Little explains the impact on query execution– and on your SQL Server instance– of forcing recompilation. This talk is appropriate for DBAs and Developers who have a working…

Why Your SQL Server’s Network Connection Matters

Last Updated February 9, 2017

Brent Ozar

Always On Availability Groups, Clustering

If you’re using SQL Server 2012’s hot new AlwaysOn Availability Groups feature, your databases will go offline when your network connection does – even if you’re using asynchronous replication. This is not a bug. This is working as designed – and it’s important to understand the underlying concepts. Nothing to see here, I'm just going…

Three Free Tools to Catch Killer Queries – Training Video

Last Updated July 20, 2013

Brent Ozar

SQL Server

What’s slowing down production? It’s easy to find out in 60 seconds by running a simple plan cache query. See, in order to turn your beautifully written query into a set of results, SQL Server needs a plan – an execution plan. It caches these plans in memory along with statistics like the number of…

We’re Presenting at the #SQLPASS Summit 2012!

Last Updated February 9, 2017

Brent Ozar Unlimited Team

#SQLPass

All four of us – Brent, Jeremiah, Jes, and Kendra – got sessions approved for the PASS Summit in November! Here’s what we’ll be covering: Shazam! We’re speaking at the PASS Summit! A Developer’s Guide to Dangerous Queries – Jeremiah Peschka Jeremiah says: “SQL Server does a good job of working with whatever garbage we…

What I Learned at #MSTechEd North America Last Week

Last Updated June 17, 2012

Brent Ozar

Last week, I soaked up sun, rain, and knowledge in Orlando, Florida at the annual Microsoft TechEd conference. It’s a huge conference with something like 10,000 attendees, and it covers development and administration for Windows, SQL Server, SharePoint, and more. Between the keynotes, sessions, and attendee chats, here’s what I learned: Microsoft’s cranking out the…

Everything You Know About Clustering is Wrong

Last Updated February 9, 2017

Brent Ozar

Clustering

Remember that weirdo in high school who had no social skills? Couldn’t get a date, worked at the fast food joint as a fry cook, face covered with zits – you know the one. Okay, actually, it was us. Anyway, the point is, we got our act together, didn’t we? So did Windows Failover Clustering. …

Meet Our SQL Storytelling Winner

Last Updated March 26, 2014

Brent Ozar Unlimited Team

SQL Server

#SQLCruise Alaska: Class is In Session! The Brent Ozar Unlimited® crew sailed on SQLCruise Alaska last week. Brent, Jeremiah, and Kendra each taught a session (or two) on the cruise. There was much talk of transactions, performance killers, and SSDs. There were lessons on backups, PowerShell, and boat drinks. As a sponsor, we got to design…

Simulating OLTP Queries: How to Run Load Tests Against SQL Server with HammerDB

Last Updated February 14, 2017

Kendra Little

Load Testing, SQL Server

Do you have a SQL Server that’s not getting enough action? Maybe you have a new piece of production or lab hardware that you’d like to benchmark, to see how it compares with other gear in your environment. Or maybe you just want to run some activity against your own test SQL Server instance to…