Tag: SQL

SQL Connector for MS Excel

SQL Connector for MS Excel

Ever wished you could update your SQL data directly from within MS Excel? It would be so quick and easy right, I mean you could just drag data, build your own formulas and calculations. Also, wouldn’t it be great if you could have random test data to go with it? […]

Search SQL for a value

Search SQL for a value

Ever wanted to search sql server for a specific value, but had no idea in which table or field it would be? Well, I found the solution, it works well on smaller databases, but it’s author Narayana Vyas Kondreddi, warns that it will be slow on bigger databases. Here is […]

What about deployment?

What about deployment?

I’ve recently been subcontracted to write an application for a clients’ client. I have to deliver the application in a easy to install fashion, since I won’t be installing the application myself. The problem with software deployment is that it is almost always an afterthought, so much time and effort […]

How big is your GIG-abyte?

How big is your GIG-abyte?

After my post about MySQL and the the reason for going that route being the size limit of MS SQL Server Express 2005, I started thinking how big is 4GB? Will it really be a limitation for the application we’re planning to develop? So, I’ve designed a little experiment to […]