-->
SQL Clone
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.

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

1 comments, 707 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, 459 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, 278 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, 1,203 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, 168 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, 506 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, 214 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, 197 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

0 comments, 1,476 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, 737 reads

Posted in Ganapathi's MSSQLLover on 12 July 2016

Simple Way to Decrypt SQL Server Stored Procedure

When stored procedures are created in SQL Server, their entire text body is accessible to all those who have the required permissions for accessing the data. Therefore, it becomes very easy to expose the underlying object content by creating stored procedures and analyzing it content via SQL Server Management Studio,… Read more

1 comments, 5,172 reads

Posted in Ganapathi's MSSQLLover on 20 May 2016

What's New in SQL Server 2016 Release Candidate 3


Microsoft announced SQL Server 2016 Release Candidate 3 Evaluations


Benefits of SQL Server 2016 Release candidate 3:

  • Enhanced in-memory performance provide up to 30x faster transactions, more than 100x faster queries than disk based relational databases and real-time operational analytics
  • New Always Encrypted technology helps protect your data at rest…

Read more

0 comments, 134 reads

Posted in Ganapathi's MSSQLLover on 16 April 2016

SQL Server Failover Cluster Configuration & its Hardware Compatibility

Introduction

Failover cluster in SQL Server is a type of cluster in which two or more independent servers are interconnected with each other via means of physical cables and software. The servers in failover type of clustering are referred to as nodes. This has a major advantage of providing availability… Read more

3 comments, 226 reads

Posted in Ganapathi's MSSQLLover on 29 March 2016

Fixing Maintenance Plan Error code 0x534



Recently I have posted a article in SQLServerCentral on Fixing Maintenance Plan Error code 0x534



Read My Article "Here



















For more updates:
Subscribe for Blog posts [Click Here]
Follow FB Page [Click Here]
Follow FB Group [Click Here]
For Suggestion & Feedback mail us…

Read more

0 comments, 105 reads

Posted in Ganapathi's MSSQLLover on 25 March 2016

Troubleshooting SQL Server Operating System Error 995

Operating System Error Message

Error: 18210, Severity: 16, State:1
BackupMedium::ReportIoError: write failure on backup device ‘VDI_ DeviceID ‘. Operating system error 995 (The I/O operation has been aborted because of either a thread exit or an application request).

Reason Behind SQL Server Operating System Error 995

There are a number…

Read more

4 comments, 635 reads

Posted in Ganapathi's MSSQLLover on 16 January 2016

Error: Microsoft .NET framework 3.5 service pack 1 is Required- SQL Server 2014



Read My Article "Here



























Ganapathi varma
Senior SQL Engineer, MCP

For more updates:
Subscribe for Blog posts [Click Here]
Follow FB Page [Click Here]
Follow FB Group [Click Here]
For Suggestion & Feedback mail us at gana20m@gmail.com

Read more

0 comments, 74 reads

Posted in Ganapathi's MSSQLLover on 12 January 2016

SQL Server 2016 AlwaysOn Availablility Enhancements


In this Article I have listed out SQL Server 2016 AlwaysOn Availability Enhancements.
SQL Server 2016 [CTP 3.2] SQL Server 2016 CTP Standard Edition now supports AlwaysOn Basic Availability Groups.
AlwaysOn Basic Availability Groups replaces the deprecated Database Mirroring feature for SQL Server 2016 Standard Edition. 
AlwaysOn Basic Availability Groups provide a…

Read more

0 comments, 284 reads

Posted in Ganapathi's MSSQLLover on 24 December 2015

What's New in SQL Server 2016, Community Technology Preview 3 (CTP 3.1)

What's New in SQL Server 2016


Benefits of SQL Server 2016:

  • Enhanced in-memory performance provides up to 30x faster transactions, more than 100x faster queries than disk-based relational databases and real-time operational analytics.
  • New Always Encrypted technology helps protect your data at rest and in motion, on-premises and in the…

Read more

0 comments, 102 reads

Posted in Ganapathi's MSSQLLover on 7 December 2015

Announcing SQL Server Management Studio - November 2015 Release



For Summary On Improvements In the Latest Release
Please go through the below link.

Summary On Improvements In SSMS Nov 2015


To Download SSMS November 2015 Preview

Download Link

Read more

0 comments, 60 reads

Posted in Ganapathi's MSSQLLover on 1 December 2015

Newer posts

Older posts