Communications: Three Questions
The better skilled we are communications, the more likely we will be understood. Whether we're talking work colleagues or our families and friends, being understood is more important than...
2025-07-28
69 reads
Blog Posts
Comparing Top AI Tools for Image and Code Generation
The post explores various AI assistants, highlighting their strengths and weaknesses in areas like coding and image generation. It emphasizes the usefulness of tools like CoPilot and Gemini for...
2025-07-28
71 reads
Navigating Modern Data Architecture: DW, Lakehouse, and Lakebase Explained
The report outlines the evolution in data management systems, transitioning from traditional siloed structures to modern integrated platforms. It compares Data Warehouses, Data Lakehouses, and Lakebases, highlighting their roles...
2025-07-28
247 reads
Zero Downtime SQL Server Upgrade: Best Practices for Seamless Migration
Upgrading SQL Server is a mission-critical task for DBAs, especially when the goal is zero disruption to application connectivity. Whether you’re modernizing for performance, compliance, or supportability, choosing the right...
2025-07-28
124 reads
SQL Saturday Baton Rouge 2025
SQL Saturday Baton Rouge is a great event hosted on LSU’s campus that has some of the best food, presenters, and attendees in the country! Had some incredible questions...
2025-07-26
31 reads
Responsible AI: Why Leaders Need More Than Just Guardrails
In the rush to adopt artificial intelligence, many organizations have quickly built ethical frameworks, compliance protocols, and technical safeguards. These “guardrails” are necessary, but not sufficient. Because AI isn’t...
2025-07-25
30 reads
TempDB Performance Tuning in SQL Server 2022 vs 2016 vs 2019
📘 What Is TempDB and Why It Matters TempDB is a shared system database in SQL Server used for: Because it’s used by every session and process, TempDB is often a performance bottleneck—especially...
2025-07-24
1,301 reads
9 questions to ask before adding generative AI to your data project
Will adding generative AI to your data project improve the outcomes? It might, but it’s not guaranteed. It can be harmful and costly to add generative AI in the...
2025-07-23
1,074 reads
How Vastu Principles Can Inspire Smarter Database Administration: A Holistic Approach to Data Architecture
In the fast-paced world of IT, Database Administrators (DBAs) are the unsung heroes who ensure that data flows securely, efficiently, and reliably. But what if we viewed database environments not just...
2025-07-23
13 reads
Microsoft Fabric shortcut‑based AI transformations
A new feature has just been released in Microsoft Fabric that I was so impressed with that I decided to blog about it. Available in public preview is the...
2025-07-23
10 reads
Blogs
Dry-run xp_delete_file Before Actually Deleting Files?
By SQLPals
Dry-run xp_delete_file Before Actually Deleting Files? xp_delete_file doesn’t really have a...
Happy Thanksgiving! (USA Holiday)
By Brian Kelley
In the United States, today is Thanksgiving. The intent behind the holiday is to...
Getting SQL Server 2025 RTM Running in Containers on macOS
SQL Server 2025 RTM is here, and if you’re running Docker on macOS, you...
Forums
Which Object Definitions Are Available?
Comments posted to this topic are about the item Which Object Definitions Are Available?
What's Your Theme Music?
Comments posted to this topic are about the item What's Your Theme Music?
T-SQL in SQL Server 2025: The PRODUCT Function
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Which Object Definitions Are Available?
For which of these object types can I get the code when I run the OBJECT_DEFINITION() function in SQL Server 2025? (choose 3)
See possible answers