(Marius Bancila) This is the second article of the tutorial. Because it is highly coupled with the first one, I recommend reading the first part before going any further.
Other News
SnapShot Isolation in SqlServer 2005 (Part – II)
(Abey George) In my Previous blog I had explained about SqlServer 2000 Isolation Levels and Locks. SQL Server 2005 gives us a new isolation level, SNAPSHOT, resulting in a total of five isolation levels available for transactions. When the SNAPSHOT isolation level is enabled, each time a row is upda
Enabling SOA Using WebSphere Messaging
(Carla Sadtler, Philipp Huber and SangMin Yi) Successfully implementing a service-oriented architecture (SOA) requires applications and infrastructure that can support the SOA principles. Applications can be enabled by creating service interfaces to existing or new functions hosted by the applicatio
Oracle to stick with current licensing
(Martin LaMonica) Oracle has no plans for a whole-sale shift away from an upfront license model to subscription pricing as rumored, a company representative said.
SQL Performance and Tuning Considerations
(Andy Oppel) This final chapter covers performance and tuning considerations for making the SQL statements you write run faster and more efficiently. First, we’ll have a look at general things that can be done at the DBMS level, followed by guidelines for writing efficient SQL. The
Generating Restrictions in XML Schema Dynamically Using VB.NET 2005: Preliminaries
(Jagadish Chaterjee) This is the first article in a series concentrating on generating restrictions in XML Schema dynamically using Visual Basic 2005. The series is mainly targeted at those who are familiar with XML, XML Schema and the .NET framework.
Custom Paging in ASP.NET 2.0 with SQL Server 2005
(Scott Mitchell) A common pattern in web development is providing paged access to data. Rather than displaying the entire contents of a report or database table to an end user, developers often show only a subset of records per web page, with controls for moving from page to page. With ASP.NET 1.x,
A Look into Transactions in ADO.NET 2.0
(Mohammad Azam) We all have used transactions in one way or the other. In this article, I will show you how you can make use of the SqlTransaction class, which is introduced in ADO.NET 2.0.
Using Grouping Sets in your MQTs
(Chris Eaton) Now that you have seen how grouping sets work, think about how you can use them to speed up your business intelligence queries.
Open Cursor Count
(Vishwamithran S.) This script reports the session-wise open cursor count, which can be helpful information when tuning the open_cursor parameter (in environments where application changes are frequent).