(Josh Lane) One of thegreatest strengths of the Microsoft .NET Framework is the wide variety of third-party open source and commercial libraries that target the platform. It’s a testament to the maturity of the .NET development ecosystem that you not only have great APIs to choose from within the .N
Author: SSWUG Research
Upload Multiple Files to Azure Storage and Manage them from an ASP.NET MVC 4 Application
(Suprotim Agarwal) Build an ASP.NET MVC 4 application that uploads multiple files to Azure Cloud Storage, get the list of items in storage and have a rudimentary view of the files.
PL/pgSQL #1 annoyance
(Joel Jacobson) I cannot count the number of times I’ve written the same stupid code, just to do something as simple as making sure the UPDATE updates exactly one row.
WPF Layout Controls – Expander
(Richard Carr) The twelfth part of the Windows Presentation Foundation Fundamentals tutorial continues the examination of the WPF layout controls. This instalment’s control is the Expander. It allows its children to be hidden or displayed with a single click.
SSIS 2012 Reporting Driver Errors
(Mangesh Mharolkar) Often times when implementing data integration projects – we come across a need to implement a row/key based lookup and based on the found/not-found condition update or insert a row.
When is a Reorg Really Online?
(Ember Crooks) We bandy about the term “online” reorg. But you’d be surprised how often there are issues with that. IBM officially calls it an “INPLACE” reorg. Read on to understand exactly when it is fully online and when it is not.
Browsing Schema Objects CBO Statistics Versions
(Carlos Sierra) Execution Plans have a strong dependency on CBO Statistics. In corner cases, a small change on the Schema Objects statistics creates havoc in an Execution Plan. If you strongly suspect the only change to your environment was a CBO Statistics gathering, you may consider restoring them
New Version Of XPLAN_ASH Tool – Video Tutorial
(Randolf Geist) A new major release (version 3.0) of my XPLAN_ASH tool is available for download.
How to Pivot Data in Oracle 11g
(David Fitzjarrell) Occasionally it may be necessary to ‘flip’ a table on its side, so to speak, meaning to convert rows to columns in order to display data in a more understandable format. Depending on the release of Oracle there are several techniques that can be used to accomplish this task.
Intellisense for custom XML in Visual Studio
(Eli Weinstock-Herman) This is one of those things that I only need once every several months and always forget how to do. Working with custom XML in Visual Studio is a whole lot easier with intellisense. Schema errors are highlighted, enumerated values are displayed, and the amount of typing goes f