(Pravinkumar Dabade) HTTP Services can be used by a broad range of clients including browsers and mobile devices. By using REST [Representational State Transfer] we can build loosely coupled services.
Author: SSWUG Research
SQL Server XQuery: Functions (sql:variable() & sql:column())
(Stuart Ainsworth) Like most query languages, XQuery has several functions that can be used to manipulate and query data. SQL Server’s implementation supports a limited subset of the XQuery specification, but there’s a lot of power in the functions provided.
TechTip: DB2 for i HTTP Functions, Part 2: Request and Response Header Fields
(Michael Sansoterra) In the first tip, I introduced the new suite of HTTP functions in DB2 for i 7.1 and demonstrated the HTTPGETCLOB and HTTPGETBLOB scalar functions. I’ll continue the topic by considering how to include and retrieve HTTP header information with each request. This tip assumes you h
Structuring an Angular Project
(John Papa) We can build amazing SPA and HTML5 applications when choosing a powerful framework like Angular, Durandal, Ember, or Backbone. And while I love my personal favorites Angular and Durandal, it’s not all magic.
Parallel For Loops for any Data Type
(Richard Carr) The standard parallel for loop is limited to working with integer values and only permits looping through an incrementing range, unlike its sequential equivalent. This article describes an alternative parallel for loop without these limitations.
Dealing with JSON Dates in ASP.NET MVC
(Bipin Joshi) Most of the time, data transfer during Ajax communication is facilitated using JSON format. While JSON format is text based, lightweight and simple it doesn’t offer many data types.
Tools for SharePoint User Experience (UX) Design: Interactive Prototyping
(Adrian England) Going through this process and separating content, functionality and aesthetics allows the designs to be considered purely on their own merit and the underlying functionality understood without further explanation or iteration.
Find Skew in Distributed Tables
(Bradley Schacht) The SQL Server PDW (Parallel Data Warehouse) is a beast of a machine. Spreading workload across multiple nodes inside the PDW provides a huge performance gain over a traditional SQL Server; however, when laying out tables it is a little different.
Data Warehouse Maturity Model
(James Serra) I have talked about the Business Intelligence Maturity Model (see Business Intelligence Maturity Assessment), but I wanted to dig further into one area and talk about the Data Warehouse Maturity Model.
(JohnSterrett) One of the secret weapons in performance tuning with SQL Server is understanding wait statistics. Every time a process (spid) changes its status from running to suspended it is typically due to resource wait or a signal wait. For example, you are typically waiting on PAGEIOLATCH_SH wh