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… Read More »SQL School: Master the Art of Data Aggregation with SQL Server
Subtitled: the SQL Server password policy query. The CHECK_POLICY option is a security feature in SQL Server that is used to enforce password policy settings… Read More »Securing SQL Server: CHECK_POLICY for SQL Server logins
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… Read More »Database Health: Untrusted Foreign Keys
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… Read More »Daily Server Monitoring – SQL Versions for June
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… Read More »SQL Server DBCC Commands: DBCC DBREINDEX
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.… Read More »SQL Server Wait Type: PREEMPTIVE_OS_MOVEFILE
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,… Read More »SQL Server Corruption: NOLOCK and Corruption
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… Read More »Securing SQL Server: Patching your SQL Server
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… Read More »SQL Server DBCC Commands: DBCC TRACESTATUS
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.… Read More »SQL Server Wait Type: PAGELATCH_UP