After concluding a broad overview of various aspects of SQL Server 2005 Integration Services, part 32 of this series focuses on individual components that have more specialized, but very useful characteristics, starting by discussing the Message Queue Control Flow task, and following with coverage of a number of Data Flow transformations.
2006-09-11
1,581 reads
Learn how to use ALERTs, a SQL Agent job and a stored procedure (SP) to create a copy of your critical database backups on another physical machine as soon as the database backups are created.
2006-09-08
4,926 reads
A CTE is a "temporary result set" that exists only within the scope of a single SQL statement. It allows access to functionality within that single SQL statement that was previously only available through use of functions, temp tables, cursors, and so on.
2006-09-07
2,652 reads
Microsoft IT developed strategies to reduce the duplication of sensitive data and improve the security of personally identifiable information in the Microsoft IT LOB application space. These strategies are based on the new security features and functionalities that Microsoft® SQL Server™ 2005 includes.
2006-09-05
2,039 reads
In this article, we examine some of the best new features and characteristics available in the 2005 version.
2006-09-04
1,994 reads
Danny Lesandrini shares a block of code that will allow users to modify (and save) datasheet layout when they are using a compiled MDE version of your Access applications.
2006-09-01
2,257 reads
Need a quick KPI prototype, using Reporting Services / Analysis Services 2000 or 2005? BI Architect Bill Pearson leads hands-on practice in presenting simple KPIs to management with Reporting Services.
2006-08-31
2,834 reads
What happens if you try to specify a Failover Partner in .NET 1.1?
2006-08-30
1,245 reads
The key to maintaining a good employment outlook in IT, it seems, is to move out of programming and up into more business-oriented IT positions such as systems analyst, business analyst, project manager, or systems architect. However, a computer programmer can't just decide to become a systems analyst or project manager overnight.
2006-08-29
3,402 reads
The superiority of SSIS over DTS goes beyond functionality alone, providing numerous efficiency benefits, which we will present in more detail in this article.
2006-08-28
2,056 reads
By HeyMo0sh
As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
Hi, ssms is free here. I can think of other reasons to do this...
I've written some documentation on using different Markdown types of files on GitHub. It's...
Comments posted to this topic are about the item Not Just an Upgrade
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers