PNG
IHDR
PNG IHDR
💡 Day 10 of 365 – SQL Server Authentication Modes Security starts with authentication. SQL Server supports two main modes: 🔹 Windows Authentication Uses Active Directory accounts Centralized password management Strong security with Kerberos Recommended for production environments 🔹 SQL Server Authentication Uses SQL logins with usernames and passwords Independent of Windows accounts Useful for legacy applications or cross-platform connections 💡 Tip: Always prefer Windows Authentication when possible. If SQL Authentication is required, enforce strong passwords and expiration policies. Fellow DBAs: Which authentication mode do you mostly use in production, and why? #SQLServer #SQLDBA #DatabaseAdministrator #Security #AzureSQL #DBATips
💡 Day 9 of 365 – SQL Server Error Logs: Your First Troubleshooting Tool As a SQL Server DBA, the error logs are your first line of defense when troubleshooting issues. They contain valuable information about: 🔹 Service startup and shutdown events 🔹 Backup and restore operations 🔹 Job failures (via SQL Server Agent) 🔹 Hardware or connectivity errors 🔹 Security and login failures 💡 Tip: Use the built-in function to read error logs quickly: EXEC xp_readerrorlog 0, 1, N'error'; This lets you filter and identify critical errors efficiently. Pro DBAs always check the error logs before running scripts—it can save hours of troubleshooting. 👉 Quick question for DBAs: Do you archive error logs regularly in your environment? #SQLServer #SQLDBA #DatabaseAdministrator #Troubleshooting #AzureSQL #DBATips
