Category: General DBA
Default Database Issues and Best Practices
Protecting Against SQL Injection
Understanding SQL Server 2008 R2 Fixed Database Level Roles
Backing Up a SQL Server Database Directly Onto a Remote Server
A Primer on Log Shrinking and Truncation in SQL Server
How to Optimize SQL Server Query Plans – The Devil is in the Detail
Extended Events in SQL Server 2012
Restoring a SQL Server Database – A Practical Example
A Journey from OLTP to OLAP- Part 2