(Joe Gregorio) In my inaugural article, I outlined the four basic steps you needed to follow when creating a RESTful web service. Now let’s take those basic steps and follow them through a worked example. To stay on familiar ground we’ll create something that you may find familiar: a web bookmark se
Other News
Get better SQL Server performance before you improve the queries
(Robert L. Bogue) When looking at SQL performance there’s an immediate desire to jump into the queries that the SQL Server is being forced to process and see what can be done to improve them. Unfortunately, it’s not always that simple. Sometimes the queries are coming from packaged software that
New DataSet Features in Visual Studio 2005
(Jackie Goldstein) Learn about the new features in the typed DataSet class and the new TableAdapter class that are generated by Microsoft Visual Studio 2005, as well as the tools for designing these classes. Also learn about the new BindingSource and BindingNavigator components, and see how to use t
Delimited data set generator
(Ravi Nookala) This tip is useful for making a backup of a given table’s data database in a delimited format. The spool file generated can then be used for future data loads using a tool like SQL*Loader or any VB application. The script works on Oracle 7.x, 8.x and 9.x. (R)
IBM to launch Informix upgrade
(James Niccolai) IBM has released a big upgrade to its Informix database and plans to offer a new “Express” edition of the product, aimed at smaller businesses, by the middle of the year.
Connect to SQL Server Using ADODB Retrieving Records
(Yatin Karekar) This tip will show you how to connect to SQL Server using ADODB Retrieving Records using Record Set and connecting it to Crystal Reports.
Versioning Tolerance Serialization in .NET Framework 2.0
(SeenivasaRagavan Ramadurai) This article is based on .NET Framework 2.0 beta 1. This version of .NET Framework has new features called VTS (Versioning Tolerance Serialization). Before discussing this, allow me to define Serialization. Serialization is the process of saving or persisting the obj
Optimizing Microsoft SQL Server Reporting Services: Performance and Access Reports from the Execution Log
(William E. Pearson, III) In our previous article, Execution Log Reporting: Preparation as a Data Source, we began with a discussion about a valuable source of information for performance and auditing analysis, the Report Server Execution Log. We noted that the Execution Log captures data specif
Unlimited Scalability at a Fraction of the Cost: Database Tiering
GoldenGate and MySQL have introduced database tiering – a solution that allows you to augment your existing database infrastructure with a low-cost, high performance MySQL server farm. Database transactions are synchronized between the MySQL instances and other production databases in real-time
Overcoming old legacy systems with XSLT and Muenchian grouping
(Edmond Woychowsky) Recently I needed to create a Web service that would allow an outside organisation to enter orders on a legacy system using XML. (R)