SQL Server – Database Mirroring for Disaster-Recovery Solution

What is Database Mirroring? Database mirroring is a solution for increasing the availability of a SQL Server database. But it has been gained popularity as a disaster-recovery option. How Database Mirroring Working. The principle server sends the active transaction log record to the mirrored server. The mirrored server applies the transaction log record one by one in sequence. Prerequisites The two partners, that is the principal server and mirror server, must be running the same edition of SQL Server. The

» Read more

SQL Server 2012 – Installation of SSRS Reporting Services Native Mode Report Server (SSRS)

You will get the step by step tutorial to install the SQL Server with Full or Partial features. Many time people are looking specific feature that we need to install for Reporting service Native Mode Report Server. So the purpose if this post is give idea of feature required for SQL Server Reporting Service Installation as shown in given snapshot:

» Read more

Reviewer – Reporting with Microsoft SQL Server 2012

I pleased to announce that Reporting with Microsoft SQL Server 2012 has been published. Officially, I have reviewed this book. I would like to request you all to read this book and provide your valuable feedback on the content. Click here for more detail about Reporting with Microsoft SQL Server 2012

» Read more

SQL Server – Understanding of SQL Server Role and Database Role

SQL Server supports the two authentication mode as Windows authentication mode and Mixed authentication mode. Once the user is authenticated, SQL server will allow access to the user based on the permission that user has. All the user permissions are based on Server Role and Database Role. So let try to user understand the meaning of each server role and database role. Server Role: Role Name Permission user can have bulkadmin Can run the BULK INSERT statement. dbcreator Can create,

» Read more

SQL Server 2012 – Get Backup History of the database

The msdb database is system database used by SQL Server Agent for scheduling alerts and jobs. msdb.dbo.backupset – Contain the information concerning the most-granular details of the backup process msdb.dbo.backupmediafamily – Contains the metadata for the physical backup files as they relate to backup sets Using the above mentioned tables, we will find the backup history of database Script: SELECT s.database_name, m.physical_device_name, CAST(CAST(s.backup_size / 1000000 AS INT) AS VARCHAR(14)) + ' ' + 'MB' AS Backup_Size, CAST(DATEDIFF(second, s.backup_start_date,s.backup_finish_date) AS VARCHAR(4))

» Read more

SQL Server – Migrate/Transfer Maintenance Plan from one Instance to another

There are very few simple steps to migrate/ transfer the maintenance plan from one SQL Server instance to another. Maintenance Plan is nothing but SSIS package which SQL Server creates and deploys it under MSDB Database. I have created one maintenance plan to for the demonstration; you may migrate/ transfer as many you have with the same steps (as shown in the below image). Now connect to SQL Server Integration Services and Navigate to Stored Packages >>MSDB >> Maintenance Plans

» Read more

SQL Server – Integration Services – Access is denied

If you are facing the access denied error while connecting to Integration Services as shown below : Error detail: Connecting to the Integration Services service on the computer “ComputerName” failed with the following error:  “Access is denied.” (shown in given image) Connect the SQL Server Management Studio with “Run as administrator” option. After that you will able to connect SQL Server Integration Services Service.

» Read more

Schedule Automatic Backup in SQL Server 2012 – Part2

In the previous post, we have scheduled automatic backup in SQL Server 2012 – Part1. As we have scheduled daily backup of database and backup file will be generated every day. It is a good practice that to delete backup files after a certain period of time as per requirement. Now we will add the Maintenance Clean Up Task along with the Back Up Database Task. Configure Clean Up Task From the Maintenance Plan Tasks tool box pane in the left

» Read more

Schedule Automatic Backup in SQL Server 2012 – Part1

You know it is very important to back up your SQL server database backup on the regular basis. So in this post, we will see how to schedule automatic backup in SQL server 2012. We will go step by step to schedule so that we all can understand each and every step clearly. Before scheduling automatic backup we have make sure the following two points: User should have the SYSADMIN privileges to schedule automatic backup. SQL Server Agent service should

» Read more

Audit columns – Created by and Updated By

I have seen two database designs to store the value in Created by and Updated By columns as: Store the PK of user in Created by and Updated By columns Store the user name in Created by and Updated By columns Now you may have question: What is best practice to store the value in the Created by and Updated By columns and why? My opinion is PK of user (user id) is preferred over user name. There are various

» Read more

Reviewer – SQL Server 2012 Reporting Services Blueprints

    I pleased to announce that SQL Server 2012 Reporting Services Blueprints has been published. Officially, I have reviewed this book. I would like to request you all to read this book and provide your valuable feedback on the content. Click here for more detail about “SQL Server 2012 Reporting Services Blueprints”

» Read more

8 Steps of Successful Data Migration

Data migration is the process of transferring data between storage types, formats, or computer systems. But here we are specifically talking about database (i.e. Sybase, MySQL, DB2, SQL Server and Oracle) migration. Data migration is usually performed programmatically to achieve an automated migration. Most of the times when we change the software system and implement a new database or change the database vendor then we will need to migrate the data from an existing database to a new database in

» Read more
1 2 3 4 12