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,766 reads
Blog Posts
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
653 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
697 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,455 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
648 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
523 reads
Identity Issues
Have you ever received the following Error when developing your ETL or working with data cleanup?
Msg 544, Level 16, State...
2009-11-06
359 reads
Montreal as a City State: Can a DBA Go Beyond their Workplace to Provoke Change in their Region?
I am very impressed with Michel David’s work, and openly endorse much of his great piece of work at MontrealCityState.ca...
2009-11-06
1,756 reads
OFF-TOPIC: Surviving, Missing Folks, Glad I'm Home
I certainly wish circumstances were different and I would have been able to attend the PASS Summit this week. I...
2009-11-06
732 reads
PASS Summit 2009 Day 3
The day started off with a mixed bag. First we had an honestly tearful farewell with Wayne Snyder saying goodbye to...
2009-11-06
1,531 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers