Email Alerts
-
SQL Server editions: Is Microsoft SQL Server Express right for you?
Which SQL Server edition is right for your IT shop? In this article by Bob Sheldon, find out if SQL Server Express is an option. Series
-
Excerpt: Planning a Microsoft SQL Server install
For many DBAs, a SQL Server installation can be tough. Read this excerpt from Dusan Petkovic's book on Microsoft SQL Server 2012. Excerpt
-
SQL Server 2012 Guide
SQL Server 2012 Guide
-
SQL Server 2012 release approaches -- what you need to know
Microsoft will soon come out with the long-awaited SQL Server 2012 release, but will your system be ready to take full advantage of the new version, also known as Microsoft Denali? Find out. Feature
-
Click 'Install' and review your summary log
Installing and configuring a SQL Server instance can be a challenging process. Installing a SQL Server 2005 instance is an entirely new learning opportunity for DBAs and developers upgrading to the latest version. Follow this step-by-step guide and e... Step-by-Step Guide
-
Choose SQL Server installation components
Installing and configuring a SQL Server instance can be a challenging process. Installing a SQL Server 2005 instance is an entirely new learning opportunity for DBAs and developers upgrading to the latest version. Follow this step-by-step guide and e... Step-by-Step Guide
-
Begin your SQL Server instance installation
Installing and configuring a SQL Server instance can be a challenging process. Installing a SQL Server 2005 instance is an entirely new learning opportunity for DBAs and developers upgrading to the latest version. Follow this step-by-step guide and e... Step-by-Step Guide
-
Specify account, authentication mode and settings
Installing and configuring a SQL Server instance can be a challenging process. Installing a SQL Server 2005 instance is an entirely new learning opportunity for DBAs and developers upgrading to the latest version. Follow this step-by-step guide and e... Step-by-Step Guide
-
Install SQL Server Service Pack 1
Installing and configuring a SQL Server instance can be a challenging process. Installing a SQL Server 2005 instance is an entirely new learning opportunity for DBAs and developers upgrading to the latest version. Follow this step-by-step guide and e... Step-by-Step Guide
-
Step 3: Choose components, features and instance types
Install SQL Server 2005 Reporting Services with detailed help from this step-by-step guide and avoid any potential hassles. Contributor Jeremy Kadlec includes the current service pack for the complete installation of this feature. Step-by-Step Guide
- See more Essential Knowledge on Microsoft SQL Server Installation
-
SQL Server 2014 due out in late 2013, in-memory OLTP a big feature
Microsoft announced that the next version of its database, SQL Server 2014, will have in-memory features and be generally available in late 2013. News | 03 Jun 2013
-
Big data a big deal for SQL Server 2012, users say
SQL Server 2012 is here, and the Apache Hadoop integration is making the biggest wave, according to some users. News | 11 Apr 2012
-
SQL Server 2012 ‘virtually’ out, Microsoft talks features, licensing
With SQL Server 2012 released in a “virtual launch” this month, Microsoft data platform specialist Mark Kromer tells us what his favorite features of the new release are. News | 14 Mar 2012
-
Don’t sweat migration from Oracle, Sybase to SQL Azure
Are you considering moving your database to Azure? Concerned about complexity? Read this tip from expert Denny Cherry. Migrating to SQL Azure might be the easiest move ever. News | 12 Mar 2012
-
Q&A;: Making the jump to 64-bit SQL Server 2005
Running SQL Server on a 64-bit platform has been an option to improve database performance and scalability for quite some time, but your configuration options were limited and not without problems. For one thing, SQL Server 2000 could only run on the... News | 20 May 2006
-
In-memory SQL Server: The implications of integration
How is in-memory SQL Server different from SQL Server with a bunch of RAM? SQL Server guru Serdar Yegulalp explains what to know before you install. Tip
-
SQL Server Upgrade Advisor, Upgrade Assistant can ease transition pains
You probably think you’re ready to upgrade to the new release, but you might not be as prepared as you think. Before you upgrade, there are some tools to become familiar with, says Bob Sheldon. Tip
-
Pros and cons of SQL Server 2012
Performance and support top the lists of pros for going to SQL Server 2012. But application compatibility and “the unknown” might keep you away for now. Tip
-
No-risk SQL Server upgrade for SSRS no problem
Worried about mishaps during your next SQL Server upgrade? What if you could perform an upgrade that is virtually risk free? It is possible, database architect Roman Rehak writes. Tip
-
Oracle vs. SQL Server face-off: Microsoft SQL cheaper, simpler than Oracle DB
SQL Server expert Denny Cherry argues that SQL Server is better than Oracle Database because it is cheaper, simpler and has a better supportive community. Faceoff
-
Tips for deploying SQL Azure Federations
Reduced SQL Azure pricing, an upgraded management portal, increased database size and the SQL Azure Federations Data Migration Wizard mean multi-tenant and “big data” projects are big possibilities. Tip
-
Microsoft SQL Server 2012 pricing, licensing packed with changes
SQL Server 2012 pricing includes some significant adjustments, including a reduction in the number of editions and the change from processor- to core-based licensing. Tip
-
Creating fault-tolerant SQL Server installations
Several fault-tolerance configuration options are available with SQL Server 2008, from the traditional (failover clustering) to the updated (database mirroring). Tip
-
Get SQL Server log shipping functionality without Enterprise Edition
Log shipping provides great high availability and disaster recovery, but only after paying the hefty licensing costs for SQL Server Enterprise Edition. Tip
-
Configuring SQL Server memory settings
While SQL Server has only a few simple memory settings, those settings are crucial. In this tip, SQL Server expert Denny Cherry shares configuration recommendations for optimal RAM amounts, how to enable AWE, the best number of gigabytes for maximum ... Tip
- See more Tips on Microsoft SQL Server Installation
-
Troubleshoot SQL Server 2005 SP2 installation error
Learn to troubleshoot an error that occurs when running the Service Pack 2 install for SQL Server 2005 that claims the account is not able to rename a file. Ask the Expert
-
Code to connect SQL Server 7.0 to Visual Basic 6.0
Get the code to connect SQL Server version 7.0 to Visual Basic 6.0. Ask the Expert
-
Can SQL Server 2005 EE be set up on Windows XP Pro?
Get that answer and more information on SQL Server and Windows platforms. Ask the Expert
-
Can SQL Server 2000 work on Windows 2003 platform?
Learn what's needed for SQL Server 2000 to be installed on Windows 2003 platform. Ask the Expert
-
Installing SQL Server native client
Find out how to install a SQL Server native client. Ask the Expert
-
Installing different SQL Server versions on one machine
Different SQL Server versions can be installed on one machine, learn how and get the best practices for SQL Server installation and compatibility. Ask the Expert
-
Multiple SQL Server instances vs. multiple databases
Get the pros and cons for installing multiple SQL Server 2005 instances on one machine vs. installing multiple databases within one instance. Ask the Expert
-
Installing two instances of SQL Server 2005 on same server
Can you install two instances of SQL Server 2005 on the same server? Ask the Expert
-
Install SQL Server 2000 Enterprise Editon on Windows 2000 Pro
I'm having a problem installing SQL Server 2000 Enterprise Edition on Windows 2000 Professional. Do I need to install any Service Packs for this? Ask the Expert
-
Integrating Oracle and MSSQL
Find out how SQL Server 2005 helps integrate Oracle and MSSQL for transactions transfer. Ask the Expert
- See more Expert Advice on Microsoft SQL Server Installation
-
SQL Server 2012
Microsoft SQL Server 2012 is a relational database management system (RDBMS) designed for the enterprise environment. Like its predecessors, SQL Server 2012 comprises a set of programming extensions to enhance the Structured Query Language (SQL), a s... Definition
-
SQL (Structured Query Language)
SQL (Structured Query Language) is a standard interactive and programming language for getting information from and updating a database. Definition
-
SQL Server 2014 due out in late 2013, in-memory OLTP a big feature
Microsoft announced that the next version of its database, SQL Server 2014, will have in-memory features and be generally available in late 2013. News
-
SQL Server editions: Is Microsoft SQL Server Express right for you?
Which SQL Server edition is right for your IT shop? In this article by Bob Sheldon, find out if SQL Server Express is an option. Series
-
In-memory SQL Server: The implications of integration
How is in-memory SQL Server different from SQL Server with a bunch of RAM? SQL Server guru Serdar Yegulalp explains what to know before you install. Tip
-
SQL Server 2012
Microsoft SQL Server 2012 is a relational database management system (RDBMS) designed for the enterprise environment. Like its predecessors, SQL Server 2012 comprises a set of programming extensions to enhance the Structured Query Language (SQL), a s... Definition
-
Excerpt: Planning a Microsoft SQL Server install
For many DBAs, a SQL Server installation can be tough. Read this excerpt from Dusan Petkovic's book on Microsoft SQL Server 2012. Excerpt
-
SQL Server Upgrade Advisor, Upgrade Assistant can ease transition pains
You probably think you’re ready to upgrade to the new release, but you might not be as prepared as you think. Before you upgrade, there are some tools to become familiar with, says Bob Sheldon. Tip
-
Pros and cons of SQL Server 2012
Performance and support top the lists of pros for going to SQL Server 2012. But application compatibility and “the unknown” might keep you away for now. Tip
-
Big data a big deal for SQL Server 2012, users say
SQL Server 2012 is here, and the Apache Hadoop integration is making the biggest wave, according to some users. News
-
No-risk SQL Server upgrade for SSRS no problem
Worried about mishaps during your next SQL Server upgrade? What if you could perform an upgrade that is virtually risk free? It is possible, database architect Roman Rehak writes. Tip
-
Oracle vs. SQL Server face-off: Microsoft SQL cheaper, simpler than Oracle DB
SQL Server expert Denny Cherry argues that SQL Server is better than Oracle Database because it is cheaper, simpler and has a better supportive community. Faceoff
- See more All on Microsoft SQL Server Installation
About Microsoft SQL Server Installation
There is a lot to keep in mind when installing Microsoft SQL Server, whether it is SQL Server 2000, 2005, or an upgrade to 2008. Installation considerations include hardware requirements, clustering, default collation, file locations, number of instances, service accounts and more. This page offers advice for installing all versions of Microsoft SQL Server, including tips on troubleshooting errors and step-by-step guides to walk you through the installation process. JGTEST