(Michael McLaughlin) A friend asked me how to get an Oracle view definition out of a LONG column and into a web application. I thought it was an interesting question because I ran into a similar problem when writing the Oracle Database 12c PL/SQL Programming book.
Author: SSWUG Research
IOQWT – A typical IBM acronym that works for DB2 BLU
(Henrik Loeser) IOQWT is a typical acronym, used to deal with lengthy product names like IBM InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows. It is part of the InfoSphere Optim suite of tools for data lifecycle management.
Secure Web API 2.0 Services using External Authentication like Twitter
(Suprotim Agarwal) A quick peek at the new and shiny Security model in the upcoming ASP.NET vNext. We use the new Claims Based Authentication system and create a ASP.NET Web API 2.0 sample app that uses Twitter as the external Authentication Service.
Oracle: Sorting Out Constraints
(David Fitzjarrell) A question was recently asked by a colleague regarding unique indexes and constraints. He was complaining that the unique index did not create the associated constraint by default.
Two Ways of Passing HTML5 Web Storage Data to ASP.NET
(Bipin Joshi) HTML5 web storage allows you to store data on the client side. However, unlike cookies this data is not passed automatically to the server with every request-response cycle. To pass the data stored in web storage to the server you need to make some programmatic arrangement.
SQL Server 2014 overview part 1: In-memory, cloud integration features
(Robert Sheldon) Microsoft released the first public Community Technology Preview (CTP) of SQL Server 2014 in June. The CTP let developers, administrators and other database types poke and prod many of the product’s new and enhanced features.
Quick ‘n Dirty: Comparing two XML documents in .NET
(Mark) Yesterday I was tasked with comparing two XML documents for equality (in .NET). The catch is that they didn’t have to be *exactly* equal. There were a few fields that were allowed to be different for the documents to still be considered a match (timestamps, GUIDs, etc).
A VB.net Example showing how to create a time limited URL to access an Azure Blob
I needed to set up a quick download service for a file stored in Azure Blob Storage. As all examples for this were in C# I thought I’d post a VB.net example for anyone that needed it. The code is documented in the comments. The example also shows sending a HTML email with the URL embedded inside it.
SSWUGtv Security Edition: What kinds of key considerations are ISVs faced with when working in HIPAA-type areas?
Video Programming for IT Professionals
Async Actions in ASP.NET MVC 4
(Eric Vogel) The .NET 4.5 Framework introduced the new async/await asynchronous programming model. With ASP.NET MVC 4 comes the application of the async/await model to controller actions.