SSIS - Creating a Deployment Manifest
Using a Deployment Manifest in SSIS allows you to deploy a set of packages to a target location using a...
2009-11-07
954 reads
Blog Posts
SSIS - Data Provider Does Not Allow Parameters in OLE DB Source
I recently worked on a project that involved loading a Data Warehouse from a DB2 source. In this project we...
2009-11-07
851 reads
SSIS - Fast Parse
I had another chance last week to answer an email follow up question from the session Brian and I gave...
2009-11-07
854 reads
SSIS - Send Errors to Message Box
While in the process of developing SSIS packages it’s likely you will deal with errors occasionally unless you’re the Superstar...
2009-11-07
1,370 reads
SSIS – Avoid OLE DB Command
I decided to do a little performance testing on some common SSIS “Tricks” that increase speed and effectiveness of SSIS...
2009-11-07
2,781 reads
Tampa Code Camp 2009
I presented a 1 hr session at Tampa Code Camp 2009: PowerShell for Developers In this sesssion we will look...
2009-11-07
654 reads
Thursday at the PASS Community Summit
The last full day of the 2009 PASS Community Summit was the first day I have had at the conference...
2009-11-07
698 reads
Worldwide Operating System Market Share for October 2009
Ars Technica has a good post up showing that Windows 7, (which has been out for two weeks) has already...
2009-11-07
1,458 reads
Geek of the Week
I made geek of the week. I’m sorry, but I’m excited by that. I’m very proud to be a geek....
2009-11-06
650 reads
Great Post on Parallel vs.. Series SSIS
Mike Davis, Author and consultant extraordinaire recently posted a great new take on parallel vs. series SSIS packages. Some interesting...
2009-11-06
525 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers