SQL DBA Regular Alerts & Tickets (Service Request and Incident)
Customer Raised Tickets Unable to connect to SQL Server Unable to access a database Unable to identify a table Want to run a script, but need DBA assistance Queries are…
Read FullYear: 2017
Important & Handy TSQL Commands
Space Management TSQL Commands 1)sp_spaceused2)dbcc sqlperf(logspace)3)xp_fixeddrives Information TSQL Commands 1) sp_helpdb2) select db_id('DBName')3) select db_name(DBID)4) select * from sys.dm_exec_sessions, dm_exec_connections5) select * from sys.databases6) select * from sys.database_files Monitoring TSQL…
Read Full
SQL Server Log shipping
What is LOG SHIPPING in SQL Server DBA? Log shipping: Shipping of transaction log files from the primary server database to second server database to get both database in continuous…
Read Full
SQL Server Upgradation
What is SQL Server UPGRADATION? Upgrading means, migrating sql server old version to sql server 2012. Before upgradation we need to run upgrade advisor tool. Microsoft sql server 2012 upgrade…
Read Full
SQL Server Migration
Migration means moving one (or) set of databases from one server to another server. SQL Server Migration Scenarios Scenario 1: As a part of launch, deployment in the production server…
Read FullSQL Server Automation
Automation refers to scheduling the regular maintenance tasks. Whenever schedule time comes automatically that task will be executed. DBA regular activities can be automated we can get the status f…
Read FullSQL Server Security
Security is the most important tasks for a DBA. we need control the access to sql server as well as provide security to the datal. Levels of SQL Server Security…
Read Full
SQL Server Restoration Tutorial
Restoration is a process of using backups to recover the exist database (or) to create a new database in another server. Situations for Restoration Planned restoration Unplanned (or) Accidental restoration…
Read Full
SQL Server Backups
Backup means, saving the exact copy of the current version of database in some other location. Situations where backup can use Hardware (or) software failure Natural disasters Internal misuse Hardware…
Read FullSQL Server Databases
Database: Database is a container which stores data and data objects. It manages data and allows fast storage and retrieval of that data. Types of Databases in SQL Server: There…
Read Full