Microsoft Purview FAQ
I get many of the same questions about Microsoft Purview, so I wanted to list those common questions here along with their answers. If your question is not answered...
2024-09-23 (first published: 2024-09-12)
245 reads
Blog Posts
Small Data SF 2024
I have often made an effort to attend conferences in the past to grow my career. Even today, when I speak at a conference, I’ll try to go to...
2024-09-23
17 reads
A New Word: Mottleheaded
mottleheaded – adj. feeling uneasy when socializing with odd combinations of friend and family, or friends and colleagues, or colleagues and family – mixing a medley of ingredients that...
2024-09-20
11 reads
Redgate Clone Graduating Images
I wanted my own custom image in our internal Redgate Clone cluster, so I decided to make one. This is an overview of how this works. This is a...
2024-09-20 (first published: 2024-09-09)
134 reads
SQL Server Quickie #47 – Azure SQL Database
Today I have uploaded SQL Server Quickie #47 to YouTube. This time I’m talking about Azure SQL Database. If you are interested in learning more about this very interestingh...
2024-09-20 (first published: 2024-09-05)
222 reads
Missing Columns in Extended Events Live Data Explorer
Let me be extremely clear up front, this is not my original work. I saw this post on DBA.StackExchange.com and I wanted to share and promote it. Nice work...
2024-09-18 (first published: 2024-09-02)
126 reads
Using T-SQL Snapshot Backup - Point in Time Recovery
Introduction In this post, the second in our series, I will guide you through using the new T-SQL Snapshot Backup feature in SQL Server 2022 to take a snapshot...
2024-09-18 (first published: 2024-09-01)
301 reads
Comparing Power BI Core Visual and Deneb Stacked Column Chart
One of the new features in the August Power BI Desktop release is the updated legends that are styled to more accurately reflect the per-series formatting on the visual....
2024-09-16 (first published: 2024-08-26)
150 reads
Connect With More Clients: Our Partner Directory Has Arrived
The partner directory connects your agency with new customers.
2024-09-16
21 reads
Spatial Databases & Geospatial Data: A Beginner’s Guide
Ever used Google Maps to find the fastest route home? That's geospatial data in action, turning physical locations into digital info so you can navigate efficiently. Spatial databases take...
2024-09-16 (first published: 2024-08-27)
316 reads
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers