(Brian Eastwood) For today’s Visual Basic 6 developer, there are three sometimes stark realities. (R)
Author: SSWUG Research
Mimic SQL Server Management Studio reports for Reporting Services
(Michelle Gutzait) One of the most useful tools shipped with SQL Server Management Studio is the standard reports. Owning the source code in these reports could satisfy a number of needs in your organization. (R)
Build a Custom Data-Bound Generator
(Jeff Levinson) In this information-packed column, I will show you how to write a custom data-bound generator (DBG) for Visual Studio 2005 Team Edition for Database Professionals (DB Pros). You can download the solution code associated with this column (it’s available in both C# and VB). This genera
SQL Server 2005 Integration Services – Part 49 – Maintenance Plan Tasks
(Marcin Policht) In the most recent articles of our series covering SQL Server 2005 Integration Services, we have focused on maintenance plans activities, represented by a number of tasks in Maintenance Plan designer of SQL Server Management Studio (including additional caveats introduced by Service
Ajax: Creating Native JavaScript Objects From SQL
(James Robson) Ajax is useful for fetching data to web pages without requiring that the pages reload; it speeds up the user experience of your web site. This article will show you how to build an ASP.NET web application in C# that takes advantage of Ajax’s dynamic ability.
DB2 9 Viper helps hospital cure performance pain by storing XML, relational data in one DBMS
(Hannah Smalltree) When a major hospital network in South Korea wanted to electronically consolidate all patient data — much of it handwritten — it faced some major hurdles. (R)
XML and Java technology: Low-level or high-level XML APIs?
(Brett D. McLaughlin, Sr.) Not many years ago, the options for working with XML were limited essentially to SAX, DOM, or a home-brewed API. With hundreds of different developer-friendly APIs today, though, have developers lost some of their ability to manipulate XML?
Now Reporting
(Sue Harper) In March 2006, Oracle announced the availability of Oracle SQL Developer, a GUI for Oracle Database. Oracle SQL Developer provides an easy-to-install, lightweight, multiplatform GUI that enables database developers to do a variety of database activities, including browsing, creating, an
Working with PHP and MySQL
(Michele Davis and Jon Phillips) Last week, you began learning how to use PHP to display and modify data from a MySQL database. This week, you’ll learn how to select the database, fetch and display data, and more.
Padding a string for fixed width display in VB.NET
(Irina Medvinskaya) Whenever you need to display data in a console or get it ready to be printed, you may need to align columns for a fixed width display in VB.NET. In this tip, I look at a simple way to pad strings for a fixed width display utilizing the PadLeft and PadRight methods of a String obj