(Barbara Darrow) What’s next on the open-source stack agenda? It could be an open-source XQuery engine, if Oracle’s Roger Bamford has his way.
Author: SSWUG Research
Transfer Excel ‘07 data to SQL Server 2005 EE with ADO.NET
(Dennis) This post is about how we can: –Retrieve data from closed workbooks (Excel 2007) with a new Provider and –Update a SQL Server 2005 EE (Express Edition) database with the retrieved data.
RDA and the DBA
(Nelson King) If I were asked to name the best feature of IBM Rational Data Architect (RDA), I’d have to say it’s the product’s versatility. Sure, the ease of creating federated data sources and the slick Eclipse-based Workbench are terrific high-level features, but they’re only contributors to RDA’
Travels with Mark: A Hitchhiker’s Guide to the UniVerse, Part 4: File and performance implications
(Mark Baldridge) In this installment of the UniVerse performance series, continue the investigation of UniVerse file performance, examining the inner workings of dynamic linear hash files. Explore the challenges of setting an appropriate separation, once you choose one. (R)
How to number rows in MySQL
(xaprb) I wrote before about a generic, cross-platform way to simulate the SQL ROW_NUMBER() function in any RDBMS. There is a much more efficient way to do this on MySQL with user variables.
TableLayoutPanels
(Ken Getz) I’ve been writing quite a bit of courseware lately, and many of the demos for the courses require the presenter to step through a number of simple procedures, demonstrating various features of Visual Studio® or the Microsoft® .NET Framework. For example, I recently worked on a course in w
Should you use SQL Server Express Edition or Microsoft Access for your small business applications?
(Tim Chapman) When you’re weighing you options in database applications, it helps to make a feature-by-feature comparison. This overview will look at the feature sets of the Express edition of SQL Server 2005 and Microsoft Access. I did my best to avoid including too many details for the categories
Enable Change Tracking in Oracle for faster incremental backups
(Bob Watkins) Recovery Manager (RMAN) was introduced in Oracle 8.0 and enabled true incremental backups for the first time. Prior to RMAN, database exports could be taken incrementally, but if any block in a table was changed, the entire table was written. RMAN incremental backups write only the cha
Build Custom Code Generators in C#
(Dave Dolan) Quite simply, code generation involves taking a small amount of input and generating a large amount of code from it. Often the structure of the output is very complicated and verbose. One key feature of generated code is that it takes only a small variation in input to produce a vastly
RFID – Too Much Intelligence or Too Little Understanding?
(Shari Rogalski) Oscar Wilde once said, “It is a very sad thing that nowadays there is so little useless information.” His observation in the 19th century has a new kind of resonance in modern corporate life. Besieged by the wizardry of the electronic age, collecting structured and unstructured data