My Tech Reading List to Start the Year

My bold learning goals call for adequate preparation and proportionate action. Before plunging into the challenge, I need to get...

Block Select/Replace (Day 11)

While Regular Expressions lets us work with text not cleanly formatted, if you are trying to work with text that...

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...

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 new location.
The ALTER DATABASE command would work for moving...

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 for our SQL Data Files...

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 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...