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.
SQL SERVER – Comparison Index Fragmentation, Index De-Fragmentation, Index Rebuild – SQL SERVER 2000 and SQL SERVER 2005
What is Index Fragmentation and how do page splits cause it? How to measure it with DBCC SHOWCONTIG in SQL Server 2000 and sys.dm_db_index_physical_stats in 2005.
SQL SERVER – Explanation and Comparison of NULLIF and ISNULL
NULLIF returns NULL when two expressions are equal and the first one when they are not. Here is how it compares with ISNULL and the matching CASE expression.
A Simple Dashboard From DMVs
A dashboard from DMVs can show live requests, database state, waits, and backups when its queries refresh without adding load.