Do We Understand Data?
With the recent issue of Facebook/Cambridge Analytica and GDPR, I ask do we really understand "data"?
2018-06-01
140 reads
Scott Crosby
The Politics of SQL Security
Dealing with SQL Server security when the application it uses is full of security holes.
2016-05-23
185 reads
Getting It Right First Time. Almost?
Mistakes happen but how can we minimize them and deal with them whey they do happen?
2014-08-05
205 reads
Wandering Towards The Lonely Cloud?
Are all RDBMS heading towards "The Cloud"? Is this something we DBAs and consultants should be doing for our client?
2014-06-05
98 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
What Are the Best Washbasin Faucets for Modern Bathrooms?
In order to create a unified and useful design, selecting the finest washbasin faucets...
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
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