(Erika Ehrli) ASP.NET 2.0 provides a new set of possibilities for SharePoint developers. Jo-Anne West and I were talking about the cool things you can do with Windows SharePoint Services 3.0. Both of us have a background working with ASP.NET and SharePoint Products and technologies, so this is a fas
Other News
Advanced topics for DB2 Data Warehouse Edition users, Part 3: Command Line Interface for DB2 Data Warehouse Edition SQL Warehousing
(Marion Behnen, Patrick Titzler and Hoi Yoo) The IBM DB2 Data Warehouse Edition (DWE) Administration Console provides a WebSphere Application Server (WAS) web-based user interface for common SQL Warehousing administration tasks, such as configuration, execution, progress monitoring and execution st
Copy-only backups: Another useful tool in SQL Server 2005
(Greg Robidoux) A new feature added to SQL Server 2005 is the ability to create copy-only backups. The advantage to this type of backup is that it doesn’t interfere with your regular scheduled backup sequences, if you need to create another backup file outside of your regular backup processing. (R)
Focusing on Templates in Oracle HTML DB
(Lawrence Linnemeyer and Bradley Brown) In this second part of a three-part article covering Oracle HTML DB, you’ll learn about common template sections and more.
Optimization Service Center for DB2 for z/OS
(Willie Favero) Have you heard about Optimization Service Center for DB2 for z/OS or OSC for short? This new tool has been demo’ed at a few of the conferences. If you haven’t had the chance to experience this latest no cost tool from IBM for DB2 for z/OS, you need to. This thing is like Visual Expla
Create a date/time value from date parts in VB.NET
(Irina Medvinskaya) When you need to put together a full date/time value from a combination of its specific parts, you can overload the Date object’s constructors and assign the necessary date/time value parts to it. This tip shows how to perform the functionality.
Automate your Database Maintenance using SMO
(Allen White) The most important thing you can do as a database administrator is perform regular database maintenance. This includes regular backups, database integrity checks and optimizations. In SQL Server 2000, Microsoft provided a way to create maintenance plans, which used xp_sqlmaint, to perf
Getting Started with ReportViewer Control
(Mahesh Chand) If you have written any reporting applications in .NET, you may be familiar with Crystal Reports and/or Microsoft SQL Server Reporting Services.
CASE function in SQL Server – part II
(Muthusamy Anantha Kumar) Part I of this series illustrated how to use simple case functions in queries. In Part II of the series, I am going to discuss how to use case functions in different types of scenarios.
Ajax RSS reader
(Jack D Herrington) Learn how to build an Asynchronous JavaScript and XML (Ajax) Really Simple Syndication (RSS) reader, as well as a Web component that you can place on any Web site to look at the articles in the RSS feeds.