(Gregory A. Larsen) Have you ever wanted to return the last 100 rows of a given set of records? What about the second set of 100 records? Or possibly, you have wanted to return the first so many billing records for each billing month. This article will discuss how to use the TOP clause to help solve
Author: SSWUG Research
SQL to View Database History
(Chris Eaton) Yesterday I posted an entry on using SQL to query the notification log. Today I’ll show you how to use a new view to query the database history. In previous releases (and still today) you can look at the database history to see when objects were created or dropped, when objects were ma
A Database Development Model Using SQL Compare
(Richard Mitchell) The Red Gate website – an ASP.NET site running on SQL Server 2000 – recently underwent a major overhaul. Here, Richard Mitchell and Steven Davidson, the developers on the project, describe how they used Red Gate’s database schema-comparison tool, SQL Compare, as an integral part o
XML 2006
(Elliotte Rusty Harold) Last month marked ten years since the World Wide Web Consortium (W3C) Standard Generalized Markup Language (SGML) on the Web Editorial Review Board publicly unveiled the first draft of Extensible Markup Language (XML) 1.0 at the SGML 96 conference. In November 1996, in the sa
A Theory of Compatible Versions
(David Orchard) Making versioning work in practice is a difficult problem in computing. Arguably, the Web was able to increase dramatically in popularity because evolution and versioning were built into HTML and HTTP. Both systems provide explicit extensibility points and rules for understanding ext
Recursive XSL Templates
(Kiran Kumar G.) XSL is a declarative programming language. Variables that are once declared cannot be reassigned. It is often difficult for programmers coming from procedural languages background to do advanced tasks. Using XSL, we can solve complex problems, which at first glance often seem to be
ADF Business Components, Resfresh After Insert/Update and Instead Of triggers
(Lucas Jellema) Some things are almost to tiny to blog about. Then again, if a blog can save you a lot of work and frustration then, even it is about something very small, perhaps it is worth it after all. Today’s topic: ADF BC Entity Objects in combination with Views that have an Instead Of trigger
Creating a Standby Database (traditional method)
The process involves making a full backup of your production database on the primary server. This can be either a hot or a cold backup. If a hot backup is used, then the archive log files created during the backup will also need to be copied to the standby database. (pdf)
Learn how to migrate from MS Access to the most popular open source database – MySQL
(Allen Lee) In an era where data becomes volumetric in every business, much attention has been given to proper database management and the ease of data access. Businesses that use Access begin to look for an alternative which allows better database performance, higher reliability, higher flexibility
Generate Permutations for Characters or Numbers
(Frank Zhou) This query generates permutations for X number of unique characters or numbers.