(Mahesh Sabnis) In WCF 4.5, there is a new option available to generate Task based async operations so that the code from the client side can be then less complex. In this article, we will see how to implement it.
Author: SSWUG Research
Using sys.dm_os_ring_buffers to Troubleshoot Connectivity Issues
John Sansom) I encountered an interesting question over on the MSDN forums concerning a poster that was reporting experiencing an issue whereby the “sa” account kept being locked out.
Getting a query plan
(Kenneth Fisher) Query plans are an essential tool when doing performance tuning. When looking at a query plan you should be aware that there are two different types of query plans. There are Estimated and Actual query plans (also called Execution Plans). Estimated and Actual query plans have the fo
Configuring the Maximum Degree of Parallelism
(Rod Colledge) A commonly altered setting is Maximum Degree of Parallelism (MAXDOP), which controls the maximum number of CPUs that can be used in executing a single task. For example, a large query may be broken up into different parts, with each part executing threads on separate CPUs. Such a quer
XMLDocument: The Faster Legacy XML Option
(Jackson) Sometimes the old, legacy option is faster than the new one you’re supposed to use. That happens to be the case with XML in Flash: XMLDocument is quicker than XML. Today’s article tests its performance to figure out just how much faster it is and if it can keep up with plain Object and typ
SSWUGtv: Steve and Joseph Vertido MD-MVP Channel Manager / Data Quality Analyst talk about clean data and SSIS.
Video Programming for IT Professionals
Getting started with WebSphere Service Registry and Repository V8: Part 1
(Martin Adams, Evan Jardine-Skinner and Martin Smithson) This article shows you two ways to populate WebSphere Service Registry and Repository (hereafter called Service Registry) with existing web services information. Part 1 shows you how to use a sample Java application to load information from a
Introduction To DOM Nodes in JavaScript
(Abhijeet Singh) The DOM represents a document as a tree. The tree is made up of parent-child relationships, a parent can have one or many child nodes.
Generating test data for MySQL tables
(Jaime Sicam) One of the common tasks requested by our support customers is to optimize slow queries. We normally ask for the table structure(s), the problematic query and sample data to be able to reproduce the problem and resolve it by modifying the query, table structure, or global/session variab
SPFILE for a CDB vs. a PDB
(Bobby Curtis) Recently, I have had conversations with users about Oracle Database 12c. One question that often comes up is, how does the database manage the parameters between a container database (CDB) and a pluggable database (PDB)? In order to answer this question, I had to work with my plugga