(Pinal Dave) This is one of the most interesting questions I keep on getting on this email and I find that not everyone knows about it. In recent times I have seen a developer writing a cursor to update a table.
Author: SSWUG Research
AngularJS Abstractions: Modules
(K. Scott Allen) Continuing from the last post, a module in AngularJS is a place where you can collect and organize components like controllers, services, directives, and filters. We’ll talk about the “when & why” of creating a module in a later post. This post will focus on the API to create a modu
Free Yourself with a Dependency Injection Container
(Peter Vogel) I’m now doing a column for MSDN magazine about how design patterns help developers solve typical business problems. The column is called “Patterns in Practice”, but it could just as easily have been called “Thinking with Objects.”
Database roles – 2. Big…Mistakes?
(Michael “Misha” Rosenblum) Looks like my Friday post about BigData got some attention. In that case – let’s continue! While looking at tons of articles about Big-anything I’ve noticed a very constant pattern – everybody is talking about multi-node clusters of database servers: you constantly hear a
Delegating Nested Directive Behavior To Parent Directive In AngularJS
(Ben Nadel) In an AngularJS JavaScript web application, the part of your code that pipes user behaviors into controller methods is known as the, “directive.” Out of the box, AngularJS ships with many powerful directives like ngClick, ngRepeat, ngSubmit, etc.; but, AngularJS also allows you to define
.NET Security Part 1
(Simon Cooper) Ever since the first version of .NET, it’s been possible to strictly define the actions and resources a particular assembly can use, and, using Code Access Security, permissions to perform certain actions or access certain resources can be defined and modified in code. In .NET 4, the
Paging Data with TSQL
(Greg Larsen) When building applications that need to display lots of data to a customer, a common practice is to display one page of data at a time. Having your application only show a single page of data requires you to build a paging function, like a button into your application to allow the use
Shortest-Path Graph Analysis Using a CLR Stored Procedure
(James McCaffrey) Graph analysis is becoming increasingly important in software applications. Here a graph is a collection of nodes and edges, not a data visualization such as a bar chart. This article presents a demonstration of how to perform shortest-path analysis using a SQL CLR stored procedure
What I should have said today at IDUG about EXPLAIN and DB2 10 for z/OS
(Willie Favero) DB2 10 for z/OS is just loaded with little gems. So many so, that sometimes I just mess up their descriptions. That’s what happened during my IDUG presentation today on a DB2 10 EXPLAIN feature. I took two very cool concepts delivered by DB2 10 and reversed their descriptions:
Migrating an Execution Plan using SQL Plan Management
(Carlos Sierra) SQL Plan Management (SPM) has been available since the first release of 11g. As you know SPM is the new technology that provides Plan Stability with some extra Plan Control and Management features. Maria Colgan has done an excellent job documented the “SPM functionality” pretty well