Tag: sql server

author:

Database

Seven SQL Server Signs the Illuminati Exist

April 1, 2019

The signs that the Illuminati exist are all around us. You can find their marking on our buildings, on our currency, and even in our music videos. The Illuminati thrive by spreading fear, uncertainty, and doubt (FUD). They’ve been using FUD for centuries to …


author:

Database

Hardware or Code? SQL Server Performance Examined

January 24, 2014

CPUs are running faster now than ever before, solid-state drives are replacing spinning disks, and database servers have terabytes of RAM. Because these resources are plentiful and increasingly affordable, it can seem tempting to solve database performance issues with hardware. But consider this example: …



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 …


1

2