Share via


ggaurav

SQL Data Sync table creation error

As you are setting your first SQL data sync between on-prem and Azure SQL you may come up with an...

Date: 07/11/2015

How Statistics in SQL Server determines performance

SQL Server collects statistical information about indexes and column data stored in the database....

Date: 04/10/2015

SQL Cluster resource fails to come online

You have a SQL clustered resource and it's failing to come online as a clustered resource. When you...

Date: 04/10/2015

Testing AlwaysOn routing URL using SQLCMD

You have created a listener and have configured routing URL for the replicas in the AlwaysOn group....

Date: 09/03/2014

AlwaysOn:Joining database on secondary replica resulted in an error

Many a times when you try to create a new Availability group it would fail with the below error...

Date: 06/25/2014

Moving database from On premise to Azure

It may be that you are trying to move your DB from on premise to Azure and using ALTER DATABASE...

Date: 05/15/2014

Explicit DBO permissions on TempDB for a domain group

To do this we created a stored procedure and added it as a startup procedure so that whenever the...

Date: 04/20/2014

Server Manager consuming memory

You may have seen issues on Windows 2012 server, where even after the users have disconnected from...

Date: 04/16/2014

Adding a Remote Distributor for a Transactional Replication

You may encounter the following messages when creating a remote Distributor : TITLE: Configure...

Date: 04/11/2014

Master DB restore & Service Master key

If we don’t have a recent master backup and have to make use of the files from the DR server,...

Date: 04/07/2014

Connect to SQL database on Azure IaaS from SSMS

When trying to connect to SQL Server on an IaaS VM server, you would get all type of weird messages...

Date: 01/08/2014

Database Deployment Wizard in SQL Server 2014

In SQL Server 2014, we have a new wizard called Database deployment using which we can deploy a...

Date: 01/08/2014

FlushCache : New in SQL Server 2012

Starting SQL 2012 we have got something new added to the SQL error logs which was logged earlier...

Date: 11/02/2013

Audit : How to track logins getting dropped in SQL Server?

Tricky!! This is what I can say when I started troubleshooting the issue when suddenly the logins...

Date: 11/02/2013

The subscription(s) have been marked as inactive

While you are troubleshooting the following error : "The subscription(s) have ben marked as...

Date: 11/02/2013

The VLF Trap

While working on one of the migration there is something which I discovered so sharing all what I...

Date: 10/23/2013

SQL2014PerformanceImprovements

There have been many new changes which have been incorporated into SQL 2014 which would be the game...

Date: 10/23/2013

SQL2014PerformanceImprovements

There have been many new changes which have been incorporated into SQL 2014 which would be the game...

Date: 10/23/2013

Going Online

Almost closing to six years of happy time in MS, I've decided to share the knowledge which I've...

Date: 10/23/2013