Featured

SQL Tips, tsql

SQL Server intelligent Database compression script with error handling

April 10, 2018 — 1 Comment

SQL Server, SQL Server Administration, sql server performance, SQL Tips, tsql

SQL Tip: Faster SQL native backups without any hardware or 3rd party software

May 2, 2019 — 0 Comments

backup, SQL Server, SQL Tips, tsql

SQL Tip: Empty space release from large databases. Small chunks at a time

April 16, 2018 — 0 Comments

Uncategorized

Description of support for SQL Server databases on compressed volumes

January 24, 2018 — 0 Comments

SQL Tips

SQL Tip: Pre and post installation checklists

October 5, 2017 — 0 Comments

SQL Tips, tsql

SQL Tip: Change owner on all Agent Jobs – TSQL code

October 5, 2017 — 0 Comments

powershell, SQL Server, SQL Tips

SQL Tip: Afraid of PowerShell? Use Dbatools.io with Powershell ISE

September 29, 2017 — 0 Comments

Visual Studio

Upgrade from TFS 2010 to TFS 2017 (with SQL 2016). Fast!

September 29, 2017 — 3 Comments

Column Store Indexes, SQL Server, sql server performance, Uncategorized

SQL Tip: Identifying Column store index potential candidate tables in your databases for major query performance improvements

August 11, 2017 — 0 Comments

Monitoring, SQL Server, SQL Server Administration, sql server performance

SQL Monitoring Solution Development – SQL Performance Dashboard Reports – Part 2 Customisation for centralised remote monitoring of SQL instances

August 4, 2017 — 0 Comments