Another Reason to Hate Ads
Malicious code embedded inside advertisements served on the web. What's next?
2007-12-13
62 reads
Editorials
The Downside of Real Time
Everyone wants real time reporting, or do they? Steve Jones talks about some of the downsides of implementing such a system.
2007-12-12
115 reads
Do We Need a PK?
A primary key is a must for every table. Or is it? Steve Jones examines the question.
2007-12-11
438 reads
Hipp, Hipp, Hooray
In an age where commercial interests seem to trump all, it's nice to see someone delivering content out there for free.
2007-12-10
109 reads
All I Want For Christmas Is ...
What do IT workers want for Christmas? Let us know in this Friday's poll.
2007-12-07
53 reads
A Smart Smartphone
Cell phones are great communication tools, but that's mostly what they do, even for IT folks. But Steve Jones talks about some other possibilities and potential problems.
2007-12-06
45 reads
Breaking Things Apart
Microsoft is unbundling their new hypervisor from Windows. Could this happen with SQL Server?
2007-12-05
40 reads
The Weekly Update for Dec 2, 2007
A few notes and comments on the database news from the previous week.
2007-12-03
15 reads
The 5 Stages of Volunteering
Volunteers are important to ensuring the success of so many organizations. IT-based organizations, such as user groups, are no different. Steve Jones leads you through a few of the stages of being a volunteer and hopes more of you will participate in your local area.
2007-11-29
49 reads
2007-11-28
78 reads
Blogs
Playing with the Data API Builder
By Steve Jones
I published an article today on the Data API Builder, which is a way...
A New Word: Dolonia
By Steve Jones
dolonia – n. a state of unease prompted by people who seem to like...
Ways to land data into Fabric OneLake
By James Serra
Microsoft Fabric is rapidly gaining popularity as a unified data platform, leveraging OneLake as...
Forums
Filter a SQL Server Audit with a predicate
Hi Gents, Silly question, but it's been a long time since I've done this....
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