DB Cloud TECH

November 19, 2015 Mustafa EL-Masry General topics, New Feature

Cumulative update package 9 for SQL Server 2012 SP2 is available now

HI Followers Microsoft Announced about new cumulative update for SQL Server 2012 SP2 (Cumulative update package 9) and it come to fix around 13 Point in SQL Server (Master Data Services , Reporting Services , High Availability , SQL security , SQL service )

the most interested fixed for me is :

5285719

321185

This update introduces a new global property that exposes the latest CU number that is currently installed on the SQL Server. After you install this update, you can obtain the CU number information by executing either of the following queries:

SELECT @@VERSIONSELECT SERVERPROPERTY(‘PRODUCTUPDATELEVEL’)Additionally, this update also adds the CU number information to the first line of the SQL Server error log.

5646993	3097636	FIX: Performance decrease when an application that has connection pooling frequently connects or disconnects in SQL Server
5699533	3051145	FIX: SQL Server may shut down when you use Service Broker in SQL Server 2012 or SQL Server 2014

4272469

2682488

FIX: Backup operation fails in a SQL Server database after you enable change tracking

For more information about the Hotfixes go 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

November 16, 2015 Mustafa EL-Masry Administration

Change DB Owner on all Databases one time

this one of wonderful scripts and very important

—Change DB Owner on All Databases
EXEC sp_MSforeachdb ‘IF ”?” NOT IN (”Master”,”tempDB”,”model”,”msdb”)
BEGIN
EXEC [?]..sp_changedbowner ”User Name”
END
‘

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

November 8, 2015February 28, 2017 devmosman SQL Server 2016

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

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

November 5, 2015November 5, 2015 Mustafa EL-Masry SQL Server 2016

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 )
Save Open Queries in SQL Server Management Studio (Tools > options > Query Execution > Prompt to save unsaved T-SQL Query Windows on Close)

Continue reading “What is New in SQL Server 2016 Management Studio” →

November 5, 2015November 5, 2015 Mustafa EL-Masry SQL Server 2016

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
—————————