Adding Database Columns
Normally one would think that adding a new, unused column to an existing database table wouldn’t break anything, right? Well, normally it wouldn’t, unless the column name is the same […]
Continue ReadingMySQL New Releases
A service pack for MySQL Enterprise 5.0 was released, bringing the version number up to 5.0.30 and including changes like: Bug Fix: InnoDB showed substandard performance with multiple queries running […]
Continue ReadingDocument your Databases for Free
Data Dictionary Creator was recently released by Jon Galloway. It’s a UI allowing you to document your SQL Server databases by storing the documentation in extended properties, and then exporting […]
Continue ReadingUnit Testing with Database Rollbacks
One of the tricky things with unit testing is getting your test system back to a known state after a test run. If your code involves a lot of database […]
Continue ReadingStored Procedures that start with sp_
…will run slower, because SQL Server will first check irish sildenafil sites the master database for them. Weird but true, according to SQLMag. So, don’t start your lamisil cream procs […]
Continue ReadingStrip Non-Alphanumeric Characters in SQL Server
I recently needed to strip out non-alphanumeric characters in SQL Server. I initially thought I might be able to use a managed stored procedure and C# regular expressions to do […]
Continue ReadingSQL Server 2005 Remote Access Security
I went into this in my post about SQL Server remote connections, but basically, for each SQL Server instance running on your database server, you can enable remote access, control which […]
Continue Reading
