Category: SQL-Server 2012

SQL Server – Enable SQL Server 2012 AlwaysOn Availability Groups

SQL, SQL-Advanced, SQL-Server 2012, Varinder Sandhu

In the previous post  SQL Server – AlwaysOn Availability Groups, described enhancement to SQL Server 2014 AlwaysOn Availability Groups. In this post, we will see how to enable SQL Server 2012 AlwaysOn Availability Groups using UI and PowerShell. Using UI Go to SQL Server Configuration Manager >> Navigate to SQL Server Service >> Right Click to SQL Server Service and Click to Properties Navigate to AlwaysOn High Availability tab >> Check the “Enable AlwaysOn Availability Groups ” check Box Using

» Read more
, , ,

SQL Server – Unattended Installation of SQL Server 2012 Using Command Line

SQL, SQL-Advanced, SQL-Server 2012, SQL-Tips and Tricks, Varinder Sandhu

Many times we face a requirement to perform the unattended installation of SQL Server. In this post we will see the steps to perform the unattended installation of SQL Server 2012 using command line. There are two ways to install the unattended installation of SQL Server 2012 using command line. Specify each required parameter , you may take the parameter help Setup.exe /ACTION=Install /FEATURES=SQL /InstanceID=… /IACCEPTSQLSERVERLICENSETERMS /INDICATEPROGRESS Specify Configuration file that contains all the parameter require for installation : Setup.exe

» Read more
, ,

SQL Server – AlwaysOn Availability Groups

SQL, SQL-Advanced, SQL-Server 2012, Varinder Sandhu

Introduction Microsoft introduced the AlwaysOn Availability Groups which is a high-availability and disaster-recovery solution that provides an enterprise-level solution in SQL Server 2012. Using Database Mirroring for local high availability and combining it with Log Shipping for a disaster recovery solution is popular deployment architecture prior to SQL Server 2012. With SQL Server 2012, the Database Mirroring and Log Shipping solution can be replaced with an Availability Group solution with multiple secondaries. AlwaysOn Availability Groups – Deployment Architecture The whitepaper

» Read more
, ,

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

SQL, SQL-Reporting Services, SQL-Server 2012, Varinder Sandhu

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

SQL, SQL-Reporting Services, SQL-Server 2012, Varinder Sandhu

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, SQL-Advanced, SQL-General, SQL-Server 2012, SQL-Tips and Tricks

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

SQL, SQL-Advanced, SQL-Backup & Restore, SQL-Server 2012, Varinder Sandhu

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 – Integration Services – Access is denied

SQL, SQL-Server 2012, SQL-SSIS, Varinder Sandhu

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

SQL, SQL-Advanced, SQL-Backup & Restore, SQL-Server 2012, Varinder Sandhu

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

SQL, SQL-Advanced, SQL-Backup & Restore, SQL-Server 2012, Varinder Sandhu

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
, , ,

Reviewer – SQL Server 2012 Reporting Services Blueprints

Others, SQL, SQL-Reporting Services, SQL-Server 2012, Varinder Sandhu

    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
, , ,

SQL Server – Download SQL Server 2012 – Evaluation

SQL, SQL-Server 2012, Varinder Sandhu

Microsoft SQL Server 2012 enables a cloud-ready information platform that will help organizations unlock breakthrough insights across the organization as well as quickly build solutions and extend data across on-premises and public cloud backed by capabilities for mission critical confidence. Deliver required uptime and data protection with AlwaysOn Gain breakthrough & predictable performance with ColumnStore Index Help enable security and compliance with new User-defined Roles and Default Schema for Groups Enable rapid data discovery for deeper insights across the organization

» Read more
,
1 2