Microsoft SQL Server 2005/2008 Express is a free edition of SQL Server that is ideal for learning, developing and powering desktop, web and small server applications, and for redistribution by ISVs.
Top Features
Supports stored procedures, triggers, functions, and views
Store all kinds of business data with native support for relational data, XML, FILESTREAM and spatial data
Improved performance, usability, visualization, in addition to integration with the Microsoft 2007 Office System in SQL Server Reporting Services
Simplify development efforts by leveraging existing T-SQL skills, ADO.NET Entity Framework and LINQ
Closely integrated with Visual Studio and Visual Web Developer
Because there’s no “SQL Agent” in SQL Express Editions, in order to create scheduled backups on SQL server Express edition, we need to user couple of tricks
In order to install SQL 2008 Express, we have to download it first . Fire up your favorite browser and point it to http://www.microsoft.com/express/download/ . After that, find the box with the SQL 2008 Express, and click download.
On the next step you have the option to register with Microsoft or download the software without registration. I will choose the “no registration part”.
In the new window, choose the version you would like to install. Personally, I will choose “Runtime with advanced services“. By clicking on install, Microsoft will ask to install the Microsoft Web Platform installer. If you dont have it installed, click on the picture to install it.
Choose “Run”, and after the download, again, choose “Run“. Wait for the installtion to finish and look at the top of the browser, a little bar will pop up and ask us if we want to run Active X control. Make sure the publisher is “Microsoft Corporation”. Click on “Run“, and then on Allow.
Now, look at the video of the installation I have made for you. The video will show you the process of installing SQL Server 2008 Express.
After that, all you need to do is run the “SQL Server Configuration Manager” under “Configuration Tools” and configure it the way you want it.
BTW, the track used is La Noche by Coca & Villa .IT’s AWESOME!!!
Hi, last couple of days I have setuped over 10 Windows 2008 servers for hosting services for testing or production, so I am pretty bored with repeating the same stuff all over again , but, here’s a recorded video tutorial of one installation process. Because the video is pretty straightforward, I’ve decided that there is no need to explain every step of the installation.
Click on the HD button and put the video into full screen mode, so you can see all the details.
In the next post, I will show you how to install Microsoft SQL server 2008 Express .
How many time did you find yourself in a situation where you need a reliable, stable and strong server? How to even determine if your server is stable enough? How to know what kind of continous load can it handle? Will it crash if it gets under heavy load for a couple of hours? Well, today, I’ve found myself in a situation like that. I have installed HyperV on some server we have at the office and wanted to see how it will perfom under extreme heavy load and how stable everyhing was .
By extreme heavy load I assume about 200 concurent users clicking every 1-3 seconds on a random page that is being served on the server . When you look at the number of 200 concurrent users, you can say: ” Hey, 200 users isnt that big of a number for a server to handle” …and you would be absolutely right … if the server i was trying to “kill” didnt have 1 cpu core and 1 gb of ram assigned to it .
So..the point was to simulate real life conditions as much as possible. To do that, once more, I turned to Linux and the little piece of awesome software called “Siege”. You can download it here. The software is able to simulate almost real user like behavior on a web page. It can randomly open link in a specified interval, simulate 200+ users at the same time without any problems and so on.
To do some proper testing I’ve installed some php+mysql and asp.net+sql2008 applications to simulate a real-life scenario as much as possible. As we all know, one of pretty hungry applications for Linux is Joomla for the PHP+MYSQL combination and DotNetNuke for ASP.Net and MSSql combination. All cacheing techniques on the application and the IIS were turned off so we can maximize the load to the server.
The server is based on Windows 2008 Server R2 Standard Edition and SQL Express 2008 .
I’ve told Siege to simulate 100 users on the Joomla site and 100 users on the ASP.Net site for 24 hours. At this moment, tests are running for 6 hours and everything seems to be in perfect order. Here’s a couple of pictures
As we like to say it..BURN BABY BURN! About 16 more hours to go under 100% cpu Results are coming soon…in about 20 hours more or less ….
Microsoft SQL Server 2005/2008 Express is a free edition of SQL Server that is ideal for learning, developing and powering desktop, web and small server applications, and for redistribution by ISVs.
