(Brian Knight) As you may have heard, the next version of SQL Server (code named “Yukon”) has a name. The release is now formally called SQL Server 2005 to match Visual Studio 2005. A new schedule was announced that pushes the beta cycle out as well. Beta 2 will be widely shipped in the summer o
Other News
5 Easy Steps to DBA Certification
(Howard Fosdick) If you’re like most people, your New Year’s resolution probably involved some pledge to self-improvement. Why not use DBA certification to fulfill that pledge? In today’s tight job market, it just might be the ticket that moves you in front of less committed candidates.
Scripting Traces for Performance Monitoring on SQL Server
(Andrew Novick) The SQL Profiler is a great tool for monitoring and analyzing SQL Server Performance. I use it all the time to watch the detailed actions of a stored procedure, trigger or user-defined function (UDF) that I am developing. It can also be used to monitor aggregate performance of an ent
CSV to XML
(Dave Pawson) This is a bit of code to build an XML file from a CSV file. Its not unique, but I like it. It addresses the problems of embedded & or < characters, embedded quote marks, even line breaks within a field. I needed the latter since one of the files I play with derives from an HTML form […]
Turning On Pivot Tables
(Jonathan Gennick) Anyone who works with SQL knows that the results of a SELECT statement are returned in rows and columns. Most people also know that you can easily generate additional columns of data in a result by writing expressions that operate on data that actually is stored in a table. For ex
Data Analysis Gets Hot
(Amy D. Wohl) Overwhelmed by the volumes of data we’re producing, organizations are looking for new ways to analyze it into useful information. Because of the volumes involved, they need to find techniques to provide as much automation as possible. Both large and established vendors and small s
Guidelines for choosing the DB2 server platform
(Craig Mullins) How do I choose the DB2 server platform (z/OS, Linux, Unix or Windows)? With some applications, we have the choice of selecting between the platforms, but when should I prefer z/OS, Linux, Unix or Windows? Any guidelines to follow? (R)
Ron Bourret on XML and databases
(Edd Dumbill) A while back, I wrote about the changing face of XML, and said that XML and relational databases appeared to be a slow starter. XML database guru Ron Bourret wrote back with a different perspective.
VoiceXML Forum To Certify Developers
(Jim Wagner) Developers can test and gain certification as a VoiceXML Developer, thanks to a test suite and educational track designed by the VoiceXML Forum, officials announced recently. Certification tracks, while not used as proof of in-depth knowledge but as an indicator of certain baseline
High Availability with SQL Server 2000 Failover and DoubleTake Part III
(Steven Warren) In my previous article, we discussed how to configure and test a typical failover scenario using Double-Take. At this point, you should now be able to create a replication set and configure replication and mirroring. In the final article of this series, we will show you how to restor