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

Archives: November 2016

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, 494 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, 95 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, 355 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, 89 reads

Posted in Ganapathi's MSSQLLover on 19 November 2016