(Mladen Prajdiæ) Multiple Active Result Sets (MARS) is a new SQL Server 2005 feature that allows the user to run more than one SQL batch on an open connection at the same time. In my previous article about MARS I explained what MARS is and how to use it. In this article I’ll discuss how transactions
Other News
TOP Clause Enhancements in SQL Server 2005
(Keyvan Nayyeri) TOP clause was a part of T-SQL for prior version of SQL Server 2005 but it was limited to SELECT statements and could be used with literal values. There were some techniques to make it dynamic using SET ROWCOUNT statement but SQL Server 2005 introduces some enhancements for this cl
Creating SQL Server Stored Procedures using C#
(Bipin Joshi) Traditionally developers used TSQL to create SQL server stored procedures, functions and triggers. SQL Server 2005 has integrated support for .NET Common Language Runtime (CLR). That means you can now use .NET languages such as C# and VB.NET to create SQL server stored procedures, func
Tip/Trick: Creating Packaged ASP.NET Setup Programs with VS 2005
(Scott Guthrie) You have built an ASP.NET Web Application using Visual Studio 2005, and want to enable customers to automatically install and deploy it on servers via an easy setup program.
Oracle Session Tracing Part V
(James F. Koopmann) Part V in our series will get closer to what we have for years experienced as Oracle’s tracing mechanism. Read On and get re-acquainted with creating trace files for TKPROF.
A beginner’s guide to Websphere Integration Developer
(Greg Fullard) It might seem strange that one person would be involved in .Net and Java projects simultaneously, but that’s my story. I have a self-destructive urge to know everything. Luckily for you, this article will focus only on my Websphere experiences. (If you’re interested in the CSLA.Net Fr
‘ORA-1652: Unable To Extend Temp Segment’ in RAC
(Alex Gorbachev) Today I’ve seen a question on OTN forum about ORA-1652 in alert.log in RAC environment. I immediately recalled the bug and thought that I should mention that here. I quickly found Metalink Note 258941.1 and was surprised to see that there are actually two bugs on that and I only was
Delegates and Events
(Rahul Saxena) Delegates are the function to pointer. A delegate keeps the reference of function. Like as pointer in C/C++, same in C# we have delegates. Delegates in C# are reference types. They are type safe, managed function pointers in C# that can be used to invoke a method that the delegate ref
ASP.NET Configuration and Group Policy, Part 2: Creating and Using Group Policy-Aware Providers
(Alex Homer) In Article 1 of this series, you saw how to create a custom configuration section in a Web.config file and access it using a custom provider. That solves the problem of where to store configuration information and how to use it in your applications, but it doesn’t address another proble
Using industry standard data formats with WebSphere ESB and DB2 Version 9 pureXML
(Mohab El-Hilaly, Andre Tost and Alaa Youssef) Within the context of service orientation, the use of standardized message formats is receiving increased attention. Message formats have been standardized for many industries, including insurance, financial trading, the federal government, and others.