New Whitepaper – SQL Server Licensing Reduction

Poor storage performance continues to be the largest pain point with enterprise Database Administrators in today’s virtual world. However, it...

Quick Tip: Why Can’t I Pin an Excel Range to a Power BI Dashboard?

So two new exciting capabilities were announced recently in Power BI.  One involved Excel and the other SSRS, but they...

SET ANSI_NULLS, NOCOUNT and QUOTED_IDENTIFIER.

Hi Guys, When you generate a script to create a Stored Procedure, below three statements are generate by default. SET ANSI_NULLS on SET NOCOUNT on SET QUOTED_IDENTIFIER on Why do we...

What Permissions Does This Login Have?

I recently was tasked with this ticket:
Please add new login Domain\Bob to server MyServer.  Grant the login the same permissions...

Cannot Open the Properties of a 2014 Availability Group in SSMS 2016 CTP 3

I ran across a bug in SSMS 2016 CTP 2 back in August.  If you try to right click and...

Picking a Clustered Index

A Clustered Index is not another term for Primary Key, and more thought should be put into the key columns...

Scripting out multiple scripts from the Object Explorer Details window.

A few weeks ago I was reading a blog post by Andrea Allred (b/t) and was just amazed by what...

What Alerts Us About The SQL Agent? - Syndication – WaterOx Consulting

The SQL Agent is our friend! Setting up SQL Server Agent to automate jobs and alerts is a great idea....

Installation SQL Server 2016

Here is some of the installation processes(https://thakurvinay.wordpress.com/category/installation/) Below is very nice step-by -step installation  process for SQL Server 2016: http://www.databasejournal.com/features/mssql/installing-sql-server-2016.html

Log Shipping: It's Better Than Bad It's Good!