• AutoMon

    Automon add target server script Automon DBA SPs

    This post will guide you, how to add SQL instances into the monitoring table to collect the data from servers. This needs to be run in each of the target server scripts i.e. whatever server we are adding into monitoring. Use CMS registered server version wise. So that, it is easy to run in one shot. -- add server -- Check HA -- enable dac -- CREATE SP FOR % SPACE & PERFMON -- ADD in Registered server -- add in table ========================= IP changes need to be update in Backup calendar table -- =============================== /*Since the SP name is same for both SQL and non SQL linked server, make…

  • Docker

    Install SQL server on Linux CentOS Redhat create multiple Docker in laptop using VMware Workstation – Part 2

    This is follow up series: What is Docker container https://www.docker.com/resources/what-container In simple container is an image or package that will have binaries, configurations etc of the application to run on. Example – In a single OS you can run multiple containers, like CentOS SQL 2017 and 2019 version etc. It is very easy to install, once the image pulled and stored locally, creating SQL server is in a seconds, the advantage is you can create your own images based on the organization standards and store it in Docker HUB. Docker is a container engine developed by Docker to run a containers. Being SQL server database administrator, mostly we will not…

  • Docker

    Install SQL server on Linux CentOS redhat create multiple Docker in laptop using VMware Workstation – Part 1

    Install SQL server on Linux CentOS Redhat create multiple Docker in laptop using VMware Workstation What is Docker container https://www.docker.com/resources/what-container In simple container is an image or package that will have binaries, configurations etc of the application to run on. Example – In a single OS you can run multiple containers, like CentOS SQL 2017 and 2019 version etc. It is very easy to install, once the image pulled and stored locally, creating SQL server is in a seconds, the advantage is you can create your own images based on the organization standards and store it in Docker HUB. Docker is a container engine developed by Docker to run a…

  • AlwaysON

    Configure cluster aware updating CAU SQL server WSFC windows cluster

    Cluster Aware Updating CAU It is nice tool given by Microsoft for windows cluster WSFC servers. How to configure for SQL servers. Open CAU – Type cluster name –connect the cluster server – click Analysis cluster updating readiness. Review the log, once all good, move on to configure. Click configure cluster self updating – Next next. I will not suggest to go default, make some change based on your environment, like failover apply node orders etc. Here is my configuration.

  • DBA

    Database suspect mode SQL server

    Database suspect mode One of my database went into suspect mode, it is not a critical one and small sized database. There was no backup πŸ™‚ How to recovery the suspect database?   Paul Randal’s post https://www.sqlskills.com/blogs/paul/creating-detaching-re-attaching-and-fixing-a-suspect-database/ If you don’t have any backups, then the only way to get into the database is to use EMERGENCY mode. This lets you into the database but you need to be aware that recovery has not completed so the contents of the database are transactionally (and possibly structurally) inconsistent. I’m going to choose to repair the database using EMERGENCY-mode repair. See CHECKDB From Every Angle: EMERGENCY mode repair – the very, very last…