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
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.
2006-09-20
6,328 reads
This article takes a look at SQL Server 2005 Reporting Solutions as applied to Business Intelligence systems.
2006-09-20
2,868 reads
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.
2006-09-19
5,809 reads
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.
2006-09-19
2,904 reads
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.
2006-09-18
8,458 reads
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.
2006-09-18
1,895 reads
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.
2006-09-15
2,087 reads
Steve Schmidt, the backup guy for SQL Server, spent a few minutes talking about his work on SQL Server and life. A look at another very interesting member of the SQL Server development team.
2006-09-14
3,281 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
In my previous post, I showed you how to build a snapshot backup catalog...
By Steve Jones
Train employees well enough that they could get another job but treat them well...
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item Why Data Modelling Still Matters...
Hi when i think of server hops , i think of how kerberos assists...
When I run this code, how many rows are returned?
DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食' DECLARE @s NVARCHAR(1) = N'食' SELECT value FROM STRING_SPLIT(@meals, @s) GOSee possible answers