Databases

4 Leading Database Certifications for Database Administrators in 2022

As a database administrator (DBA), you need to demonstrate your skills on a daily basis. However, if you have no formal training or certification, it can be challenging to land a new job or achieve an internal promotion. Fortunately, there are various highly-regarded database certifications for the leading databases. Whether you work primarily with SQL … Read more 4 Leading Database Certifications for Database Administrators in 2022

A Complete Introduction to SQL Server Transactions

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 … Read more A Complete Introduction to SQL Server Transactions

How Data Types and Query Tuning Can Improve Application Performance

One of the easier ways to improve the performance of your SQL Server and Azure SQL database queries is to ensure you choose the right data types for your data, and the data types in your application’s code match the ones in your stored procedures and queries. Choosing the right data type conserves space, because … Read more How Data Types and Query Tuning Can Improve Application Performance

How to Make SQL Server Faster on Azure VMs

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 … Read more How to Make SQL Server Faster on Azure VMs

SQL Server Storage Best Practices: Choosing Storage Options

Storage is one of the most critical components for any relational database management system, and getting the right storage configuration affects reliability, availability, and performance. When it comes to SQL Server storage best practices, choosing between storage hardware options has changed significantly over the last decade, but that doesn’t necessarily make choosing the correct storage … Read more SQL Server Storage Best Practices: Choosing Storage Options

Spotting and Avoiding Database Drift

Managing any database ecosystem is difficult enough: taking backups, maintaining statistics, and doing performance tuning all tax the time of the DBA or database developer. The job is complex even without considering the work you do to manage the various schema and data drifts that can occur. Unless you operate in a vacuum or within … Read more Spotting and Avoiding Database Drift