Introducing – Live SQL Discussion with Stedman Solutions We are thrilled to share the exciting news that our team will now be hosting weekly live streams! This means you can look forward to regular, engaging broadcasts and get your SQL Server questions answered from us on a consistent basis. We can’t wait to connect with you in real-time and bring …
Hello SQL Server enthusiasts, Throughout my SQL Server journey, I’ve come to appreciate the critical role that data aggregation plays in extracting meaningful insights from data. With this in mind, I have created a course on Teachable called “Aggregating Data in Your SQL Queries.” https://stedman.us/aggregation I’m eager to share some of the compelling benefits that this course offers and explain …
SQL School: Master the Art of Data Aggregation with SQL Server Read more »
The CHECK_POLICY option is a security feature in SQL Server that is used to enforce password policy settings for SQL authenticated logins. When CHECK_POLICY is set to ON, SQL Server will check the password for a login against the password policy defined in the operating system. This can help ensure that passwords used for SQL authenticated logins are strong and …
Securing SQL Server: CHECK_POLICY for SQL Server logins 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 …
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 DBREINDEX is a has been announced to be deprecated for more than 10 years ago, meaning it may disappear in future versions of SQL Server. DBCC DBREINDEX is a database console command (DBCC) in Microsoft SQL Server that can be used to rebuild the indexes of a database. DBCC DBReIndex has been deprecated meaning that Microsoft has announced that …
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 …
Database corruption in Microsoft SQL Server can present serious challenges, causing data loss, disruption of services, and potential impact on business operations. Understanding the causes, symptoms, and potential solutions for such corruption is essential for any database administrator looking to maintain the integrity and reliability of their SQL Server environment.. NOLOCK is a query hint in SQL Server that allows …
Keeping your SQL Server up-to-date with the latest patches and updates is an important part of maintaining the security and stability of your system. Here are a few reasons why it is important to keep your SQL Server up-to-date: * Security vulnerabilities: Software is often developed with certain vulnerabilities that can be exploited by hackers. These vulnerabilities are often discovered …
DBCC TRACESTATUS is a database console command (DBCC) in Microsoft SQL Server that can be used to display the status of a trace flag, which is a special setting that can be used to enable or disable specific behaviors in the database engine. Trace flags can be useful for troubleshooting issues or for testing the effects of different behaviors on …