SQLAndy

This was fun to run through, nice to see MS adding features even if in my view they didn't quite...

2007-06-12

1,330 reads

Clustered Index Seek or Key Lookup

When I teach performance tuning I always remind students to be cautious about service packs because things you "know" may...

2007-06-04

1,762 reads

I'll be doing a spotlight session called 'Transactional Replication for Beginners' this year. I've been speaking at the Summit since...

2007-05-29

1,369 reads

I've got a new article running on SSC today with a few more book reviews: http://www.sqlservercentral.com/columnists/awarren/2998.asp.

2007-05-23

1,428 reads

gnossienne– n. the awareness that someone you’ve known for years still has a private...

How I used AI for this postChatGPT to generate images based on info specifically...

A few months ago I started using Deepstash. Deepstash breaks books into the key...

Comments posted to this topic are about the item How Can SQL Server Detect...

Comments posted to this topic are about the item Getting Database MaiL Profiles

Comments posted to this topic are about the item Preserving Data

If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?