Archive for the 'Database' Category « Previous Entries Intro to Relational Databases Monday, December 28th, 2009 A database is just a series of one or more tables. Each table is a separate and distinct entity. What makes a database “relational” is the ability to define relationships between one table and another. In some db systems (mssql), you can actually tell the system that there is a relationship. In others (mysql) you […] Posted in Database, MS SQL, MySQL | Comments Off on Intro to Relational Databases Dynamic data layout with vertical tables Saturday, April 25th, 2009 Developers today are faced with poorly defined requests and constantly changing requirements. It is not uncommon for a developer to spend countless meetings and design sessions getting the database and object layout just right, only to have the client request just one more field when the first beta application is delivered. That one more field […] Posted in CMTK, Database, MySQL, PHP, PHP Class, Products | Comments Off on Dynamic data layout with vertical tables InnoDB Corruption common in MySQL Thursday, November 6th, 2008 I am now recovering corrupt InnoDB files in MySQL for the 6th time in the last year. Not a good sign considering all the press I have seen about how InnoDB should be default storage engine in MySQL and how superior it is with its added features such as transactions. First let me give a […] Posted in Database, MySQL | Comments Off on InnoDB Corruption common in MySQL MSSQL 2000 – Merge Replication Errors Wednesday, November 14th, 2007 The ProblemOn a recent project, merge replication was required. Any one who has seriously tried to use MSSQL Merge replication knows that it can be a total pain. It sounds nice, but in practice it can be a real bear. It gets worse if you have had to break the replication manually for any reason.Replication […] Posted in Database, MS SQL | Comments Off on MSSQL 2000 – Merge Replication Errors Slow connections to MySQL Server Thursday, November 2nd, 2006 I have an app that connects to a MySQL Server on a different box. Only one connection is created and it is held for the duration of the app. The minimal time it takes to connect to the database server is not that important so while it bothered me, the 2-5 seconds it took to […] Posted in Database, MySQL | Comments Off on Slow connections to MySQL Server « Previous Entries

Article Search You are currently browsing the archives for the Database category. Pages Web Hosting with Computer Magic WPDelayCron Archives February 2014 May 2011 September 2010 December 2009 September 2009 April 2009 March 2009 January 2009 December 2008 November 2008 August 2008 June 2008 May 2008 November 2007 September 2007 August 2007 July 2007 June 2007 December 2006 November 2006 October 2006 July 2006 June 2006 May 2006 April 2006 March 2006 February 2006 January 2006 December 2005 Categories *nix (6) AJAX (6) Apache (4) ASP.NET (8) Boot Linux from USB Hard drive (3) CMTK (1) Configuration (2) CPanel (2) Database (8) DOT NET (6) E-mail (1) Humor (2) IIS (2) Java Script (2) JSON (JavaScript Object Notation) (1) MS SQL (2) MySQL (10) PHP (4) PHP Class (15) Products (1) Python (1) Python.NET (1) Quick Scan (1) Report Viewer (1) Ruby (1) Server Admin (6) Student Loans (1) Tech Rambling (18) Uncategorized (11) Win Foms (3) windows (2) XML (1)