Article Three: Why haven’t you tried MS SQL Express yet?
Last week we touched on the value of leveraging MS Access when using MS SQL. At TDC, we’re using full blown versions of MS SQL, but that doesn’t mean you can’t get a taste as well. MS is generous enough to allow everyone access to a completely free version called, MS SQL Express. With the latest iteration (2K8 R2), we’ve seen an increase in the overall DB size allowed, grow from 4gb (2K3) to 10gb (2k8 R2). You can download the runtime and management interface from here.
So, what’s stopping you from jumping with both feet in? Well, you do need to have a bit of an idea on how to write Transact Structured Query Language (TSQL). Without this, it’s pretty hard to get anywhere. SQL 2k8 R2 has become a lot more intuitive, as in it will actually help you write the query, but it’s still reliant on initial user input thus, initial user knowledge. But fear not all you novices out there, there is a simple “cheat” you can employ. Within Access, when you’re putting together a query in design view, you have the option to also write that in SQL. If you’re lucky enough to have access installed, then this is the least path of resistance. Just write put your query together in design view, then click on the design button to drop down the “SQL” item.
If not, then simple commands like “SELECT * FROM [table]” will get you started. After that you starting putting variables into the “WHERE” clause, such as, “SELECT * FROM [table] WHERE like ‘%variable%’ ”
Limitations??? Sure, nothing that is free in life is perfect! And the fundamental missing element from the “Express” version, is the ability to schedule jobs. It is possible, with 3rd party software, but it’s not a supported feature. As such, user beware!
So you want to dip your toe in, but unsure how to really get started. It’s pretty basic, just download the corresponding 32/64bit package from the above link, and install. If you need help in putting together your SQL code…you know where I am! J
Happy SQLing!
Missed the first two articles??? We can’t have that!