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)
255 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)
255 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)
654 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)
300 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)
442 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)
47 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
135 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 was asked about state-based deployments in Flyway Teams, so I decided to show...
By Steve Jones
The main thing is to keep the main thing the main thing. – from...
When Covid took out the PASS organization, I had someone say to me, “Well,...
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
I'm attempting to set up log shipping from SQL Server 2005 Standard to SQL...
Comments posted to this topic are about the item Smile and Wave Boys
What do these two selects return?
SELECT BIT_COUNT (CAST (-1 as smallint)) , BIT_COUNT (CAST (-1 as bigint))See possible answers