Reboot
Apologies, a minor reboot of the db server this morning. Somewhere we're leaking memory, more details later, so I had...
2005-07-14
1,488 reads
Blog Posts
RunAs
When I started working at JD Edwards, I was a corporate administrator
on the windows network. Since the DBAs were a...
2005-07-12
1,526 reads
It's always something
As Phill posts in his blog, we've had a couple interesting threads in the forums where the respect and tolerance...
2005-07-11
1,436 reads
This is lovely
I got a note that someone thought they shouldn't have to register on
the site and get a newsletter to read...
2005-07-07
1,375 reads
What Is Really Interesting?
When I wrote the editorial for today on A Humbling Experience,
I was sure that it would generate a bunch of...
2005-07-07
1,493 reads
Interviewing a DBA
Andy and I had an interesting question on this today. He's trying to
hire a DBA and he had his first...
2005-07-05
1,567 reads
To Blog or Not To Blog
Blogging seemed like a big deal in 2004. At the 2003 PASS Summit, we were told by Microsoft that they...
2005-06-29
1,506 reads
My First Blog!
At least here 🙂 Normally I blog over at http://www.dkranch.net/
That's usually personal stuff going on in my life, so I'll try...
2005-06-28
1,401 reads
2001-01-01
7 reads
Privacy Policy
The Agile SQL CLub Privacy Policy (google Made me do it) The website uses cookies to track views and where you go, if you block cookies then they will...
2001-01-01
3 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
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...
The AI/Human Spectrum
Comments posted to this topic are about the item The AI/Human Spectrum
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