Waiting For Superman
This site really is about business intelligence, but it is good to mix things up a bit every now and...
2011-03-15
716 reads
The Lighter Side of Technical Interview Questions
I hate those puzzle type interview questions. I am sure that they show some level of aptitude about something, but...
2011-03-14
1,018 reads
Passing Values into an SSIS Package at Runtime from Outside the Package
SSIS provide several methods for passing values into your packages at runtime.The benefit of doing so allows you to change...
2011-03-14
34,692 reads
DB Benchmarking
As database professionals, we have a need to benchmark performance of the database, processes, and essentially overall performance. When benchmarking, it is preferable to get a baseline and then...
2011-03-14
10 reads
DB Benchmarking
As database professionals, we have a need to benchmark performance of the database, processes, and essentially overall performance. When benchmarking,...
2011-03-14
1,103 reads
ANSI Connection Settings
It’s reasonably well known that you can get different execution plans if you change the ANSI connection settings. But the...
2011-03-14
1,717 reads
More Changes for the Dimension Merge SCD?
A while back, I ran a contest to find a new name for the SCD component hosted on CodePlex. The results were the best "lemons into lemonade" situation I could...
2011-03-14
10 reads
More Changes for the Dimension Merge SCD?
A while back, I ran a contest to find a new name for the SCD component hosted on CodePlex. The results were the best "lemons into lemonade" situation I could...
2011-03-14
18 reads
Stored Procedure Definitions and Permissions
I wrote a post a while back that showed how you can grant execute permission ‘carte blanche’ for a database...
2011-03-14
2,792 reads
SQLPeople: An Interview With Andy Leonard
The thing that I most enjoy about going to conferences, SQLSaturdays, and user group meetings is the people I get to meet or see there. That’s why I was intrigued...
2011-03-14
15 reads
Blogs
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
Forums
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
A Worse Computer; A Better Car
Comments posted to this topic are about the item A Worse Computer; A Better...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers