The Evolving Role of Database Administrators: From Junior to Senior In the world of database administration, the journey from a Junior Database Administrator (DBA) to a Senior DBA is marked not just by years of experience but by a depth of understanding and a trail of resolved challenges. This path is crucial not only for personal career growth but also …
Introduction: In my years of working with SQL Server, I’ve encountered a variety of common mistakes that can impact performance and database health. In this blog post, I’ll share these pitfalls and provide tips on how to avoid them. Remember, understanding these mistakes is the first step in enhancing your SQL Server’s Performance. Ignoring Database NormalizationNormalization is crucial for reducing …
Common SQL Server Mistakes and How To Avoid Them Read more »
Elevating SQL Server Performance with Managed Services from Stedman Solutions In the realm of database management, SQL Server stands out for its robustness, scalability, and wide range of features catering to various business needs. However, like any sophisticated technology, it requires expert handling to fully harness its potential and ensure peak performance. That’s where managed services from Stedman Solutions, LLC …
Here is a video that I created on Indexing for Performance, some of the techniques that I use when doing performance tuning: Steve StedmanFounder/Owner — Stedman Solutions, LLC.SQL Server DBA Services Looking to schedule a meeting with me? Here is my availability: https://Stedman.us/schedule
We are thrilled to extend a special invitation to you for an exclusive, free informational 30-minute session on SQL Server maintenance for IT Managers and Leaders! This event will take place on Wednesday May 22, 2024 at 10:30 am Pacific Time. We will be covering: And just how Stedman Solutions LLC can assist you today. This is an exclusive event, only allowing …
Introduction to SQL Server maintenance for IT Managers and Leaders Read more »
Today Microsoft released a new update for SQL Server. SQL Server 2022 CU13 for 2022 (16.0.4125.3 – May 2024) CU12 + GDR (16.0.4120.1 – April 2024) 2024-05-16 Here are the latest updates for each version of SQL Server. SQL Server 2008 R2 RTM Download links: SP3 (10.50.6000.34 – September 2014) SP2 (10.50.4000.0 – July 2012)None SQL Server 2022 RTM Download links: NoneCU13 …
Monitoring backups is an essential part of database administration, as it ensures that you have reliable and up-to-date backups in case of data loss or corruption. The Database Health Monitor for SQL Server provides insights into backup status, enabling you to identify potential issues and take corrective action to ensure that your backups are running smoothly. The Database Health Monitor …
Database Health: Monitoring Backups with Database Health Monitor Read more »
Database corruption in Microsoft SQL Server can result in critical data loss, disrupting business workflows. The meticulous process of identifying and repairing such corruption often involves implementing methodologies such as those devised by Steve Stedman, a recognized authority in the SQL Server community known for his expertise in corruption repair. These stories come from a recording of a presentation by …
SQL Server Corruption: Stories About Causes of Corruption Read more »
Transparent Data Encryption (TDE) is a feature of Microsoft SQL Server that enables the encryption of a databases data and log files, as well as the encryption of backups, to protect sensitive data from unauthorized access. TDE encrypts the data at the page level, meaning that the data is encrypted as it is written to the disk and decrypted when …
Securing SQL Server: Transparent Data Encryption Read more »
DBCC INPUTBUFFER is a DBCC command in Microsoft SQL Server that can be used to retrieve the last batch of Transact-SQL statements submitted through a specific connection to the database engine. It can be useful for troubleshooting problems with long-running queries, identifying the cause of deadlocks, or simply examining the T-SQL code being executed on the server. To use DBCC …