Tag: database


author:

Database

Connect to Windows Azure Virtual Machine Using SSMS

December 18, 2013

In 2013, Microsoft made it available for customers to utilize virtual machines running in Windows Azure. This allowed customers to run an on-premises version of SQL Server, but have the instance hosted in the cloud. The natural question then became, “How do I connect …



author:

Database

5 Things You Didn’t Know About SQL Agent

November 27, 2013

Microsoft SQL Server comes with a boatload of additional components. One component is the SQL Agent. The purpose of the SQL Agent is to serve as a job scheduler. Many experienced DBAs use jobs running inside the SQL Agent to perform routine tasks such …



author:

Database

Improve SQL Server Performance by Looking at Plan Cache (Part 3)

October 3, 2013

You can use the information in the SQL Server plan cache to research performance issues and investigate opportunities for performance improvement. In this three-part article series, we’ve examined several important opportunities you have in mining information from the plan cache, including eliminating single-use plans …




author:

Database

SQL Server Consolidation, Part 3

December 20, 2012

I wrote a couple of posts previously on SQL Server consolidation. The first post tried to give insight on some of the problems and associated motivating factors that most companies have for consolidation efforts. The second post was an attempt to cover some of the decision factors …


author:

Database

SQL Server Consolidation, Part 2

December 20, 2012

Consider for a moment that you have a deck attached to your house. It is one story above ground level and is growing weaker with each passing year. The former homeowner painted (!) the deck, making your options for upkeep quite limited. And what …