As with most professionals, the list of what we can do is often very large and diverse. When we start to make a list of everything that we ‘could’ do, we often get overwhelmed. Instead — focus on what you really want to do, and then align you skills to support the more specific ‘focus’. This ten
Author: SSWUG Research
HTML5 and SharePoint 2010 – Part 4: Adding the Code (Continued)
(Eric Overfield) Now that we understand the first five steps, let’s move on. There are a few more general updates that could be made to the new HTML5 Master Page.
A File Input Directive For AngularJS
(K. Scott Allen) Now that we have a FileReader service for AngularJS, we need something that will give us a file to read. The two ways for users to select files are to use , or to drag and drop a file into the browser.
SQL SERVER – Check Database Level (IsNullConcat) and Session Level Settings (CONCAT_NULL_YIELDS_NULL) using T-SQL
(Pinal Dave) Earlier I wrote a blog post SQL SERVER – A Quick Note on CONCAT_NULL_YIELDS_NULL and in follow up to the blog post, I received few questions. Let me try to answer those questions in following blog post.
Creating LINQ-Enabled Frameworks
(Chris Eargle) Many developers use LINQ without fully realizing the power at their fingertips. The features of the language enable queries of in-memory collections or external data sources, and Microsoft has extended those queries to events and other observable sources via Reactive Extensions (Rx).
DB2 NoSQL for JSON Capabilities, Part 4: Using the IBM NoSQL Wire Listener for DB2
(Ioannis Papapanagiotou, Marion Behnen and John Paul Parkin) Rapidly changing application environments require a flexible mechanism to store and communicate data between different application tiers. JSON (JavaScript Object Notation) has proven to be a key technology for mobile, interactive applicati
Columnstore Queries in SQL Server 2012
(Roy Ernest) On demo, the columnstore index of SQL Server 2012 gives dazzling performance, but it is optimised for data warehouse queries so it is by no means a universal route to high-performance queries. Once you understand the context in which they are best used, and the ways of ensuring that th
Security Questions: Server Role Tips
(Jason Strate) As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’s Training on the T’s, I received a large number of questions that there wasn’t time to answer. Instead of just a re-cap of all of the questions, instead I’ve opted to p
Practical SQL: OLAP, Part 2
(Joe Pluta) In my previous OLAP article, I used the OLAP function ROW_NUMBER to provide the concept of "next record" that we take for granted in RPG’s native access (contrast RPG’s native ISAM access with SQL’s relational access). In this article, I’ll show you the magic of GROUPING SETS and how the
(Updated) NoSQL and JSON with DB2
(Henrik Loeser) You may have heard that DB2 10.5, which recently became available, includes a technology preview “DB2 NoSQL JSON”. JSON is the JavaScript Object Notation. The important stuff for JSON in DB2 can be found in the sqllib/json directory. Once I added the “lib” directory to the Java CLASS