Test Post 2
Ut enim ad minim veniam, quis nostrud exercitation ullamco labo-
ris nisi ut aliquip ex ea commodo consequat.
2025-01-09
2 reads
Blog Posts
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,273 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,757 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)
318 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
85 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)
373 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
343 reads
Database Build Error – Incorrect syntax near DISTINCT
I wrote a piece of SQL that had some new T-SQL syntax in it: IS DISTINCT FROM. This predicate checks if two expressions are equal taking NULL into account....
2025-01-03 (first published: 2024-06-24)
700 reads
Introduction to OpenAI and LLMs – Part 2
My previous blog post on this topic was Introduction to OpenAI and LLMs, the “what” part (what is OpenAI and LLM), and this blog post will talk about the...
2025-01-03 (first published: 2024-06-05)
1,301 reads
Plan Time for Self-Development
As you begin the new year, if you don't already have time set aside each week for self-development, plan it. Don't just "make time," but actually set up the...
2025-01-02
29 reads
Blogs
PASS: Quantum Computing Slides
By Brian Kelley
If you're an attendee at the PASS Data Community Summit this year, there are...
A New Word: Dead Reckoning
By Steve Jones
dead reckoning– v. intr. finding yourself bothered by somebody’s death more than you would...
PASS Data Community Summit 2025 Slides and Code
By alevyinroc
Thank you for attending my PASS Summit 2025 session Answering the Auditor’s Call with...
Forums
Personal Contact Is Vital
Comments posted to this topic are about the item Personal Contact Is Vital
Getting the Schema for Tables
Comments posted to this topic are about the item Getting the Schema for Tables
An Unexciting Exciting Release
Comments posted to this topic are about the item An Unexciting Exciting Release
Question of the Day
Getting the Schema for Tables
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'Person.Person')) AS [Object Definition]; GOSee possible answers