Shutting down multiple servers with Powershell
I’ve recently helped a company move their infrastructure to a new data centre. Part of this involved shutting down a...
2014-01-09
536 reads
The DBA Who Came In From The Cold
Happy New Year!
Happy New Year!
Hope you all had a good Xmas, ate too much, drank too much and are still telling yourselves...
2014-01-02
320 reads
Disaster Recovery Planning
As a SQL Server DBA it is absolutely vital you regularly take backups of the databases you look after. If...
2013-11-26
432 reads
My favourite online references
There is a wealth of information about SQL Server online. Absolutely hundreds of blogs, white papers, editorials, the list goes...
2013-11-19
410 reads
My 5 pieces of advice for new DBAs
As my first post, I thought I’d list a few points that I would say to any new DBA. I’ll...
2013-11-07
792 reads
Blogs
Ways to land data into Fabric OneLake
By James Serra
Microsoft Fabric is rapidly gaining popularity as a unified data platform, leveraging OneLake as...
A Very Cool Benefit in SSMS 21
By Steve Jones
I saw a post from Erin that Preview 2 is available. I’d gotten a...
AI Helping with an API
By Steve Jones
Can an AI help me with some database API work? Let’s see. This is...
Forums
How to speed up this query?
Hi everyone I have a query that is taking a real long time. It...
The New Log File
Comments posted to this topic are about the item The New Log File
Getting Started with the Data API Builder
Comments posted to this topic are about the item Getting Started with the Data...
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 GOHow big is the new log file? See possible answers