Detailed steps on how to move model database files (mdf and ldf) from one location to another. This change requires a restart of your SQL Server Instance, so make sure to do this during a maintenance window. First find the model database files location which we want to move. To do that, execute the following […]
Author: Editorial team
How to move tempdb database files in SQL Server
Detailed steps on how to move tempdb database files (mdf and ldf) from one location to another. Tempdb is recreated every time you restart SQL Server Instance. So all we have to do is update the new path in master database, and a restart of the sql server instance will create tempdb in the newly […]
How to move database files in SQL Server
Detailed steps on how to move database files from one location to another. We will see how to move user database files, and how to move system database files. We will see how to move both mdf and ldf files to another location. Move User Database Files First find the database files location which we […]
How to shrink a file in SQL Server
How to shrink data or log files in SQL Server. What to do if a file is not shrinking, how to find the reason for not shrinking. Connect to your SQL Server Instance Click New Query to open a query window. Now first run the below query to find the name of the data or […]
Running virtual machines in OpenShift
This is a quick and interesting session to show how easy is to install a virtual machine on OpenShift. OpenShift allows us to install virtual machines using Operators. We can have vms and containers running in parallel. This is a huge benefit, as some of the legacy applications which cannot be containerised can be deployed […]
Build images, containers using Podman and Red Hat Quay
Use Podman to create images, push and pull images from Red Hat Quay image Repository. Create the container using the pulled image, connect to the container and the application. You can either watch the detailed video or follow the below given text blog. Today we will talk about Podman and Red Hat Quay image Repository. […]
How to find SQL Server version
How to find the installed version of SQL Server. This query will give us the required version information of the SQL Server instance.
SQL Server 2014 Build Versions
Microsoft SQL Server 2014 Build Versions details and where to download information. Download the most recent or search for the required SQL Server Service Pack 2014 (SP), SQL Server Cumulative Updates (CU) or General Distribution Release (GDR). Find SQL Server Build Versions for all SQL Server products, click here SQL Server Build Versions Detailed
SQL Server 2016 Build Versions
Microsoft SQL Server 2016 Build Versions details and where to download information. Download the most recent or search for the required SQL Server Service Pack 2016 (SP), SQL Server Cumulative Updates (CU) or General Distribution Release (GDR). Find SQL Server Build Versions for all SQL Server products, click here SQL Server Build Versions Detailed
SQL Server 2017 Build Versions
Microsoft SQL Server 2017 Build Versions details and where to download information. Download the most recent or search for the required SQL Server Service Pack 2017 (SP), SQL Server Cumulative Updates (CU) or General Distribution Release (GDR). Find SQL Server Build Versions for all SQL Server products, click here SQL Server Build Versions Detailed