A Microsoft SQL Server community of 1,900,073 DBAs, developers and SQL Server users

The business decides on a packaged application and buys it. After installation, you look at the schema and realize that is is a nightmare. How do you manage this nightmare?  Read more...

There are several ways to to anonymize / pseudonymize email addresses. This post discusses a few frequently used approaches, as well as how you can use Redgate Data Masker for SQL Server to achieve realistic masking of email columns.  Read more...

Check out these scripts to create SQL Server jobs and Alerts when a login is created or dropped, a database user is added or dropped and when logins are added or removed from server roles or users are added or removed from database roles.  Read more...

A fun experiment using DBCC SHRINKFILE to rebalance data.  Read more...

Greg Larsen shows you a quick trick to programmatically script a way to identify when SQL Server was last started.  Read more...

The next meeting of the Luxemborg SQL Server User Group has some great sessions planned.  Read more...

A common SQL Server crime is the unnecessary overuse of ad-hoc queries by applications. In this article, Phil Factor shares some custom queries for monitoring problems that can be caused by this.  Read more...

Make sure your SQL Server database release scripts to make life easier.  Read more...

By looking at a query execution plan, you can determine which steps are used to resolve the query. But what if you just want to find out what the query plans are for only the queries that are currently running?  Read more...

Backups. Are you confident you can restore? Do you have a process that ensures you can recover your systems? Learn how one system works in the cloud.  Read more...

vCore based performance levels are very new, currently in preview and not yet rolled out to all Azure regions (The...  Read more...

Well, it is that time of the year, again. PASS puts on a 24 Hours of PASS where 1 hours...  Read more...