(Seth Delconte) SQL Server filtered indexes can save space and improve performance if they are used properly. Under what circumstances can they be used? When are they most effective, and what sort of performance gain or space-saving is likely? How does a filtered index affect the choice of executio
Author: SSWUG Research
Managing Slowly Changing Dimension with Slow Changing Transformation in SSIS
(Arshad Ali) As a data warehouse expert or as an ETL developer you will often come across scenarios in which you need to maintain and manage slowly changing dimensions. There are multiple ways to implement that in SQL Server and the easiest of those is using Slowly Changing Dimension Transformation
BEFORE triggers and NOT NULL columns in MySQL
(Dmitry Shulga) For a long time there was a Bug#6295 in implementation of BEFORE triggers related to handling of NOT NULL column. The problem was that if a column is declared as NOT NULL, it wasn’t possible to do INSERT NULL (or UPDATE to NULL) even though there was associated trigger, setting NOT-N
ADF 11g PS6 Table Pagination and Displaying Selected Row Issue
(Andrejus Baranovskis) There was a post about new ADF 11g PS6 feature Table Pagination – ADF 11g PS6 – ADF 10g Table Pagination Feature is Back Finally. I had a question from the reader in the comments, about displaying selected row from the page range other than the first.
TypeScript Template for ASP.NET MVC4
(Sumit Maitra) Microsoft introduced TypeScript to the world on October 1, 2012. Read my post on Hello TypeScript – Getting Started if you are new to TypeScript.
SQL Developer Performance Issue
(Andrew Reid) This happened when I was using SQL Developer in an Oracle 11.1.0.6 database. I clicked on the + sign next to Tables (Filtered) in the top left hand corner of the screen below (as usual, click on the image if necessary to enlarge it and bring it into focus):
Won’t You Be My Neighbor? Selecting Related Objects in Oracle SQL Developer Data Modeler
(Jeff Smith) I loved Fred Rogers. He helped raise me. Nicest guy ever?
Analysis of JSON use cases compared to XML
(drrwebber) Before there was either XML or JSON there was EDI. JSON is very reminiscent of EDI, both syntactically and conceptually, and that the claims made back then as to why EDI would be sustained over XML.
Using SimpleMembership With Mobile Applications In ASP.NET MVC 4
(Kevin Junghans) Someone recently asked on StackOverflow if you can use the SimpleMembership provider in a mobile application generated by the mobile template for ASP.NET MVC 4. The shell of the mobile application generated by this template generates basic security, such as logging in, logging out,
Passing Parameters to the ActionLink in ASP.NET MVC
There are times when the parameter has to be passed along with the URL from an ActionLink control in ASP.NET MVC. This can be done easily using the anonymous type which can be passed as the third parameter for the ActionLink helper method.