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

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

Fixing logins

I ran into an issue recently where I couldn’t get a Windows login to work with some application software. This...

Regular Expressions (Day 10)

Have you ever downloaded a script from an internet site, only to find that there are extra blank lines between...

The cloud is not just someone else’s computer

A year ago, I wrote in a post that cloud computing is just someone else’s data center. I was wrong. Whether...

It’s All in the Name, Index Naming Conventions

Awhile back, if you are on Twitter, you can probably recall my ranting about the 949 indexes I was reviewing....

SCOM: SQL Instance and Databases exclusion

This  post is by Chris Gibson

I recently wanted to exclude some temporary SQL databases from being discovered by our SCOM...

Comparing two SQL instances

Last week I was working on a couple of SQL instances that contained databases which were part of an Always...