Stairway to Biml Level 5 - Biml Language Elements
In the next level of the Stairway to Biml, we breakdown the various elements in a Biml file to help you understand what parts of the files are used to control the package generation.
The myth of the ‘shared development model’
Phil Factor fluffs the feathers of the shared sandbox model of development.
Database Branching and Merging Strategies
Source control will allow you to maintain branches in the development of your database, but the subsequent merge isn't pain-free. How can the database developer support the rapid development and delivery of features in an application? Versioning, branching and merging is part of the solution, but what about the rest of the solution?
All the People Smarter than Me - Editorial
Today we have a guest editorial from Sarah Wagner that thanks all the people that have helped her become a better DBA.
Database Permissions
Here is a short How To article on querying for permissions in a SQL Server database
Finding SQL Server objects that reference invalid objects
Since many environments haven't committed to using a source control system, identifying mismatched objects can offer a challenge. Tim Smith offers a solution.
Application Developers don’t own their data
As a data guy, I always smile when application developers refer to ‘their’ data. If only it were that simple.
The Product Centric Career
How did you fall in into your particular career? Was it because of a product? Andy Warren talks about his career evolution and how often we become trapped by the products we work with.
Why Primary Keys can be important on large tables
I inherited a database that was getting large and not performing well. After adding primary keys life got better.
Blogs
Creating a Pulsing Conducting Baton - Part 1
By Bert Wagner
Train Wreck The last time I watched a high school band nearly fall apart mid-performance...
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Forums
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
Comments posted to this topic are about the item Why Your Index Isn't Being...
Distance Metric Algorithms
Comments posted to this topic are about the item Distance Metric Algorithms
What Can AI Really Do?
Comments posted to this topic are about the item What Can AI Really Do?
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers