(Nigel Campbell, Henk Cazemier, Robert Hatfield, Martin Petitclerc, Glen Seeds and Jason Tavoularis) This IBM Redbooks publication explains how IBM Cognos Business Intelligence (BI) administrators, authors, modelers, and power users can use the dynamic query layer effectively. It provides guidance f
Author: SSWUG Research
Case Study: Import data from XML to SQL (Part-2)
(Dilkush) In part one we took care of creating tables, columns, assigning appropriate data type, creating xsd file at run time and bulk insert data in SQL.
SSIS 2012 – Introduction to Windows Azure SQL Databases
(Marcin Policht) Throughout our coverage of SQL Server 2012 Integration Services published on this forum, we have been dealing mainly with the traditional data management model, where the entire SQL Server environment resides on-premise.
SQL Server: Variables, Parameters or Literals? Or… Constants?
(Jared Ko) “Should I use Variables, Parameters, or Literals in my code?” We’ve all seen the pros and cons for each of them and had to choose the option with the least negative impact. What if I told you there was a fourth option?
SQL Server Database Files Groups
(Om Agarwal) This article describes SQL Server database file Groups. When we create a new database, then the Server database contains default file Groups. They are called primary files Groups.
5 Features for your SharePoint 2013 Intranet Homepage
(Chris Clark) A well designed homepage can be the make or break of an intranet. It forms first impressions of the system and acts as a starting point for a range of tasks and journeys.
Working with the New Windows Runtime HID APIs in Windows 8.1
(Vipul Patel) As part of Windows 8.1, Microsoft will be introducing over 5000 new APIs enabling a bunch of new features under the umbrella of its flag ship product – the next version of the Windows operating system.
Rethinking Oracle Optimizer Statistics for P6
(Brian Diehl) This is the first in a series of posts about Oracle Optimizer Statistics and the P6 application. Over the past six months, I’ve done a lot of rethinking about the best process for maintaining optimizer statistics given the type of data in the PM database and the variety of queries comi
Delphix, direct I/O, and direct path reads
(Bobby Durrett) I’ve been working on testing performance on a database that uses Delphix as its storage system and ran across an unexpected side effect of using Delphix to clone a production database for testing.
Sorting Paging a Grid using Knockout JS and ASP.NET Web API Data Service
(Suprotim Agarwal) This article uses ASP.NET Web API and Knockout JS to implement Templating and Data Binding and applies it to a common Line of Business application requirement – Paging and Sorting a Grid.