(Chad Churchwell) I need to produce mailing labels from my SQL Server database so I am using the + sign for concatenation the first, middle, and last names together. The issue I see is I get NULL for a lot of rows. This makes me unable to produce the full names. What are some options to address thi
Author: SSWUG Research
Reading XML Data into a DataTable Using ASP.NET
(Mannava Siva Aditya) Sometimes, we need to read huge amounts of data from XML and need to be displayed on the page. Here we can do this in many ways but in this example I will explain how to read XML data via DataTable in ASP.NET. You just need to use one method of DataTable called ReadXML. This ti
Architecting Code in the Presentation Layer
(Peter Vogel) The term “architecture” is a metaphor that ties “software design” to “bricks-and-mortar design.” If you think of architecture as “the design of rooms and their relationship to each other,” the metaphor works well in an object-oriented world: you design objects and establish how they wo
Fancy SQL Monday: generate_series() and cross joins
(Josh Berkus) So, here’s the situation: you want to create a report which shows totals of registrations by day and by category, and shows zeros for each day and category you don’t have any registrations for. Your first attempt looks like this:
Use Optim Data Tools to get the most out of BLU Acceleration
(Loic Julien, Daniel Zilio and Leila Johannesen) BLU Acceleration is an exciting new feature in IBM DB2 10.5 that can speed up complex analytic workloads tremendously. Workloads run faster without the need for tuning. At the heart of this new technology is the column-organized format for user tables
Create a ‘Save My Searches’ Feature in SharePoint 2010 with JavaScript/jQuery
(Craig Pilkenton) The end-result is a Web Part that can be dropped on any page for quick access to their saved searches while having a small UI profile and doesn’t require navigating away from the core idea; seeing their favorite Search Results.
Detecting Screen Resolution Changes
(Richard Carr) Some applications need to detect when the user changes their screen resolution in order to ensure that the user interface remains correctly displayed. This detection is made possible with static events provided by the SystemEvents class.
Designing Bullet Graphs in SSRS – Part 2
(Jason Thomas) The concepts in this 3 part blog series is heavily borrowed from the book Information Dashboard Design, authored by the data visualization guru – Stephen Few and is going to concentrate on the following topics:-
Oracle 12c: Scalar Subquery Unnesting transformation
(Tanel Poder) I promised to write about Oracle 12c new features quite a while ago (when 12c got officially released), but I was actually on (a long) vacation then and so many cool 12c-related white-papers and blog entries started popping up so I took it easy for a while. I plan to be focusing on the
SSIS 2012 – Using PowerShell to Remotely Execute File System Packages in Multi-Server Scenarios
(Marcin Policht) In our recent articles published on this forum, we have been discussing different methods of executing SQL Server 2012 Integration Services packages deployed by employing the traditional Package Deployment Model, focusing in particular on those stored in the .dtsx file system format