Welcome to Geekdojo Sign in | Join | Help

SQL Server (RSS)

All Versions, but mostly 2005.

SQL Server Integration Services Woes after SP2

posted Monday, October 01, 2007 11:06 AM by mitchell
So, I installed SQL Server 2005 SP2 the other day and tried to create a new SSIS package today. No workie! So, in searching for the error GUID, I came across this Forums article, and, sure enough, registering the DLL worked. Now, why SP2 couldn't possibly Read More
0 Comments
Filed Under:

Free Integration Services Components?

posted Tuesday, July 25, 2006 8:57 AM by mitchell
Apparently, these guys are working for free... ;-) http://www.konesans.com/products.aspx Read More
0 Comments
Filed Under:

Microsoft High Availability Secrets Revealed

posted Thursday, March 02, 2006 10:02 AM by mitchell
A really candid and excellent article from the "Group Manager for database engineers" at Microsoft on why they don't cluster their servers. Read More
0 Comments
Filed Under:

Upgrading to SQL Server 2005

posted Tuesday, February 14, 2006 8:47 PM by mitchell
Went to another session at our Tech Fair. This one was given by Microsoft on upgrading your 7.0 or 2000 instances to 2005. What really got me was that they were very blase about just going ahead and upgrading without any thought at all. Their recommended Read More
0 Comments
Filed Under:

Death to Cursors - Make Your T-SQL Faster

posted Tuesday, January 17, 2006 8:42 AM by mitchell
Excellent article on SQL Server Central regarding getting rid of cursors. If you don't absolutely need a cursor, kill it, and let this help.Note, registration may be required. Read More
0 Comments
Filed Under:

Building A DAL with VS 2005

posted Monday, January 16, 2006 11:31 AM by mitchell
Check out Scott Gu's blog for an excellent tutorial on using the new Data Designer to generate a DAL (Data Access Layer).Note, the ServerSide.Net also has an excellent article on this. Read More
0 Comments
Filed Under: ,

SQL Server 2005 CLR Integration

posted Wednesday, November 16, 2005 8:25 AM by mitchell
Bad code will not, necessarily, bring down the database server, but it can sure hurt your chances for promotion. I've been working with one of our SQL Server DBAs in attempting to break the CLR Integration piece. I created a C# assembly, called mutual_recursion, Read More
0 Comments
Filed Under: