• DBA

    Remove Trim last character of string in the column – SP_helpdb

    The requirement is load sp_helpdb for all databases in the server, about 100+ serves to check database size quickly (sp_helpdb will hold both used and unused). Use CMS registered server, copy the data and paste in excel, import the excel file into a table. (OR) use BCP command.   sp_helpdb create table tbl_sp_helpdb ( server_name varchar (100),name varchar(100),Size_in_mb varchar(100),owner varchar(100), dbid int,created datetime, status varchar(100), compatibility_level int ) -- Import the excel select * from tbl_sp_helpdb order by Size_in_mb alter table tbl_sp_helpdb alter column Size_in_mb numeric --Error converting data type nvarchar to numeric. select left (Size_in_mb,LEN(Size_in_mb) -2) as Size_in_mb,* from tbl_sp_helpdb order by Size_in_mb update tbl_sp_helpdb set Size_in_mb =left (Size_in_mb,LEN(Size_in_mb)…

  • Docker

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

    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 worked on Linux platform, I…

  • Docker

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

    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 worked on Linux platform, I…

  • Docker

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

    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 worked on Linux platform, I…

  • 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…