Join Gerry O'Brien for an in-depth discussion in this video SQL Server versions and supported operating systems, part of Installing SQL Server 2012.
When planning an installation of SQL Server, it's important to know the available editions and the capabilities to ensure that you purchase and install the correct edition to support your database requirements. At the end of this video, you will understand the different versions of SQL server 2012 and the supported operating systems for those versions. SQL Server 2012 comes in five edition, SQL Server Express Edition, Developer Edition, Standard Edition, BI or Business Intelligence and the Enterprise Edition.
The SQL Server Express Edition is an entry level version designed for learning about SQL Server. Or for building small data driven applications. SQL Server Developer Edition contains the same features as the Enterprise Edition but it is only licensed for development and testing purposes it is not licensed for production use. As an example, you cannot use SQL Server Developer Edition as the back-end for a data store that would be providing data for a production website.
SQL Server Standard Edition is intended for smaller scale employments but it provides data management and BI functionality as well. SQL Server Standard Edition would be the right edition for a small business operation. SQL Server Business Intelligence edition is a new edition in SQL Server 2012. It is intended to provide business intelligence functionality to the organization. SQL Server 2012 BI Edition provides data discovery with the power view tool, reporting functionality, analytics.
Data quality services, master data services, as well as all of the features contained in the Standard Edition of SQL Server. The SQL Server Enterprise Edition is a mission critical, data warehousing installation of SQL Server. It's designed to provide high availability. High performance and is used for large scale data warehousing. If you're looking for high availability installing the Enterprise Edition on a system that supports clustering, we'll provide that high availability to your SQL Server environment.
SQL Server runs on the Windows Operating System as a result, the different versions of SQL Server. We will require different versions of the operating system to be installed. For example, the Enterprise and Business Intelligence versions require at least Windows Server 2008 Service Pack 2 or Windows Server 2008 R2 Service Pack 2. These are the 64-bit versions and can be found in the web standard enterprise. Or data center versions of the Windows Operating System.
Standard and developer additions can be installed on Windows 7 Service Pack 1, in either the Professional or Ultimate versions. Windows Vista Service Pack 2, again in the 60-40 bit version for Vista Business, Enterprise or Ultimate Editions. Or they can be installed on the Windows Server 2008 Service Pack 2 or later operating systems. 64 bit versions and supported on the DataCenter and Foundation versions of the operating system. All SQL Server editions also require the installation of the .NET Framework 3.5 Service Pack 1 or later.
SQL Server offers different editions to support various needs and options. Choosing the correct version is critical to ensuring the installed database engine and supporting tools will meet your needs. This video has discussed the different versions of SQL Server 2012.
- Choosing the right SQL Server edition for your organization
- Installing SQL Server
- Testing the installation and connectivity
- Configuring SQL Server services
- Connecting to the network
- Creating and connecting to databases
- Backing up and restoring a database