SQL Authority News – Download Microsoft SQL Server 2014 Feature Pack and Microsoft SQL Server Developer’s Edition

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)

About these ads

SQL Authority News – Microsoft Whitepaper – SQL Server 2014 and Windows Azure Blob Storage Service: Better Together

Microsoft has released SQL Server 2014 earlier this month and now have released very long but interesting white paper on Windows Azure Blog Storage Services. SQL Server Data Files in Windows Azure feature is available in all editions of SQL Server 2014. This feature is enabled by default and at free of cost. This feature makes SQL Server 2014 hybrid cloud database as it provides native support for database files stored as Windows Azure Blobs. If you notice this is a big leap forward where data stored locally as well as on a cloud are accessed by SQL Server 2014 at the same time. You can also host SQL Server Instance in Azure cloud and it can also use the Windows Azure Blobs just like on-premises SQL Server.

Let me give you another example, if you have a situation that you have stored your database files in the cloud as well as backup on Windows Azure Cloud. Now if you want to restore your backup you do not have to bring that back to on-premises before restoring it. You can just restore your data directly from Windows Azure Storage to your SQL Server 2014 instance in a Virtual Machine. It will remove the necessity to do lots of data movement between cloud and on-premises servers.

This white paper discusses exactly the same feature very much in detailed. This white paper has over 116 pages and the size of the word file is 2.5 MB. However, after a long time I have found a Whitepaper which explains concepts from the beginning and walks users step by step with the examples. The appendix file to this Whitepaper contains all the necessary code as well as very interesting reference material. I think I am going to spend my entire weekend reading and learning from this Whitepaper.

Image included in this blog post is courtesy to the same white paper and it explains the story of entire white paper in just one image. Brilliant.

Download the white paper SQL Server 2014 and Windows Azure Blob Storage Service: Better Together.

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

SQL SERVER – SQL Server 2014 Developer Training Kit and Sample Databases

SQL Server 2014 RTM is around the corner (2014). There is plenty of the interest in the SQL Server 2014 in recent time. One of the most frequently asked questions is about learning resources of SQL Server 2014. Everybody wants to learn SQL Server 2014 but there is not enough learning material available currently in the outside world.

Microsoft has released two important resources around it.

SQL Server 2014 Developer Training Kit

The SQL Server 2014 Developer Training Kit includes technical content designed to help you learn how to develop SQL Server 2014 databases, BI Solutions, and gain insights into the new cloud capabilities to simplify cloud adoption for your SQL databases and help you unlock new hybrid scenarios.

SQL Server 2014 Developer Training Kit Sample Databases

This download contains several sample databases for the SQL Server 2014 Developer Training Kit which showcase many of the new and improved features of SQL Server 2014, including Clustered Columnstore, Online Operations, and Resource Governor IO.

Here are few of the key features in SQL Server 2014

  •  Resource Governor IO
  • Online Operations
  • Updatable Columnstore Index
  • In Memory OLTP Engine
  • Enhencements in SSDT and BI tools
  • Power BI Integration

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

SQL SERVER – Writing SQL Queries Made Easy with dbForget SQL Complete

Down with shackles of convention! dbForge SQL Complete 4.5 came in this world.

What does SQL mean for each of us? For some – the only language for working with relational databases. Yet, for others – it is a way of life…

However, when working with SQL queries, both categories of people face the same difficulties.

Eventually, writing queries becomes routine, and all because of imperfection of the built-in Intellisense in SSMS.

The new dbForge SQL Complete 4.5 is called to release everyone from the shackles of convention in SSMS Intellisense and provide more opportunities when working with T-SQL code.

For this, SQL Complete has several key features in its arsenal:

1. Code auto-completion

Because of contextual object tooltips and syntactic elements of the T-SQL language, the productivity of work with SQL Complete is not just rising – it opens on to a qualitatively new level, providing greater opportunities.

Not just a trite hint of tables and columns is ensured. The ability to generate foreign key relationships, aliases, and many other things…

Object hints are provided in such a big number of structures, that an incomplete list of them can be learned only on a separate page.

2. SQL Formatter

Features of the SQL Formatter embedded in dbForge SQL Complete will allow to forget about manual query editing forever.

Using the SQL Formatter, your code will always be perfect due to a huge number of settings, that allow to customize formatting of all SQL constructs according to your personal preferences.

Moreover, there is a possibility to format not only the current document or selected code fragment, but groups of files on the disk as well.

3. Snippets

Code reuse through snippets is a perfect opportunity to accelerate the process of writing code.

As Devart developers said, their analysis of more than 5.000 topical posts from authoritative resources such as StackOverflow had shown that the list of basic snippets was significantly extended to prevent users from typing frequently used T-SQL statements.

Besides, owing to the Snippet Manager, users can easily extend the set of existing snippets.

When typing code, a required snippet can be selected by capital letters:

and by match with the snippet’s name:

4. Auto-refresh after update schema changes

On active schema changing, many encounter a situation when new or modified objects are not suggested in SSMS Intellisense. For this, you have to manually refresh the object list.

But all that is in the past, since in the version 4.5, there is a capability of smart refresh of hints for modified objects only at specified time intervals.

