Database Tutorials & Articles
-
An introduction to object to relational data mapping with SQLAlchemy
by Sing LiUse SQLAlchemy to ease the creation, testing, and maintenance of database code - with objects.
-
Jazz up your JSP applications with Cewolf
by Sing LiDo you want to create web applications incorporating compelling charts and graphs? Cewolf provides a quick route.
-
MultiValue data with InterSystems Caché
by Kay EwbankWhile the majority of attention in the media focuses on traditional relational databases, the MultiValue market continues to thrive.
-
What's new in SQL Server 2008
by Kay EwbankThis year sees the arrival of SQL Server 2008. What are the key features?
-
Creating rich Internet applications with InterSystems Zen
by Kay EwbankLast month, we looked at the combination of Jalapeño and Caché from InterSystems to see how well the two worked together for the Java developer. This month, it's the turn of the web browser development feature in Caché, Zen.
-
Caché and Jalapeño
by Kay EwbankThe unified approach to objects, data structures and programming.
-
Service Broker - the asynchronous messaging framework in SQL Server 2005
by Klaus AschenbrennerSQL Server's Service Broker sounds mysterious, but it's easy to use and effective, as Klaus Aschenbrenner demonstrates.
-
Table variables v temporary tables in SQL Server
by Kay EwbankAre variables or temporary tables better in SQL? Kay Ewbank offers us the answer.
-
Chain of command
by Kay EwbankUsing Reporting Services with SQL Server 2005 Express and Visual Studio 2005.
-
Plain Old Java Persistence with Caché
by Andreas DieckowHow InterSystems' Jalapeño Technology benefits data storage through object technology
-
Caché gains strength
by Kay EwbankMoving beyond the relational model.
-
Indirect Replication of Access 2003 databases
by Kay EwbankHow do you replicate an Access 2003 database? Kay Ewbank explains how to solve this tricky problem.
-
Quicker, cannier SQL with Caché
by Dr. Mark MassiasHow Intersystems' technology enables business intelligence solutions.
-
Solving Sudoku with SQL
by Samuel AinaIf you thought Sudoku was a challenge, then consider the more interesting challenge of writing a program to solve it. Samuel Aina shows how in T-SQL.
-
Managing database locks in SQL Server
by Kay EwbankDon’t ignore the way that records are locked by your database – choosing the right lock can result in much improved performance from your applications.
-
CLR and SQL Server 2005
by Niels BerglundThe Common Language Runtime within SQL Server 2005 frees programmers to create powerful procedures to manipulate stored data.
-
Improvements to Transact-SQL
by Dandy WeynNew features and enhancements in SQL Server 2005 automate several previously laborious ranking and windowing functions.
-
Leading the database race
by Kay EwbankNew features and tools in SQL Server 2005 – an overview.
-
Flying out of the gate with Derby
by Sing LiDerby is a 100% Java open source relational database, and you can’t afford to ignore it.
-
Assessing SQL Server 2005 Express Edition
by Kay EwbankThe new SQL Server 2005 Express Edition is aimed at developers – is it up to the job?