2024-11-27
74 reads
2024-11-27
74 reads
2024-11-25
142 reads
There were a number of T-SQL functions added in SQL Server 2022. Today Steve asks if you are using any of these in your work.
2024-11-22
269 reads
There is no shortage of mundane tasks at work. Steve Jones notes that you might not want to depend on those to fill your day in the future.
2024-11-20 (first published: 2015-05-18)
431 reads
The challenges of managing lots of system are significant and there aren't easy solutions, but Steve has a few thoughts on what you can do.
2024-11-18
190 reads
Today Steve wonders if official solutions from a vendor are that important.
2024-11-15
92 reads
Today Steve wonders how many software developers use separate connections for reads and writes in their application.
2024-11-13
96 reads
Many of you can't choose your team, or even change teams if you want, but from an organizational perspective, it might be the right thing to do. Whether you like it or not.
2024-11-11
128 reads
2024-11-08
92 reads
2024-11-06
164 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...
You can find the slides for the session Building the €100 data warehouse with...
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