Uncategorized

  • Hi

  • dbatools

    This is my favorite power shell tool , very simple use and with elaborate options.Earlier migrations used to take hr’s with missing pieces, i BET with this power shell tool you are not miss a single user role and access privileges. i did multiple migrations till now and still loving it. Few links below to…

  • My first PostgreSQL

    ,

    Hush Hush Hush…. after 3 long days i at last did it, setup vm , installed CentOS , configured Postgres 9.6-3 ( Redhat Linux edition). So let me spit it when my head really hot with all the syntax… i promise its not a boring subject but yes its worth learning. Step 1: Get the…

  • NoSQL

    ,

    Here i come get ready.. going to post exiting Postgres 101 for DBA.

  • Upgrade Advisor Error

    , ,

    Scenario : When trying to upgrade from lower version to rich upgraded SQL Server version its a sanity check to do UPGRADE ADVISORY REPORT. Cause : When you try to run this report from remote machine this might fail with error message : and this little above message caused havoc in internet for multiple users…

  • Don’t panic while error.

    , ,

    Here is what happened and i did panic while answering the blog’s like this… READ THE ERROR MESSAGE VERY CAREFULLY WITH SOUND MIND. DO NOT PANIC. Scenario : Upgrading from 2008R2 Sp2 Standard Edition to 2014 Sp1 Standard CU11. Error : “The upgrade patch cannot be installed by the Windows Installer service because the program…

  • Recover DB from NO LDF

    Friends today i got the situation where i need to restore just using mdf file but no ldf. and again experience from CSS engineers helped me. thanks for blogging and sharing all knowledge… below link helped me recovering. https://blogs.msdn.microsoft.com/sql_pfe_blog/2016/11/16/recover-database-without-ldf-file/ Hope you enjoyed.

  • SQL 2016 Auto Update Stats Changed

    Do you know this…. in SQL 2016 Auto Update Stats Frequency for Large Tables changed now. Earlier 2014 and Old versions we need to enable 2371 Trace flag to change the frequency than 20% data change when there are millions of rows in a large tables. For more information follow the link below. https://blogs.msdn.microsoft.com/psssql/2016/10/04/default-auto-statistics-update-threshold-change-for-sql-server-2016/

  • Hurray!!!

    Yes i did it at last .. i created my domain controller and added 2 windows machines in AD.it took 3 Hrs for total setup .. now i am going to install 2016 SQL Server Trial Version and do all sorts of tests… Dream project.

  • Params Error/17300/Event ID 18053

    Hello Folks, I just installed 2014 SQL Instance and configured max and min memory settings and in hurry i did not see what the max value is set to, guess what it was too low 128MB which is lower than minimum memory accepted by SQL Engine and all the errors followed. Event Viewer Messages :…