(Steve and Gargi) Showplan is a feature in SQL Server to display and read query plans. While some of you may already be very familiar with Showplan, it is one of the most important diagnostic tools that we use in the query processing team to locate and identify problems, and therefore deserves some
Author: SSWUG Research
zIIP APAR alert
(Willie Favero) I have posted a bunch of times now with list of APARs required to enable the zIIP specialty engine. This time, although zIIP related, is a little different. The APAR PK27712 fixes a problem with the accounting reports in DB2 PM and DB2 PE when reporting real zIIP time or PROJECTCPU
Compress Binary Messages Using SQL
(Alex Kozak) Binary data is natural for computers. Everything running on the computer’s physical layer, in the registers, ALU, memory, and so on, is just a result of manipulating a set of 0’s and 1’s, where 0 and 1 are the logical representations of two different voltage levels. While very convenien
Build an RSS Blog Roller with C# and ASP.NET
This example demonstrates how to build an ASP.NET blog roller that is capable of aggregating multiple RSS feeds and displaying a specific number of items from each one. The application was writen using C# and demonstrates using generics, nullable types and XmlReaders and subreaders to accomplish the
Designing a SQL Service Broker Control Bus
(Jeffrey Juday) SQL Service Broker (SSB) is the new standard for distributed messaging solutions built on top of SQL Server 2005. Although SQL Server Management Studio provides some administration for SSB, its features are inadequate for complicated configuration and monitoring implementations. So,
Adding New Nodes to Your Oracle RAC 10g Cluster on Linux
(Murali Vallath) In most businesses, a primary business requirement for an Oracle Real Application Clusters (RAC) configuration is scalability of the database tier across the entire system—so that when the number of users increases, additional instances can be added to the cluster to distribute the
Learn Data Warehousing: Data Warehouse Schedule
(Lewis Cunningham) I am frequently asked to blog about data warehousing from a beginner view. I have started to do that several times but there are just so many topics to talk about it’s hard to know where to start.
Drilling GL sub-ledgers
(njethwa) In this article we will see how to drill from GL balances to Journal Details and into Sub-ledger transactions. We will also see how all these things fit together in an Operational Finance Dashboard.
CodeSnip: How to Create an Extended Calendar in ASP.NET
(Nidal Arabi) Using a calendar control to let the end user select a date in the standard normal way in ASP.NET would cause a post back. Is there a way of using the control with minimum roundtrips between the server and the client browser? In this article I will be using a calendar control that was
.NET Portable Executable File
(Abey George Peter) Lets try to figure out what’s inside PE and how its helps CLR to run our dlls. If you compile your source code, the compiler translates your source code into Microsoft Intermediate Language (MSIL), which is a CPU-independent set of instructions that can be efficiently converted