Notes from my database architecture meeting in New York and New Jersey: backup routines, index optimization and the maintenance tasks we discussed.
Why SQL Server Has Cumulative Updates, Not Service Packs
Understand why SQL Server uses Cumulative Updates instead of service packs, what each CU contains, and how to plan a reliable patch cycle.
Index Maintenance on Modern Storage
Index maintenance on modern storage needs query evidence, page density, and statistics checks before you choose a rebuild or lighter action.
SQLAuthority News – Birthday of SQL Authority Author
Today is the birthday of the SQL Authority Author, and my thought of the day is a simple one that I truly believe: family is everything.
Grouping Current Connections by Program Name and Host Name
Group connections by program name, host, and login, then inspect client addresses and idle sessions without trusting client labels blindly.
SQLAuthority News – SQL Blog SQLAuthority.com Comment by Mr. Ben Forta
Ben Forta, author of Sams Teach Yourself SQL Server T-SQL in 10 Minutes, wrote about SQLAuthority.com on his blog. Here is what he said and why it means a lot to me.
Keeping an Inventory of Every SQL Server You Own
Build an Inventory of Every SQL Server you own, including hidden instances, owners, versions, recovery details, and a process to keep it current.