(Sateesh Kumar) Everyone knows, there will be lot of processes running in a system. We can see process list in Task Manager. But it gives limited information. If we want to integrate that Process list in your application, there is no solution for that. But, we can create our own Task Manager to disp
Author: SSWUG Research
Is Data Modeling Sufficient for Database Design?
(Malcolm Chisholm) Data modeling has been with us for several decades now and has been wildly successful. It has provided IT professionals with a set of tools, techniques and methodologies that have not only allowed us to implement databases, but which have also given us a way to communicate and dis
SQL to View Long Running Queries
(Chris Eaton) The next view I’ll focus on in this series of posts (click previous entry at the top of this page to view others) is the SYSIBMADM.LONG_RUNNING_SQL view. This view shows you the longest running SQL statements in the database you are connected to. From this view you can quickly see the
Get out of a jam by using SQL Server’s DBCC
(Arthur Fuller) In moments of distress, the database consistency check (DBCC) may prove to be your most valuable friend. This tip provides a thumbnail sketch of the things DBCC can do for you, which include the following: –Check the integrity of your tables and their related indexes. –Check t
Rational Data Architect skills series, Part 3: Discover schema relationships with Rational Data Architect
(Torsten Bittner) You can use IBM Rational Data Architect to define data mappings. When working with large schemas, it can be very cumbersome to manually create mappings. Rational Data Architect offers a discovery component to semi-automatically identify potential mappings. This tutorial provides an
Removing Nulls From A DataTable
(Mads Kristensen) The individual cells in a DataTable can have a null value in the form of System.DbNull.Value.
FIX: The members of a role that uses dynamic security cannot access the SQL Server 2000 Analysis Services database when you run a query against a cube
When you run a query against a cube in Microsoft SQL Server 2000 Analysis Services, the members of a role that uses dynamic security cannot access the Analysis Services database. This problem occurs if the following conditions are true: • The cube uses dynamic security on a partition. • The pa
Recipe: Deploying a SQL Database to a Remote Hosting Environment (Part 1)
(Scott Guthrie) You finish building a great ASP.NET application, have everything tested and working right on your local system, are taking full advantage of the new ASP.NET 2.0 Membership, Role and Profile features, and are ready to publish it to a remote hosting environment and share it with the wo
Understand column group statistics in DB2
(Samir Kapoor and Vincent Corvinelli) With column group statistics in IBM DB2 for Linux, UNIX, and Windows (DB2), the optimizer can determine a better query access plan and improve query performance when there is a correlation between multiple equality local predicates or equality join predicates. I
Using Control Adapters to Automatically Attach AJAX Extenders to ASP.NET Controls
(Damian Mehers) They have confusingly similar names, but how can ASP.NET AJAX Control Extenders and ASP.NET Control Adapters be usefully combined?