Securing SQL Server Against Ransomware: The Role of Immutable Backups Securing SQL Server Against Ransomware: The Role of Immutable Backups In the digital age, data is arguably an organization’s most valuable asset. For those of us who have been in the trenches with SQL Server since the early ’90s, the evolution of data management and security has been both fascinating …
In SQL Server, you can create logins using Windows local groups as a way to manage access to the database server. This means that you can add users to a Windows local group and then create a SQL Server login using that group. The users who are members of the group will then be able to connect to the database …
Securing SQL Server: Windows Local Groups as SQL Logins Read more »
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 April Read more »
SQL Server’s DBCC IND command is an undocumented database console command that is used to display the allocation and deallocation status of the data pages in a table or index. This command is not officially supported by Microsoft and is not intended for general use. To use the DBCC IND command, you must first connect to your SQL Server instance …
Welcome to April at Stedman Solutions, LLC! This month, we’re excited to announce that April is JOINS month, where all our promotions and activities will revolve around the fundamental concept of JOINs in SQL Server. Whether you’re a seasoned SQL professional or just starting out on your database journey, this is the perfect time to dive deeper into the power …
Welcome to April at Stedman Solutions, LLC! This month, we’re excited to announce that April is JOINS month, where all our promotions and activities will revolve around the fundamental concept of JOINs in SQL Server. Whether you’re a seasoned SQL professional or just starting out on your database journey, this is the perfect time to dive deeper into the power …
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 …
Celebrating World Backup Day with Stedman’s SQL School: Unlock the Secrets of Efficient Backup and Recovery As we mark World Backup Day on March 31st, it’s a timely reminder of the critical importance of data backups in our increasingly digital world. In the realm of database management, particularly with SQL Server, the significance of having a reliable backup and recovery …
Celebrating World Backup Day with Stedman’s SQL School Read more »
In SQL Server, the DBCC CHECKDB command is a critical tool for ensuring the integrity of your databases. It performs checks on the logical and physical integrity of all the objects in the specified database. Using DBCC CHECKDB with different options can tailor the scope and performance impact of these integrity checks. DBCC CHECKDB with No Options Running DBCC CHECKDB …
Embrace Efficiency and Growth: The Integrated Power of Managed Services In today’s fast-evolving business landscape, organizations are constantly seeking ways to optimize their operations, scale efficiently, and ensure the robust management of their critical IT infrastructure. Stedman Solutions offers a suite of Managed Services designed to address these core needs, emphasizing the essential role of expert database administration in achieving …
Embrace Efficiency and Growth: The Integrated Power of Managed Services Read more »