Software Projects

DBA Security Advisor

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

Snippets Generator

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

Dynamic SQL Generator

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

In-Memory OLTP Simulator

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

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.

eBooks

Tuning SQL Server (Second Edition) - eBook

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) - eBook

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 with SQL Server (Second Edition) - eBook

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. 

TechHowTos Vol.1 (eBook)

Tech How To's Vol.1

Do you love Technology? By reading this eBook, you can learn more about different technology topics such as: Databases, Programming, Search Engine Optimization, Software and Database Security, Trending Technologies and more. 

My Free Online SQL Server Services

SQL Server Service Pack and Cumulative Update Info

Easily retrieve useful information about the latest service pack and cumulative update for any version of SQL Server. Check it out!

SQL Server Backward Compatibility Check

Easily retrieve useful information about the backwards compatibility support for any version of SQL Server. Check it out!

Recent and Selected Publications (...check them all here)

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!