SQLServerCentral Editorial

Do As I Say, Not As I Do

Yesterday morning I sat down to start a new project. Before I got started, I knew I needed to put this in source control. Now, the project was going to be in AWS, but, AWS has shut down their flavor of Git, CodeCommit. I decided to use GitHub instead, no big deal. Well, until I […]

Blogs

Playing with the Data API Builder

By

I published an article today on the Data API Builder, which is a way...

A New Word: Dolonia

By

dolonia – n. a state of unease prompted by people who seem to like...

Ways to land data into Fabric OneLake

By

Microsoft Fabric is rapidly gaining popularity as a unified data platform, leveraging OneLake as...

Read the latest Blogs

Forums

Understanding allowed topics for testing

By avishwan

Hi, I am a first time writer looking to author some content here. I...

Do As I Say, Not As I Do

By Grant Fritchey

Comments posted to this topic are about the item Do As I Say, Not...

Filter a SQL Server Audit with a predicate

By michal.lisinski

Hi Gents, Silly question, but it's been a long time since I've done this....

Visit the forum

Question of the Day

The New Log File

I have a detached database from SQL Server 2019, called TDE_Primer. This database had a 100MB data file and a 73MB log file. The log file was lost, so I need to run this code:

USE [master]
GO
CREATE DATABASE [TDE_Primer] ON 
( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\TDE_Primer.mdf' )
 FOR ATTACH_REBUILD_LOG
GO
How big is the new log file?

See possible answers