RSS

Monthly Archives: May 2015

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:

My new Arabic blogs in SQL Server 2014 on MSDN Microsoft

msdn

Hello Guys this My new Arabic blogs in SQL Server 2014 on MSDN Microsoft

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

View all my tips , LinkedIn Slideshare ,Youtube Channel.

 
19 Comments

Posted by on May 16, 2015 in Arabic Posts, MSDN

 

Tags: , ,

Microsoft announced SQL Server 2016

Very Amazing technology didn’t Stop 

dpi-may4-1Satya Nadella, CEO of Microsoft, announced SQL Server 2016, an intelligent platform for a mobile first, cloud first world.  The next major release of Microsoft’s flagship database and analytics platform provides breakthrough performance for mission critical applications and deeper insights on your data across on-premises and cloud. Top capabilities for the release include: Always Encrypted – a new capability that protects data at rest and in motion, Stretch Database – new technology that lets you dynamically stretch your warm and cold transactional data to Microsoft Azure, enhancements to our industry-leading in-memory technologies for real-time analytics on top of breakthrough transactional performance and new in-database analytics with R integration.

For More information go here

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

View all my tips , LinkedIn Slideshare ,Youtube Channel.

 
1 Comment

Posted by on May 5, 2015 in SQL Server 2016

 

Tags: ,

SQL Server 2014 Health check DMV queries Day 7

 Hi guys in the Previous post i explained three DMV related to SQL Server cluster and  AlwaysOn AG, Get information about your OS cluster , Cluster Node Properties and Failover Cluster Node with AlwaysOn AG put today in DAY 7 i will show new DMV in our track Instance Level configuration .

DMV#17 Instance Configuration Properties

now we can know easily all the instance configuration properties like (backup compression, Ad Hoc Distributed Queries,affinity I/O mask,max server memory (MB) and max degree of parallelism…etc

SELECT name, value, value_in_use, minimum, maximum, [description], is_dynamic, is_advanced
FROM sys.configurations WITH (NOLOCK)
ORDER BY name OPTION (RECOMPILE);

DMV#17

Read the rest of this entry »

 
Leave a comment

Posted by on May 3, 2015 in SQL Server 2014

 

Tags: , , , , , ,

SQL Server 2014 Health check DMV queries Day 6

Hi guys in the Previous post i explained How we can Getting the Server Model Number ,Getting the Processor Description  and get SQL Server Error Log Properties put today in DAY 6 i will show new DMV in our track Instance Level configuration .

in this post i will explain three new DMV related to SQL Server Cluster and AlwaysOn AG You will see no results if your instance is not using Clustering or AlwaysOn AG.

DMV#14 Get information about your OS cluster

If your SQL server is cluster not standalone you can use this DMV to get very useful information about the OS (Operation System)

SELECT VerboseLogging, SqlDumperDumpFlags, SqlDumperDumpPath,
 SqlDumperDumpTimeOut, FailureConditionLevel, HealthCheckTimeout
FROM sys.dm_os_cluster_properties WITH (NOLOCK) OPTION (RECOMPILE);

DMV#15 Cluster Node Properties

by this DMV we can return the node name and the current status of it so know you can now easily SQL Server cluster running in which node .

SELECT NodeName, status_description, is_current_owner
FROM sys.dm_os_cluster_nodes WITH (NOLOCK) OPTION (RECOMPILE);

DMV#16 Failover Cluster Node with AlwaysOn AG

by this DMV you can return the Cluster name , quorum_type_desc  and  quorum_state_desc for SQL Server AlwaysOn

SELECT cluster_name, quorum_type_desc, quorum_state_desc
FROM sys.dm_hadr_cluster WITH (NOLOCK) OPTION (RECOMPILE);

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

View all my tips , LinkedIn Slideshare ,Youtube Channel.

 
1 Comment

Posted by on May 2, 2015 in SQL Server 2014

 

Tags: , , , ,