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

If it fails where you thought it would fail that is not a failure....

Quite a long title for a short blog post ??While deploying a DACPAC (from...

Some of the best career enhancers you can buy. Why I Go to...

Comments posted to this topic are about the item A Place where AI Technology...

alternate for xp_delete_file

I have a need where I need to pass a field name to a...

What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?

SELECT OBJECT_DEFINITION (OBJECT_ID(N'dbo.uspGetBillofMaterials')) AS [Object Definition]; 
GO