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...
Author: GauravSrivastava 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....
Author: GauravSrivastava 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...
Author: GauravSrivastava 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....
Author: GauravSrivastava 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...
Author: GauravSrivastava 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...
Author: GauravSrivastava 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...
Author: GauravSrivastava 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...
Author: GauravSrivastava 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...
Author: GauravSrivastava 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,...
Author: GauravSrivastava 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...
Author: GauravSrivastava 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...
Author: GauravSrivastava 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...
Author: GauravSrivastava 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...
Author: GauravSrivastava 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...
Author: GauravSrivastava 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...
Author: GauravSrivastava Date: 10/23/2013
SQL2014PerformanceImprovements
There have been many new changes which have been incorporated into SQL 2014 which would be the game...
Author: GauravSrivastava Date: 10/23/2013
SQL2014PerformanceImprovements
There have been many new changes which have been incorporated into SQL 2014 which would be the game...
Author: GauravSrivastava 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...
Author: GauravSrivastava Date: 10/23/2013