Use Your Voice
If you want more of a career and less of a job, one thing you will have to do is learn to use your voice. I mean this on...
2024-07-08
30 reads
Blog Posts
What to Know about Power BI Theme Colors
Power BI reports have a theme that specifies the default colors, fonts, and visual styles. In Power BI Desktop, you can choose to use a built-in theme, start with...
2024-07-08 (first published: 2024-06-21)
235 reads
A New Word: Symptomania
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly captures the kind of person you are, tying together your many flaws and contradictions into...
2024-07-05
32 reads
How do you restore a SQL Server 2000 database in the year 2024?
A discussion on LinkedIn led to this hypothetical “real world” question: Problem statement: I have a SQL Server 2000 database backup that I need to restore to a supported...
2024-07-05 (first published: 2024-06-20)
394 reads
Polyglot Persistence
I’ve seen the term polyglot persistence floating around Redgate a bit recently in the marketing department. I haven’t really seen this term anywhere, and I wonder if you have....
2024-07-05 (first published: 2024-06-17)
137 reads
Async stats update causing blocking
I recently encountered an issue where an index rebuild set to wait_at_low_priority ended up blocking an asynchronous statistics update.
This interaction led to a large blocking chain where queries were...
2024-07-03 (first published: 2024-06-16)
105 reads
EightKB 2024 – Schedule and Registration
Hello Hello, We. Are. Back! The schedule for EightKB 2024 Edition has been announced! We’re kicking off at 1pm UTC on August 8th (8th of the 8th…get it? 🙂...
2024-07-03
75 reads
Export Azure SQL DB to Storage
After a data migration, we needed to decommission the old Azure SQL DBs, but we wanted to keep a copy in case we needed anything later. Enter exporting an...
2024-07-03 (first published: 2024-07-02)
435 reads
Inside SQL Server Backup and Restore History Pruning with sp_delete_backuphistory
I had a customer that was looking to document a restore that had occurred on one of their systems and didn’t see it. They had concerns about SQL Server...
2024-07-03
663 reads
Query deadlock info in Azure SQL DB
A couple of weeks ago, a developer came to me and wanted to know how to figure out what was causing a deadlock. I honestly didn’t know where to...
2024-07-03 (first published: 2024-06-14)
59 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers