Object Explorer Drag-N-Drop (Day 14)

Did you know that items in the Object Explorer can be dragged and dropped into a query window? This can...

Happy New Year… Late:)

Yeah I know its new year and i am back from quite some time. during these days i was learning...

The SSMS Super Clipboard (Day 13)

We’re all used to using the clipboard in Windows programs. You copy something into it with Ctrl+C, and paste it...

tsqlt Tests for Advent of Code 2017 Day 2

This is day 2 of the Advent of Code 2017. If you want to read about the puzzles, start with...

Changing Case (Day 12)

In yesterday’s tip, I showed an example of changing a block of text from upper case to lower case. However,...

Creating a SQL Server Test Lab On Your Workstation – Part Two, Creating a Domain Account and Joining a SQL Server to the Domain

In the second part of our series on creating a SQL Server test lab on your workstation, I’m going to...

Friday Reading 2018-01-11

Phew, what a week! Have been looking for a new flat to live so it’s been a bit mad. Have...

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