Database testing is often skipped until there is a problem. Here is my approach to testing database performance with tSQLt and SQLQueryStress.
Creating and Running an SQL Server Unit Test – Best Ways to Test SQL Queries
Testing SQL code matters as much as writing it. I show how to create and run a SQL Server Unit Test with tSQLt, the free open source framework.
SQL SERVER – Delayed Durability, or The Story of How to Speed Up Autotests From 11 to 2.5 Minutes
My friend Sergey Syrovatchenko shares how Delayed Durability helped speed up autotests from 11 to 2.5 minutes on a SQL Server 2014 project.
The Tale of the Cunning Dev, Encrypted Procedures, DAC and God Mode = ON – Experts Opinion
My friend Syrovatchenko Sergey from Devart tells a detective story about a free tool, Encrypted Procedures, DAC and God Mode. A creative read you will enjoy.
SQL SERVER – View Dependencies on SQL Server: Hard & Soft Way
Most databases I meet as a consultant have no up-to-date documentation. Here is the hard way and the soft way to check SQL SERVER – View Dependencies yourself.
SQL SERVER – Practical Tips to Reduce SQL Server Database Table Size – Experts Opinion
Practical tips to reduce SQL Server database table size, from my friend and SQL Server expert Sergey, for faster queries and smaller storage.
SQL SERVER – Story of Temporary Objects
Temp tables, table variables and more: the story of Temporary Objects in SQL Server, why you would use them and how they can help performance and scalability.