(Serdar Yegulalp) SQL administrators typically set up a nightly or weekly maintenance plan for their databases. The details of a maintenance plan will vary depending on what’s needed for a particular database, but it usually consists of making a backup, checking the database and its indexes for inte
Other News
Getting Started with MySQL and SQL (Sample Chapter)
(Paul DuBois) Perfect for SQL novices, this chapter provides an introduction to the MySQL relational database management system (RDBMS), and to the Structured Query Language (SQL) that MySQL understands.
Introduction to DB2 Stored Procedures
(Justin Whitney) When it comes to stored procedures, there seem to be three kinds of developers: those who love them, those who hate them, and those who don’t really know what the heck they are. DBAs usually fall into the first category, coders in the second, scripters in the third (as a former scri
Convert VBA Code to Visual Basic .NET When Migrating to Visual Studio 2005 Tools for Office
(Dale Oberg) Convert code from Visual Basic for Applications to Visual Basic .NET when migrating to Microsoft Visual Studio 2005 Tools for the Microsoft Office System. This document highlights the reasons to migrate, the major code conversion issues, and additional resources for further details.
Automated Smart Client Deployment and Update – Today and Tomorrow
(Brian Noyes) Smart client application architecture is gaining ground as a replacement for many intranet and some internet web applications. Smart client architectures have many considerations that you need to take into account to build a well robust, reliable, scalable, performant, and secure app.
Anatomy of an Attack: The Five Ps
(Kerry J. Cox and Christopher Gerg) In a meeting with an engineer (Jonathan Hogue) from a security company called Okena (recently acquired by Cisco), I was introduced to the concept of the five Ps. Hogue graciously gave me the presentation slide and I use it all the time. There are a lot of models o
Microsoft SQL Server Express 2005 (MSDE)
(Don Schlichting) SQL Express 2005 is a new, FREE, Microsoft SQL Server lightweight edition. This new edition is the upgrade to Microsoft’s SQL Server 2000 Desktop Edition (MSDE). Targeted to developers of “simple” applications, it includes a fully functional SQL Server database engine and a Query A
Tip: Twisting XML with XSLT 2.0
(Jack Herrington) The XML story has two sides: data creators and data consumers. XSL typically falls on the consumer side of the equation, and all too often the format of the data is fixed well before a template gets to it. Take a list of books, for example. You might have an XML file with a list so
Database 10g update to feature more automation
(Mark Brunelli) If Oracle has its way, the vast majority of database management functions will soon be fully automated. To find out more about those plans, SearchEnterpriseLinux.com recently got on the phone with Willy Hardy, Oracle senior director of database product marketing, and Monica Kumar, Or
Database Security: Beyond the Password
(George Jucan) Recently we’ve seen a dramatic increase in public and business awareness of safeguarding private and personal information. With specific legislation now in place in many countries, it is now not only a public relations matter but also a legal obligation to protect identifiable data ab