On August 30, 2008 I presented a technical session at the Microsoft Student Partner conference in my city, and I explain what the MSP program offers students.
SQLAuthority News – 4 Million Visits – over 675 SQL Server Articles
Thank you to every reader: this blog has reached 4 Million Visits and over 675 SQL Server articles, and I was awarded SQL MVP along the way.
Spotting Agent Jobs That Run Longer Than Usual
Spot Agent jobs that run longer than usual by decoding msdb duration, comparing recent runs, and checking jobs still active now.
Finding the Client IP Address of a Connection
Find the client IP address of a SQL Server connection with DMVs and CONNECTIONPROPERTY, and understand proxy and local transport limits.
Generating Backup Commands for Every Database With STRING_AGG
Use STRING_AGG for generating backup commands with copy-only backups, checksums, safe database names, and dated files for careful review.
Choosing Where to Put Data and Log Files
Choosing where data and log files live means checking storage behavior, capacity, install defaults, and a tested move procedure.
Checking Which Accounts the SQL Server Services Run As
Inventory SQL Server services and their accounts, compare virtual and managed identities, and verify permissions after a change.