SQL Agent job history on a Managed Instance
The defaults for saving SQL Agent Job history are ok (at best), so you should probably check and update them ... Continue reading
2023-08-09 (first published: 2023-07-25)
253 reads
The defaults for saving SQL Agent Job history are ok (at best), so you should probably check and update them ... Continue reading
2023-08-09 (first published: 2023-07-25)
253 reads
One of the wonderful things about blogging is the ability to make notes for future me. Which is basically what ... Continue reading
2023-08-02 (first published: 2023-07-18)
648 reads
I was having a conversation with some friends the other day and Jen McCown (blog|twitter) asked about SQL Server security ... Continue reading
2023-07-28 (first published: 2023-07-13)
299 reads
I stopped blogging late last year. I’ll be honest, I was tired. I had decided to take a month or ... Continue reading
2023-07-27
29 reads
It’s been a while, but I’m finally participating in T-SQL Tuesday again! This month Erik Darling (blog|twitter) is hosting. Ever ... Continue reading
2023-07-26 (first published: 2023-07-11)
348 reads
A while back I talked about the fact that you can grant someone CREATE PROCEDURE and ALTER on a schema ... Continue reading
2023-07-20
53 reads
SQL Server 2022 has been released! Long live SQL Server! No really, I’ve still got a while before retirement. I ... Continue reading
2022-12-19 (first published: 2022-12-01)
439 reads
It’s T-SQL Tuesday again! And Garry Bargsley (blog|twitter) has asked us what we have planned for the end of the ... Continue reading
2022-12-15 (first published: 2022-12-13)
45 reads
One of my favorite parts of having a new job is that I learn a ton. (No really, my brain ... Continue reading
2022-12-08
134 reads
I was given 4.5 months notice this past June and was fortunate to find a new job. I blogged about ... Continue reading
2022-12-06
18 reads
By Steve Jones
I started a short thread on Twitter/X and Bluesky recently after leaving the Tesla...
By Steve Jones
Life gets better as you replace transactions with relationships. – from Excellent Advice for...
I’ve been putting together a new PostgreSQL session called “Performance Monitoring for the Absolute...
Comments posted to this topic are about the item Understanding Bit Manipulation Functions: BIT_COUNT,...
Comments posted to this topic are about the item Mixed Backups
Hello, I ran below statements in MS SQL, and got error, but fine in...
I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).
BACKUP DATABASE [complex] FILE = N'thirdone' , FILE = N'thirdtwo' , FILEGROUP = N'second' TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak' WITH NOFORMAT, NOINIT, NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10 GOSee possible answers