Use PWDCOMPARE() to Find SQL Logins With Weak Passwords
SQL Server ships with an internal system function, PWDCOMPARE(), that we can use to find SQL logins with weak passwords.
SQL Server 2017
Yes, SQL Server Standard Edition is NUMA Aware
The official documentation suggests that SQL Server Standard edition is not NUMA aware due to Standard having limits on the amount of hardware available.
The Cause of Every Deadlock in SQL Server
Deadlocks are the result of application code combined with a database schema that results in an access pattern that leads to a cyclical dependency.
Adding Python Packages to SQL Server 2017
SQL Server 2017 allows for the use of Python scripts called as an external script. SQL Server comes with some Python packages by default. Today I wanted to talk about adding Python packages to SQL Server 2017. To get started with Python in SQL Server 2017 we must enable the use of external scripts. … Read more
Using DATABASEPROPERTYEX to Find Last Good DBCC CHECKDB Time
For decades, a pain point for SQL Server administrators has been determining when the last known DBCC CHECKDB was run against a database.
Analyzing Stack Overflow Data Directly and with PowerBI
It’s easy to get started analyzing Stack Overflow Data. You can query the database directly or import the data into PowerBI.
