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...

AI Helping with an API

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...

Continuous Learning

The idea of continuous learning is great for individuals and organizations.

Creating a “Real” Copy of a View: #SQLNewBlogger

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....

The Hash Join III

Grinding Away: Brent Ozar

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...

Monday Monitor Tips: Am I Patched?

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...

T-SQL Tuesday #181: A Technology Present

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...

Adding Test data to msdb.sysjobhistory

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...

Getting ANY of the data