Category Archives: SQL Server 2014

How to create backup to multiple disk files

By using Ms SQL Server any edition you can  create a full backup to multiple disk file, which is the best solution. In a steps of one Job you can do it by using this Transact SQL, as it follows:

Posted in SQL Server 2014, SQL Server 2016 | Tagged , , , | Leave a comment

Install SQL2014 CTP2

Video | Posted on by | Leave a comment

SQL Server 2014 Health check DMV queries Day 2

This gallery contains 1 photo.

Hi guys in the Previous post i explained How we can get the SQL Server instance version and How we can know the installed date for SQL Server instance put today is DAY 2 and i will show new DMV in … Continue reading

Gallery | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

SQL Server 2014 Health check DMV queries Day 1

This gallery contains 1 photo.

Hello Guys Follow Me from today and over the next 30 days i will share with in this 30 days 70 DMV each day we will have at least 2 new DMV this DMV Library used for healthy check in SQL … Continue reading

Gallery | Tagged | Leave a comment

Insert into table with default values only

In this article you will find how to insert a row without any specified values in SQL Server table, if the columns have default values. I recently had this issue. I had a table with only two columns one of … Continue reading

Posted in SQL Server 2008, SQL Server 2012, SQL Server 2014, SQL Server Denali | Tagged , , , , , , | Leave a comment

Preview Release of the SQL Server PHP driver

Preview release of the SQL Server Driver for PHP is now available. Find out how it will help developers access Microsoft SQL Server and Microsoft Azure SQL Database. Get it now! http://cic.ms/NzhI9z

Gallery | Tagged , , , | Leave a comment

The System Center Management Pack for SQL Server 2014

The System Center Management Pack for SQL Server 2014 enables the discovery and monitoring of SQL Server 2014 database engines, databases, SQL Server agents and other related components. It also includes performance, availability, and configuration monitoring. Learn more:http://cic.ms/yUWT9f

Gallery | Leave a comment