(Andras Belokosztolszki) Semantic heterogeneity might sound like a meaningless bit of tech jargon, but it actually describes a subtle set of problems confronting many developers and DBAs. Anyone who’s ever had to combine data sets from two different databases (and what DBA or database developer hasn
Other News
FIX: Books Online Incorrect About Default Value of @terminate for SP_CHANGE_PRIMARY_ROLE
The SQL Server 2000 Books Online documentation is incorrect regarding the default value for the @terminate parameter for the sp_change_primary_role stored procedure in the msdb database.
Eye on Information
(Alan Joch) For years, Louisiana’s Office of Group Benefits (OGB) has successfully run a self-insured, self-administered health plan for more than a quarter million state and public sector employees and their families. The OGB is large: With revenues of more than US$1 billion, it’s the second-la
Condition handlers in SQL procedures
Condition handlers determine the behavior of your SQL procedure when a condition occurs. You can declare one or more condition handlers in your SQL procedure for general conditions, named conditions, or specific SQLSTATE values.
Use Oracle Obfuscation to Encrypt Data Securely
(Sushil Srivastava) Sometimes you need to encrypt certain data stored in your database—data like passwords and other condfidential information.
Using ODBC you can connect MySQL with ASP.NET
Considered the “world’s most popular open source database,” MySQL has come a long way from its beginnings as a no-frills, low-cost database server to one that powers high-volume Web sites and critical business systems. If you’re an ASP.NET developer, though, there’s always been one tiny glitch:
Session Variables – Saving with XML
(Keith Barrows) When developing web sites there are many times that session state has to be saved between pages. Maybe you are writing an Intranet app that takes 20 pages to do one action. Or, maybe you have an Internet site that state must be saved as the user randomly navigates through the site.
Tip: Default and error handling in XSLT lookup tables
(Uche Ogbuji) As I wrote in my earlier tip, lookup tables are a common technique for quickly finding results that would be very inefficient or impossible to determine through programming. They consist of a mapping that associates a key with a value. In that article, I demonstrated how to build l
Valid XHTML within .NET – Introduction
(Kevin Brown) The first article in this series will concentrate on the HtmlForm control and its child controls, deciding how we can best modify the default implementation and extend its capabilities so that it will validate to the W3C’s XHTML 1.0 and 1.1 strict standards. Additionally we’ll look at
Data Domain Replicator: Reducing the Cost of Online Data Replication for Disaster Recovery and Remote Backup
Eliminate costly, time-consuming tape vaulting today! This new whitepaper tells how Global Compression technology makes remote data replication both practical and cost-efficient. Learn how the DD200 recovery appliance and its Replicator module enable companies to create Disaster Recovery/Business Co