Year: <span>2017</span>

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

by Our Tech Ideas

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 Our Tech Ideas

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 Our Tech Ideas

14. Log shipping

by Our Tech Ideas

13. SQL Server Upgradation

by Our Tech Ideas

A Guide to SQL Server Migration

by Our Tech Ideas

SQL Server Automation Tutorial

by Our Tech Ideas

10. SQL Server Security

by Our Tech Ideas

9. SQL Server Restoration Tutorial

by Our Tech Ideas

8. SQL Server BACKUPS

by Our Tech Ideas

7. SQL Server Databases

by Our Tech Ideas

6. SQL Server installation

by Our Tech Ideas

SQL Server Database Architecture

by Our Tech Ideas

SQL Server Storage Architecture

by Our Tech Ideas

SQL Server Architecture

by Our Tech Ideas

SQL Server Database Administration

by Our Tech Ideas