SQL Server administration and development

Blog inspired by Erik Darling’s book: “Great Post, Erik”, and my friend Mark @tSqlTidy

I am a SQL Server DBA a.k.a “The F5 guy” as I get to press F5 a lot. I have worked with SQL Server for over 10 years as a consultant, DBA and developer. There are a lot of very clever people out there who know much more about SQL and who have better writing and blogging skills than I do. However, Erik’s book made me stop being Certain Kind of Person and start sharing my work. @tSqlTidy convinced me there is always a need for the new content for the ever-growing SQL family. Thanks! Writing my own blog also helps me learn and dig deeper into various problems.

How to read large SQL Server ERRORLOG (the 5GB test)

Let’s take a look at different ways of reading the SQL Server ERRORLOG….I often come across large ERRORLOGS mainly because they are not being recycled frequent enough, or not at all. Sometimes, despite the frequent recycling, the ERRORLOG can grow to unmanageable size. This has recently happened to me during a large transaction rollback over Synchronous Availability Group. Within a few hours, the ERRORLOG log grew to 5GB in size due to “Sending page request for Undo” messages. …read more

Database Development in Visual Studio

A lot of database administrators and developers like to use the SQL Server Management Studio to make changes to the database schema directly. As a production DBA, I can definitely say that there are situations where this is acceptable and even desired, however, in most cases a Visual Studio Database Project is a much better approach. I have made a switch from developing in SSMS to Visual Studio several years ago and never looked back. …read more

SQL Agent Jobs Timeline with dbatools.io (download)

An important element of performance monitoring is knowing what SQL agent jobs run at what time to understand and avoid potential clashing. Notice the underlined what time – time correlation is very important when it comes to performance but finding it is not always easy. I wrote a simple PowerShell script to help visualise what jobs run and when …read more

SQL Server Performance Dashboard using PowerBI (download)

I often help improve the performance of a SQL Server or an application. Performance metrics in SQL Server are exposed via Dynamic Management Views (DMVs). However, DMVs only provide a view of the current state and no history. This is important as it makes it particularly difficult to draw a bigger picture of how the system is behaving over time and what problems are occurring during overnight batch processing or during peak operational times, for example when users log in to the system at 8 am or when they leave for lunch at 1 pm. To address this deficiency I have built a simple yet comprehensive SQL Server Performance Dashboard in PowerBI. …read more

Hello World! – How I built this blog

The engine This blog runs on the free and the most popular blogging platform WordPress. You can download a copy from wordpress.org/download. I host this blog myself but if you do not have your own server, there are many hosting providers that support WordPress including WordPress.com themselves. Go to wordpress.com for details. Styling WordPress is written in …read more

This site, like most websites, uses cookies. By continuing to use this website, you agree to their use.