This white paper describes how application developers can leverage the functionality of Microsoft SQL Server 2005 Integration Services to address the data integration challenges of Master Data Management applications.
2008-01-18
1,821 reads
2008-01-17
2,708 reads
Continuing on with his series on table partitioning, Andy Warren takes a look at some fo the advanced features available in SQL Server Enterprise Edition.
2008-01-17
7,486 reads
Two big events this week captured Steve Jones' attention. A little MySQL and Apple commentary to break up the week.
2008-01-17
49 reads
A common activity in applications is to page results or record sets from a database. This is usually done on the client using the client's paging functionality or on the server through a variety of methods. In SQL Server 2000 those server side methods typically used dynamic SQL or nested TOP clauses and weren't very efficient. Using Common Table Expressions in SQL Server 2005 we have a better way to page record sets on the server.
2008-01-17 (first published: 2007-01-25)
4,640 reads
We get tested in a variety of ways before we take a job, but what should be open for examination besides our technical skills? Answer this week's poll with your opinion.
2008-01-17
39 reads
We get tested in a variety of ways before we take a job, but what should be open for examination besides our technical skills? Answer this week's poll with your opinion.
2008-01-17
55 reads
We get tested in a variety of ways before we take a job, but what should be open for examination besides our technical skills? Answer this week's poll with your opinion.
2008-01-17
58 reads
The definitions of data governance and data stewardship that I use have changed, albeit slightly, over the years of providing data governance and stewardship solutions.
2008-01-17
1,477 reads
Report parameters assist in narrowing down a report for better analysis.
2008-01-17
2,614 reads
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item SQL Server Still Wins
Comments posted to this topic are about the item DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I specify only the Resource Database?
See possible answers