-
SQL DBA Cheatcode : 15 Things about SQL Server Error logs
Today I am writing about some good facts about SQL Server Error logs. SQL Server maintains its own error logs that contain messages describing informational and error events. “Error logs” is just the name but it contains warnings, error, information messages. 1. How to View SQL Server Error Log file location EXEC xp_readerrorlog 0,1,”Logging…
-
Series : SQL DBA Cheatcode
SQL DBA Cheatcode is a series or you can say a collection of those SQL Server scripts which we find very useful while troubleshooting issues day to day. These scripts are trusted and tested however there are some chances that a script may not work with some versions of SQL Server. SN Date Topic Part…
-
Common Human Errors as DBA (Part 3)
In continuation of the series of “Common Human Errors as DBA” – here I am posting Third Part of it. You may check others here. Part 1 & Part 2 Poor naming standards & Lack of documentation: This is a common mistake (not human error) that frequently happens. From the very beginning, a DBA…
-
Common Human Errors as DBA (part 2)
You must have read my previous post (Part-1) about Common Human Errors as DBA and how to avoid them. Here is another post of the same series. Third error – Data or Log file Shrinking – sometimes, one may not be checking how much free space is available in data or log files and shrinking databases…