Changing the Path for the Master Database

Link Below:

Changing the Path for the Master Database
This article will show how we can move the master database to a...

DevOps Does Not Make Admins Obsolete

As a follow up to my tweet, I stand by my belief that DevOps does not make administrators obsolete. I...

Fun with sp_rename

Currently the only way to rename objects in SQL Server is to use sp_rename. Although that may be changing in...

How to Change the File Extension for a Data File

Link Below:
How to Change the File Extension for a Data File
In general, the file extensions that we use for SQL Server data files are MDF (Primary Data File), NDF...

How to Change the File Extension for a Data File

Link Below:

How to Change the File Extension for a Data File

In general, the file extensions for our SQL Data Files...

How to fix Orphaned Users easily

What are Orphaned Users
“Orphaned Users” is a common issue in SQL Server where a Database User is no longer associated...

SQL Server Configurations – Back to Basics

One thing that SQL Server does very well is come pre-configured in a lot of ways. These pre-configured settings would be called defaults. Having default settings is not a...

SQL Server Configurations – Back to Basics

One thing that SQL Server does very well is come pre-configured in a lot of ways. These pre-configured settings would...

T-SQL for Performance and Accuracy – Vern Rabe: A preconference essential for anyone using SQL Server

SQL Saturday Preconference: February 9th, 2018 in Redmond, WA Do you think you write T-SQL queries that perform well?  Think...

T-SQL Tuesday #98 Round Up

Thank you to everyone that took the time to write and contribute, I enjoyed reading about how you conquered your...