Blog

4 min read

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.

3 min read

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.

4 min read

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.

3 min read

Microsoft Releases Final SQL Server 2008 Service Pack

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

4 min read

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.

3 min read

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.

3 min read

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.

3 min read

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

4 min read

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.

5 min read

Choosing the Right Health Check

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

6 min read

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…

5 min read

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.