SSIS Component Addins

Thanks to John the Greek God again. It seems he has come across another piece of valuable info. It seems you can purchase SSIS development components. Maybe some of these will be useful to you. Also now that you know they can be created, you could possibly generate your own as well to help others. Here is the link:

http://www.cozyroc.com/support/ssis_home.html

If you have any tips, tricks, resources you would like to share with the group please email Susan Fischer at susan@clinchportal.com

Data Warehousing Architecture event in Toronto

For thoses interested in data warehousing architecture or for those who are friends of people who are here is the link to an event in Toronto on December 16, 2008

http://www.tsql.ca/Events/200812DataWarehouseArchitecture/tabid/723/Default.aspx

We look forward to seeing you there. We will be hanging out with Susan Fischer.
She is so supportive of us even though she doesn't understand any of these technologies.

Script to Copy database schema and all objects

Have you every created a database and after finishing it all and putting test data in it, you realize now you need an empty one or need to allow someone else to create one. Well a Greek SQL God just sent me a link to do just that. The link to the article is below:

http://blog.sqlauthority.com/2007/08/21/sql-server-2005-create-script-to-copy-database-schema-and-all-the-objects-stored-procedure-functions-triggers-tables-views-constraints-and-all-other-database-objects/

Hope this helps you and if you have any tips, tricks, resources that you think may help others in this group please email them to susan@clinchportal.com and I will post them.

How To Configure SQL Express To Allow Remote Connections

It seems by default you cannot have remote connections to your sql express server.
This article explains how to enable it:

http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

If you have any tips, tricks, resources. Please email them to susan@clinchportal.com and we will post them.

Welcome to the SQL Server Expert blog

Welcome to the SQL Server Expert blog.

This blog is designed to fill a void in that exists when searching for answers to difficult SQL Server issues.

Our team of SQL server Experts will post answers to issues they have solved.

If have any issues you need assistance with, or issues have solved, please email them to us at steve.j.mccann@gmail.com or susan@clinchportal.com and we will post them here.