(Jeremy Smyth) The SQL language is a bit like a toolkit for data. It consists of lots of little fiddly bits of syntax that, taken together, allow you to build complex edifices and return powerful results. For the uninitiated, the many tools can be quite confusing, and it’s sometimes difficult to dec
Author: SSWUG Research
Deep Focus on Your Code with CodeLens
(Mickey Gousset) Every once in a while, I come across a feature in Team Foundation Server or Visual Studio that almost seems like magic. I find at least one “Oh, wow!” moment with each release.
TechTip: BLOBs Keep PDF, XLS, and Other Reports Safe in DB2, Part 2
(Rafael Victoria-Pereira) In the previous TechTip, I covered the BLOB basics, so now it’s time to implement the archiving and retrieving operations in a reusable, yet simple, way.
Testing with Team Web Access using Visual Studio 2013
(Gouri Sohoni) In Visual Studio 2012 Microsoft provided test case management and test execution capabilities in TFS Web Access. It was part of Visual Studio 2012 Update 2. Now in Visual Studio 2013, new capabilities and features have been added to create and modify test plans in Visual Studio 2013 W
Say ‘Hello’ to DB2 11 for z/OS
(Craig S. Mullins) As was announced earlier this month (see press release) Version 11 of DB2 for z/OS is officially available as of today. Even if your company won’t be migrating right away, the sooner you start learning about DB2 11, the better equipped you will be to embrace it when you inevitably
Using After Delete Trigger in F#
(Pankaj Lohani) In this article I explained how to delete records in one table and after using an “after delete” trigger on the table and deleting records they are saved in another table. In a previous articles you can learn about the After Insert Trigger and After Update Trigger.
Asp.Net MVC 5 Server Side Validation(Visual Studio 2013 RC)
(Rama Sagar Pulidindi) Server side validations are required for validating the user input whether it is correct and valid. If the received input data is valid then we do the further processing with the data.
Flashback Data Archive in #Oracle 12c
(Uwe Hesse) This article highlights some 12c changes of Flashback Data Archive (FDA). See here for an introduction. Remarkably, the feature is now included in all editions. I will focus here on the 12c enhancement that an application can be registered to FDA. That has two major benefits:
Best Practices – updated: which domain types should be used to run applications
(jsavit) One frequent question “what type of domain should I use to run applications?” There used to be a simple answer: “run applications in guest domains in almost all cases”, but now there are more things to consider.
Saving jQuery Sortables In ASP.NET Razor Web Pages
(Mike Brind) jQuery Sortables offer a way to specify the order of a collection of items through an easy drag and drop interface. I have just been working on the next release of Web Pages CMS and am in the process of implementing Sortables for managing the display order of menu items. This article lo