New Job -> Week 6 -> Ozar sp_BlitzIndex
This is part of a series of new job blog posts. You can find them all here. Week 6 goal: Analyze all Azure SQL Database indexes. Last week, I...
2023-05-01 (first published: 2023-04-24)
760 reads
Blog Posts
Tales From The Field Weekly Wrap Up for the Week of 04-24-2023 Steve Martin, Martin Short, & Tacos
Hello Dear Reader! I've realized something writting this blog. I don't like to sit still. It is very rare that I have a down weekend, and this weekend was...
2023-05-01
54 reads
Creating Your First Azure SQL Database
Azure SQL Database is a cloud-based database service that offers scalability and flexibility to handle large workloads. It’s based on Microsoft SQL Server Database Engine and provides a managed...
2023-04-30
72 reads
Get your Query History in Redshift
Because my Windows machine apparently decides to install updates over night (and thus reboot my machine), it has happened that I lost the query that I was writing for...
2023-04-28 (first published: 2023-04-20)
131 reads
Monitor SQL replication subscriptions synchronization status
In your current role if you are managing a SQL server replication setup, you are probably well aware that if any of the subscriber is not getting synchronized within...
2023-04-28 (first published: 2023-04-22)
351 reads
EightKB 2023 – Schedule and Registration
The schedule for EightKB 2023 Edition has been announced! We’re kicking off at 1pm UTC on May the 24th…here’s the schedule: – N.B. – If you click on the...
2023-04-26
46 reads
I’ve Got 99 Problems But xp_cmdshell Ain’t One
xp_cmdshell is an extended SQL stored proc that allows users to run Windows command prompt commands from within SQL. Sound scary? It might, but is xp_cmdshell really a security...
2023-04-26 (first published: 2023-04-12)
580 reads
Video – Recovering data with crash consistent snapshots
A while back I posted a blog on how to recover data with crash consistent snapshots. Snapshots are pretty handy in certain situations so I thought I’d show you...
2023-04-26 (first published: 2023-04-11)
138 reads
Why Learn PostgreSQL?
At Redgate, we’ve spent a lot of time adding PostgreSQL functionality to our DevOps tools. We’ve also hired an advocate, Ryan Booz, to help us spread the word and...
2023-04-26
297 reads
Data Marketplace
I question I have been getting from customers lately is about a data marketplace. What is it, and what products can I use to build it? A data marketplace,...
2023-04-24 (first published: 2023-04-10)
158 reads
Blogs
Data Céilí 2026 Call for Speakers!
Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is...
Streamlining Azure VM Moves Into Availability Zones
By John
One of the more frustrating aspects about creating an Azure virtual machine is that...
Monday Monitor Tips: Native Replication Monitoring
By Steve Jones
Redgate Monitor has been able to monitor replication for a long term, but it...
Forums
Stairway to Azure SQL Hyperscale Level 6: Backup and Restore Internals
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
The Challenge of AI
Comments posted to this topic are about the item The Challenge of AI, which...
Deprecated Feature Tracking
Comments posted to this topic are about the item Deprecated Feature Tracking
Question of the Day
Deprecated Feature Tracking
From T-SQL, without requiring an XEvent session, can I tell which deprecated features are being used on my instance?
See possible answers