(Harry Dragstra) Once you are able to show the xml version of the alert log as data in database table Alert_XML, it would be nice to checkout the errors with accompanying timestamps from within view Alert_XML_Errors. Like this, with the help of 2 types and a pipelined function.
Other News
What’s in a Job Title and What Does It Really Mean?
What’s in a Job Title and What Does It Really Mean? Hello, this is Laura Lee Rose. I am a speaker and author. I am an expert in time and project management. I help busy professionals and entrepreneurs create effective systems so that they can comfortably delegate to others, be more profitable and have time to enjoy life even if...
Capturing Performance Counter Data for a Process by Process Id
(Rick Strahl) The .NET PerformanceCounter class generally is pretty easy to use in order to retrieve performance information. You create a perf counter, initialize the first value to read, let some time pass and then read the next value and Windows gives you access to a plethora of performance infor
Building OData Service using ASP.Net Web API Tutorial – Part 3
(Taiseer Joudeh) In this post We’ll add another OData controller which will support all the CRUD operations, as we talked before OData follows the conventions of HTTP and REST; so if we want to create a resources we’ll issue HTTP POST, if we want to delete a resource we’ll issue HTTP DELETE and so o
A Better Understanding of TSA Resources and States
(Ember Crooks) It is very possible to support DB2Œs HADR using TSA to automate failover without understanding many of the TSA components and details, and even the TSA commands. Ifve posted several blog entries on TSA issues resolved without any deeper knowledge of things.
TechTip: A Hidden Tax with SQL Programs and SQL Packages
(Michael Sansoterra) Thanks to the spectacular library list concept, it’s common to have multiple instances of application data libraries on the IBM i. Further, a typical IBM i application stores its programs in one or more object libraries, separate from the data libraries. This configuration allow
AlwaysOn Availability Groups and SQL Server Jobs, Part 2: Putting AlwaysOn into Context
(Michael K. Campbell) AlwaysOn is a marketing term used to describe two different high-availability (HA) and disaster recovery (DR) solutions from Microsoft: AlwaysOn Failover Cluster Instances (FCIs) or raditional clusters and AlwaysOn Availability Groups (AGs) which are a lot like Database Mirrori
WCF with no service xml or endpoints? What is this magic?
(Ben Hosking) I had to write a WCF service for a project and I hadn’t created a WCF service for a while.
Calling Server Side Method and Web Service method using JavaScript and Ajax
(Mahesh Nandanan) In this Article we will see how to call a server side method(a method in our aspx file) and a Web Service method using Ajax and JQuery in ASP.Net.
Understanding How to Use the UPDATE Statement to Change Your Data
(Greg Larsen) If you are an application programmer then you will more than likely need to write TSQL code to update your SQL Server database tables. In order to update a row in a SQL Server table you will use the UDPATE statement. In this article I will show you a number of different ways to use t
