Books

Tuning SQL Server (Second Edition)

The book suggests several techniques that can be used for ensuring performant SQL Server instances and assumes intermediate-level experience with knowledge of basic database principles (i.e. indexing, locking, etc.). 

Administering SQL Server (Second Edition)

This eBook suggests several techniques that can be used for ensuring a healthy and fully manageable SQL Server instance and assumes at least intermediate-level experience with SQL Server administration. 

Developing SQL Server (Second Edition)

This eBook features tens of articles that provide detailed information on how to develop in SQL Server and assumes at least intermediate-level experience with SQL Server development and knowledge of basic database principles. 

Recent and Selected Publications

Script to Manage SQL Server Rebuilds and Reorganize for Index Fragmentation

A super script I have authored and published on MSSQLTips.com which helps you rebuild/reorganize all your SQL Server database indexes. Check it out!

Modifying the SQL Server Model System Database to Customize New Database Settings

Learn how to properly use the "Model" system database in SQL Server in one of my articles on MSSQLTips.com. Check it out!

Top 10 Security Considerations for you SQL Server Instances

Learn about the top 10 security consideration for SQL Server by reading my article on SQLShack.

Paper: "In-Memory OLTP Simulator: The Experiment"

See how with a simple simulation of an UPDATE operation on a 5M record table against SQL Server's In-Memory OLTP Engine, a speedup of 26x was achieved!