Tag: sql server

author:

Database

Seven SQL Server Signs the Illuminati Exist


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


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

5 Things You Didn’t Know About SQL Agent


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

SQL Server Consolidation, Part 3


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