Recent Posts

A Complete Introduction to SQL Server Transactions

Default Post Image

One of the most fundamental concepts in any relational database management system (RDBMS), such as SQL Server, is the transaction. During my consulting career, I’ve seen many performance problems caused by developers not understanding how transactions work in SQL Server. In this tutorial, I’ll explain what transactions are, why they’re necessary, and how they work…

Subjectivity: Naming Standards

Default Post Image

Naming conventions are a very subjective thing, of course. Just like coding styles, they can often lead to anything from minor debates to full-blown religious arguments. Upper case vs. lower case keywords, tabs vs. spaces, and where to put commas come to mind. Heck, these same people even get into sub-arguments about whether the terms “upper…

Top 10 SQL Server Mistakes Made by DBAs

Default Post Image

SQL Server DBAs—even those who have years of experience with relational databases—frequently make the same mistakes repeatedly. Wouldn’t you like to learn about those blunders so that you can sidestep them? Well, I have good news! In a recent webinar, I counted down the 10 most common SQL Server mistakes DBAs make. Read below as I recap…

Auditing Tools for Windows and SQL File Servers

Default Post Image

Considering the widespread use of Windows file servers in enterprise settings, every IT professional should have a handle on server auditing, including the use of appropriate tools to get the job done. File server auditing ensures your file server remains secure and verifies your safety measures are adequate and not breached by any malicious actors….

Issues with Performance Counter Collection

Default Post Image

Description from The SentryOne community One of the things we’ve come to understand in our dealings with the Windows operating system as it relates to performance monitoring is that the performance counter system is very fragile. It doesn’t take much at all to set it off kilter and most of the time you won’t even…

How to Make SQL Server Faster on Azure VMs

Default Post Image

Many organizations have migrated their environments from on-premises to the cloud, and one of the clouds of choice is Microsoft Azure. For SQL Server workloads, organizations can use platform as a service solutions with features like Azure SQL Database and Managed Instance or infrastructure as a service solutions with Azure SQL virtual machines. Azure SQL virtual…

Does Your Database Have Trust Issues?

Default Post Image

You probably know someone with trust issues, but do you know if your database has trust issues? In other words, does your database have Check Constraints and Foreign Keys that are not trusted? If so, it’s important to realize that SQL Server may not be able to use them for query plans and optimization, which…

How to Find and Solve Blocking Chain Issues in SQL Server

Default Post Image

When a reporting application issue occurs and users begin to complain their screens are frozen, it could be a blocking problem. This is especially likely if the issue isn’t caused by an overactive A/C vent and if users report seeing an SQL-related timeout issue. As a database administrator, you need to conduct some reactive, investigative…

Ultimate Guide to Database Monitoring + Best Tools List

Default Post Image

Databases are at the center of most fundamental business processes. As applications become more complicated, IT infrastructures become increasingly diverse and sophisticated. This is a good thing—our IT technology is advancing, becoming more versatile and evolved. But with this evolution comes the issue of troubleshooting and problem rectification. In such wide-ranging infrastructures, finding the source…

What to Know Before Choosing a Database Management System

Default Post Image

A database management system, also called DBMS, is a program that allows admins to access, alter, and analyze a database. In this article, I’ll describe the functions of a database management system and review different types of databases. While this isn’t a comprehensive list of all DBMS types, it’s a start if you’re looking for…

Cloud Migration Tips from SQL Server Experts

Default Post Image

During our recent SentryOne Accelerate 2020 virtual conference, I led a cloud migration panel discussion with several SQL Server experts. I asked the panelists to imagine they were riding in an elevator and someone turned to them and said, “You are really good at managing SQL Server. What tips do you have for someone like…

Azure SQL vs. SQL Server: What’s the Difference? Plus a Guide to On-Prem or Cloud Database Performance Monitoring

Default Post Image

Cloud computing is now an integral part of business IT infrastructures, and Microsoft Azure SQL is one of the forerunners in providing cloud computing services. Using Azure, you can build, test, deploy, and manage applications in your IT environment to support better service delivery with overarching service, application, and database management. No matter how useful…

How to Migrate a SQL Server Database to Azure

Default Post Image

For many organizations who traditionally had to adopt expensive and usually relatively inflexible on-site database solutions, the increasing adoption of database-as-a-service (DBaaS) providers is a welcome alternative, as DBaaS offers a flexible, cloud-based database option through subscription services. Among DBaaS platforms, Microsoft Azure® SQL Database has become a go-to option for organizations hoping to move…

Azure Data Factory: A Quick Guide

Default Post Image

Big data integration and processing can be a tedious task for every organization. However, it’s needed to unlock transformational insights. With tools like Azure Data Factory, organizations can make the most of their data regardless of the source and with almost no complexities and challenges. This article will provide a quick guide to Azure Data…

5 Common Challenges Companies Without a DBA Encounter

Default Post Image

The most used term for someone who is not a Database Administrator (DBA) but is tasked with looking after one or more database servers is “accidental DBA.” It can be a hard and thankless task, which is sometimes assigned to someone who has little to no experience managing a database server. This is in addition…

10 SQL Server Performance Tuning Best Practices

Default Post Image

There are a large number of best practices around SQL Server performance tuning – I could easily write a whole book on the topic, especially when you consider the number of different database settings, SQL Server settings, coding practices, SQL wait types, and so on that can affect performance. For this post I decided to…