-->
Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Ganapathi's MSSQLLover

Ganapathi Varma is an MCP Lead Database Administrator and Blogger. He works as Lead SQL Server DBA for CtrlS Datacenters pvt ltd, Asia's only Tier 4 datacenter. He is responsible for managing thousands of SQL instances providing database managed services, High Availability and Disaster Recovery. Other than SQL Server, he is also expertised in different datacenter technologies. He is the owner of MSSQLLover blog and he is fully dedicated to the SQL Server community. You can also visit the mssqllover fb page for more SQL blogs and follow FB group: SQLHyderabad.

TempDB Database On a Local Disk for an FCI


Link Below:


TempDB Database On a Local Disk for an FCI


This article will be helpful in configuring TempDB on a local Disk instead of shared storage in SQL Server 2012/2014. This will reduce the I/O requests from the shared storage and overall it can improve performance.

Read more

0 comments, 83 reads

Posted in Ganapathi's MSSQLLover on 23 March 2017

Backup and Restore Strategies in SQL Server : A Brief Introduction

Establishment of a successful business requires the proper maintenance of the data. SQL Server is one the popular platform for the same. In SQL Server, a proper strategy has been introduced for the management of data. The Main reason of introducing SQL Server backups and restore strategies in SQL Server…

Read more

1 comments, 130 reads

Posted in Ganapathi's MSSQLLover on 20 March 2017

Webinar: Performance Troubleshooting Using Wait Statistics by Paul Randal



Hi Folks, 

Join Webinar on Webinar: Performance Troubleshooting Using Wait Statistics. Tue 3/07/2017 from 10:30 PM to 11:45 PM IST

Click [Here] to join



Read more

0 comments, 143 reads

Posted in Ganapathi's MSSQLLover on 7 March 2017

Step By Step Logshipping configuration


Log shipping provides a means to maintain a secondary server on an automated basis
using a chain of transaction log backups. This chapter explains the basic confi guration of
log shipping along with considerations for configuring the failover and failback within a log
shipping environment.

In this article, I will…

Read more

2 comments, 224 reads

Posted in Ganapathi's MSSQLLover on 2 March 2017

Everything on Always on Availability Groups series




Step By Step configuring Windows 2012 R2 fail over cluster How to setup windows cluster for Always on Availability Groups

AlwaysOn Availability Groups: Step by Step Setup Step by Step procedure to setup Always on Availability Groups

Read more

0 comments, 122 reads

Posted in Ganapathi's MSSQLLover on 1 March 2017

Step By Step configring Windows 2012 R2 fail over cluster



One of my client requirement is to install Always on availability groups for SQL databases. You don't require shared storage to setup Always on availability. it can be configured in local disks.
AlwaysOn Availability Groups rely on the Windows Server Failover Cluster for failure detection and management of the Availability…

Read more

0 comments, 168 reads

Posted in Ganapathi's MSSQLLover on 1 March 2017

Webinar- SQL Server 2016 - Always Encrypted / Security


Join Webinar on SQL Server 2016 - Always Encrypted / Security. Thu 2/23/2017 from 12 PM to 1 PM

SQL Server has had ways to encrypt data in the past - for example, Transparent Data Encryption (TDE). This technology protects the data at rest and when the database files or backups are…

Read more

1 comments, 198 reads

Posted in Ganapathi's MSSQLLover on 23 February 2017

AlwaysOn Availability Groups: Step by Step Setup



An availability group supports a failover environment for a discrete set of user databases, known as availability databases, that fail over together. An availability group supports a set of primary databases and one to eight sets of corresponding secondary databases. Secondary databases are not backups. Continue to back up your…

Read more

0 comments, 453 reads

Posted in Ganapathi's MSSQLLover on 20 February 2017

vCenter Server fails to start, Purge and Shrink Vcenter SQL Database


One of my client vCenter Server fails to start as below shown error in event logs.
Could not allocate space for object 'dbo.VPX_EVENT'.'VPXI_EVENT_USERNAME' in database 'VCDB' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup,…

Read more

0 comments, 71 reads

Posted in Ganapathi's MSSQLLover on 17 February 2017

Upcoming list of webinars


SQL folks, upcoming list of webinars from SQL PASS. 


