SQL Saturday US Map
Apparently, SQL Saturday isn’t popular in the west. See for yourself. I wanted to see what cities frequently host SQL...
2012-08-03
1,554 reads
Sam Vanga
SCRIPT: Basic Information About Indexes
I’m having a little fun with documenting basic information about indexes in my current project. I’m posting the scripts here...
2012-07-31
2,088 reads
Parallel Execution in SSIS with MaxConcurrentExecutables
MaxConcurrentExecutables, a package level property in SSIS determines the number of control flow items that can be executed in parallel....
2012-07-20
19,493 reads
Generating Surrogate Keys With SSIS
A surrogate key is an auto generated value, usually integer, in the dimension table. It is made the primary key...
2012-06-28 (first published: 2012-06-24)
7,745 reads
Status Column in SSISDB Catalog Database
I occasionally review the search terms people use to get to this blog and secretly celebrate knowing my post helped...
2012-06-19
1,218 reads
T-SQL Tuesday 31: SSIS 2012 Logging
Topic for this month’s T-SQL Tuesday, hosted by Aaron Nelson (@SQLVariant) is Logging.
I like to think of logging as a...
2012-06-19 (first published: 2012-06-12)
3,802 reads
Tips to improve your blog, really!
As I learnt a few things about blogging, I made a list of tips to get better at blogging. Thought...
2012-05-17
908 reads
Workspace database server was not found
You might constantly see a warning message that appears like the one below when creating Analysis Services Tabular projects. It...
2012-05-08
1,102 reads
How to execute a package from another package?
I hear you. You’ll use the Execute Package Task. This mechanism of executing one package from another is popularly knows...
2012-05-01
2,162 reads
Change Package Properties Using Parameters–SSIS 2012
In DTS, changing package properties was close to impossible (the less we talk about DTS, the better). Package configurations introduced...
2012-04-24
14,279 reads
Blogs
Giving AI Agents Visibility Into SQL Server with MCP
I’ve been thinking a lot lately about what it actually takes to make an...
The Book of Redgate: Profits
By Steve Jones
Redgate is a for-profit company. We look to make money by building and selling...
Session Materials for Techorama & DataGrillen 2026
I’ve uploaded the slides for my Techorama session Microsoft Fabric for Dummies and my...
Forums
Stop Prompting Your AI Agent. Give It a Playbook.
Comments posted to this topic are about the item Stop Prompting Your AI Agent....
Finish the quote
Comments posted to this topic are about the item Finish the quote
Everything I Needed to Know Used to be Found in One Book
Comments posted to this topic are about the item Everything I Needed to Know...
Question of the Day
Finish the quote
Finish this quote (for a fun Memorial Day question):
Do not try and bend the spoon. That's impossible. ...See possible answers