SQL Server 2016 Storage Limits

Validate Integer and Decimal Values in SQL Server

Bhavesh Patel shows how to validate specific use-cases for integer and decimal values in SQL Server.

SQL Server 2014 system databases

Doing Fuzzy Searches in SQL Server

A series of arguments with developers who insist that fuzzy searches or spell-checking be done within the application rather then a relational database inspired Phil Factor to show how it is done. When the database must find relevant material from search terms entered by users, the database must learn to expect, and deal with, both expected and unexpected.

PowerShell 3rd Party tool Memory Alert

Keeps a memory leak under control until the bug fix is developed and applied. Short term band aid.

Using PerfMon and PAL to Diagnose SQL Issues

Free tools to help you find and diagnose SQL issues

Dynamic SSRS report documentation via a ReportServer.dbo.Catalog query

This article demonstrates a method of generating SSRS report documentation by using an SSRS report that queries the ReportServer.dbo.Catalog table.

SQL Login Password Audit

Audit your SQL logins to find passwords that have never been changed or that are very weak.

Azure Data Warehouse 7: Create reports in Azure SQL DWH using SSRSS

In this article, we will show how to create reports in ASDW using SSRS

Backups in Azure SQL Data Warehouse

This time we explain how to recover an Azure SQL Data Warehouse (ASDW) from a disaster.