How to Load SQL Server Error Log into Table for Analysis

February 14, 2020February 14, 2020 Jeff Mlakar1 Comment

A while ago I wrote a post about the SQL Server error log. Today I will show how to load the SQL error log into a table for analysis via T-SQL.

Read on to see a couple of ways to traverse all the error logs and load into a table for analysis.

How to Generate Scripts In SQL Server

May 31, 2019May 30, 2019 Jeff Mlakar2 Comments

There are multiple methods for exporting data from SQL Server. We will explore a few and focus on the “Generate Scripts” feature in SSMS.

Feature Image / License

Wait Statistics in SQL Server – Performance Troubleshooting

March 8, 2019March 11, 2019 Jeff Mlakar2 Comments

Wait statistic are a fundamental concept of any RDBMS. Let’s review some basics of troubleshooting performance issues with wait statistics.

SQL Server Data Compression – Crunch Time!

February 22, 2019February 28, 2019 Jeff Mlakar1 Comment

There are many articles online describing SQL Server data compression. In this post I will summarize some of the salient points.

Feature Image / License

How to Analyze the SQL Server Error Log

November 2, 2018November 2, 2018 Jeff Mlakar2 Comments

The SQL Server Error Log is one of the most useful thing to troubleshoot database server issues. System errors get logged here along with a host of other useful information.

Read on to see how to understand, analyze, and manage the SQL Server Error Log…

Stop and Think Before You Shrink – Shrinking a SQL Server Database

September 25, 2018September 24, 2018 Jeff Mlakar1 Comment

I like Halloween so I find myself getting mentally ready each year about a couple of months prior. My mind turns to horrors and I must warn wary travelers in DBA-land about an evil I see all too often – shrinking a database.

I know this has been done to death but I still see it. Gather around the fire as I tell you the ills of shrinking database files.

Working With Different Languages in SQL Server

September 4, 2018March 12, 2019 Jeff Mlakar1 Comment

Today I want to talk about some of the language settings in SQL Server and the impact they have. Read on to see about setting up a default language in SQL Server, setting language for a scoped session, and differences between SQL Server and Windows Server settings.

How to Move and Configure tempdb Files

August 10, 2018August 9, 2018 Jeff Mlakar1 Comment

Every SQL Server instance relies heavily on tempdb to function. Because of this it is important to properly setup and configure tempdb. If you work on a system with a sub optimal tempdb setup then you may have to move files. Read on to see a technique for getting this job done.

SQL Server Database Corruption! Fixing and Preventing

July 24, 2018July 21, 2018 Jeff Mlakar4 Comments

In my previous post, SQL Server Database Corruption! Understanding and Diagnosing, we talked about database corruption. We discussed what it was so we could better understand the threat we face. Then we learned how to diagnose database corruption. Today we are going to talk about remediating and preventing database corruption.

If you haven’t already read the previous post please read it first.

SQL Server Database Corruption! Understanding and Diagnosing

July 20, 2018July 30, 2018 Jeff Mlakar4 Comments

Of all the things that can ruin your day as a DBA and possibly get you fired, database corruption ranks right up there with backups and security enforcement of the database. Database corruption can be a resume generating event! A corrupt database can affect system stability, lead to unnecessary downtime, and possibly the loss of some data. To manage the risk you must know what database corruption is, how to diagnose, how to fix, and how to prevent.

Read on to learn how to understand and diagnose database corruption.

UPDATE: Part 2 on Fixing Database Corruption