Shrinking SQL Server Backup Files and Speeding Up Backups

With backup compression you can speed up our backups, while making your backups smaller.

SQL Server Referential Integrity Across Databases Using Triggers

In this tip we cover how you can implement SQL Server cross database referential integrity using triggers.

Isolation Levels in SQL Server

Details discussion on the different isolation levels available in SQL Server

Introduction to SQL Server Security — Part 2

In this article, the second in the series, Robert Sheldon demonstrates how to manage the SQL Server security with granting permissions to users, logins, and groups.

Which Version of SQL Server Should You Use?

Wait! Before you install that next SQL Server, hold up. Are you sure you’re using the right version?

Working with SQL Server Stored Procedures and .NET

Learn how to build a simple .NET application that uses SQL Server stored procedures to retrieve and update data from a database.

SQL Server Auditing for HIPAA and SOX – Part 4

Regulations may require that you audit exactly who does what in your databases. Robert Sheldon explains how SQL Server can help you meet those requirements with its built-in auditing capabilities.

Generate documents from SQL Server

Automating population of SQL Server data into Word and PDF document templates for contracts, invoices,letters etc. creation saves thousands of hours for businesses. This article explores various approaches and offers few suggestions on how to choose the best approach for your requirements.

ISNUMERIC function

Foundational Material: Microsoft SQL Server Book and Blogs From The Past

Erik Darling dusts off his favorite archival-quality bloggers and books.