SQL Injection is not a SQL Server problem, it comes from coding habits. Here is one trick of handling dynamic SQL to avoid SQL injection attack on a search page.
SQL SERVER – Invoking a Stored Procedure from Azure Mobile Services – Notes from the Field #066
Can you call a SQL stored procedure from Azure Mobile Services? In Notes from the Field #066, Kevin Hazzard shows how, with a bit of humor along the way.
SQL SERVER – How to fix the SQL Server Error 8657 or 8658?
Error 8657 and 8658 appear when a query or columnstore index build needs more memory than its Resource Governor workload group allows. Here is the fix.
SQL SERVER – Script – When/Who did Auto Grow for the Database?
A reader saw the database file grow every day with very few users. Here is a script to find when auto grow happened for a database and who triggered it.
SQL SERVER – How Can Deadlock Happen on Same Table?
How can deadlock happen on same table? A World Chess Championship match inspired this post, where I walk through how two sessions can block each other.
Interview Question of the Week #005 – List All the Tables with Name Containing Specific String
Find SQL Server tables whose names contain a specific string, handle literal underscores, and include schemas without a date filter.
Reads per Execution: Ranking Queries by Average I/O
The query with the most total reads is not always the one to tune first. Here is how to rank by cost per call and read the spread.