Database Tutorials & Articles
-
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.
-
Developing for Office 2007
by Matt NicholsonThe forthcoming 2007 Microsoft Office System offers many new opportunities for software developers. Matt Nicholson looks at the new user interface and the Open XML file format, finds out what's happened to VSTO, and explores the possibilities opened up by SharePoint Server 2007 and Groove 2007.
-
Plain Old Java Persistence with Caché
by Andreas DieckowHow InterSystems' Jalapeño Technology benefits data storage through object technology
-
Testing for Security in the Age of Ajax Programming
by Bryan SullivanAjax programming, which allows a web page to refresh a small portion of its data from a web server, is an exciting technology that has recently been introduced. However, this type of programming can also leave applications open to SQL injection and similar attacks. Learn more about Ajax programming and what it means in terms of security.
-
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.
-
SharePoint, Document Library and SQL Server
by S.S. AhmedThis tutorial shows how you can capture a document in SharePoint's document library, retrieve information from its properties and store in in SQL Server. It will teach you how to use Event Handler Toolkit.
-
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.
-
Using WMI From Managed Code
by Andriy KlyuchevskyyWindows Management Instrumentation (WMI) is Microsoft's implementation of Web-Based Enterprise Management (WBEM) and the Common Information Model (CIM). Although WMI is COM-based, Andriy Klyuchevskyy shows you how you can access it from C# and VB.NET through System.Management, thanks to COM Inter-Op.
-
Creating Applications for Handheld Devices Using eMbedded Visual Basic
by Rob BickelA no nonsense tutorial designed to give Visual Basic developers an insight into developing VB applications for handheld devices such as PDAs.
-
High-Performance .NET Application Development & Architecture
by Dimitrios MarkatosThis article demonstrates the art of creating and architecting high-performance and scalable .NET applications, covering all stages, from planning to development and their perspective best practices.
-
Locking the Door behind You: Hacker Protection for Your Web Applications
by Caleb SimaYour Web applications can be the most important and most vulnerable entry point into your organization, and, as such, ensuring adequate hacker protection in your Web applications can be critical. This article discusses some of the issues.
-
Visual Basic 6.0 - Exporting a DataReport to Microsoft Word
by conwayjdThis article is a simple yet effective way to export a DataReport to MIcrosoft Word using the DataEnvironment and DataReport. This walk-through starts with creating a simple database in Microsoft Access and then creating a User Interface in Visual Basic 6.0.
-
New features for web developers in ASP.NET 2.0
by Alex HomerASP.NET 2.0 brings enhanced performance and many new features that make the web developer's life easier. Alex Homer takes you through what's new.
-
DataGrid/GridView Paging and Sorting Using A DataReader
by Dimitrios MarkatosThis article will demonstrate two ways one could implement the DataReader to bind a DataGrid, that includes caching, paging and persistent bi-directional sorting, all without the use of a DataAdapter/DataSet at all, and includes ASP.NET 2.0 GridView version!
-
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.
-
Selecting, Confirming & Deleting Multiple Checkbox Items In A DataGrid/GridView - Part 2: Maintaining CheckBox State Acr
by Dimitrios MarkatosIn this article, we will examine how to create a fully functional DataGrid and GridView in .NET 2.0 with all the features you'd find set up on Hotmail, Yahoo, and AOL Mail, and further demonstrate how you can multi-select items across pages and batch delete them all.
-
Improvements to Transact-SQL
by Dandy WeynNew features and enhancements in SQL Server 2005 automate several previously laborious ranking and windowing functions.