You Need Two SLAs for Disaster Recovery
Continuing on with my MCM prep, I was listening to the High Availability/DR prep module today and I was once...
Changing the Past
This Friday Steve Jones explores archived data. Can you restate past results or change old data? This week Steve Jones asks how data professionals feel about this and what guidance they give to their customers.
31 Days of SSIS – Environmental Variable(17/31)
31 Days of SSIS
It’s time to go back to discussing the environment when it comes to SSIS packages. For the...
Getting Fast Counts of Large Service Broker Queues
Getting Fast Counts of Large Service Broker Queues
This question regarding getting a fast count from a service broker queue came...
LINQ Lycanthropy: Transformations into LINQ
LINQ is one of the few technologies that you can start to use without a lot of preliminary learning. Also, it lends itself to learning by trying out examples. With Michael Sorens' help, you can watch as your conventional C# code changes to ravenous LINQ before your very eyes.
How to make Net Meeting a success
This article is a basic guide line to chapter leaders who are planning to have Net meetings as part of the User Group meetings.
The Face of BI for SQL Server
Donald Farmer recently left Microsoft, and he will be missed, but Steve Jones knows that there will be new faces to get to know.
Check that what you expected is actually what you got - DB's and SQLCMD
I feel that it is wise move for a script to actually check itself that the database connection that is...
ShowPlan Operator of the Week - Merge Join
Did you ever wonder how and why your indexes affect the performances of joins? Once you've read Fabiano Amorim's unforgettable explanation, you'll learn to love the MERGE operator, and plan your indexes so as to allow the Query Optimiser to use it.
XQuery for the Non-Expert – @Variable Use
Talk to the Experts
In a previous post, I discussed the exist() method as part of the XQuery for the Non-Expert...
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