(Ben Nadel) As I’ve been trying to think more deeply about software application architecture, and experimenting with new ideas, one thing has become painfully obvious to me: shoehorning your domain model into your user interface (UI) leads to pain.
Author: SSWUG Research
Angular Abstractions: The Application
(K. Scott Allen) One of the nice features of AngularJS is how the framework comes with a complete set of abstractions and features for building complex client pages from loosely structured and maintainable pieces of code. There are controllers, services, directives, data binding, and other pieces we
INFORMATION_SCHEMA the un-sung system views
(Kenneth Fisher) I spend a reasonable amount of time looking through various forums, answering some questions and reading the answers to others. One of the things I’ve noticed is that while I frequently see system views referenced I only very rarely see the INFORMATION_SCHEMA views mentioned. This s
SignalR-Dependency Injection
(Mira Javora) Setting up dependency injection with SignalR is pretty straightforward. SignalR uses DefaultDependencyResolver to resolve its own services (IConnectionManager, IConfigurationManager, IJsonSerializer, ITransportManager and many more) and hub extensions (IHubManager, IJavaScriptProxyGene
Cooking With SQL Server’s New SSIS Catalog
(Dandy Taylor) With the release of SQL Server 2012, Microsoft has added some nice features. Recently I’ve spent time with one of those, the SQL Server Integration Services (SSIS) Catalog and its supporting database. For those of you unfamiliar with it, the SSIS catalog is the new model for logging i
Practical RPG: BLOBs, CLOBs, and XML Part 1
(Joe Pluta) Recently, several different requirements ended up colliding in a way that led me to do a lot of research on using Large Objects (LOBs) in my RPG programs. While they require a little bit of extra up-front investment, LOBs provide a way to integrate large-scale use of stream file data int
SQL*Plus tips #5: sql_text/sql_fulltext formatting(sql beatifier)
(Sayan Malakshinov) Sometimes I get tired of watching unformatted query text from v$sqlarea, dba_hist_sqltext in SQL*Plus, so I decided to include automatic query formatting in my scripts.
Improving SQL Server Analysis Services Query Response Time with msmdsrv
(Daniel Calbimonte) Sometimes SQL Server Analysis Services query response time is too slow and we want to improve the performance. How can we do so? What options are available to improve SQL Server Analysis Services performance? In this tip we will improve the performance by testing two parameters
Building an application using design patterns and principles in C# Part II
(Jon Woo) This is part 2 of an article that started here. You’ll probably want to read it first or you wont’ know what I’m talking about. I’m going to continue with the same code base while re factoring and demonstrating some more coding principles.
Why won’t you just die?! (Cleaning DB2 Process in Memory)
(Michael Krafick) It happens. We joke that it doesn’t. Make sure not tell our Oracle or SQL Server counterparts but occasionally DB2 becomes … How do I put this eloquently? Hosed.