Yesterday I attended the SQL Server Community Launch in Bangalore and presented on Performing an effective Presentation. It was a fun presentation and people very well received it. No matter on what subject, I present, I always end up talking about SQL. Here are two of the questions I had received during the event.

Q1) I want to install SQL Server on my development server, where can we get it for free or at an economical price (I do not have MSDN)?

A1) If you are not going to use your server in a production environment, you can just get SQL Server Developer’s Edition and you can read more about it over here.

Here is another favorite question which I keep on receiving it during the event.

Q2) I already have SQL Server installed on my machine, what are different feature pack should I install and where can I get them from.

A2) Just download and install Microsoft SQL Server 2014 Service Pack. Here is the link for downloading it.

The Microsoft SQL Server 2014 Feature Pack is a collection of stand-alone packages which provide additional value for Microsoft SQL Server. It includes tool and components for Microsoft SQL Server 2014 and add-on providers for Microsoft SQL Server 2014. Here is the list of component this product contains:

• Microsoft SQL Server Backup to Windows Azure Tool
• Microsoft SQL Server Cloud Adapter
• Microsoft Kerberos Configuration Manager for Microsoft SQL Server
• Microsoft SQL Server 2014 Semantic Language Statistics
• Microsoft SQL Server Data-Tier Application Framework
• Microsoft SQL Server 2014 Transact-SQL Language Service
• Microsoft Windows PowerShell Extensions for Microsoft SQL Server 2014
• Microsoft SQL Server 2014 Shared Management Objects
• Microsoft Command Line Utilities 11 for Microsoft SQL Server
• Microsoft ODBC Driver 11 for Microsoft SQL Server – Windows
• Microsoft JDBC Driver 4.0 for Microsoft SQL Server
• Microsoft Drivers 3.0 for PHP for Microsoft SQL Server
• Microsoft SQL Server 2014 Transact-SQL ScriptDom
• Microsoft SQL Server 2014 Transact-SQL Compiler Service
• Microsoft System CLR Types for Microsoft SQL Server 2014
• Microsoft SQL Server 2014 Remote Blob Store
• SQL RBS codeplex samples page
• SQL Server Remote Blob Store blogs
• Microsoft SQL Server Service Broker External Activator for Microsoft SQL Server 2014
• Microsoft OData Source for Microsoft SQL Server 2014
• Microsoft Balanced Data Distributor for Microsoft SQL Server 2014
• Microsoft Change Data Capture Designer and Service for Oracle by Attunity for Microsoft SQL Server 2014
• Microsoft SQL Server 2014 Master Data Service Add-in for Microsoft Excel
• Microsoft SQL Server StreamInsight
• Microsoft Connector for SAP BW for Microsoft SQL Server 2014
• Microsoft SQL Server Migration Assistant
• Microsoft SQL Server 2014 Upgrade Advisor
• Microsoft OLEDB Provider for DB2 v5.0 for Microsoft SQL Server 2014
• Microsoft SQL Server 2014 PowerPivot for Microsoft SharePoint 2013
• Microsoft SQL Server 2014 ADOMD.NET
• Microsoft Analysis Services OLE DB Provider for Microsoft SQL Server 2014
• Microsoft SQL Server 2014 Analysis Management Objects
• Microsoft SQL Server Report Builder for Microsoft SQL Server 2014
• Microsoft SQL Server 2014 Reporting Services Add-in for Microsoft SharePoint

Reference: Pinal Dave (http://blog.sqlauthority.com)

Filed under: PostADay, SQL, SQL Authority, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL