Tuesday, June 30, 2015

What is PolyBase?

PolyBase is a New technology ...
  • Integrates Microsoft product with Hadoop
  • Installing this feature requires Oracle Java JRE 7.
  • Previously a Parallel Datawarehouse feature only, now its part of standard SQL Server product 2016.
So, With the help of PolyBase, you can,
  • Fetch the data from Hadoop and even allow that data to be joined with native relational tables, means we can get the integrated results from each source.
  • Join structured and semi-structured data seamlessly.
  • Import data from HDFS to relational tables.
  • Export data from relational tables to HDFS.
 
Next Steps:
Go through the below artifactes which may give some insights on PolyBase
 
PASS talk: Polybase: What, Why, How
Polybase: Hadoop Integration in SQL Server PDW V2
MSDN: Getting started with PolyBase 
Hope This Helps!

Wednesday, June 24, 2015

SQL Server Management Studio Query Designer Shortcuts

Problem
 
While writing and editing scripts, we often try to use the keyboard as much as possible. This should be the same for SQL Server scripts as well. When using the Query Designer in SSMS there are some shortcuts that will help you be more efficient and in this tip we will take a look at a few of these shortcuts.
 
Solution
As you know, shortcut keys play a vital role. A shortcut is a key or combination of keys assigned to perform an operation.
 
The best and familiar shortcut keys are:
  • Save (CTRL + S) or (ALT + F + S)
  • Copy (CTRL + C)
  • Paste (CTRL + V)
  • Cut (CTRL + X)
  • Undo (CTRL + Z)
  • Redo (CTRL + Y)
These are all familiar shortcuts keys which are common and standard across most of the modern operating systems and associated applications to perform the same activities.
 
In this tip, we will look at a couple of shortcut keys to work with the "Query Designer" editor in SSMS.
 
To Continue Reading >> Please Refer My Articles at MsSQLTips.com

Tuesday, June 16, 2015

Azure DB Backup/Restore Via SSMS 2014

This topic will provide details(on high level) of new features introduced in SQL Server 2014 Management Studio (SSMS) to Manage Azure Databases.
 
Enhanced Backup:SQL Server 2014 provides new Windows Azure integration to SQL Server's backup capabilities. You can specify a Windows Azure URL as the target for your SQL Server 2014 database backups. This new Windows Azure backup feature is fully integrated into SSMS.
 
In Backup Interface, you will see additional Option called "URL" as shown in the exhibit below,This option will backup the data on azure(cloud), 
 
Select "URL" as "Back up to" and provide the azure connection and file details to backup the data on azure.
 
Enhanced Restore: Same with the restores, you can choose URL as your Source…and provide the details accordingly as shown below.
 

 
Select "URL" and Click on "Add" Button
 
 
This backup and restore functionality are same or similar to when using DISK or TAPE, with a few differences.
 
Hope This Helps!

Monday, June 15, 2015

Deprecated/Discontinued DBEngine Features in SQL Server 2014

As we all aware, each and every new release of any software, we might expect changes in the release like, new features, update/upgrade on the existing features, outdated features due to compatibilities or alternate options.
 
The below link provides the list of the features and functionality that Microsoft is dropping from SQL Server 2014,
 

Wednesday, June 10, 2015

SQL Server 2016 CTP 2

Microsoft has released the first public preview of SQL Server 2016 Community Technology Preview 2. This version delivered with faster transactions and queries, deeper insights on any device, advanced analytics, new security technology, and new hybrid cloud scenarios, etc., Also find the other benefits below,
 
Benefits:
  • Enhanced in-memory performance provide up to 30x faster transactions, more than 100x faster queries than disk based relational databases and real-time operational analytics
  • New Always Encrypted technology helps protect your data at rest and in motion, on-premises and in the cloud, with master keys sitting with the application, without application changes
  • Built-in advanced analytics– provide the scalability and performance benefits of building and running your advanced analytics algorithms directly in the core SQL Server transactional database
  • Business insights through rich visualizations on mobile devices with native apps for Windows, iOS and Android
  • Simplify management of relational and non-relational data with ability to query both through standard T-SQL using PolyBase technology
  • Stretch Database technology keeps more of your customer’s historical data at your fingertips by transparently stretching your warm and cold OLTP data to Microsoft Azure in a secure manner  without application changes
  • Faster hybrid backups, high availability and disaster recovery scenarios to backup and restore your on-premises databases to Microsoft Azure and place your SQL Server AlwaysOn secondaries in Azure