This white paper enumerates the connectivity options for databases with Microsoft SQL Server 2005 Integration Services and mentions special considerations that are required when using some database sources with some of the more complex transformations.
2008-01-28
2,727 reads
One of the new features found in SQL Server 2005 is the ability to add additional columns, called Included Columns, to a non-clustered index. This article will explain the advantages of using included columns and what impact they will have on your database.
2008-01-28
3,277 reads
This white paper describes how application developers can incorporate data quality into their Microsoft SQL Server 2005 Integration Services solutions.
2008-01-25
1,512 reads
Part one of this series illustrates how to enable Change Data Capture on a database, and on a table, and how to keep track of Data Definition Language changes on a table.
2008-01-25
2,880 reads
This article explores the data types and methods used for storing BLOBs (Binary Large Objects), such as images and sounds, inside SQL Server.
2008-01-24
4,577 reads
Data governance is NOT a methodology. Data governance is about authority and discipline over the management of data but not THE method in which the data is governed.
2008-01-24
1,323 reads
Information governance is defined by Larry English as the act or process of leading, directing, controlling and assuring that information is managed effectively as an enterprise resource. (PDF download)
2008-01-23
1,140 reads
Paul Randal talks about the new spatial data types and their indexes.
2008-01-23
2,907 reads
Every developer needs to ensure that each TSQL statement is optimized. This article will give you a few different ideas on how to identify slow running queries and provide you with some tips on monitor your query performance while you make iterative changes to each query to try and improve performance.
2008-01-22
4,005 reads
Microsoft SQL Server 2005 Service Broker is a new platform for building distributed asynchronous database applications. Including an asynchronous, reliable messaging feature in the SQL Server database makes it possible to build a variety of database applications that were difficult, if not impossible, to build before.
2008-01-21
2,109 reads
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Referrals have never been more important in the job market. They’re no longer nice...
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Comments posted to this topic are about the item Make It Routine
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers