A SQL Compare Picklist
Recently a customer was trying to sync up production and development. They’d somewhat lost control of both environments and wanted to build a plan of how to sync them....
2022-12-30 (first published: 2022-12-19)
349 reads
Blog Posts
Daily Coping 30 Dec 2022
Today’s coping tip is to give thanks. List the kind things others have done for you. I know that my life is great, but it’s because of a lot...
2022-12-30
28 reads
Goal Progress for Dec 2022
I set goals at the beginning of the year, and I’m tracking my progress in these updates during 2022. December is usually quiet, though this year I spent the...
2022-12-30
21 reads
T-SQL Tuesday #157- “End of Year Activity” – RECAP
I am humbled that many posts were submitted for T-SQL Tuesday #157. There is such a wide range of plans to wind down 2022. So enjoy the posts below...
2022-12-30 (first published: 2022-12-20)
259 reads
Daily Coping 29 Dec 2022
Today’s coping tip is to ask for help and let someone else discover the joy of giving. I do most of the cooking in the house, but I thought...
2022-12-29
36 reads
Clickable SVG images in Power BI using the HTML Content custom visual
People have done creative things with SVG measures in Power BI, ranging from KPI cards to infographics to fun games. For my latest Workout Wednesday challenge, I used SVG...
2022-12-28 (first published: 2022-12-15)
309 reads
Daily Coping 28 Dec 2022
Today’s coping tip is to look for something positive to say to everyone you speak to. This works well during the holiday season as most people are in a...
2022-12-28
16 reads
Recommended Approach to Encryption in SQL Server
We looked earlier at the various places our data lives – on disk, in memory, in-transit across the network. A good strategy will protect all of these locations –...
2022-12-28 (first published: 2022-12-14)
557 reads
Daily Coping 27 Dec 2022
Today’s coping tip is to share a happy memory or inspiring thought with a loved one. This is a memory for me: This came up in a Google Photo...
2022-12-27
24 reads
Join me at VS Live Las Vegas 2023
I’m heading back to VS Live in March 2023 for the Las Vegas show. This time it’s at Planet Hollywood, which is a hotel I’ve never visited. I’m excited...
2022-12-27
50 reads
Blogs
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
Randomly Selecting Columns and Rows from a Table or View
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
How Can SQL Server Detect Application Errors When Developers Can’t?
Comments posted to this topic are about the item How Can SQL Server Detect...
Getting Database MaiL Profiles
Comments posted to this topic are about the item Getting Database MaiL Profiles
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers