(Ashish Gilhotra) This article is intended to help the people who are beginners to SSIS. In this article we will see what is SSIS? Why we use SSIS ? and how to create a package using BIDS (Business Intelligence Development Studio). The article describes this through an example which will show us how

(Roman Rehak) SQL Server 2005 and 2008 offer several options for high availability such as log shipping, replication and database mirroring. All of these technologies provide the option of maintaining a standby server that you can brought online and made the new primary server in the event your old

(Bill Graziano) This article covers using the REPLACE function to selectively replace text inside a string in SQL Server. The REPLACE function is easy to use and very handy with an UPDATE statment.

(José Moreira Neto) sp_addpublication parameter: [ @immediate_sync=] ‘immediate_synchronization’ Immediate_sync has a default of FALSE. independent_agent must be true for immediate_synchronization to be true.

(Buck Woody) Replication is a feature included with all editions of SQL Server from version 2000 and higher (to some degree) that allows you to copy data from one database to another. In this feature overview I’ll explain (at a high-level) the concepts, how the process works, and explain a practical

(Tibor Karaszi) You know the answer already: It depends. But I often see some percentage value quoted and the point of this post is to show that there is no such percentage value.

(Atif Shehzad) A new service, SQL Server Browser, was introduced with SQL Server 2005 and is also used with SQL Server 2008. In this tip I will cover what this is and how to use this service to improve your SQL Server environment.

(Sean McCown) SQL developers on every platform are struggling, seemingly stuck in a DO WHILE loop that makes them repeat the same mistakes again and again. That’s because the database field is still relatively immature. Sure, vendors are making some strides, but they continue to grapple with the big

(Jamie Thomson) I saw a question on MSDN’s SSIS forum the other day that went something like this: I’m loading data into a table from a flat file but I want to be able to store the name of that file as well. Is there a way of doing that?

(Gregory A. Larsen) Indexes help your application find your data quickly and provide users with a well performing application, while minimizing server resources. This article discusses indexing guidelines related to join tables and covering indexes.