Microsoft SQL Server 2005 | SQL Server 2007
Would you get benefits from the brand new easy to get SQL server expert certification?
I just received an email with doc that tell us the benefits to get SQL server expert certification. This is also a big credit to Michele Rouse who's the blog owner to SQL certification blog
hopefully this benefits will give us some inspiration to be a SQL server expert cheer .. :)
Would you get benefits from the brand new easy to get SQL server expert certification?
In my experience the top DB platforms are Microsoft and Oracle. I have come to learn that MySQL is trusted in start-up companies and DB folks who know this platform might make higher salaries, but I honestly rarely ever found MySQL in job searches.
One reason why I like MS SQL Server is because it also includes the SSRS BI platform that is powerful and popular. DB folks who know SSRS (SQL Server Reporting Services) have become very sought-after candidates in many companies. Typically, companies end up needing to buy licenses for third-party BI (Business Intelligence) applications which could cost a lot of extra money.
How To Install SQL Server 2005 on Windows Server 2008
First, We will need to make sure your Windows Server 2008 is a clean install.
If you already have Microsoft SQL server express then you need to uninstalled it first.
Preparing Anything:
1. ISO Microsoft SQL Server 2005 full release (en_sql_2005_std_x86_dvd.iso)
2. Microsoft Service Pack (we can download it from : http://www.microsoft.com/downloads/details.aspx?FamilyId=FB0EE17E-96EB-4...)
3. Microsoft SQL Server 2005 SP2 (you can download it from microsoft website )
Configuring SolarWinds Orion

Below is steps for first configuring Orion after installation. If Orion not installed yet, you can follow this related article for installation, Installing SolarWinds Orion.
Orion configuration wizard :
How To Create A User And Database In Mssql 2005
Here is a simple tutorial How to Create a User and Database in Mssql 2005 Windows Server.
First you need to login into MSSQL server with administrator access.
[code]Click Start >> All Programs >> Microsoft Sql Server 2005 >> SQL Server Management Studio[/code]

You will see the authentication screen below
Recent blog posts |
Recent comments
4 days 2 hours ago
1 week 2 days ago
1 week 3 days ago
2 weeks 4 days ago
4 weeks 4 days ago
4 weeks 4 days ago
5 weeks 2 days ago
5 weeks 4 days ago
5 weeks 4 days ago
6 weeks 5 days ago