All Aboard the SQL Server Express!

Tweet

SQL Server ExpressIn today’s tutorial, web application development specialist Akash Mehta takes a look at Microsoft SQL Server Express and shows us how to build a simple web app. It’s a natural follow-up to an article we published last year about the Microsoft Web Platform Installer, which demonstrated how easy it is to set up a web server on Windows with PHP, IIS, and SQL Server Express.

After reminding us of the various open source applications that can be installed with the WPI, Akash then takes us through the process of setting up the development environment. Next we take a tour through the SQL Server Management Studio interface, to see how easy it is to setup and manage your databases. Once all the relevant components have been installed, you’ll learn how to build a simple project time tracker that can help to organize timing records and accurately bill clients.

By the time you’ve finished the tutorial, you’ll also be able to use standard SQL functions to create a simple report. If you really feel like challenging yourself, you can research T-SQL and go on to build a more complex report. Before you know it, you’ll have an SQL Server-driven PHP application up and running!

A big thankyou to Microsoft, who are sponsoring the quiz for this article. If you found the tutorial interesting, be sure to give the quiz a go – and if you’re one of the first 200 people to complete the quiz, you could snap up a copy of Microsoft SQL Server Developer Edition (please see quiz for terms and conditions) delivered to your door for FREE!

Read the article: Get Started with PHP on Windows with SQL Server Express
Take the quiz: Get Started with PHP on Windows with SQL Server Express Quiz

Free book: Jump Start HTML5 Basics

Grab a free copy of one our latest ebooks! Packed with hints and tips on HTML5's most powerful new features.

  • USPatriot

    Sweet Jesus, an article on something other then Adobe, Google, or Open-Sucks (I mean Source). Epic fail however, you chose Hobby PHP, over .NET.

  • http://www.optimalworks.net/ Craig Buckler

    @USPatriot
    I guess you haven’t noticed that SitePoint is primarily aimed at designers, developers and business owners who use web standards and open-source technologies? There are a few ASP.NET, Java, Flash etc. articles and discussions, but the emphasis is on HTML, CSS, JavaScript, PHP and MySQL. Sorry if that’s not to your taste.

  • Alex

    I simply don’t get why people hurl unfair and derogatory insults at poor .NET – EVERY Windows PC has it nowadays, and any Microsoft language is better than paltry, second-fiddle alternatives such as PHP, and SQL Server is 5000% better than the second-rate lemon that is MySQL or other wretched, two-bit, technically inferior options.

    –Interpretive moderation by the admin. Bolding indicates creative license taken when substituting for offensive words.

  • Anon

    Any reason why the Quiz prizes are only open to US residents?

  • Louis Simoneau

    LOL @ the moderation … Like the creative touch ;-)

  • http://www.optimalworks.net/ Craig Buckler

    @Alex
    I don’t think anyone’s hurled an insult at .NET (which isn’t a language, incidentally – it’s a framework). C# is one of the languages you can use with .NET and it’s very good. It’s possibly one of the best around because it took the good features from other languages and rejected the nasty stuff.

    Oh yes, C# is an open standard.

    @USPatriot
    I’m sorry you feel that way. But I guess you won’t read my apology since you’re not wasting any more time here?

  • willthiswork

    What’s the point of publishing comments full of insults, childish statements, personal attacks and distorted reality?
    I’m disgusted.