SQL System Database

In this second part of this article we look at how to move the SQL Server master database files to a different location.

2021-06-21

Five facts about the SQL Server Model Database

In this article we cover interesting facts about the SQL Server model database and how new databases inherit properties from the model database.

2021-04-08

In this article we cover some interesting facts about the SQL Server TempDB database that could be useful to know.

2021-03-22

Hey data friends! This blog is to discuss an edge case I’ve run into...

I was experimenting with a local model (article) and as a part of this,...

Redgate Monitor has grown tremendously from its early days and I find many customers...

At work we have quite a few databases that I'm frequently browsing. This is...

So I backup & restore db as db_copy. within both there is a proc...

I want to transpose sql table rows to columns. I have written a query...

What are the restrictions for defaults on columns declared as sparse?