Incorporating logging, error handling, and reliability into your SQL Server Integration Services (SSIS) package design – (Part 1) Author: Basit A. Farooq SQL Server Integration Services (SSIS) – A very brief overview SQL Server includes SQL Server Integration Services (SSIS). It was first introduced in SQL Server 2005 as a replacement for the Data Transformation Service (DTS). SQL Server Integration...
Other News
Limit the User to Typing Only Letters Into a TextBox Using JavaScript
(Rahul Bansal) In this article I will demonstrate how to limit the user to typing only letters into a TextBox with the help of JavaScript.
Oracle 12c – READ Privilege
(Biju) The READ privilege is new in Oracle Database 12c 12.1.0.2. Why do we need a READ privilege when there is SELECT privilege? Well, the SELECT privilege includes few more privilege than a pure read-only privilege! With the SELECT privilege, in addition to reading (or “selecting” from) the table,
Is Oracle Database Time Correct? Something Is Not Quite Right.
(Craig Shallahamer) Oracle Database tuning and performance analysis is usually based on time. As I blogged HERE, the Oracle “database time” statistic is more interesting than simply “time spent in the database.” It is the sum of CPU consumption and non-idle wait time.
Data Guard and Oracle Restart, aka relink always !!!
(Marcin Przepiorowski) During my early years with PC I love to play “Leisure Suit Larry” (especially part 1 to 3 which has running on CGA or Hercules graphics card). Author of this games, Al Lowe had a good sense of humor and every time you failed your mission or stuck in a place – there was an pop
Full table scans and MySQL performance
(Vlad Fedorkov) High season is coming, how do you make sure that MySQL will handle the increased load? Stress tests could help with that, but it’s not a good idea to run them in a production environment. In this case Select_scan, Select_full_join and other MySQL counters could quickly give you an id
Converting Adabas to IBM DB2 for z/OS with ConsistADS
(Paolo Bruni) Consist Advanced Development Solution (ConsistADS) is an end-to-end conversion solution that conversion and transparency methods for migrating to IBM DB2 for z/OS software. The solution includes DB2 for z/OS and several DB2 tools as part of the package.
DB2 Catalog Cleanup Best Practices
(Troy L Coleman) DB2 for z/OS maintains a set of tables called the DB2 catalog. These tables, which are maintained in the DSNDB06 database, contain information about DB2 database objects and application objects, as well as object recovery information.
Usage of the @ (at) sign in ASP.NET
(Mike Brind) The number of places where you might use or encounter the @ sign in ASP.NET has grown over the last few years and its exact purpose in all circumstances still seems to cause confusion. Here’s an overview of the most common places that it crops up, and guidance on its correct usage.
Blend Path interfering with C# Project Builds
(Rick Strahl) Yesterday I ran into a nasty bug in Visual Studio that caused a compiler error in a Web project. It appears that Visual Studio looks in a completely unrelated path and pulls in an assembly that overrides the project assembly reference. Specifically it’s related to accessing a Type from
