(Willie Favero) This one sounds like a winner. It’s a great topic with an excellent speaker. Even if you are not into WebSphere, I think you can still get a ton of information out of this session. And Maryela really knows her stuff!!!
Author: SSWUG Research
Show 51: Database, managing user expectations, 60 second tip of the day and more.
Pro-Center Video Programming for IT Professionals
A Successful Enterprise Data Warehouse? The Four Biggest Reasons for Failure
(Ad Stam) Many large organizations are preparing or executing projects with the aim to improve business intelligence (BI) delivery by implementing a data warehouse on an enterprise scale. However, in practice, it proves to be very difficult to bring such ambitious projects to a successful implementa
Performance Impact of Enabling Page Checksum and Default Trace
(Linchi Shea) “Should I keep the database page checksum and the default trace enabled on SQL Server 2005?” That is a frequently-asked best practice question. Out of box, these two options are enabled. Although you can argue about the pros and cons of enabling or turning off these options, it is most
SQL Server 2005 Command Line Tool ‘SQLCMD’ – Part I
(Muthusamy Anantha Kumar) Microsoft shipped the SQL Server 2005 command line tool “SQLCMD” along with SQL Server. This SQLCMD replaces the old ISQL command line utility and the OSQL utility. This series will illustrate the various ways of using the SQL Server 2005 command line utility “SQLCMD”.
Quick Tip: Performing an FTP rename
(Nigel Rivett) A common requirement is to process files from an FTP directory. Often this is done by processing every file in the directory and moving each file to an archive directory after processing. Therefore, on the next run, the “live” directory will only contain unprocessed files and the “arc
Exception Handling in .NET 2.0
(Uday Denduluri) Exceptions are unusual error conditions that occur during execution of a program or an application. Most of the programmers concentrate more towards the core functionality and, hence, handling of the exceptions is neglected. It is commonly observed practice that placing a try and ca
An alternative way to MSWord Render extension of SQL Reporting Service using XSLT and xml document mapping
(n_ahid) SQL Reporting service doesn’t support export report to MSWord yet. By using render extensions for exporting MSWord not so easy. This article describes export report to MSWord doc file has some data before. Basically some client/end users always prefer adhoc reporting and some time prefer ba
Introducing Regular Expressions (Part 1)
(Peter Aitken) It’s usually considered a complement to say that someone is a regular guy, but what about a regular expression? Yep, they’re good too, way cool. OK, they’re not really cool, but they are very useful! In a nutshell, a regular expression (sometimes called regexp or regex) is a template
Some thoughts on Declared Global Temporary Tables from Pat Bossman
(Willie Favero) Pat Bossman, DB2 for z/OS Query Optimizer Team at IBM’s Silicon Valley Lab (SVL), was nice enough to share with me an internal blog entry he recently wrote on Declared Global Temporary Tables and told me I could in turn share it with you all. So, since I cannot use a link to point yo