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

This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...

Recently a customer asked if SQL Compare and SQL Data Compare can be used...

I am off to Live 360 today, on my last trip of the year....

I have an application team that is insisting on daily (and for some, weekly)...

i see this in the definition of a linked server on our wh sql...

Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...

What does this code return in SSMS 20 from SQL Server 2019?

select '|' + CHAR(0)+'abc' + '|';