Monthly Archives: April 2017

Using the SQL Server Profiler


These SQL Server Profiler event classes can be used to help you find out if SQL Server is running as efficiently as it can. They include: Execution Warnings: For very busy servers, it is possible that a query may have … Continue reading

Aside | Posted on by | Leave a comment

Windows Administrator Skills


Windows OS & AD Incident/Production Management Network and VPN trouble shooting activities Printer troubleshooting and management Perform customer catalog and windows updates periodically Upgrade software on a variety of hosted products Installing, Configuring and Hardening of Windows 2008/2012 R2 Servers … Continue reading

Aside | Posted on by | Leave a comment

Task for MSSQL Server DBA


DAILY CHECKLIST Check the previous night’s SQL Server database and transaction log backups and SQL Server Agent jobs for errors. Check all databases to make sure all are up and not marked as suspect.Check previous night’s DBCC CHECKDB for errors. … Continue reading

Aside | Posted on by | Leave a comment

Day-to-Day Tasks of the Average DBA


DBAs (Database Administrators) perform many different tasks, and one way to explain what a DBA is, is to describe the kinds of tasks they perform on a regular basis. The following lists some of the most common tasks performed by … Continue reading

Aside | Posted on by | Leave a comment