Guidelines and Requirements

We have some requirements that we meet a particular setting or value, but often we have guidelines and recommendations. Do you know the difference?

Copying Production Schema

Change Tracking Default Retention

What is Delayed Durability in SQL Server — And Should You Turn It On?

Learn about delayed durability in SQL Server and how it might help you with a heavily loaded server.

Which MAXDOP?

New Backup Compression

Common SQL Server Problems: Network Related or Instance Specific Error Occurred

This is the first in a series of articles meant to provide practical solutions to common issues. In this post, we’ll talk about one of the most pervasive error messages out there:

Automating SQL Server Access Review

Learn how you can automate checks and reports to l...

Retrieving SQL Server Index Properties with INDEXPROPERTY

SQL Server has several functions to assist with meta data about the server, databases, indexes, and more. In this tip, we will look at how to get index information for indexes in a database using the INDEXPROPERTY function.

Recovering data in SQL Server without full backup

There are multiple reasons for no full backup: corrupted backups, taking too much time to restore, etc. In this post, I want to show an alternative for these cases, an ace up one’s sleeve, that you can use to recover data.