System Center and Visual Studio Team Foundation Server 2010
Because the relationship between application development and the IT operations teams is critical, Microsoft has released a CTP of a new...
2011-09-06
1,081 reads
James Serra
- Twitter: @https://twitter.com/JamesSerra
- Website: https://www.jamesserra.com/
- LinkedIn: https://www.linkedin.com/in/JamesSerra/
Preventing projects from deploying when debugging a SSIS package
This is a quick tip to help quickly solve a problem I run into sometimes, and now that I am...
2011-09-02
1,415 reads
Receive error #13119 in toolbox instead of tools in Visual Studio 2008
A couple of times over the past few months, while in Visual Studio 2008 working on an SSIS package, I went...
2011-08-31
2,155 reads
When to use T-SQL or SSIS for ETL
When doing ETL, you have the choice of using T-SQL or SSIS. What things should you consider when deciding which...
2011-08-29
10,240 reads
Microsoft SQL Server Parallel Data Warehouse (PDW) Explained
Microsoft SQL Server Parallel Data Warehouse (PDW), formally called by its code name “Project Madison”, is an edition of Microsoft’s SQL Server...
2011-08-26
3,822 reads
Microsoft Small Basic
This is a bit off-topic, but I wanted to mention a great tool for beginners to learn how to program. ...
2011-08-24
2,056 reads
Tracking down KPI error in PerformancePoint
On a few occasions, I have opened up my PerformancePoint scorecard on SharePoint to see an error staring at me:
So...
2011-08-22
754 reads
Methods for populating a data warehouse
Source tables change over time. A data mart or data warehouse that is based on those tables needs to reflect these...
2011-08-19
4,943 reads
Microsoft SharePoint Online
Microsoft SharePoint Online is a cloud-based service that is part of the recently released Microsoft Office 365. For those of us...
2011-08-17
926 reads
Using SSIS lookup transformation editor with millions of rows
If you are using a SSIS lookup transformation editor and the reference dataset is large (millions of rows) and you...
2011-08-15
12,284 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
Why the following cmds in sequence do not work
I need to delete rows from both the temporal main and history tables. The...
When SQL Server Central Went Down
Comments posted to this topic are about the item When SQL Server Central Went...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers