The 4 Presentations I’m Proudest Of, and What Inspired Them
Take a look at some of Brent Ozars favourite public presentations, and hear the stories of how they came to be.
Clownpocalypse and DR
Today we have a guest editorial as Steve is out of town at the PASS Summit. Grant looks at disasters and being prepared.
SQL Server Synonyms
SQL Server synonyms can be used to permanently alias database objects in the same or another database. In this article, Greg Larsen demonstrates how to use synonyms and the many reasons to consider using them.
Chopping Off Data
An ETL issue with Excel causes issues, because the users didn't realize a limitation.
Bringing Data Catalog into your CI/CD pipeline
As business rules shift and data structures change, organizations need to be able to maintain and update their data catalog. Discover how you can implement an automated solution using PowerShell and Redgate’s SQL Change Automation.
Orchestrating Azure Databricks Notebooks with Azure Data Factory
Learn how to orchestrate your Databricks notebooks through Azure Data Factory in this article with a step by step walkthrough.
Responding to the Call of the Wild
Phil Factor's manual for taming machines, applications, and other wild beasts.
Career Goals and Inspiration
Steve asks what you might want to achieve or accomplish in your career.
Count the Number of Weekend Days between Two Dates
Handling weekends can be tricky in SQL. This article shows you how to Count the Number of Weekend Days between Two Dates
Blogs
A Prompt AI Experiment
By Steve Jones
Prompt AI released recently and I decided to try a few things with the...
Scaling PowerShell – Lessons from a Technical Interview
By gbargsley
Recently, I was in a technical interview where the topic of running PowerShell at...
Installing Old Versions of PowerShell Modules with Their Dependencies
By alevyinroc
I don’t recall where this came up (probably in SQLSlack), but I had a...
Forums
how to get notification that my database has corssed 8gb
i have sqlexpress on rds, is there any way i can get notifacation that...
SQL Server, Heaps and Fragmentation
Comments posted to this topic are about the item SQL Server, Heaps and Fragmentation
Stairway to Azure SQL Hyperscale – Level 2: Page Server Architecture Explained
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
Question of the Day
SQL Server, Heaps and Fragmentation
A table without a clustered index (heap) will NOT suffer from fragmentation during frequent updates or deletes. True or False?
See possible answers