Today Microsoft released a new update for SQL Server. SQL Server 2008 None 2024-06-07 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 for 2022 (16.0.4125.3 – May 2024) CU12 + GDR (16.0.4120.1 – April 2024) …
Out of all of the customers we have running our daily monitoring here are the versions of SQL Server that are being run. All the data is sanitized, so there is no private client information to expose here. What is this service? With this service we detect and alert you of any issues that arise on your SQL Server. Then …
DBCC OPENTRAN is a DBCC command in Microsoft SQL Server that can be used to display information about the oldest active transaction in the database. This can be useful for troubleshooting issues with long-running transactions, as it can help identify the cause of the problem and allow you to take appropriate action to resolve it. To use DBCC OPENTRAN, you …
Wait statistics, in the context of SQL Server, refer to the amount of time that a query spends waiting to access data in the database. When a client application requests data from the database, the request is placed in a queue and the client application must wait for its turn to access the data. The time that the query spends …
Performance tuning in SQL Server is an essential aspect of database management that focuses on optimizing database performance and efficiency. This includes activities such as query optimization, indexing strategies, and server configuration. The Performance Tuning Course from Steve Stedman can help you as the student learn how to performance tune your SQL Server. Find out more about this Performance Tuning …
SQL School: The Importance of Performance Tuning in SQL Server Read more »
Foreign keys are a fundamental aspect of relational databases, as they enforce referential integrity between related tables. However, foreign key relationships can also cause performance issues, particularly if the foreign key is untrusted. An untrusted foreign key occurs when SQL Server is unable to verify the relationship between two tables, potentially leading to performance issues and data inconsistencies. The Database …
At Stedman Solutions we have done many corruption repairs since 2015. When I talk about corruption, most of this information comes from real world scenarios that actually happened at different businesses that we were part of recovering… or not part of recovering if things were completely gone. Transcribed from a presentation on Database Corruption by Steve Stedman and Derrick Bovenkamp. …
SQL Server Corruption: Corruption vs Drive Failure 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 CHECKCATALOG is a DBCC command in Microsoft SQL Server that can be used to check the consistency of the system catalog, which is a set of tables that store metadata about the objects in a database. Checking the consistency of the system catalog can be useful for troubleshooting issues with database objects or for detecting corruption in the database. …
10 Most Common Worst Practices or Mistakes with SQL Servers Ignoring Regular Backups: Failing to schedule regular backups is a critical mistake. Without proper backups, data loss is inevitable in the event of hardware failure, corruption, or a ransomware attack. Not Monitoring the SQL Server: Many administrators neglect to implement monitoring and alerting systems. Without proper monitoring, performance issues and …
10 Most Common Worst Practices or Mistakes with SQL Servers Read more »