(K. Brian Kelley) We recently instituted a new database and it has a case-sensitive collation due to the application requirements. We have several monitoring scripts that check the health of our SQL Servers and their databases by querying particular dynamic management views (DMVs) and they were work
Author: SSWUG Research
jQCalendarPart Mini SharePoint Calendar Web Part
(SC Vinod) This application is to integrate the jQuery Calendar control with the events added in a SharePoint Calendar list. This works in both SharePoint 2010 and SharePoint 2013.
REST with WCF and Entity Framework with JSON Serialization
(Dmitriy Kozlov) Problem: you have some database and use Entity Framework to get data from it. You need develop web-service which returns JSON-data based on your entities. And as a consumer of this service you need to use javascript client. Also, you should provide cross-domain access to your web-se
Creating data marts with the IBM OpenAdmin Tool (OAT) for Informix
(Sumanth Rajagopal) The IBM OpenAdmin Tool (OAT) for Informix is a web application for administering and analyzing the performance of IBM Informix database servers. You can now use OAT to administer Informix Warehouse Accelerator. Informix Warehouse Accelerator processes warehouse queries more quick
Inside Portable Class Libraries
(Simon Cooper) Portable Class Libraries were introduced with Visual Studio 2010 SP1 to aid writing libraries that could be used on many different platforms – the full .NET 4/4.5 framework, Windows Phone, Silverlight, Xbox, and Windows Store apps.
Take a Sneak Peek at the New DB2 11 for z/OS
(Julian Stuhler) In last month’s column, IDUG president Joe Borges outlined his vision for IDUG in the organization’s 25th year. But IDUG isn’t alone in celebrating 2013; this year also marks 30 years since IBM DB2 for z/OS became generally available. In an industry as fast-moving as ours, it’s an a
DB2 for z/OS: Goodbye ‘Security’ Views, Hello Row Permissions and Column Masks
(Robert Catterall) It’s an age-old requirement — one that’s been around as long as DB2 itself: ensure that a particular group of users can see only certain rows in a given table, and/or ensure that values in a certain column of the table are transformed before being returned to users in the group.
Lifecycle of an ASP.NET Web API Message
(Suprotim Agarwal) ASP.NET Web API, as we know now, is a framework that helps build Services over HTTP. Web API was introduced as a lightweight service framework keeping in mind the modern web development paradigm where multiple devices and client platforms access data via an API that’s made availab
How to perform a time-based incomplete recovery
(Marco V.) Every incomplete recovery is followed by a resetlogs command before opening the database: each time you use a resetlogs command, a new incarnation of the database is created.
How to Quickly Set Classification Types for Tables in Oracle SQL Developer Data Modeler
(Jeff Smith) Your relational model may for a data warehouse or star schema where you need to define a table as being a dimension or fact. Or maybe you’re like my friend who asked me this question last night: