• ggaurav

    Database Deployment Wizard in SQL Server 2014

    • 2 Comments
    In SQL Server 2014, we have a new wizard called Database deployment using which we can deploy a database which is in-premise to Azure without even having a knowledge of what Azure is all about. All what you require an Azure subscription to play with....
  • ggaurav

    Connect to SQL database on Azure IaaS from SSMS

    • 1 Comments
    When trying to connect to SQL Server on an IaaS VM server, you would get all type of weird messages when trying to make a connection using SSMS. Yes! we can connect to SQL Server on Azure IaaS VM from the local SSMS on our machine. The easiest way to...
  • ggaurav

    Master DB restore & Service Master key

    • 0 Comments
    If we don’t have a recent master backup and have to make use of the files from the DR server, then as long as our target instance matches the path and build requirements we can restore master and bring it up. If the build is different , we will...
  • ggaurav

    Adding a Remote Distributor for a Transactional Replication

    • 0 Comments
    You may encounter the following messages when creating a remote Distributor : TITLE: Configure Distribution Wizard ------------------------------ SQL Server could not connect to the Distributor using the specified password. For help, click...
  • ggaurav

    Server Manager consuming memory

    • 0 Comments
    You may have seen issues on Windows 2012 server, where even after the users have disconnected from the server, their session is still consuming the memory. When you open task manager, you would see the session manager of the disconnected session taking...
  • ggaurav

    Explicit DBO permissions on TempDB for a domain group

    • 0 Comments
    To do this we created a stored procedure and added it as a startup procedure so that whenever the SQL server service is restarted then the stored procedure will automatically grant the access to the group on the tempdb. Add the domain group to the SQL...
  • ggaurav

    Moving database from On premise to Azure

    • 0 Comments
    It may be that you are trying to move your DB from on premise to Azure and using ALTER DATABASE command. Once you make the metadata change using ALTER DATABASE and then move the physical file to AZURE, the DB fails to come online with the following error...
  • ggaurav

    AlwaysOn:Joining database on secondary replica resulted in an error

    • 0 Comments
    Many a times when you try to create a new Availability group it would fail with the below error message : TITLE: Microsoft SQL Server Management Studio ------------------------------ Joining database on secondary replica resulted in an error...
  • ggaurav

    Going Online

    • 0 Comments
    Almost closing to six years of happy time in MS, I've decided to share the knowledge which I've acquired over the period. As of now, I'll start with SQL server related blogs which I've been associated from day one. Planning to start with the blog on SQL...
  • ggaurav

    SQL2014PerformanceImprovements

    • 0 Comments
    There have been many new changes which have been incorporated into SQL 2014 which would be the game changer in terms of the adoptability of SQL server. Some of the new noticeable changes which we have in SQL 2014 are : ϠNew cardinality estimate : ...
  • ggaurav

    SQL2014PerformanceImprovements

    • 0 Comments
    There have been many new changes which have been incorporated into SQL 2014 which would be the game changer in terms of the adoptability of SQL server. Some of the new noticeable changes which we have in SQL 2014 are : ϠNew cardinality estimate : ...
  • ggaurav

    The VLF Trap

    • 0 Comments
    While working on one of the migration there is something which I discovered so sharing all what I know about VLF’s and how we can ensure that we don’t get into VLF trap: Few issues which you can see if there are too many VLF’s: ...
  • ggaurav

    The subscription(s) have been marked as inactive

    • 0 Comments
    While you are troubleshooting the following error : "The subscription(s) have ben marked as inactive" Please make sure you have checked the following : 1. MSSubscriptions table and the value is showing as zero for the status column http:/...
  • ggaurav

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

    • 0 Comments
    Tricky!! This is what I can say when I started troubleshooting the issue when suddenly the logins were getting dropped and no one had a clue what's going on since no one from the DBA team would go ahead and drop the logins. However, SQL 2008 and above...
  • ggaurav

    FlushCache : New in SQL Server 2012

    • 0 Comments
    Starting SQL 2012 we have got something new added to the SQL error logs which was logged earlier when a TF was enabled. Below is the message which is new in the SQL error logs : 2013-09-20 03:01:48.10 spid14s FlushCache: cleaned up 12773 bufs with...
Page 1 of 1 (15 items)