SQL Server Tune Your Transaction Log

Whenever a transaction log file grows the space it is allocated is divided up into virtual log files (VLFs). Depending...

Stop Worrying About Index Fragmentation and Manage Your Statistics

I see a lot of posts online about rebuilding indexes in a scheduled maintenance task, this is a pretty intensive...

Fixing a SQL Server That Wont Start Due To Max Memory Being Set Too Low

I recently came up against a SQL Server instance that wouldnt start, after going through the event log the reason...

SQL Server Unique Constraints With Where Conditions

Imagine we have the following table

Users
FieldTypeIdINTUsernameNVARCHARDeletedBITThen imagine we want Username to be unique for non deleted users. Normally we would...

Upgrade Your SQL Server CASE Statements With IIF and CHOOSE

SQL Server 2012 introduced IIF and CHOOSE functions and I completely missed they even existed until recently. They make some...

SQL Server 2017+ How To Replace Multiple Characters In A Single Statement With TRANSLATE

The REPLACE function in SQL Server has until now been quite limited. SQL Server 2017 has introduced a new TRANSLATE...

Level Up Your SQL Server Cross Platform Skills With mssql-scripter

The ability to export a script of database objects has for a long time been a feature of SQL Server...

SQL Server 2017 Concatenation With STRING_AGG

One of the new less publicized features in SQL Server 2017 is STRING_AGG. This new feature can take an expression...

SQL Server Installed and Running on macOS In Less Than 5 Minutes (With Video)

SQL Server 2017 is the first version of SQL Server that will also run natively on Linux and on macOS...

SQL Server 2017 Graph Data Features In Action

The Wikipedia Graph Database page has the following definition…
In computing, a graph database is a database that uses graph structures...