Earlier this year I had a PM at Microsoft reach out and ask me what I thought about the Data API Builder. I hadn't looked at it, so I made a note to check it out. I hadn't done that by the time SQL Saturday Denver 2024 occurred, where I saw Jerry Nixon from Microsoft […]
2024-12-13
2,792 reads
This isn't really a first look, per se. I've seen Erin Stellato present on this a few times in MVP sessions and at the PASS Data Community Summit. However, this is a look on my machine, where I'm in control. The new version preview was announced recently, and this looks at the new process to […]
2024-11-25
6,055 reads
This is a list of the builds for SQL Server 2022. There are other build lists available here. A list of all the builds that I can find and install on my Build VM. If you find a build not listed here, please let the webmaster know (webmaster at sqlservercentral.com). All builds are listed in reverse […]
2024-11-15 (first published: 2022-09-01)
3,250 reads
Timescale embeds advanced AI into PostgreSQL, the most popular database, leveling the playing field and equipping every developer to build AI—fast and hassle-free.
2024-10-30
143 reads
This article looks at the old style of calculating a running total and how to convert that to code that uses a window function.
2024-09-30
2,353 reads
Azure Data Studio (ADS) is a lightweight IDE built...
2024-09-27
857 reads
A list of articles in my series on Azure Data Studio along with a few other links.
2024-09-13 (first published: 2024-01-10)
2,704 reads
A list of all builds for SQL Server 2016. Updated with CU2 for SP2 and CU10 for SP1.
2024-09-11 (first published: 2017-01-25)
39,130 reads
2024-09-11 (first published: 2018-12-18)
8,797 reads
2024-09-11 (first published: 2018-12-20)
11,230 reads
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...
By James Serra
Microsoft Fabric is rapidly gaining popularity as a unified data platform, leveraging OneLake as...
Hi Gents, Silly question, but it's been a long time since I've done this....
Hi everyone I have a query that is taking a real long time. It...
Comments posted to this topic are about the item 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