Category: SQL Saturday

24HOP Session: Forgotten T-SQL

Post author By Jen McCown
Post date September 16, 2010
Categories In 24HOP, 24HOP, Beginner, Intermediate, Level, News-ish, SQL Saturday, SQLPASS, Tips, TSQL
3 Comments on 24HOP Session: Forgotten T-SQL

Here, just in case you don’t want to read all my rambling: Download the Forgotten T-SQL session code here. Edit (10/1/2010): The 24 Hours of PASS Fall session recordings are up! You’ll need to use your PASS login, or register, to access the recordings. Session Wrapup Speakers always say “thanks for coming” and “I really appreciate […]

Follow Friday: Ryan Adams

Post author By Jen McCown
Post date August 20, 2010
Categories In FollowFriday, NTSSUG, SQL Saturday
3 Comments on Follow Friday: Ryan Adams

Our last Follow Friday, at the end of May, was mister Tim Mitchell of the NTSSUG board. I’m apparently following a theme this summer, for today’s Follow Friday is NTSSUG board candidate Ryan Adams (blog, Twitter)! Ryan’s a SQL Server DBA who has been at the same company for…twelve years?? I don’t even know what you […]

Tip: Connect to dBASE files in SSIS

Post author By Jen McCown
Post date August 12, 2010
Categories In NonSQL, SQL Saturday, sql server, sqlserverpedia-syndication, SSC, SSIS, Tips
1 Comment on Tip: Connect to dBASE files in SSIS

This has come up several times in the course of the last TWO jobs, so I’ll put it here for my reference (and yours). To use a dBASE file as a source in SSIS (and I know you want to), in your new connection manager: Select Native OLE DB\Microsoft Jet 4.0 OLE DB Provider . […]