Within the dbForge SQL Complete 4.5 release, I would like to bring to your attention that memory consumption is reduced and objects describing is now much faster.

All these improvements are aimed to ensure that our users to be able to enjoy work and perform it without delays.

To support words with deeds, I recommend users to re-discover the wonderful world of SQL with dbForge SQL Complete 4.5.

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

SQL SERVER – Download SQL Server 2014 CTP2 and Related Downloads

SQL Server 2014 CTP2 was announced quite a while ago. I still see very few people working on it or writing about it. There can be many reasons for not attempting to start with SQL Server 2014 but the reality is that it is coming in the next few months and it will be here before we know it. Today is December 1, 2013 and in one month we will be in the year 2014. SQL Server 2014’s release cycle will announce its GA very soon and if we have not started with SQL Server 2014 we will be a bit late for sure. Here are few of the downloads related to SQL Server 2014.

Feel free to download them and experiment with SQL Server 2014.

Microsoft SQL Server 2014 Community Technology Preview 2 (CTP2)
Microsoft SQL Server 2014 brings to market new in-memory capabilities built into the core database, including in-memory OLTP, which complements our existing in-memory data warehousing and BI capabilities for the most comprehensive in-memory database solution in the market. SQL Server 2014 also provides new cloud capabilities to simplify cloud adoption for your SQL databases and help you unlock new hybrid scenarios.

Microsoft SQL Server 2014 Data Tools – Business Intelligence for Microsoft Visual Studio 2012, Community Technology Preview 2 (CTP2)
Installs the Microsoft SQL Server 2014 CTP2 Data Tools Business Intelligence project templates for Analysis Services, Integration Services, and Reporting Services.

Microsoft Data-Tier Application Framework for SQL Server 2014 CTP2
The Microsoft Data-Tier Application Framework for SQL Server 2014 CTP2 provides application lifecycle services for database development and management.

Microsoft SQL Server Data Tools for SQL Server 2014CTP2
SQL Server Data Tools provides an integrated environment for database developers to carry out all their database design work for any SQL Serverplatform within Visual Studio.

Microsoft SQL Server 2014 CTP2 Product Guide
Download the datasheets, white papers and technical presentations that will help you evaluate Microsoft SQL Server 2014 CTP2.

Microsoft SQL Server 2014 Reporting Services Add-in for Microsoft SharePoint, Community Technology Preview 2 (CTP2)
The SQL Server 2014 CTP2 Reporting Services Add-in for Microsoft SharePoint technologies allows you to integrate Reporting Services features with the collaborative SharePoint experience.

Microsoft SQL Server 2014 PowerPivot for Microsoft SharePoint 2013, Community Technology Preview 2 (CTP2)
Microsoft SQL Server 2014 PowerPivot for SharePoint 2013, CTP2 extends SharePoint Server 2013 to add server-side data refresh processing, collaboration, and management support for PowerPivot workbooks.

Here is the question for you – Have you installed SQL Server 2014 CTP R2?

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

SQL SERVER – Download FREE PDFs from SQLAuthority.com

Throughout the last seven years, we have created many PDF downloads from SQLAuthority.com and many are very much appreciated by users. I just wanted to list all the downloads which we have created so far in a single place, hence here is the blog post which contains all the PDF downloads which we have created so far.

SQL Server Interview Questions and Answers Download
Beginning Big Data with NuoDB
SQL Server Management Studio Keyboard Shorts Download
SQL Server 2008 Certification Path Complete Download
SQL Server Cheat Sheet Download
SQL Server Database Coding Standards and Guidelines Complete List Download
SQL Server Indexing Checklist

Let me know which one of the PDF you like the most and if you expect us to create any more PDF articles. Leave a comment.

Additionally, we have created various script bank for all the script which has been used on SQLAuthority.com so far. You can get access to the scripts by clicking on following link.

SQLAuthority.com Scripts Download

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

SQL – Download NuoDB and Qualify for FREE Amazon Gift Cards

July has been a fantastic month and Team NuoDB has really appreciated the active participation of the SQLAuthority.com active reader base.

Earlier we had launched two contests with NuoDB and both of them are very much appreciated by readers. There are constant demands of more contests and team NuoDB is very much excited to support more contests.

Here are the details to constests ran earlier:

Based on the earlier successful contests, the kind folks at NuoDB decided that they will support one more round of the giveaways to SQLAuthority.com contests. However, please note that this month’s contest will end in next 48 hours. You have to take part before July 31st, 2013 11:59:00 PM PST.

Here is the quick contest:

You just have to go and download NuoDB. The first 10 people who will download the NuoDB will get Amzon USD 10 cards. Remaining everyone will be entered into a lucky draw of Amazon Gift cards of USD 50. Winners will be announced in next 24 hours. To eligible for this contest, please download NuoDB before July 31st, 2013 11:59:00 PM PST.

Bonus Round:

If you have entered in the contest above, you can also enter to win latest Beginning SSRS Joes 2 Pros book. You just have to leave a comment over here with the note about how many different platform NuoDB supports.

Here are few of the blog post I wrote earlier on that subject:

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