Other News

Community

A Rose By Any Other Name

(Linchi Shea) Regardless of the DBMS make or model, the transaction throughput curve of a database system is often shaped like a trapezoid. As the load level goes up initially, so does the transaction throughput. As the load level continues to go up, the transaction throughput will reach a plateau.

Community

MERGE command in SQL Server 2008

MERGE command (also known as UPSERT in Oracle circles) is nothing new to Oracle. It has existed since quite some time. We have also blogged about it on our site – including the enhancements to that command that were made in Oracle 10g. It gets introduced in SQL Server 2008 as well which is a welcome

Editorials

Are You Open to Version 1.00?

Featured Article(s) Handling Concurrency issues in ADO.NET (Part II) This is the second and the concluding part in this series where we will discuss the types of concurrency and the best practices in choosing and working with them. Latest SSWUGtv: Mock Interview, Part II. The Technical Interview: Go through the interview process, questions, answers and interpreting the responses. Learn About […]

Uncategorized

Mock Interview, Part II. The Technical Interview

SQLonCall Mock Interview, Part II. The Technical Interview: Go through the interview process, questions, answers and interpreting the responses. Learn About Questions, Answers and Tips for a Great Experience. > Watch the show here Also, don’t miss: Watch: Microsoft’s Matt Nunn on SQL Server, Visual Studio, features, roles and disciplines. Watch: Handling a DBA interview. A Mock interview with questions, […]

Community

Parsing XML Files with PowerShell

(James McCaffrey) In the context of using Windows PowerShell for lightweight software test automation, one of the most common tasks you need to perform is parsing data from XML files. For example, you may want to extract test case input and expected result data from an XML test cases file, or you mi