MS SQL Server

Analysis Services is used to analyze huge amounts of data and apply to business decisions. It is also used to create two or multidimensional business models. In SQL Server 2000…

Integration Services is used to carry out ETL (Extraction, Transform and Load data) and admin operations. The BIDS (Business Intelligence Studio till 2008 R2) and SSDT (SQL Server Data Tools…

Execution plans will be generated by Query optimizer with the help of statistics and Algebrizer\processor tree. It is the result of Query optimizer and tells how to do\perform your work\requirement.…

In this topic, we will learn about Reporting Services in MS SQL Server. Report is a displayable component. Usage The report is basically used for two purposes - Company Internal Operations…

HA Technologies(High Availability) is the solution\process\technology to make the application\database available 24x7 under either planned or un-planned outages. Mainly, there are five options in MS SQL Server to achieve\setup high…

MS SQL Server provides the following two services which are mandatory for databases creation and maintenance. Other add-on services available for different purposes are also listed. SQL ServerSQL Server Agent…

Monitoring refers to checking database status, settings which can be the owner’s name, file names, file sizes, backup schedules, etc. SQL Server databases can be monitored mainly through SQL Server…

Assign Permissions refer to the rules governing the levels of access that principals have to securable. You can grant, revoke and deny permissions in MS SQL Server. To assign permissions either…

In this topic, we will discuss about Create Users in MS SQL Server. User refers to an account in the MS SQL Server database which is used to access the…

Restoring Databases is the process of copying data from a backup and applying logged transactions to the data. Restore is what you do with backups. Take the backup file and turn…