Book Review – Fundamentals of Data Engineering
This book was recommended by some of my colleagues, so I decided to give it a try. After finishing the book, I was pleased that I did. As the...
2024-06-24 (first published: 2024-06-05)
501 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,327 reads
Prevent SQL Injection Attacks Using SQL Server Stored Procedures
Learn how to prevent SQL injection attacks using SQL Server stored procedures for secure database interactions
2024-06-04
Large System Databases on SQL Server
This one is an oldie in my blog drafts, but a goodie! So, I will finally post it after nearly three years of sitting around. Thank you, past self,...
2024-06-04
103 reads
Free Advanced SQL Course for June: Don’t Miss Out!
Summer is here, and it's the perfect opportunity to enhance your SQL expertise with LearnSQL's special offer. For the entire month of June 2024, they are giving away their...
2024-06-04
75 reads
How to give developers access to Query Store
Let’s have devs look at their own query performance. Yes, please, sign me up for that! Sometimes, it’s hard for me to know the best course of action, especially...
2024-06-24 (first published: 2024-06-03)
668 reads
Sharpen Your SQL Skills: June’s Challenge Awaits!
This June, LearnSQL is throwing down the gauntlet with a fresh SQL Practice challenge. Dive into a real-world gym database and help Christine, the gym's manager, wrangle her data....
2024-06-01
83 reads
Denver Dev Day – Best Practices for Database Deployments Resources
I delivered a talk today on database deployment best practices at the Denver Dev Days 2024. This is a great event, and I have been lucky enough to attend...
2024-05-31
35 reads
A New Word: desanté
desanté – n. the brooding delirium of being sick, which makes time slow to a trickly and turns even the most pathetic of tasks into monumental struggles, until the...
2024-05-31
31 reads
What happens when we drop a column on a SQL Server table? Where's my space?
This article was initially posted on SQLServerCentral @ 2024-04-26.
Short answer: The column is marked as ‘deleted’ and will stop being visible/usable.
But, most importantly - The record/table size will remain...
2024-05-29
298 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