Author: SSWUG Research

Community

Restoring Your Database Safely

By Joe Lax – As I’ve shown in my previous 10-Minute Solution, “Choosing the Right Backup in SQL Server,” SQL Server provides you with numerous ways to back up your database, allowing you to choose the options that best suit your situation. However, the best backup solution comes to naught if you don

Community

SQL Server Locks – Introduction

by Michael Balloni – Relational databases like Microsoft’s SQL Server use locks to prevent multiple users from making conflicting modifications to a set of data: when a set of data is locked by a user, no other users can modify that same set of data until the first user finishes modifying the data a