Tag Archives: database

A Smaller Database is a Faster Database

You can probably save a considerable amount of storage by right sizing your columns. It’s been documented that right sizing data types for columns can return data faster and of course making the data smaller results in less wasted storage … Continue reading

Posted in : Applications, MySQL, SQL | Tagged : , | Comments Off on A Smaller Database is a Faster Database

Before You Buy that new DB

Database servers are tricky. Before jumping to the conclusion that more hardware is needed, make sure you’re getting the most out of the hardware you already have. Hiring a DBA is definitely the right way to go. They’ll quickly be … Continue reading

Posted in : Applications, Microsoft SQL Server, MySQL, SQL, Technology | Tagged : , , , , | Comments Off on Before You Buy that new DB

Database Migration Tips

Moving database servers is a nontrivial task that requires planning and forethought. This guide provides some tips for planning a migration of a small to midsize databases, but not yet data-warehousing in the 5Gb – 500Gb size. Of course the … Continue reading

Posted in : Data, Software, SQL, Technology | Tagged : , , , , , | Comments Off on Database Migration Tips

Blissful Unions

I’ve been sharpening the saw lately and decided to take a few minutes to clearly illustrate some SQL terminology that newbie developers might be troubled by. Nothing in here is magic or even comprehensive, but we all often overlook the … Continue reading

Posted in : Software, SQL | Tagged : , , , , , | Comments Off on Blissful Unions

Sharpening the Saw

Cutting through wood with a hand saw is a hard job. Pushing the blade back and forth through the wood slowly but surely making the cut deeper and deeper until it’s completed is a time consuming, labor intensive task. Once … Continue reading

Posted in : Small Business, SQL | Tagged : , , , , | Comments Off on Sharpening the Saw

Running a Stored Procedure from MS-SQL Server with PHP on Linux

After some effort getting the MSSQL drivers in PHP, I was ready to hook into the RDBMS and use my nicely developed stored procedures. FreeTDS required minimal setup and configuration and I was able to establish a connection and run … Continue reading

Posted in : Microsoft SQL Server, PHP, SQL | Tagged : , , , , , , | Comments Off on Running a Stored Procedure from MS-SQL Server with PHP on Linux

Cloud Databases Coming Soon

Startups looking for a database back end will soon have more options (hopefully). MySQL is a fantastic lightweight database that scales reasonably well for most projects. Microsoft SQL Server, Oracle, DB2 and other commercial offerings scale well and have lots … Continue reading

Posted in : Technology | Tagged : , , , , | Comments Off on Cloud Databases Coming Soon