Welcome to weblogs.com.pk Sign in | Join | Help

Browse by Tags

All Tags » Databases   (RSS)

5th CTP of Visual Studio Team System for Database Professional

DataDude (Team System for Database Professional)' 5th CTP is released recently. It features Schema management (similar to SQL Enterprise or Management Studio) the difference is instead of working on some "physical database" it works on "virtual database";
Posted by khurram | 1 Comments

mySQL Profiler?

I am looking for a tool for mySQL 4/5 servers having SQL Server Profiler like features; using which I can see in real time what SQL queries are being executed... I have used SQL Server Profiler to optimize database hits and some time reverse engg some
Posted by khurram | 1 Comments
Filed under:

Unique Identity Across Multiple Tables

This week had been a busy one; we had three deliverables; one internal app and two clients app. Due to training sessions; things get screwed up; it got hard to find the time…I was checking my timesheets; and wow! I have given about 50% extra time to the
Posted by khurram | 2 Comments
Filed under:

UnixOdbc

I am planning a solution for a small ISP who needs a cheaper and straight forward billing system. Our solution contains FreeRadius running on Linux configured with UnixOdbc having a DSN of FreeTDS driver talking to SQL Server Express running on Windows.

Agile Documentation in Database Layer

If you are maintaining a database; you might have adopted some mechanism to maintain notes; like what was changed; any discovery; documentation and sometime even queries performed so that things can be rolled back. In past; I have used .txt/.sql files,
Posted by khurram | 0 Comments
Filed under:

Information Management :: Historical Data

Continuing the topic of information management; and how we should think about it as a developer; we basically need to consider two things that impacts our implementation approach. Maintaining historical data Making available the aggregated data In this
Posted by khurram | 0 Comments
Filed under:

Information Management :: Establishing Measurement Plan

Last weekend in a family get together; there was a discussion going on epidemic diseases; that eventually turns out the purity of food items being sold in market. One of my cousin has a farm and supplies milk to commercial local company; he was telling
Posted by khurram | 2 Comments
Filed under:

Organizational Data Consumption

Yesterday I posted about lack of proper data consumption in general in our local enterprises. A simplified view of one data consumption model presented here is shown below. As you can see; “Technical Activities” are important, as its feeding all the higher
Posted by khurram | 3 Comments
Filed under:

Information :: Done with gathering; what about conumption?

We had been introducing automation at different points; with this; lot of data has been generated; which in past might have lost in those big registers archived in stores for rats; but now all that information in accessible. Thanks to the technologies;
Posted by khurram | 0 Comments
Filed under:

Access denied for user 'ODBC'@'localhost' (using password: NO)

If you are receiving this error; and you happen to use PHP4 and mySQL 5; its due to the reason that mySQL client library being used is older. The simplest work-around is that you issue the following commands (I guess you need root level access; contact
Posted by khurram | 0 Comments
Filed under:

mySQL :: STRICT_TRANS_TABLE :: mySQL or SQL-Express

I was free today; so I planned to upgrade mySQL database server, which is used by some our intranet applications at my workplace. I moved things to mySQL version 5. I dumped the databases; remove previous mySQL service; installed mySQL 5 in separate location.
Posted by khurram | 0 Comments
Filed under:

mySQL engine is ridicules

Consider a table Populations with fields, Country, City, Area, Population. In SQL Server (and I am sure in Oracle as well) you cannt execute query like select Country, City, sum(Population) from Populations group by Country order by Country, City You
Posted by khurram | 0 Comments
Filed under:

Zombie Objects

The one problem; that is very common in team projects is existence of “zombie objects”. I weblogged about how one can trace such objects with in database layer; but what about business layer? Here is one approach that we try to follow. We establish interfaces
Posted by khurram | 0 Comments

VistaDB 2.1 database for .NET has been released

This 2.1 update includes over 60 improvements, including new support for .NET 2.0 and Visual Studio 2005. VistaDB is a small-footprint, embedded SQL database alternative to Jet/Access, MSDE and SQL Server Express 2005 that enables developers to build
Posted by khurram | 0 Comments
Filed under: ,

SQL Server Compare

I am assigned a job in which I have to deal with multiple servers all running different variations of the product that we have built. For this I often need to compare and keep track of the differences, not only in applications but also in the databases
Posted by khurram | 0 Comments
Filed under:
More Posts Next page »