T-SQL Tuesday #186–Agent Jobs
It’s that time of the month again, when the T-SQL Tuesday blog party takes place. I manage this site, and am looking for hosts all the time. This month...
2025-05-13
19 reads
It’s that time of the month again, when the T-SQL Tuesday blog party takes place. I manage this site, and am looking for hosts all the time. This month...
2025-05-13
19 reads
I’ll walk through the KDA UI and tackle the first challenge before diving into the real cases.
The UI layout
This is what your layout might look like:
LHS menu where you...
2025-05-12 (first published: 2025-04-26)
25 reads
My first time at SQL Saturday New York City was an absolute blast! Thank you so much to the organizers and the incredible people who chatted with me during...
2025-05-12
20 reads
Indexes 101: What, Why, and When? “What Is an Index?” I get this question a lot, especially from developers and sysadmins who’ve been handed a SQL Server and told,...
2025-05-12 (first published: 2025-04-23)
252 reads
Just a quick one this morning. I’m on the road and haven’t worked up a full blog post, apologies. I’ve been using the preview for SQL Server Management Studio...
2025-05-12
44 reads
lookaback– n. the chock of meeting back up with someone and learning that your mental image of them had fallen wildly out of date – having grown up or...
2025-05-09
13 reads
I do believe most people know about the ability to backup your SQL server databases to URL (from Azure VMs). If you recall you would use the storage key...
2025-05-09 (first published: 2025-04-23)
366 reads
Yeah, yeah, second AI post in a row. I promise not to make a habit of it. But I saw someone else mention that you can feed them XML...
2025-05-07 (first published: 2025-04-21)
544 reads
Can you restore multiple differential SQL Server backups
The post Can You Restore Multiple Differential Backup Files? appeared first on Tim Radney.
2025-05-07
35 reads
In a couple of weeks, I’ll be in New York City for the Redgate DevOps Devour Hour Lunch and Learn. This is at the Industrious office at 730 3rd...
2025-05-07
12 reads
One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved...
By Kevin3NF
Flexibility and Scale at the Database Level When SQL Server 2012 introduced Availability Groups...
Setting page visibility and the active page are often overlooked last steps when publishing...
Comments posted to this topic are about the item Password Guidance
Comments posted to this topic are about the item Using table variables in T-SQL
I am trying to check out elastic query between two test instances we have...
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers