Using and troubleshooting SQL Server IntelliSense – For SQL Server 2012 or higher

February 29, 2016 by

When I first heard that Microsoft was going to introduce IntelliSense for SQL Server I could hardly contain my excitement. Much to my disappointment the initial version of IntelliSense left a lot to be desired. From issues like just not popping up at all, to not working on remote servers and sometimes picking incorrect entries […]

MS SQL Server backup optimization

January 19, 2016 by

Backup and recovery are some of the most important DBA tasks, although they look simple enough and usually you setup them, leave them running on schedule and only come back if they fail – there is a whole new world in regards to optimization you can do to make them faster, better and … smaller. […]

How to Avoid CXPACKETs?

November 25, 2015 by

CXPACKET is one of the famous wait types that database administrators are experiencing. Before moving into the details of the CXPACKET wait type, first, let us discuss the waits in SQL Server in brief. SQL Server is a mini operating system. When SQL Server is executing any task and if for any reason it has […]

Cloud Witness – A new feature to make our lives easier

September 4, 2015 by

In order to have a well-configured cluster we need to setup the quorum properly, but there’s more…Here is where the Cloud Witness comes to help. In this article, I’m going to present something that would be very useful if was already been released, but no, I need to anxiously wait for the next version of […]

The DBAs guide to stretch database

August 11, 2015 by

One of the new features in SQL Server 2016 – and there is a lot – is the ability to stretch the on premise databases to an Azure environment. This blogpost will cover some of the aspects of this – including: Primarily setup – how to get started Monitoring state of databases that are in […]

Stretch Database – The art of extend to reduce

August 7, 2015 by

Let’s continue the hybrid saga! After two articles talking about the Azure Blob Storage and what we can do using it, it’s time to check an alternative solution, that does the same of what was presented in the last article (a Hybrid Database used as archival solution for who didn’t read). This time we are […]

How to work migrate backups, files and scripts to/from the cloud using the command line

May 26, 2015 by

Introduction Sometimes we need to move our local files, SQL scripts, backups from our local machine to Azure or vice versa. This can be done manually by accessing to Azure and using a browser, but there are other methods to automatically do this. This article describes the Microsoft Azure Storage Tool. This is a command […]