Many organizations need to centralize data to improve corporate decision-making. However, their data may be stored in a variety of formats and in different locations. Data Transformation Services (DTS) addresses this vital business need by providing a set of tools that lets you extract, transform, a
Tag: sql server
Pass Recordsets in N-Tier Applications
(Richard Campbell) There are three popular techniques for passing multiple records from the middle-tier to the client-tier. The most common approach is the one you mention – variant arrays. Typically the array has two dimensions: The first is the field name, and the second is the value. Because the
Basic and complex SQL joins made easy
When you perform an INNER JOIN, only rows that match up are returned. Any time a row from either table doesn’t have corresponding values from the other table, it is disregarded. Because stray rows aren’t included, you don’t have any of the “left” and “right” nonsense to deal with and the order in wh
Exploring SQL Server Triggers
(John Papa) Triggers are one of the core tools available in relational databases such as SQL Server™ 2000. As one of the mainstays of SQL Server database programming, triggers also happen to be one of the topics that I get most of the questions about. In this month’s installment of Data Points, I wi
SQL users: Microsoft must do more on security
(Marc L. Songini) Microsoft Corp appears to be trying to make the security of its SQL Server database more watertight, but it still has a ways to go, according to users. That was the message from SQL Server database administrators here at the Professional Association for SQL Server Community Sum
Yukon Getting Data Warehousing Overhaul
(Scott Bekker) The next version of Microsoft SQL Server, code-named “Yukon,” will have a completely rebuilt engine for extraction, transformation and loading of data from one source to another — a key element of data warehousing and business intelligence operations.
Creating UNIQUE and PRIMARY KEY Constraints on Computed Columns
In SQL Server, the physical mechanism that UNIQUE and PRIMARY KEY constraints use to enforce uniqueness is a unique index. Because SQL Server 2000 supports indexes on computed columns, you can create UNIQUE and PRIMARY KEY constraints on computed columns.
Review: eXpress Persistent Objects for .NET
(Mike Gunderloy) Here’s another product to make the link between objects in your .NET code and a database for persistent storage. The DevExpress folks have done a good job of making the most common case easy.
SQL Date Handler function
If you’ve ever written a script that needs to UPDATE or INSERT Date values in a database AND you live outside of North America, then I’d nearly bet that (like me) you’ve stayed up until midnight cursing the fact that all dates in SQL Server and MS-Access are natively converted from US date format (
Embarcadero Technologies Adds Sophisticated Change Control Management Features to Embarcadero Change Manager 2.5
Embarcadero Technologies(R), Inc., a leading provider of application and database lifecycle management solutions, announced the latest version of its cross-platform change management solution, Embarcadero(R) Change Manager. Embarcadero Change Manager 2.5 incorporates new change-based notification fe