Archive for the 'Database' Category « Previous Entries 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 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 […] Posted in Database, MySQL | No Comments » PHP Tutorial - Lesson 13 Looping, looping, looping, looping, looping, looping, looping, looping… Friday, February 17th, 2006 There are 4 main concepts that you have to understand inside and out to be a good programmer. Variables Arrays Choices (if statements) Looping We have talked about variables (those named containers where we can store information) and we have talked about choices. We have also touched on arrays (remember $_GET and $_POST?). Remember arrays are variables that […] Posted in Database, MySQL, PHP Class | No Comments » PHP Tutorial - Lesson 12 Hello!? Are you there?! - Using the SELECT statement Monday, February 13th, 2006 This is both the easiest and most difficult of the four SQL statements. The SELECT statement. We have covered putting data in the database (INSERT), removing data (DELETE), and changing data that already exists (UPDATE). Aside from the INSERT statement, which simply jams data into a table, you append a WHERE clause onto your […] Posted in Database, MySQL, PHP Class | No Comments » PHP Tutorial - Lesson 11 Just make it go away! - Using the DELETE statement Tuesday, January 31st, 2006 The next of the big four SQL statements that you need to master on this long and bumpy road is the DELETE statement. At some point, a customer will leave, or an item will permanently go out of stock or some other reason will pop up where you will need to remove data that […] Posted in Database, MySQL, PHP Class | No Comments » « Previous Entries

Article Search You are currently browsing the archives for the Database category. Pages Web Hosting with Computer Magic Archives 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 (1) AJAX (5) Apache (2) ASP.NET (7) Boot Linux from USB Hard drive (3) Configuration (2) Database (5) DOT NET (5) E-mail (1) Humor (1) IIS (2) Java Script (2) JSON (JavaScript Object Notation) (1) MS SQL (1) MySQL (7) PHP (2) PHP Class (14) Python (1) Python.NET (1) Quick Scan (1) Report Viewer (1) Ruby (1) Server Admin (3) Student Loans (1) Tech Rambling (13) Uncategorized (10) Win Foms (3) XML (1)