Using Transactions in SSIS
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.
Database Snapshots
In the first part of his series on SQL Server Availability, new author Kumar Parthasarathi brings us a look at Database Snapshots in SQL Server 2005.
Using the For Each ADO Enumerator
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.
Preventing Identity Theft Using SQL Server
Solving business problems is an interesting problem for most application developers. Usually the issues are handled in application code, but there are some places where SQL Server can be used to help. Yaroslav Pentsarskyy brings us a creative use of SQL Server functionality to prevent identity theft.
Business Intelligence in SQL Server 2005, Part 1
This article takes a look at SQL Server 2005 Reporting Solutions as applied to Business Intelligence systems.
Beauty is in the Eye of the Beholder
Is dynamic SQL good or bad? We've had lots of arguments over the years in the forums and articles on both sides of the coin, though with most of the opinions being that dynamic SQL is bad. Stephen Hirsch brings us his own view that beauty is in the eye of the beholder.
Demo of Visual Studio Team Edition for Database Professionals
In this video by the product's Program Manager, Sachin shows you a "whistle-stop" tour of the features of Visual Studio Team Edition for Database Professionals. This is the first part in a large series all on Microsoft's new development and administration platform for SQL Server.
Data Quality
What is data quality? How do you measure it and how does it affect your data warehouse? SQL Server warehousing expert Janet Wong brings us a look at what data quality is and what it means to you.
SQL Server 2005 – DML Usage on an untyped XML column
Learn how to use Data Manipulation Language, a set of statements used to store, retrieve, modify, and erase data from a database, for untyped XML columns.
Using and Monitoring SQL 2005 Query Notification
The aim of this article is to show you how to make full use of SQL 2005 query notification with ASP.NET 2.0. It tackles the implementation details largely from SQL Server's perspective and includes many DBA tips and tricks for troubleshooting query notification.
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCU RAWAMANGUN Telpon/WA:08213111185
BCA KCU RAWAMANGUN Telpon/WA:08213111185 Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta...
Cs Lion Air Tower Tlp/ Chat 083843888827
Cs Lion WhatsApp 083843888827 Sunset Road 100 C,Simpang Siur Kuta, Jimbaran, Kec. Kuta Sel.,...
BCA KCU KALIMALANG Telpon/WA:08213111185
BCA KCU KALIMALANG Telpon/WA:08213111185 Jl. Tarum Barat Blk. E No.5, Wil. Kota, Kec. Duren...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers