(Andrew Novick) The current theme is about application trace messages. So far we’ve created AppSession rows to organize a session, AppSessionTrace rows with the trace lines, and AppSessionMeasurement rows to store metrics. At the end of each script that uses the usp_AppSession_* stored procedures
Other News
Need a Date? Here’s DB2’s Answer— Using Chronological Data in DB2 Chronological Data Type Formats
(B.L.“Tink” Tysor) One of the first things I became aware of when I started my programming career was how often time (or chronological) data was used in calculations. I became convinced that more design time was spent deciding the definition of dates and times (chronological data) than any other sin
T-SQL Checklist
(Itzik Ben-Gan) T-SQL is the core language for server-side data access and manipulation in SQL Server. Applying best practices will help you get the most out of T-SQL. You can use the following checklist to make sure that your T-SQL code is efficient and easy to maintain. (R,$)
IBM Targets Enterprise Content Compliance, Integration
(Brice Dunwoodie) IBM announces a new Enterprise Content Management (ECM) portfolio touting over 160 vertical content applications, features for regulatory compliance, and broad enterprise information repository integration.
Microsoft & Sun: What is the Right XML Strategy for Information Interchange? – Keynote Debate at Gilbane Content Management Conference
The Gilbane Report and Lighthouse Seminars announced that the Gilbane Conference on Content Management, taking place April 11-13 at the Palace Hotel in San Francisco, will present a keynote debate titled: “What is the Right XML Strategy for Information Interchange?” Participating in this debate are
Implementing PEAR’s DB package
(Phillip Perkins) PHP provides the adept developer with the tools to create some powerful Web solutions. Moreover, with the ability to add additional functionality through extensions, it makes creating solutions easy. PEAR, the PHP Extension and Application Repository (http://pear.php.net/) is a fra
Inside Software Factories
(Matt Nicholson) Software factories integrate modelling and code generation with patterns, frameworks and guidance to provide developers with a development environment tailored to the job in hand. Matt Nicholson talks to Steve Cook, an Architect for Visual Studio Team System, about software fact
Users Express Confidence in SQL Server 2005 Performance
(Lisa Vaas) SQL Server 2005 is performing just fine in at least one beta customer’s site, contrary to a recent report that expressed doubt as to the upcoming relational DBMS’ ability to do high-performance computing.
VSA Scripting in .NET – Introduction
(Mark Belles) This article will focus on Visual Studio for Applications, or VSA, and explain how it can be integrated with .NET programs. It will also explain a few key areas you must understand in order to successfully integrate VSA into your programs.
xp_pcre – Regular Expressions in T-SQL
(Dan Farino) xp_pcre is a follow-up to my extended stored procedure xp_regex. Both allow you to use regular expressions in T-SQL on Microsoft SQL Server 2000. This version was written because xp_regex uses the .NET Framework, which many people were reluctant to install on their SQL Servers.