How to execute Stored Procedures from ASP

Tweet

The power of Stored Procedures in SQL Server is quite useful when developing web applications. It is sure that using such power in your code is very important in order to be sure the queries are executed quickly and efficiently. But, how do you execute those queries from asp? Actually it is very easy as soon as you understand the logic behind it. I've seen many web site and blogs explaining that, however it seems that a simple and straight way of showing the method is missing. Here we go.

SQL Server utilities: SSMS Tools Pack

Tweet

Working with SQL  Server sometimes is really boring: you need to write a lot of stuff and - as an almost-without-memory person as I am - remember 'how were those stored procedures done'. I know very expert people who use a simple list of cleverly named txt  file, where they store all the knowledge. So when a specific function/procedure is needed, they look into that knowledge base, copy and paste. That's handy, and - as humans - quite helpful.

If you use Microsoft SLQ Server Management Studio to do your database development and maintenance, you might find the SSMS Tools Pack very useful. I've used the tool for some time and I really don't think I can do without it now.

Web application’s menus

Tweet

When developing a web application, one of the things I am almost always dissatisfied with is menus. Thinking back to my first web app, I now realise how much I pondered and rethought about the user interface and about the way all the single functions are logically made available to the user. That is usually done through an intelligent menu.

Back at work...

Tweet

Hello everybody and especially my two spiders (well actually my only recurring visitors!)... I am back at work. What to say? The holidays have been too fast and too short, but here I am back on track. Soon I will get back to you with new tech stuff, now let me just readjust myself...

Too many blogs...

Tweet

I am on vacation. I arrived on Saturday and the first thing I heard was a big noise coming from the top of trees. You should understand that I hired this little mobile house in a big camping place. I am on the coast of Toscana and the place is deep inside a big pine forest. As I am writing now, the noise is still there. I must say that nature is incredible and that staying far from technology for a while is not that bad! I have my little web book, an internet connection, my favourite applications and a remote connection to the servers back at work. But who cares? The noise is still there. And what about it? It is very high – at the beginning. So high that it is almost unbearable, then – as time goes by – you stop hearing it. The noise is made by the friction of cicada’s wings. If the sun is shining, if it’s daytime the cicadas are probably only thinking about sex and so they are trying to find someone to do it with. AH! When I first thought about it, something clear came to my mind: one voice alone is surely not heard, many voices together are surely very noisy but after a while you stop noticing them. A little number of blogs, forums, info sites might be interesting and might be worth reading. Too many blogs might be lost in oblivion.

Well, my friends. This is only to make you aware of the fact that I am on vacation. I will probably write more during this period, but we will most likely leave tech things alone for a while.