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)
333 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
12 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
9 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)
242 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
8 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)
265 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
10 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)
539 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
9 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
37 reads
Blogs
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least,...
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Monday Monitor Tips: CIS Compliant
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
Forums
SQL Server 2005 service fails to start
Hello, I’ve been trying to install Ms SQL Server 2005 for over two weeks...
How to Repair Corrupt MySQL Tables
Comments posted to this topic are about the item How to Repair Corrupt MySQL...
The Funny Dynamic SQL
Comments posted to this topic are about the item The Funny Dynamic SQL
Question of the Day
The Funny Dynamic SQL
What happens when I run this code:
EXEC sp_executesql N'PRINT 1; GO';See possible answers