Webinar title / Registration link / more info
Speaker
Date / Time
Andy Yun
2/18/2017 9:00PM~10:30PM EST
"Reports on the Go: SSRS 2016 Mobile Reporting" https://attendee.gotowebinar.com/register/2771711963895711489
Steve Wake

Read more

0 comments, 24 reads

Posted in Ganapathi's MSSQLLover on 15 February 2017

Fix SQL Server Commvault Backup Failures After an Upgrade



One of my friend sent an email that backups of a SQL Server 2016 instance are failing suddenly when the backups run through the Commvault backup tool. The error is:
Error Code: [30:325]
Description: Error encountered during backup. Error: [System.IO.FileNotFoundException:Could not load file or assembly 'Microsoft.SqlServer.BatchParserClient, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or…

Read more

0 comments, 44 reads

Posted in Ganapathi's MSSQLLover on 10 February 2017

Join webinar on SQL Server 2016 Always on




Click [HERE} to Join webinar.

SQL Server 2016 - AlwaysOn

An availability group supports a failover environment for a discrete set of user databases, known as availability databases, that fail over together. An availability group supports a set of primary databases and one to eight sets of corresponding secondary databases.…

Read more

0 comments, 19 reads

Posted in Ganapathi's MSSQLLover on 31 January 2017

Microsoft SQL Server 2016 Cumulative update 1 (CU1)


Microsoft just announced Microsoft SQL Server 2016 Cumulative update 1 (CU1)


Microsoft reference: [Click Here]








Ganapathi varma Chekuri
Lead SQL DBA, MCP

Read more

0 comments, 17 reads

Posted in Ganapathi's MSSQLLover on 27 January 2017

How to Change an Analysis Services Instance to Tabular Mode



One of my client accidentally set up an SQL Server Analysis Services in multi-dimensional mode instead of Tabular mode. In this post I will show a procedure to change Analysis tabular mode in SQL Server 2016. 

Analysis Services Modes 

Analysis Services can be installed in one of three server modes: Multidimensional…

Read more

0 comments, 23 reads

Posted in Ganapathi's MSSQLLover on 28 November 2016

Change the Collation Setting for Clustered SQL Server 2014 Instance


One of our SQL Server 2014 clusters was installed and after the install, my client told me that we are supposed to change the SQL Server collation setting. In this post I will show a procedure to change the collation settings of a clustered SQL Server instance. 
To change the default…

Read more

0 comments, 11 reads

Posted in Ganapathi's MSSQLLover on 26 November 2016

Configuring Integration Services in a SQL Server 2016 Cluster




In this post I will show a procedure to configure Integration Services in a SQL Server 2016 Cluster.
Clustering Integration Services is not recommended because the Integration Services service is not a clustered or cluster-aware service, and does not support failover from one cluster node to another. Therefore, in a clustered…

Read more

0 comments, 43 reads

Posted in Ganapathi's MSSQLLover on 23 November 2016

Microsoft SQL Server 2016 Service Pack 1 (SP1)


Microsoft just announced Microsoft SQL Server 2016 Service Pack 1 (SP1)


Microsoft reference: [Click Here]








Ganapathi varma Chekuri
Lead SQL DBA, MCP

Read more

0 comments, 18 reads

Posted in Ganapathi's MSSQLLover on 19 November 2016

Resolving an Error When Creating an Availability Group Listener

Resolving an Error When Creating an Availability Group Listener.

In this post, I’m going to talk an issue that I found when creating an Availability Group (AG) listener by using SQL Server Management Studio's Add Listener dialog box, you may receive below error message that includes information about the cause of the…

Read more

0 comments, 17 reads

Posted in Ganapathi's MSSQLLover on 6 September 2016

Why SQL Server Database Is In Recovery Mode?

The SQL Server whenever it restarts all the databases goes into the recovery mode. In this state the database comes back in online mode and has a consistent state. It contains three sub phases within this process. Roll forward and rollback are the process contained in this phase. The detailed… Read more

1 comments, 12 reads

Posted in Ganapathi's MSSQLLover on 29 August 2016

SQL Server Error 3257 – Causes and Solution

Overview

While working with SQL server, users may encounters numerous errors in different stages. These errors creates huddles in SQL transactions and its working, which sometimes vanishes the smooth working of SQL server.

SQL Server error 3257 is one of such error that resist database restoration in the system due… Read more

0 comments, 11 reads

Posted in Ganapathi's MSSQLLover on 12 July 2016

Older posts