(Ben Nadel) This odd ColdFusion behavior took me a little while to track down because, at first, it seemed like it was happening randomly. I started to notice that some of my error-logging was, itself, throwing errors that were showing up in the ColdFusion application logs. But, most of my error-log
Author: SSWUG Research
APAR Friday: New functions, HIPERs, and fixes for some metrics
(Willie Favero) Lots of variety in this first APAR Friday post for 2014. Hopefully, there’s a little bit of something for everyone. We’ll cover 6 APARs today and introduce one APAR that will be discussed in a future post.
A little trick with redefining any object in a view from another schema
(Sayan Malakshinov) A couple months ago i used this trick with one of the dba_ views in own query for convenience.
SSWUGtv: Steve discusses his opinion on the recent Google acquisition of Nest. Be sure to comment with your opinion!
Video Programming for IT Professionals
Asynchronous programming in C++ using resumable functions and await
(Raman Sharma) As you know we recently released the Visual C++ Compiler November 2013 CTP. One of the many features in this CTP is the support for resumable functions and await. In this blog post, I want to touch upon some examples where these features make the experience of programming with asynchr
Insert XML Document in SQL Server in ASP.Net
(Pankaj Lohani) This article shows how to read a XML file (EmployeeDetaisl.xml) residing in the application and the XML data will be displayed in a GridView control then selected rows will be inserted in a SQL Server database.
Static Code Analysis in Visual Studio 2013: What’s New
(Mickey Gousset) The last time we talked about static code analysis was with Visual Studio 2010 in these two articles: “Static Code Analysis in VS2010” and “Static Code Analysis Configuration.” Code Analysis is used to analyze managed assemblies and report any programming and/or design rule violatio
Postgres 9.4 feature highlight: wal_log_hints for consistent relation page tracking in WAL
(Michael Paquier) In PostgreSQL terminology, hint bints are a page-level mechanism implemented to be able to guess the visibility status of a tuple directly at the page level (actually whether the tuple xmin or xmax is committed or aborted), without going though checks in pg_clog and pg_subtrans whi
Identifying a Subsequence in a Sequence, Part 1
(Itzik Ben-Gan) I recently got the chance to work on a T-SQL challenge that involved identifying a subsequence within a sequence. I found the challenge to be interesting and therefore decided to dedicate this month’s and next month’s columns to it.
SQL Agent Monitoring – Long Running Job Queries
(Derik Hammer) The SQL Server alert system does a great job of handling notifications for SQL Agent job failures but if want to know if a job is hung, taking longer than expected, or maybe it’s disabled and hasn’t been running, we will need to put in a bit of effort ourselves.