Free Second Shot offer for Microsoft Certification Exams
Nothing for me to really say except if you mess up, you get a free second chance Click HERE to see...
2012-08-29
1,135 reads
Nothing for me to really say except if you mess up, you get a free second chance Click HERE to see...
2012-08-29
1,135 reads
One big question I have gotten often is “I need data, what kind of reports do you have?” It is...
2012-08-27
455 reads
The whole “7 Habits” title is so cliché so I decided to make it eight! Plus that will probably relieve...
2012-08-20
443 reads
A part of every DBA’s job is to justify all those disk space requests. The phrases “I just need it”...
2012-08-13
528 reads
Hey all you proactive SQL junkies, want to jump start your SQL 2012 Certification? Or are you just here because...
2012-08-06
446 reads
Every wonder who all your orphaned SQL Server users are on your server? Just run the script below and copy...
2012-07-30
1,415 reads
Want to learn SQL and get some real practice this December? Check out the...
By Steve Jones
I published an article today on the Data API Builder, which is a way...
By Steve Jones
dolonia – n. a state of unease prompted by people who seem to like...
Hi, I am a first time writer looking to author some content here. I...
Comments posted to this topic are about the item Do As I Say, Not...
Hi Gents, Silly question, but it's been a long time since I've done this....
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