Month: <span>October 2017</span>

SQL DBA Regular Alerts & Tickets (Service Request and Incident)

by Sanjay Humania

Customer Raised Tickets 1) Unable to connect to SQL Server 2) Unable to access a database 3) Unable to identify…

SQL DBA Important & Handy Commands

by Sanjay Humania

Space Management: 1)sp_spaceused 2)dbcc sqlperf(logspace) 3)xp_fixeddrives Information Commands: 1) sp_helpdb 2) select db_id(‘DBName’) 3) select db_name(DBID) 4) select * from…

SQL DBA Checklist/Activities

by Sanjay Humania