Video Programming for IT Professionals Career management advice, coaching and much more. We discuss making the best of your professional development, provide specific tips and ideas for advancing your career and even answer questions from field.
Author: SSWUG Research
Rolling up multiple rows into a single row and column for SQL Server data
(Douglas P. Castilho) I need a way to roll-up multiple rows into one row and one column. I know I can roll-up multiple rows into one row using Pivot, but I need all of the data concatenated into a single column in a single row. In this tip we look at a simple approach to accomplish this.
SharePoint 2013 Analytics Feature – ITPro, DB Admin and PowerPivot Issues
(Nicki Borell) This post covers some facts and details about the new SharePoint 2013 Analytics feature.
How to prevent SQL Injection in Stored Procedures
(Wong Shao Voon) Some database programmers believe that by using stored procedures, their code are safe from SQL injection attacks. That is not entirely true if dynamic query is used inside the stored procedures and the dynamic query is constructed by concatenating the parameters. In circumstances,
Implement responsive web design using WebSphere Portal, Part 2: Using device classes to develop for specific devices
(Jonathan Lidaka and David Nixon) Using responsive web design has become a popular approach for creating a single web site that optimizes content and layout automatically by relying on the use of CSS media queries. This article discusses how to leverage the device class mechanism in WebSphere Portal
Delayed row-based replication with large tables lacking a primary key
(Joshua Prunier) I configure all our master databases to use row-based binary logging where I work. In my opinion it is a much safer option than row-base replication. The advantages and disadvantages of both types of MySQL replication are detailed in the online documentation here.
Adding Functionality to an Object: Building the Objects
(Peter Vogel) In my January 2013 column, I described a typical business problem: a sales order management system that allows users to apply zero or more sales options to individual order lines in a sales order. Each sales option would be applied in the Order Taking application, where sales orders ar
Are Legos the Building Blocks of the Cloud?
(David Honan) Legos have been a part of my life for as long as I can remember. Some of my earliest, fondest memories involve Legos – starting from a small car made from a couple of simple bricks to very complex spaceships and wild creatures. I’m always amazed at how nicely and cleanly they snap toge
Streams Pool is only for Streams? Think Again!
(Arup Nanda) If you don’t use the automatic SGA (i.e. set the sga_target=0) – something I frequently do – and don’t use Streams, you probably have set the parameter streams_pool_size to 0 or not set it at all, since you reckon that the pool is used for Streams alone and therefore would be irrelevant
Introduction To Constructor In Java
(Sandeep Sharma) A constructor it is a special kind of method; it defines the state of an object (initializes an object). When the object is created then by default a constructor is generated by the Java compiler.