Database

So, you have an interview lined up for a sweet new gig as a SQL Server database administrator (DBA). What interview questions will you be asked? How can you make…

SQL Server monitoring is continuous collection and analysis of usage, performance, and event metrics for Microsoft SQL Server. It’s the first step in optimizing performance for applications that depend on…

You can learn a lot about an organization by looking at their data. For example, if I see “LoanToValue” (LTV) or “CollateralValue,” I could surmise they deal with financial data—specifically…

If you’ve worked in IT in recent years, you’re no doubt familiar with the term “DevOps.” Accelerating the pace of development and faster delivery of new features is the goal.…

A data center typically employs between 30-200 people depending on the size and the intended project use. But only a fraction of those folks run the IT side. Besides swapping…

It’s important to understand how a database engine works, and knowing what to monitor is the key to overall performance. As part of that overview, this infographic outlines some need-to-know…

Every company needs data for various reasons, but hoarding too much data can be a dangerous habit. An overload of data can turn the average IT pro into a hoarder…

We’ve reached the final piece of our five-part series, and while I’m sad to end it, I hope you or your DBA teams have learned enough to move forward with…

Have you ever heard the mantra “Don’t deploy on Fridays?” There are blog posts, tweets, and t-shirts shouting this slogan to anyone who will listen. Maybe your organization follows this…

Welcome back! We’re nearing the end of our five-part series, and I hope you’ve gotten the information you need as a DBA to mature your business. In this part of…