Microsoft Systems Management Server (SMS) 2003 Reporting uses Microsoft SQL Server views to provide access to data from the tables in the SMS site SQL database and to offer an efficient reporting option. The SMS site SQL database contains a large collection of information about the network, computer
Other News
Forging Transact SQL Code with CodeSmith
(Jeffrey Juday) Coding Transact SQL (TSQL) can be tedious and repetitive. Often, a TSQL statement or stored procedure is a one-off variation of a program you may have written just yesterday. Nothing excites a developer more than eliminating unnecessarily tedious or repetitive work. Face it: We’re la
Using Asymmetric Encryption and Digital Signatures in a SQL Server 2005 Database
(Erich Peterson and Siqing Li) Two previous article of ours, An Overview of Cryptographic Systems and Encrypting Database Data and Using Symmetric Encryption in a SQL Server 2005 Database, explored cryptosystem fundamentals and looked at encryption support in Microsoft SQL Server 2005. We compared a
MySQL Multi-Master Replication
(Patrick Galbraith) I have put on the hat of a MySQL user, a customer, as opposed to a developer (Federated Storage Engine, DBD::mysql) these last couple months with my new employer, Grazr. One of the things we need is a whole replication set-up, with read-only slaves, and write masters. Thats maste
Breaking Out of the Browser
(Steve Muench) In previous columns, I have focused on the basics of creating Web applications by using Oracle Application Development Framework (Oracle ADF). However, the Oracle JDeveloper environment is also great for creating applications that have a polished desktop look and feel. These desktop a
Oracle’s Hyperion Deal Puts Users on Guard
(Heather Havenstein) Oracle Corp.’s purchase of business intelligence vendor Hyperion Solutions Corp. will likely benefit Oracle, but Hyperion customers could experience a decline in service and end up with less negotiating leverage, some users and analysts said.
The Three Faces of ASP.NET AJAX
(Jesse Liberty and Dan Hurwitz) The new Microsoft ASP.NET AJAX web development framework (which we’ll refer to simply as AJAX throughout the rest of this article) is like a mythological figure with three faces to its personality: one is friendly but rigid, one is playful, and the third is, to most A
WebSphere Classic Replication Server for z/OS (Release 9.1) – An end-to-end scenario using native VSAM capture
(Anil Varkhedi, Thomas Atwood and Tom Wabinski) Follow an end-to-end data replication scenario from native Virtual Storage Access Method (VSAM) files to IBM DB2 Universal Database (DB2 UDB) for z/OS using IBM WebSphere Classic Replication Server for z/OS, IBM WebSphere Replication Server for z/OS, a
Hey Houston, more free System z education
(Willie Favero) First we have an extremely well attended DB2 User Group meeting. Now IBM is offering a free one day mainframe seminar that is including Houston as one of the cities they will be stopping at.
What to Know and Avoid when Migrating to XML
Global XML is having a profound impact on localization strategies, revolutionizing the assembly and delivery of information and decoupling content from its containing form. Global XML content is mobile and wants to aggregate, flow, and recombine. This leads to agile information systems and assets-an