Ben Johnston

Jan 7, 2025 | red-gate.com | Ben Johnston

I recently had an interesting production SQL Server issue that turned out to be very easy to fix. The fix doesn’t fit every workload or server, but for the limited use cases described below, it’s a simple configuration change. The general best practice for server level configurations is to leave things at default, unless there is a specific reason for changing the settings. This will outline a use case for using memory-optimized tempdb metadata. This covers a very specific scenario and workload.

Oct 19, 2024 | red-gate.com | Ben Johnston

SQL is easy to start writing. The basic syntax to start returning data is very simple. This low threshold for starting SQL hides some of the nuances that divide efficient queries from inefficient queries. As your SQL gets more complicated and you need to join multiple tables and perform intricate operations on the data, it is important to understand the basics of how queries are processed and how your query decisions impact performance.

Aug 31, 2024 | red-gate.com | Ben Johnston

An entire post on choosing the correct data types either seems like overkill or much needed and overdue. The perspective might vary based on the databases you’ve worked with recently. I decided to write this after seeing some code with data type decisions that I would classify as questionable. There are many decisions in technology that can be ambiguous, but the correct date type should be based on business rules and a set of technical guidelines.

Aug 20, 2024 | red-gate.com | Ben Johnston

This continues my series on auditing SQL Server. The fist parts covered discovery and documentation, server level hardware audits and SQL Server engine level audits. This section examines database configuration audits. As with the previous audit sections, the boundaries for the audit can be blurry. I try to stick to configuration items only, but I also discuss some code smells and items that can impact performance or might be covered in a code review.

Jul 24, 2024 | red-gate.com | Ben Johnston

This is the continuation of my series on auditing SQL Server. In the first part, I discussed basic server discovery and documentation. The next section went over server hardware configuration and audits. This section gets into detailed SQL Server configuration details. This is less relevant in a cloud environment, but there are still items to confirm. The format follows the server audit format.