Other News

Community

LINQ provider basics

(Mehfuz Hossain) LINQ (Language Integrated Query) works as a middle tier between data store and the language environment. From a developer’s point of view, it is just a new pattern for querying data from multiple data structures directly in the IDE. Behind the scenes it does a whole lot of tasks lik

Community

Oracle Library Cache—Part I

(James Koopmann) Gaining an understanding of internal Oracle structures is essential to becoming better DBAs and servicing our end user community. Oracle’s library cache is one such internal structure that, after learning about, can help eliminate some very nasty denial of service requests originati

Community

PIVOT AND UNPIVOT IN 11g

(malam) The Pivot clause is a new feature that has been introduced with the introduction of 11g.The simple logic behind the Pivot clause is that it enables the user to rotate rows into columns in the output of a query and at the same time enable the user to run aggregate functions on the data.

Editorials

Final Virtualization Thoughts and Feedback

Featured Article(s) Kill a Blocking Session After Waiting a Parameterized Wait Time Value The following stored procedure can be used inside a job that runs on a recurrent basis and kills all blocking session (block column in sysprocesses != 0) that the wait time column of the blocked session is greater than a parameter value (in miliseconds) The procedure kills […]

Uncategorized

Virtualization, Getting Help with SQL Server and More

Featured Article(s) New Features in ADO.NET (Part III) ADO.NET has introduced many cool features to improve the scalability and performance of data centric applications. With features like provider independent factory models, support for XQuery handling with xml data type and asynchronous processing techniques, the amount of LOC, code complexity and maintenance has been greatly reduced thus helping the developers to […]