by Kendall Grant Clark – In last week’s column I suggested, only half-jokingly, that one motivation for new XML developments was to give techie journalists like me something new to write about. In making this silly claim, I was primarily reacting to what is widely seen as a kind of monotonous redund
Other News
DTS Programming Techniques Used in Microsoft SQL Server Accelerator for Business Intelligence
Learn about the Data Transformation Services (DTS) programming techniques used in SQL Server Accelerator for Business Intelligence (BI Accelerator). Using these techniques, the Microsoft BI Practices team created an extensible data movement system for analytical applications that developers can exte
Create Reusable Windows Data Entry Controls
by Tim Landgrave – When bad client logic allows invalid data to make it to the database, only to be rejected on an insert or update operation, extra database calls are generated. This isn’t a problem when you’re developing applications for a small number of users in a connected environment. But in a
Return all values in a comma-delimited string
(Preethiviraj Kulasingham) This script will return one big string where the rows are seperated by commas. When getting a set of rows of a field (any string type field), this script could be used to find the field names seperated by commas. It works on SQL server 2000 and 7.0. (R)
Monitor SYS and SYSTEM Accounts
by Daniel Stanley – Create a procedure to monitor and log users logging onto the database with the SYS and SYSTEM accounts. Create two new SYS objects:
IBM Aims To Help Partners Become ‘Web Services Gurus’
By Elizabeth Montalbano – At PartnerWorld, IBM plans to unveil a new developer subscription service and a host of programs to help partners deploy Web services, an IBM executive said. The new developer service, called IBM developerWorks Toolbox, is similar to Microsoft Developer Network and M
Modular Speech Application Development Using VoiceXML
By Hitesh Seth – One thing weve learned from Web-based application development is that tools are useful only if they can reuse components and third-party libraries and make it easy to assemble applications. This article reviews how we can build modular speech applications using VoiceXML. The focus w
e-business on demand: A developer’s roadmap
By Alfredo Gutierrez – IBM has defined e-business on demand as an enterprise whose business processes — integrated end-to-end across the company and with key partners, suppliers, and customers — can respond with speed to any customer demand, market opportunity, or external threat. Are you wonderin
SQL Server System Administration (The Landmark Series)
Book by Sean Baird, et al – SQL Server System Administration assumes that you are familiar with the fundamentals of database administration and have worked with SQL Server in some capacity. This book focuses on the topic of interest to most administrators: keeping data consistently available to user
Detecting “Runs” or “Streaks” in your data
This article comes from Jeff Smith. Jeff writes “It can be difficult in a set-based language such as SQL to determine when a number of records in a row (when ordered by a unique key) have the same values in a particular field. For example, you may have a table of GameResults, with fields such as Gam