Month: May 2023

By Posted on Posted in Corruption, Ransomware No Comments Tagged with , , ,

Having a SQL assessment is important in terms of security for several reasons: Identifying vulnerabilities: A SQL assessment can help identify security vulnerabilities in the database. This includes identifying weak passwords, inadequate user access controls, and other security weaknesses unknown to the organization that can leave the database vulnerable to attacks. Preventing attacks: Addressing security vulnerabilities proactively can help prevent …

Why Having a SQL Assessment is Crucial for Ensuring Database Security Read more »

By Posted on Posted in Performance No Comments

I have used my over 30 years of SQL Server experience to personally curate my favorite performance tuning tips and tricks into this training. I am excited to contribute and share with the SQL Server community some of my favorite solutions. Become part of this exclusive group of subscribers learning to put the horse power back into their SQL Server. …

Exclusive SQL Performance Tuning Training Read more »

By Posted on Posted in Database Health No Comments

Today I released version 1015 of Database Health Monitor. This is the May 2023 release of the product. Here is a list of some of the features and updates in the latest release. You can download the latest version at http://DatabaseHealth.com/download2. May 2023 – Version 1015 Release Notes New Features Bug Fixes Here is a big of an overview on …

Database Health Monitor May 2023 Release Read more »

By Posted on Posted in Performance No Comments

DBCC CHECKDB is a command in SQL Server that is used to check the integrity of a database. It performs a thorough analysis of all the objects in a database, including tables, indexes, and foreign keys, to ensure that they are structurally sound and do not have any corruption or inconsistencies.One of the main benefits of using DBCC CHECKDB is …

SQL Server DBCC Commands: DBCC CHECKDB Read more »

By Posted on Posted in Performance No Comments

DBCC USEROPTIONS is a database console command (DBCC) in Microsoft SQL Server that can be used to view the current session-level settings for a user connection. Viewing the session-level settings can be useful for troubleshooting issues with a user connection or for understanding the behavior of the database engine. To use DBCC USEROPTIONS, you must specify the session ID of …

SQL Server DBCC Commands: DBCC USEROPTIONS Read more »

By Posted on Posted in Performance No Comments

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 …

Daily Server Monitoring – SQL Versions for May Read more »

By Posted on Posted in Performance No Comments

The Scan For Startup Procs feature in SQL Server allows you to specify a list of stored procedures that will be automatically executed whenever the database engine starts. This can be useful in certain scenarios, such as when you want to perform tasks such as restoring a database or performing maintenance tasks when the database engine starts. “Scan for startup …

Securing SQL Server: Scan for Startup Procs Read more »

By Posted on Posted in Performance No Comments

Determining when corruption was introduced into a SQL Server database can be challenging, as corruption can occur without generating any obvious symptoms. However, there are some steps you can take to help determine when corruption was introduced: * Check when the last good CheckDB was run. This won’t tell you when the corruption started, but it will tell you the …

SQL Server Corruption: When Did It Happen Read more »

By Posted on Posted in Performance No Comments Tagged with ,

As a business owner or IT professional, you know your SQL Server is critical to the success of your organization. It’s essential to ensure your SQL Server is running smoothly and your data is protected against data corruption and other issues. One of the most critical steps you can take to protect your data is to run regular CheckDB on …

The Importance of Running CheckDB on SQL Server  Read more »