Written by Buck Woody – When a new release of SQL Server comes out, there are many books rushed to publication so that they are released at the same time the new version of SQL Server is released. Unfortunately, this “book rush” often leads to poor quality books. But if you wait some time after a n
Community
Speed Up Jet-to-SQL Server Conversion With Conditional Compilation
by Susan Sales Harkins – By using conditional compilation constants that control SQL statement generation, you can target both Jet and SQL Server, deliver applications to either platform, and reduce conversion time.
Google SVG Search I
In the next couple of installments we will make use of our previously acquired knowledge on the Google Web Services API and SVG in order to produce a CGI that graphically presents the search engine results returned by Google.
Ejen: Java/XML/XSLT-based code-generation
F. Wolff has released the final 1.0 version of Ejen, a Java/XML/XSLT system (currently implemented as an Ant task) designed to facilitate the creation of code generators.
Interactive Microsoft SQL Server & XML Online Tutorial
Written by: Scott Klein – This tutorial will introduce you to using XML with Microsoft SQL Server 2000™ and guide you through the concepts and techniques of how to read and write data using XML with Microsoft SQL Server 2000™. You will learn the various methods used and see how powerful and flexible
Oracle Data Provider for .NET
The Oracle Data Provider for .NET (ODP.NET) features optimized data access to the Oracle database from a .NET environment. Unlike OLE DB .NET and ODBC .NET, ODP.NET is a native driver and does not use a data access bridge, which can reduce performance.
In the Picture
By Itzik Ben-Gan – Test your T-SQL skills (and create cool wallpaper) by creating code that randomly generates abstract patterns to certain specifications.
Creating a view between servers
Question to Jorge Cano – I have two MS SQL Servers 2000 on two machines. Is there a way I can create a view table in ServerA, which would look at ServerB, using a ServerA user, who does not exists in ServerB. Check out the answer! (R)
Define Your Own Functions in SQL Server 2000
SQL Server 2000 is the first version of the DBMS to enable SQL programmers to write their own functions. SQL Server Pro Joe Lax explains the three ways to write a user-defined function in SQL Server 2000.
Web Services at Work: Google Web APIs
A lot of hype is buzzing around Web Services these days. New acronyms are appearing every day and protocols and tools are implemented at break-neck speed; but not many real applications are publicly available up to now.Search engine Google makes the leap now and offers the Google Web APIs in