Database snapshots provide a handy way to provide data integrity for Integration Services. In this presentation, Brian shows you how to create a package that can "self-heal". In the event of any problem, the database will automatically roll back to a pre-ETL snapshot.
2006-09-29
2,186 reads
In this presentation, Brian shows you how you can use database snapshots for data protection. He shows you how to create a snapshot, read from it and lastly how to do a database recovery from the snapshot.
2006-09-27
2,767 reads
In SSIS demostration, you can wrap a package or container in a MS DTC transaction. This type of transaction ensures that if a problem occurs in a package, your data can roll back to a prior state.
2006-09-22
1,808 reads
In this video, you'll learn how to use the For Each ADO enumerator in SSIS to loop through a table and reconfigure the package based on the rows in the table. You can use this type of example to store meta data about your client and reconfigure the package for each client dynamically.
2006-09-21
1,758 reads
By default, SSIS is not an easily cluster-aware product. In this video, Brian shows you how to cluster the service and make it highly available.
2006-09-14
1,754 reads
On February 24th, 2005, Microsoft announced the new editions and pricing of SQL Server 2005. There have been quite a few changes and MVP Brian Knight has put down a comparison as well as details about which features are included with each. Read about the 4 new additions and see which one might be right for your next project.
2006-09-01 (first published: 2005-02-28)
65,491 reads
In this presentation, you'll learn how to use the ForEach Loop Container to loop through a folder and load each file in the directory. This presentation uses variables to dynamically configure the package so nothing is hard coded.
2006-08-30
2,171 reads
With Windows 2003 now clustered, you're ready to begin to clustering SQL Server 2005. In this presentation, you'll see how to cluster SQL Server 2005 and some best practices in how to configure the SQL Server cluster after the fact.
2006-08-29
2,982 reads
In this presentation, you'll learn step-by-step how to cluster Windows 2003 R2. Brian shows you how to configure and cluster a two node cluster, preparing it for any future services like SQL Server or Exchange.
2006-08-23
2,131 reads
So you've created a SQL Server package and now you're ready to integrate it into your Visual Basic application? In this series, Brian Knight will show you how to use the DTS object model to execute a DTS package from Visual Basic.
2006-08-18 (first published: 2004-01-23)
25,429 reads
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
By Steve Jones
“You don’t need more time because you already have all the time that you...
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Comments posted to this topic are about the item What Did Healthy Look Like?
Comments posted to this topic are about the item DML Trigger Types
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
How many types of DML triggers are there?
See possible answers