Answering Questions On Dropped Columns
Howdy folks! Long time no write.
In this post, I will be answering a couple of questions from the previous posts about dropping columns.
A quick refresh
If you haven’t read the...
2025-03-10
27 reads
Mistakes IT Shops Without a DBA Make
We get it. There’s no budget for a DBA on staff, or even a contract support firm like Dallas DBAs. You are not alone! There are thousands of firms...
2025-03-19 (first published: 2025-03-07)
627 reads
A New Word: Waldosia
waldosia– n. a condition in which you keep scanning faces in a crowd looking for a specific person who would have no reason to be there, as if your...
2025-03-07
41 reads
Deploy at Low Priority
Learn how to deploy schema changes in an always-online SQL Server environment without a maintenance window. This utility reduces blocking and improves deployment success.
The problem
I attempted to deploy a...
2025-03-19 (first published: 2025-03-07)
226 reads
A Couple Quick GENERATE_SERIES Tests
I had someone reach out about generate_series() recently, saying they hadn’t realized this was a new feature in SQL Server 2022. They were wondering if it was better than...
2025-03-17 (first published: 2025-03-05)
388 reads
How I passed the DP-700 Exam
I recently took and passed the DP-700 exam, which is required for the Microsoft Certified: Fabric Data Engineer Associate certification. It’s the second Fabric certification, and it focuses more...
2025-03-17 (first published: 2025-03-05)
1,081 reads
Which approach to take: Build it, buy it, cloud it?
As a Consultant, I would typically answer with – it depends! Then a typical conversation starts with an expression of personal preferences based on experience, the organization’s history, and...
2025-03-14 (first published: 2025-03-05)
315 reads
Build It, Buy It, Cloud It? The IT Decision Puzzle
The Never-Ending Question in IT: Which Approach to Take? As a Consultant, I would typically answer with = it depends! Then a typical conversation starts with an expression of...
2025-03-05
38 reads
Knoxville M365 Community Days Recap
Hello data friends! Had a blast at my first ever M365 Community Day this past weekend! Thank you to all the amazing organizers and sponsors who made it happen,...
2025-03-04
38 reads
What is Deferred Name Resolution?
One interesting concept in SQL Server is Deferred Name Resolution. This is something many developers struggle with understanding how this works and where it works. In the Microsoft docs,...
2025-03-10 (first published: 2025-03-03)
451 reads
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Choose the Second One
Comments posted to this topic are about the item Choose the Second One
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers