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

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

Advent of Code 2017 Day 2–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

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

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

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

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