A SQL Server disaster is an event that causes data loss or any serious SQL Server disruption. Causes of a disaster can be numerous: power failure, hardware failure, virus attack, natural disaster, human error, etc. Some SQL Server disasters cannot be prevented. That’s why a good disaster recovery plan is important
A SQL Server disaster recovery plan (DRP) is a process to have SQL Server up and running, and to overcome data loss after a disaster. A disaster recovery plan must be planned and documented in order to prevent catastrophic data loss and incidents.
T-SQL (Transact-SQL) is an extension of SQL language. SQL is a structure query language which is a common database language for all RDBMS products. Different RDBMS product vendors have developed their own database language by extending SQL for their own RDBMS products.T-SQL stands for Transact Structure Query Language which is a Microsoft product and is an extension of SQL Language.
Database tuning can be an incredibly difficult task, particularly when working with large-scale data where even the most minor change can have a dramatic (positive or negative) impact on performance.In mid-sized and large companies, most SQL database tuning will be handled by a Database Administrator (DBA). When working with large-scale data, even the most minor change can have a dramatic impact on performance.
Database Optimization : The MS SQL Server Management Studio has a couple of functions. It enables you to manage your SQL Database with ease from your computer one of the functions being to optimize SQL databases. To properly optimize MS SQL Server, you need to know how optimization works. This will have a great positive impact on your decision making. Creating an efficient index is one of the best ways of upping the queries performance. If you have a well-constructed index, the query will be not need to scan the whole table unnecessarily to get results.
Database security refers to the collective measures used to protect and secure a database or database management software from illegitimate use and malicious threats and attacks.It is a broad term that includes a multitude of processes, tools and methodologies that ensure security within a database environment. Database security covers and enforces security on all aspects and components of databases. Database security is generally planned, implemented and maintained by a database administrator and or other information security professional.
SQL Server Profiler is an interface to create and manage traces and analyze and replay trace results. Events are saved in a trace file that can later be analyzed or used to replay a specific series of steps when trying to diagnose a problem. Microsoft SQL Server Profiler is a graphical user interface to SQL Trace for monitoring an instance of the Database Engine or Analysis Services. You can capture and save data about each event to a file or table to analyze later.
For example you can monitor a production environment to see which stored procedures are affecting performance by executing too slowly.
SQL Server Agent is a Microsoft Windows service that executes scheduled administrative tasks. SQL Server Agent uses SQL Server to store job information. Jobs contain one or more job steps. Each step contains its own task, for example, backing up a database. if you want to back up all the company servers every weekday after hours, you can automate this task. Schedule the backup to run after 22:00 Monday through Friday; if the backup encounters a problem, SQL Server Agent can record the event and notify you.
Maintenance plans create a workflow of the tasks required to make sure that your database is optimized, regularly backed up, and free of inconsistencies. The Maintenance Plan Wizard also creates core maintenance plans, but creating plans manually gives you much more flexibility. Maintenance plans can be run manually or automatically at scheduled intervals.