Six Scary SQL Surprises

The working life of the DBA can be punctuated by surprises, but they aren't generally nice surprises. This is especially true if the DBA is not checking and monitoring the databases for obvious things such as database corruption, and disk space. However, the really scary surprises are less obvious and provide fewer warning signs. Brent Ozar gives six scary surprises that can be avoided by the shrewd DBA.

The Basics of Good T-SQL Coding Style – Part 3: Querying and Manipulating Data

SQL was designed to be a third-generation language, expressed in syntax close to real language, because it was designed to be easy for untrained people to use. Even so, there are ways of expressing SQL Queries and data manipulation in ways that make it easier for the database engine to turn into efficient action. and easier for your colleagues to understand. Robert Sheldon homes in on data querying and manipulation and makes suggestions for team standards in SQL Coding.

How to Find Out Which Database Object Got Deleted

Greg Larsen shows you how to use the Transaction ID value to identify the object_id for a deleted table.

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

SQL Login Password Audit

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