Blog

TempDB and Instance Standards

One of the ‘best practice’ practices I like to consider putting in place on a SQL instance is multiple tempdb files to eliminate any chance of tempdb allocation contention.

Three Ideas for Returning Microsoft SQL Queries Faster

Would you like to make your users happy? Give them the information they need through optimization that allows SQL queries to be returned faster.

Where Can You Run SQL Server?

If you want to run SQL Server, you’re no longer limited to having it operate from a box in a closet. You have a lot of choices, some of which we cover below.

Microsoft Releases Final SQL Server 2008 Service Pack

Microsoft announced it was releasing a final update for the SQL Server 2008 Service Pack recently.

Solving SQL Server Issues: The Long Road

You can easily resolve some issues related to SQL Server performance, but there are others that require more time and resources.

Solving SQL Server Issues: The Best Bang for the Buck

There are many issues that can affect the health and stability of your SQL Server performance.

Solving SQL Server Issues: The Easy Pickings

There are several issues that can affect the health and stability of your SQL Server performance. Most can be easily resolved without an extreme technical intervention.

SQL Profiler vs. Extended Events: Time to Switch?

Many people working with enterprise technologies live by rule, “if it ain’t broke, don’t fix it.”

Managing A Healthy SQL Server Database: Three Principles We Overlook

In managing a database or sometimes numerous databases, we often get caught up in the day-to-day maintenance and lose sight of the other principles we know are critical to ensuring optimal performance.

Choosing the Right Health Check

For some businesses, conducting a Health Check can be cumbersome, time-consuming, and the results, well, frustrating.

Who is afraid of the Data Collector? (Part 2)

In a previous blog post we talked about what scares me most. Sharks and avalanches. While they may terrify me, they are still pretty cool…

Who is afraid of the Data Collector? (Part 1)

What is scary to you? For me, top of the list, it’s avalanches and sharks. And I am afraid of the Data Collector. Yup… a little-bit. And also the Management Data Warehouse.