Pro-Center Video Programming for IT Professionals
Author: SSWUG Research
Getting started with DB2 Document Manager, Part 2: Set up Integration and Properties Exchange
(Paul R. Welka) This tutorial builds on an earlier tutorial (Getting started with DB2 Document Manager, Part 1: Build a simple client application in DB2 Document Manager) and illustrates a valuable feature of the product. In this step-by-step tutorial, learn how to improve productivity and end-user
A classic ‘Good New – Bad News’ story: KEEPDYNAMIC YES
(Willie Favero) And it fits the “Good New – Bad News” criteria so well. It can help you, hurt you, confuse you, and get you into all kinds of debates about what it does. There’s stuff that affects its behavior and it affects all kinds of other processes behavior. It could be one of DB2’s perfect con
CodeSnip: Take SQL Server Database Backup in any Network Path
(Jaya Nehru Kumar) In MS SQL Server the backup wizard does not show the network’s path to store the backup database. The reason is the MS SQL Server instance is running under Local System Account.
Data Access Component and the Factory Design Pattern
(Waleed El Tamimi) Merely, every application today uses a relational database as its backend, applications used to be monolithic and structured, but with the need for more functionality and ease of use, applications became larger, more complex and harder to maintain, and the solution for rapid devel
Get practical database normalization tips
(Tim Chapman) The database organization process called normalization is a series of steps to guide you through analyzing and designing relations in your database schema; the goal is to try to reduce redundant data and inconsistent functional dependencies.
Mastering OLAP Reports: Parameters for Analysis Services Reporting, Pt. I
(William Pearson) In this article, we will get hands-on exposure to providing the most basic Parameter support, from the perspective of reports based upon an Analysis Services 2005 cube, for the information consumers we support. Our hands-on practice will specifically focus upon how to create a Para
Creating CSV Files Using BCP and Stored Procedures
(Nigel Rivett) This article focuses on the use of the Bulk Copy Program (BCP) to create CSV files. Although it is possible to create a CSV file using DTS or SSIS, using BCP is often simpler and more efficient.
The MySQL SET Datatype
One of the least commonly used of the MySQL datatypes has to be the SET datatype. The SET datatype is a string type, but is often referred to as a complex type due to the increased complexity involved in implementing them. A SET datatype can hold any number of strings from a predefined list of strin
Best Practice for Database Encryption Solutions
(Ulf Mattsson) Encryption can provide strong security for data at rest, but developing a database encryption strategy must take many factors into consideration. Organizations must balance between the requirement for security and the desire for excellent performance. Encryption at the database level,