Understand a SQL Server cumulative update, identify your build and servicing branch, and read fixes and known issues before planning a patch.
SQL SERVER – Find Row Count in Table – Find Largest Table in Database – Part 2
An improved script to find row count in table for every table and spot the largest table in the database, now with the schema name, thanks to Ameena.
Tagging With a Many-to-Many Table: Storing and Querying Hashtags
Store hashtags in a tag and bridge table, normalize input, query any or all requested tags, and count weekly trends without scans.
SQL SERVER – Introduction to BINARY_CHECKSUM and Working Example
BINARY_CHECKSUM helps detect changes in a row. My working example shows how it works and why it misses a value changed from A to B and back to A.
SQL Tips – 5 SQL Server Best Practices
5 SQL Server Best Practices worth a quick check, starting with backing up the master database and testing it, and rebuilding indexes online to cut downtime.
A Monthly Health Check You Can Run in Ten Minutes
Run a SQL Server health check that reviews backups, integrity-check evidence, file growth, users, build level, and space without guessing health.
SQLAuthority News – Meeting Bryan Oliver and Learning Wisdom of Life
I met Bryan Oliver of Solid Quality Mentors expecting a proud expert, and found an extremely friendly and knowledgeable person. Some wisdom I learned from him.