Master SQL Subqueries with This Free Course
Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World Exercises for All Levels. It covers subqueries – a must-have tool for any SQL pro....
2025-01-10
172 reads
Blog Posts
Introduction to OpenAI and LLMs – Part 3
My previous blog posts on this topic were Introduction to OpenAI and LLMs, the “what” part (what is OpenAI and LLM), and the “how” part Introduction to OpenAI and LLMs –...
2025-01-09
29 reads
2025-01-09
8 reads
Test Post 2
Ut enim ad minim veniam, quis nostrud exercitation ullamco labo-
ris nisi ut aliquip ex ea commodo consequat.
2025-01-09
5 reads
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least, and sometimes even on non-working days. I’ve been working with SQL Server for years now,...
2025-01-08 (first published: 2024-12-24)
2,282 reads
Replacing Images in PBIR Format Reports
With the PBIR format of Power BI reports, it’s much easier to make report updates outside of Power BI Desktop. One thing you may want to do is to...
2025-01-08 (first published: 2024-12-30)
1,764 reads
Monday Monitor Tips: CIS Compliant
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many enterprises think about as their auditors use this as a benchmark. If you’ve never looked...
2025-01-06 (first published: 2024-12-23)
327 reads
Monday Monitor Tips: Lots of Postgres Options
Redgate Monitor is growing to include more than just Microsoft SQL Server monitoring. We added PostgreSQL support in 2023 and that continues to grow. This post looks at a...
2025-01-06
95 reads
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to really learn, you need a project. I’m a DBA by trade and as such…haven’t really...
2025-01-06 (first published: 2024-12-20)
377 reads
Advice I Like: Experience and Aptitude
Experience is overrated. Most breakthrough accomplishments were done by people doing them for the first time. Therefore when hiring hire for aptitude and attitude and then train for skills....
2025-01-03
346 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