Search for queries with Query Store GUI
Hey folks, long time no write!
Today I want to bring a tip that I use every week but I found that most SSMS users are unaware it exists.
I can...
2024-02-09 (first published: 2024-01-29)
667 reads
Blog Posts
My data architecture book is published!
I’m thrilled to share that after 15 months of dedicated effort, my book, “Deciphering Data Architectures: Choosing Between a Modern Data Warehouse, Data Fabric, Data Lakehouse, and Data Mesh,”...
2024-02-08
159 reads
How to Call REST API using VS Code
Sometimes you need a fast way to test your API call and responses, and for that VS code is the perfect tool to do that. For today’s demo, we...
2024-02-07 (first published: 2024-01-24)
970 reads
Your gradient fill bar charts in Power BI have poor color contrast, but you can fix them
Since conditional formatting was released for Power BI, I have seen countless examples of bar charts that have a gradient color fill. If you aren’t careful about the gradient...
2024-02-07 (first published: 2024-01-23)
188 reads
David Kahn, legendary author, has passed away
I first saw this at Schneier on Security. David Kahn, author of The Codebreakers, has passed away at 93. The Codebreakers was considered the best book on the history...
2024-02-05
47 reads
Digging up undiscovered savings
You might be able to shave off thousands – or more – in your monthly cloud bills for your critical SQL Servers, all while maintaining or even improving performance....
2024-02-05 (first published: 2024-01-21)
219 reads
Moving towards the DataFrame API using the Spark Connect gRPC API in .NET
All Spark Connect Posts
Code
Goal of this post So there are two goals of this post, the first is to take a look at Apache Arrow and how we can...
2024-02-05
90 reads
SQL Server's Buffer Cache: How to Calculate Dirty Page Sizes
SQL Server's Buffer Cache: How to Calculate Dirty Page Sizes
As we know, the SQL Server buffer cache is an area or region inside the server's memory where SQL Server...
2024-02-05 (first published: 2024-01-24)
535 reads
The DevOps Airways Roadshow
I love this logo. Our marketing people were very creative. After the van tour last year, we decided to go with a plane this year. I wrote about the...
2024-02-05
45 reads
Azure Function App doesn’t retrieve most recent secret value from Azure Key Vault
Quite a long title for quite an annoying issue. Let me explain the set-up first: I have pipelines running in Azure Data Factory and I want to send e-mails...
2024-02-03 (first published: 2024-02-02)
25 reads
Blogs
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...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
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