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. 

Software Projects

DBA Security Advisor

Secure your SQL Server instances against misconfigurations and potential security risks.

In-Memory OLTP Simulator

Easily test the power of SQL Server In-Memory OLTP against your own custom workloads.

Snippets Generator

Easily generate T-SQL snippets in order to reuse them in SQL Server Management Studio.

Dynamic T-SQL Generator

Easily generate dynamic or static T-SQL scripts by converting a given T-SQL script.

SQL Instance Info Finder by SQLArtBits

SQL Instance Info Finder

Easily retrieve useful information about your SQL Server instances.

SQL Multi-Exporter

Easily run queries against SQL Server and export the results to XML, CSV or HTML file.

Recent and Selected Publications

Administering SQL Server (eBook) - Second Edition

The second edition of my eBook on SQL Server administration. Check it out!

Tuning SQL Server (eBook) - Second Edition

The second edition of my eBook on SQL Server tuning. 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!