Interfaces
The interface is crucial for getting data in and out of a system. Steve Jones talks a little about past interfaces and possible future ones.
2009-04-22
887 reads
Articles
SQL Server Data Mining: Plug-In Algorithms
Describes how SQL Server 2005 Data Mining allows aggregation directly at the algorithm level. Although this restricts what the third-party algorithm developer can support in terms of language and data types, it frees the developer from having to implement data handling, parsing, meta data management, session, and rowset production code on top of the core data mining algorithm implementation.
2009-04-22
1,606 reads
Taking Advantage
I read SQLBatman's post about his first week as an MVP , and it really resonated well with me. I think that he really hit it when he said that he wasn't going to sit around, he was going to go look for information and take things back from the...
2009-04-22
1,226 reads
Creating a Subscription - SQL School Video
SQL School expands its replication series with a look at how you can set up a subscriber with MVP Andy Warren.
2009-04-21
2,604 reads
Mastering SQL Server Profiler - Video Training Course
In this 6-module course, Brad McGehee provides an in-depth, step-by-step guide to mastering the basics of SQL Server Profiler, a powerful performance monitoring and analysis tool.
2009-04-21
7,200 reads
The Multi-valued Parameters problem in Reporting Services
Longtime SQLServerCentral author, Alex Grinberg, brings us a short piece on how to deal with multi-valued parameters in Reporting Services when you have a stored procedure call.
2009-04-21
14,795 reads
Container Tasks in SQL Server 2008 Integration Services
Learn how container control flow tasks within SSIS can be used by database developers to provide a structure to a package and repeat control flows.
2009-04-21
1,993 reads
Installing Data Protection Manager 2007 as a VM in a lab environment
This article describes how to install DPM 2007 as a virtual machine in a lab environment. Here are the gotchas to look out for and an explanation of the benefits you can realise.
2009-04-21
887 reads
Manage Your Career
The person responsible for your career is you. Steve Jones gives you a few thoughts on how you might approach your career.
2009-04-21
283 reads
Manage Your Career
The person responsible for your career is you. Steve Jones gives you a few thoughts on how you might approach your career.
2009-04-21
161 reads
Blogs
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Forums
Huge frustration - Database watcher with two elastic pools
Think there's a reason why this is still in preview, but have someone manage...
SQL Server 2025 Query Performance Tuning: Troubleshoot and Optimize Query Performance
Comments posted to this topic are about the item SQL Server 2025 Query Performance...
Is it uncommon for Dev's to have a data model of the source data
This is a generic question. To the moderators, I wasn't sure where to place...
Question of the Day
Creating JSON I
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers