Grant Fritchey

Grant Fritchey is a SQL Server MVP with over 20 years’ experience in IT including time spent in support and development. Grant has worked with SQL Server since version 6.0 back in 1995. He has developed in VB, VB.Net, C# and Java. Grant has authored books for Apress and Simple-Talk, and joined Red Gate as a Product Advocate in January 2011. Find Grant on Twitter @GFritchey or on his blog as the Scary DBA.

Blogs

Finding the Latest Backup Timestamps for Your Databases

By

Finding the Latest Backup Timestamps for Your Databases I wanted to find out the most...

Using SQL Elastic Pools

By

We use SQL elastic pools at work. I needed to learn more about their...

Webcast: How to Secure SQL Server – End to End Security

By

On April 16, 2024, I will be giving another webcast; this one will be...

Read the latest Blogs

Forums

Database Mirroring is Back in Azure SQL Database

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Database Mirroring is Back in...

Tracking Database Growth - Script Automation & Reporting

By EM2

Hello,   I found this script that helps me in populate a table with...

Outer join table where there is 2 foreign keys to join

By mjohnson 71479

I am asked to provide a date in a query from a table that...

Visit the forum

Question of the Day

The Cloned Database Size

I have a small test sandbox database on an instance with default master, model, msdb, and tempdb settings. The database has these files:database file propertiesI now run this command:

DBCC CLONEDATABASE(sandbox, sandbox_clone);
GO
When I examine the database file properties, what do they show?

See possible answers