(Mel Shum) As a DBA, one of your many tasks is to manage your SQL Server databases’ ever-expanding storage requirements. How often do you find yourself adding more disk, trying to accurately size a database, or wishing you could more efficiently use your existing disk capacity? Storing database
Author: SSWUG Research
Road test: Four databases tested
(Steve Turvey) For many businesses, a database is the vital organ that lives, breathes, and protects precious data — the treasured jewel of their enterprise. Everything they know, and every way to know it, is dictated by these all-powerful tools.
Automate acceptance tests with Selenium
(Christian Hellsten) Acceptance, or functional, testing is designed to put manual tasks through their paces, but testing these tasks by hand can be time consuming and prone to human error. In this article, the author shows architects, developers, and testers how to use the Selenium testing tools to
Top Ten UI Development Breakthroughs In Windows Presentation Foundation
(Ian Griffiths and Chris Sells) The current Win32-based Windows UI graphics subsystem, found in Windows XP, has been around for nearly 20 years. It’s aging and limited, and as a result, user interface development has been somewhat, well, constrained at best.
.NET Stored Procedures: Autogenerating INSERT Statements for rows in Oracle Tables
(Jagadish Chaterjee) In this article, I shall introduce you to developing a .NET based CLR stored procedure, which can generate INSERT commands automatically for every row in a specified SELECT statement against an Oracle database.
Comparing real-time cardinality to the optimizer cardinality estimates
(Samir Kapoor, Sudharsan Selvarajah and Kaarel Truuvert) Evaluating real time cardinality in IBM DB2 Universal Database (DB2 UDB) versus the estimated cardinality in the access plan can help DBAs make various decisions to improve query performance. Here are all the details to create count queries to
Forms and URLs (Sample Chapter)
(Chris Shiflett) This chapter discusses form processing and the most common types of attacks that you need to be aware of when dealing with data from forms and URLs. You will learn about attacks such as cross-site scripting (XSS) and cross-site request forgeries (CSRF), as well as how to spoof form
XML Onboard: The Developer Potential of Office 12 for Commercial Enterprise Software
(Alan Zeichick) The beta’s out! The technical beta of Microsoft Office “12” (where do they get those clever code names?) hit in mid-November. Unfortunately, many developers can’t have access to this very preliminary beta—Microsoft is only distributing it to a short list of customers and partners. (R
Consider what’s new in Microsoft SQL Server 2005
(Scott Lowe) SQL Server 2005 has finally hit the market and brought with it significant new features and changes from previous versions. This document explains the various editions of SQL Server 2005 and provides you with an overview of the new management console.
Create Reusable Project And Item Templates For Your Development Team
(Matt Milner) Over my years of working with clients on building Microsoft .NET Framework-based applications, I have often heard a common feature request for Visual Studio .NET: “It would be great if we could create our own project types and item types so that all developers in our organization would