(Alan Zeichick) The release of ADO.NET 2.0, as part of the Visual Studio 2005 launch and the refresh of the .NET Framework and Common Language Runtime, passed relatively unnoticed. That’s understandable. With so much going on in the Microsoft tools domain, with the new Visual Studio Team System, SQL
Other News
OLAP SQL Part 2 – CUBE
(Chris Eaton) Much like the rollup operator, the GROUP BY CUBE statement performs groupings on the columns listed to deliver subtotals and grand totals. The syntax is SELECT … FROM … WHERE … GROUP BY CUBE(column1,column2,..)
Securing your WCF service
(William Tay) In this article I will show you how you can implement security on a WCF service. There are many options and extensibility points for implementing security in WCF. You can also use specific products, such as the Windows 2003 Server Authorization Manager, together with WCF to implement t
‘Father of DB2’ to Mentor Super-Fast Database Startup
(Lisa Vaas) Don Haderle, the man known as the “father of DB2,” has signed on to be the first member of a technical advisory board being set up by ANTs Software.
Presenting Data with the DataGridView Control in .NET 2.0
(Brian Noyes) In .NET 1.0, the DataGrid control was the primary Windows Forms control for presenting tabular data. Even though that control had a lot of capability and could present basic tabular data well, it was fairly difficult to customize many aspects of the control. Additionally, the DataGrid
Improve your dev skills with an intimate knowledge of PHP’s date and time functions
(Mellonfire) Whether they’re being used to display the current server time or record the exact instance of a database entry, PHP’s date and time functions are a critical part of any Web developer’s toolkit. Any tool, however, is only as good as the craftsman wielding it; and that’s where this docume
Microsoft BizTalk to WebSphere Business Intergration Express Migration
(Rufus Credle) The purpose of this Redbook is to help the reader understand what is involved and identifies known issues involved in migrating a BizTalk® application into the WebSphere Business Integration Server (WBIS) environment. This Redbook deals only with migrating a BizTalk 2002 application i
SQL Server Clinic: T-SQL performance problems and solutions
(Baya Pavliashvili) When application users start experiencing performance problems, they typically call the database administrator and ask if there is a problem with the database. Interestingly, most people will look at memory, CPU and disk utilization, but not at the particular code modules that ca
Executing SQL Stored Procedures from inside a Web Application Part 1
(Don Schlichting) This article will explore the hows and whys of executing SQL Stored Procedures from inside a web application.
FIX: Error message 17883 may be logged in the error log when you try to manually update table statistics in SQL Server 2000
When you try to manually update table statistics in Microsoft SQL Server 2000, the following message may be logged in the SQL Server error log: DateTime server Error: 17883, Severity: 1, State: 0 DateTime server Process 905:0 (19c4) UMS Context 0x0000000053E318F0 appears to be non-yielding on