TFS vs SSIS project versioning
I had someone ask me the other day if they are using SSIS 2012 Project Versions, is there any benefit...
2013-03-26
4,103 reads
Blog Posts
Use Powershell to Pick Up what Database Mirroring Leaves Behind
Database mirroring has been around since SQL Server 2005, and it's turned out to be an excellent step up from...
2013-03-26
2,460 reads
XML Support and SQL Server (Part 5)
Checkout the fifth part of my XML support and SQL Server article series here.
In this article, I discussed the basic...
2013-03-26
639 reads
A Week from Omaha–SQL Saturday #197
Next week I head out to SQL Saturday #197 in Omaha NE. I’m looking forward to it as I’ve never...
2013-03-25
979 reads
Count Weekdays in MDX
I recently implemented an MDX expression to count the number of weekdays in a given timeframe. This logic is likely...
2013-03-25
2,746 reads
Cumulative Update – 10 for SQL Server 2008 Service Pack 3 Is Now Available !
The 10th cumulative update release for SQL Server 2008 Service Pack 3 is now available. Cumulative Update 10 contains all...
2013-03-25
725 reads
Implicit Conversions and Avoiding Them With Computed Columns
I recently encountered an interesting performance issue (due to implicit conversions) that I was able to solve using a lesser known technique and I wanted to share it with...
2013-03-25
39 reads
Last Weeks Top “Reading” Links #25
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-03-25
1,103 reads
Pragmatic Works Webcasts This Week #passwit
Every week, Pragmatic Works offers up its “Training on the Ts” webcast series and this month, in honor of Women’s History Month,...
2013-03-25
736 reads
Speaking at SQLSaturday #197 in Omaha on April 5-6
I will be speaking on both Friday and Saturday (April 5-6) at SQLSaturday #197 in Omaha, Nebraska. I will be...
2013-03-25
790 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Training the next generation
Comments posted to this topic are about the item Training the next generation
Reusing Customer Specific Order Filtering Logic with CROSS APPLY and an Inline TVF (Part 4)
Comments posted to this topic are about the item Reusing Customer Specific Order Filtering...
PostgreSQL psql Meta Commands: Databases
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Databases
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers