RSS

Category Archives: SQL Server 2016

SQL Server 2016 Community Technology Preview 3.1 is available

Configurations for all Microsoft SQL Server 2016 followers and for the guys are interested to know more and more about this new technology Microsoft released version no 3.1 CTP from SQL Server 2016 and it released new improvement in this version (In-Memory OLTP) i will explain it later in detail but now for more information and for downloading this new version you can check it from Here

Also to cover all the new updates in SQL Server 2016 you can check it from Here

To know More about new feature in SQL Server 2016 you can check it from HERE

Follow Us :

LinkedIn Slideshare ,Youtube Channel.MSDN POSTS ,Facebook WHO WE ARE

 

 

 
Leave a comment

Posted by on December 8, 2015 in SQL Server 2016

 

Tags: , ,

Live Query Statistics in SQL Server 2016

Today we have very good features it will help us in our daily work (Performance troubleshooting and for the debugging of queries) as we know to tune any SQL Server query you should Check first the Execution plan to decide from where the problem from SQL Server 2005 to SQL Server 2014 we have two types of Execution plan:

  • Estimated Execution Plan: Giving you an idea of how SQL Server will most likely perform query execution
  • Actual Execution Plan       : This will show you things that might hint at “out-of-date” statistics etc. But to get this, you must run the query – which can take a long time.

So before if we have case one Query returned Millions of record and we need to check the Query execution plan for it we will go directly for the Estimated Execution plan because actual Execution plan if we need to see it we will wait more time to the query finish and return all the result but Now in SQL Server 2016 we have new Execution plan type ” Live Query Statistics ”  this new features it will he;p us to see the Execution plan when the Query running and the Effect of the Query on the Execution plan step by step from more points:

  • Execution Query Percentage
  • Actual Number of Rows
  • elapsed time
  • operator progress

What I use here in my demo is simple Query return more than 8 Millions of records if I wait for this query to return all this data to see the Actual Execution plan I will wait around 20 Minutes but now in SQL Server 2016 I will See the Execution plan the Actual Execution Plan Live with Live Query Statistics 

SELECT *
FROM sys.all_columns tmp1
Cross JOIN sys.all_columns tmp2

Live Query3

Live Query1 Live Query2

To know More about new feature in SQL Server 2016 Keep following us and to check the previous posts in SQL Server 20116 you can check it from HERE

 
Leave a comment

Posted by on November 8, 2015 in SQL Server 2016

 

Tags: , , , , , , , ,

What is New in SQL Server 2016 Management Studio

Hello my followers today i will speak in very good Point in SQL Server 2016 all we are working on SSMS (SQL Server Mangment Studio) and we should now the options in this tools and what is the new on it so today we will show the new features in SQL Server 2016 Management Studio then later will explain deeply this features if it needed

  • In the installation you find new tape for Tempdb Configuration 
  • Check for Update : ( Now we can update the SQL Server Management Studio alone you will find it under tools )
  • 1- SSMS Update
  • Save Open Queries in SQL Server Management Studio (Tools > options > Query Execution > Prompt to save unsaved T-SQL Query Windows on Close)

Save unsaved T-SQL

Read the rest of this entry »

 
7 Comments

Posted by on November 5, 2015 in SQL Server 2016

 

Tags: , , , , , ,

SQL Server 2016 installation Error Rule “Oracle JRE 7 Update 51 (64-bit) or higher is required” failed.

Hello my Followers as we know Microsoft is going very fast for SQL Server 2016 RTM , Recently Microsoft announced about SQL Server 2016 CTP 3 “SQL Server 2016 Community Technology Preview 3.0” and this force us to learn more about the new features of this new SQL Server Release and to know ” What’s New in SQL Server 2016 “.

Problem

When i installed SQL Server 2016 CTP 2.4 i faced the below issue and this one we can solve it be the below solution

—————————
Rule Check Result
—————————
Rule “Oracle JRE 7 Update 51 (64-bit) or higher is required” failed.

This computer does not have the Oracle Java SE Runtime Environment Version 7 Update 51 (64-bit) or higher installed. The Oracle Java SE Runtime Environment is software provided by a third party. Microsoft grants you no rights for such third-party software. You are responsible for and must separately locate, read and accept applicable third-party license terms. To continue, download the Oracle SE Java Runtime Environment from http://go.microsoft.com/fwlink/?LinkId=526030.
—————————
OK
—————————

SQl Server 2016

Solution

  1. Go to http://www.oracle.com/technetwork/java/javase/downloads/index.html
  2. Click on Download on JRE as highlighted below

Untitled

Follow Us :

LinkedIn Slideshare ,Youtube Channel.MSDN POSTS ,Facebook WHO WE ARE

 
Leave a comment

Posted by on November 5, 2015 in SQL Server 2016

 

Tags: , ,

New TempDB Configuration in SQL Server 2016

SQL Server 2016 Logo

Hello my Followers as we know Microsoft is going very fast for SQL Server 2016 RTM , Recently Microsoft announced about SQL Server 2016 CTP 3 “SQL Server 2016 Community Technology Preview 3.0” and this force us to learn more about the new features of this new SQL Server Release and to know ” What’s New in SQL Server 2016 “.

In the Previous versions of SQL Server we couldn’t touch the tempdb Configuration while the SQL Server installation but now in SQL Server 2016 CTP 2.4 we can configure your Tempdb easily without any effort from the beginning

Tempdb Configuration in SQL Server 2016 2.4 :

  • By defalut now SQL Server 2016 Setup add 4 Data files for the Tempdb not like before one file only.
  • the default initial size is 8MB and the default autogrowth is 64MB.
  • we can now add specified data File in Specified Direction
  • During the Setup now we can configure the Data File , initial Size , Database Growth

SQl Server 2016 TemPDB

Follow Us :

LinkedIn Slideshare ,Youtube Channel.MSDN POSTS , WHO WE ARE

 
Leave a comment

Posted by on November 4, 2015 in SQL Server 2016

 

Tags: , , ,

SQL Server 2016 Community Technology Preview 2.1 is available

Microsoft is going very fast to SQL Server 2016 last month Microsoft announced about SQL Server 2016 and you can know more information about it from here , and today microsoft release CTP 2.1 (Community Technology Preview) you can dwenoad it from here

for the Official News from Microsoft’s Information Platform you go to this link 

SQL Server 2016 CTP 2.1

SQL Server 2016 CTP 2.1

To check all my posts you godirect to my personal website or you can download this Excel sheet My Technical POSTS

View all my tips , LinkedIn Slideshare ,Youtube Channel.My posts in MSDN

 
2 Comments

Posted by on June 26, 2015 in SQL Server 2016

 

Tags: , ,

look at the next Microsoft data platform in SQL Server 2016

SQL Server 2016I love microsoft it is going up very fast it is triple jump in SQL Server technology Microsoft already announced about the new version of SQL Server (( SQL Server 2016 )) look here but today we are going to try and look look at the next Microsoft data platform in SQL Server 2016 As the biggest leap forward in Microsoft’s data platform history, SQL Server 2016 delivers breakthrough mission critical performance, deeper insights across any data on many devices and enables the power of hyperscale cloud to unlock new hybrid scenarios by this new version we are going for lot of enhancement amzing job

SQL Server 2016 delivers breakthrough mission-critical capabilities with in-memory performance and operational analytics built-in. Comprehensive security features like new Always Encrypted technology help protect your data at rest and in motion, and a world-class high availability and disaster recovery solution adds new enhancements to AlwaysOn technology.

What is new and Enhanced in SQL Server 2016

  • Enhanced in-memory performance with up to 30x faster transactions,
  • Always Encrypted
  • Even higher availability and performance than SQL Server 2014 with AlwaysOn secondaries with the ability to have up to 3 synchronous replicas,
  • Built-in advanced analytics provide the scalability and performance benefits of running your “R” algorithms directly in SQL Server
  • Enhanced database caching
  • New tools for SQL Server migration with Microsoft Azure easier than before.

for more information read the SQL Server Datasheet here also be one for the first DBA downloaded and tried the new SQL Server 2016 version you can download it as CPT2 from here 

SQL Server 2016 Enhancement

SQL Server 2016 Enhancement

To check all my posts you godirect to my personal website or you can download this Excel sheet My Technical POSTS

View all my tips , LinkedIn Slideshare ,Youtube Channel.My posts in MSDN

 
1 Comment

Posted by on May 28, 2015 in SQL Server 2016

 

Tags: