Adobe Solution Partner

February 26, 2007

How do I search across all columns in all tables in SQL?

Filed under: Databases — Tags: — Nat Papovich @ 8:00 pm
The development practice at Webapper does a fair bit of “version 2″ system development. Our customer has an existing application, built maybe in ColdFusion, maybe in PHP or another scripting language. Maybe in Access forms, maybe as a desktop application. We’ll use it as a prototype for creating a new webified application. One part of these [...]

November 21, 2006

Doing multi-server development with MSSQL? You need Red Gate tools.

Filed under: Databases — Tags: , — Nat Papovich @ 10:33 am
About a year ago, I came across the Red-Gate suite of products for MSSQL. Between then and now, I’ve used SQL Compare and Data Compare about once a week, sometimes more often. These tools are one of those things that, once you have them, you ask yourself, “How did I survive without it?” For example, let’s [...]

October 19, 2006

Upgrading MSDE RTM to SP4

Filed under: Databases — Tags: — Nat Papovich @ 11:54 pm
I’m reformatting my laptop tonight and went to upgrade the Microsoft SQL Server Desktop Edition (MSDE) from the 1.0 RTM to SP4. Damn the dreaded “The instance name specified is invalid” error! I’ve installed this setup countless times and always had to futz, mess, finagle, tweak my setup command to get the darn thing to run. [...]

March 3, 2006

(Almost) A Billion Served

Filed under: Databases, Performance, SeeFusion — Patrick Quinn @ 11:13 am
As many people know by now, we run a live demo of our SeeFusion product under a constant load, 24 hours per day, 7 days per week (SeeFusion Live Demo). Occasionally, we have to pause the test, typically for software updates to ColdFusion, the load test software (Paessler Webserver Stress Tool), or perhaps even to [...]

July 11, 2005

Debugging Stored Procedures Using SQL Server Query Analyzer

Filed under: Databases — Mike Brunt @ 12:00 am
Builder.com are always creating articles of interest and as we use our blog to store and refer back to good stuff, here is a link to a very good Builder.com article: - Debugging stored procedures with SQL Server’’s Query Analyzer

January 28, 2005

Forbot Network Worm Affects MySQL On Windows

Filed under: Databases — Mike Brunt @ 12:00 am
MySQL on Windows became the latest victim of a worm on Thursday of this week. A worm call THE FORBOT NETWORK WORM. The worm, which also has Trojan horse features, infects machines by breaking into the default administrator or ROOT account password. With access to the MySQL root account, Forbot was programmed to use a recently-discovered [...]

September 3, 2004

Generic top-levels domain names at risk – .com, .org etc

Filed under: Databases — Mike Brunt @ 12:00 am
This is best stated verbatim – Under new proposals from The Internet Corporation for Assigned Names and Numbers (Icann), which is responsible for worldwide domain name policy, every domain owner will be obliged to update their full contact details on Icann’’s publicly available WHOIS database annually. Details can be found here.

April 2, 2004

Everything You Wanted To Know About Stored Procedures

Filed under: Databases — Mike Brunt @ 12:00 am
But were afraid to ask, well that is what this informative piece from The Code Project web site claims. It is a good piece though and is based on Microsoft SQL Server although the concepts can be applied to any RDBMs that support Stored Procedures. Here is a quick verbatim from the article Stored procedures [...]

March 23, 2004

SQL Server 2000 Version Comparison Matrix

Filed under: Databases — Mike Brunt @ 12:00 am
Good heavens five days no posts, disgraceful on our parts, we are just blindingly busy at present. Anyhow, we often want to find useful stuff quickly and for some reason can”t just when we need it-them. That really is the whole purpose of this blog, a pack-rats paradise (bit lofty that ;o) for all of [...]

SQL Server (again) How To Set Up Master-Master Replication

Filed under: Databases — Mike Brunt @ 12:00 am
For those of you lucky enough to see the really only great film in the Desperado; series “El Mariachi” there is a classic line with a spanish expletive, What is this #%^&***! Maricahi day!?. Well today is SQL Server day at Webapper, or so it seems. One of our clients needed some advice regarding [...]
« Newer PostsOlder Posts »

Server Down?

Maximize Web application uptime by drawing upon Webapper's years of experience tuning and stabilizing many of the world's largest ColdFusion Web applications. Contact us today!