A Very Cool Benefit in SSMS 21
I saw a post from Erin that Preview 2 is available. I’d gotten a message when I started SSMS v21 this morning, but got distracted. I made a short...
2024-12-11
I saw a post from Erin that Preview 2 is available. I’d gotten a message when I started SSMS v21 this morning, but got distracted. I made a short...
2024-12-11
Can an AI help me with some database API work? Let’s see. This is part of a series of experiments with AI systems. The Scenario One of the things...
2024-12-11
6 reads
2024-12-11
55 reads
I saw a post where a developer was trying to read the Information Schema views to create a copy of a view as a “real” table, a user table....
2024-12-11
6 reads
2024-12-11
1,022 reads
Brent Ozar is a very successful DBA/consultant/speaker/business owner in the data platform space. Many of you have likely seen him speak, read his blog, used his sp_Blitz script, or...
2024-12-10 (first published: 2024-12-09)
26 reads
One of the things that I think is neat is that Redgate Monitor helps you track patching on your systems. This is something that has been challenging in every...
2024-12-10 (first published: 2024-12-09)
19 reads
It’s the last T-SQL Tuesday of the year, and it’s amazing to think we’ve gotten to #181. That’s over 15 years of monthly blog parties. This month we have...
2024-12-10
8 reads
One of our internal people was looking to test some process in (I assume) Redgate Monitor and needed more job history than they had in msdb.sysjobhistory. They wanted to...
2024-12-09 (first published: 2024-11-27)
180 reads
2024-12-09
511 reads
By Steve Jones
I saw a post from Erin that Preview 2 is available. I’d gotten a...
By Steve Jones
Can an AI help me with some database API work? Let’s see. This is...
By Steve Jones
I saw a post where a developer was trying to read the Information Schema...
I have query which is filling TEMPDB I need suggestion how to modify this...
I have query which is filling TEMPDB I need suggestion how to modify this...
Hello, We recently made the following observation working with VS2022 combined with the SSIS...
In a hash join, if all the build input does not fit in memory, what type of hash join is this?
See possible answers