Configure Agent alerts for serious severities and errors 823, 824 and 825, connect an operator to Database Mail, and test response delays.
SQL SERVER – How to Find Weak Passwords Using T-SQL?
After a hacker got in through the sysadmin account, a reader asked for help. Here is how to find weak passwords for SQL logins using T-SQL.
Interview Question of the Week #003 – How to Write Script for Database Cursor?
Write a database cursor with LOCAL FAST_FORWARD, understand cleanup and fetch status, and compare the loop with a set-based update.
SQL SERVER – Watching Table Variable Data in TempDB
Are table variables only in memory? I watch table variable data in TempDB to answer a reader’s questions on where it is stored and if it is logged.
Cost Threshold for Parallelism and MAXDOP: Setting Both Together
Review cost threshold for parallelism with MAXDOP, inspect NUMA layout and settings, then measure plans and waits after changes.
SQL SERVER – The Easy Functions of SQL Server – Notes from the Field #062
Kathi Kellenberger, the SQL author who got me hooked early in my career, explains some easy functions of SQL Server that many experts still do not know.
SQL SERVER – How to Increase Number of Errorlog Files
An audit needed 30 days of ERRORLOG, but a nightly recycle job kept only a few files. Here is how to increase the number of errorlog files in SQL Server.