SQL Server in Kubernetes Cluster using KOPS May 24, 2019 by Ranga Babu In this article, we will review how to create a Kubernetes cluster in AWS using KOPS, provision Elastic Block Store (EBS) as persistent volume to store the database files and deploy SQL Server in the K8s cluster. Read more »
SQL Server in Azure Kubernetes Service (AKS) May 22, 2019 by Ranga Babu In this article, we will review how to create a Kubernetes cluster in Azure Kubernetes Service, provision the persistent volume to store the database files and deploy SQL server on Kubernetes cluster. Read more »
Change default database file and backup paths in SQL Server on Linux January 10, 2019 by Rajendra Gupta In a previous article, we explored the process to change default SQL dump file location in SQL Server. In this article, we will view the process to change the default database files and backup locations in SQL Server on Linux. Read more »
Uninstalling SQL Server on Ubuntu December 31, 2018 by Rajendra Gupta We learned to install SQL Server 2019 installation on Ubuntu without a Docker Container in one of my previous articles, but we might also get a request to uninstall SQL Server running on Ubuntu as well. Both the installation and the uninstallation of SQL Server is different in Linux than of Windows OS. In windows, we can remove or uninstall any program using the add or remove programs feature. In Ubuntu, We need to run the commands in order to uninstall the programs. However, before performing uninstallation, we need to take care of the below point. Read more »
Monitoring Disk Space on Linux – Helpful Commands for SQL Server DBAs December 25, 2018 by Rajendra Gupta In this article, we will explore the different Linux commands related to the disk space. ‘ls’ command ‘df’ command ‘du’ command
Changing SQL Dump file locations in SQL Server on Linux December 24, 2018 by Rajendra Gupta In this article, we will talk about SQL Dump files and the process to change the dump directory in Linux SQL Server.
Renaming a SQL Server instance on Ubuntu Linux December 20, 2018 by Rajendra Gupta In my previous articles, we installed the SQL Server 2019 CTP 2.1 on Ubuntu Linux. You can follow the below articles to prepare the SQL instance on Linux.
Helpful Linux commands for SQL Server DBAs – iotop and iostat December 13, 2018 by Rajendra Gupta In the article, we will learn how to use the ‘iotop’ and ‘iostat’ commands with various configuration options.
Renaming Logical and Physical file names in SQL Server on Linux December 12, 2018 by Rajendra Gupta Each database in SQL Server contains at least two files i.e. Data file (*.mdf) and log file (*.ldf). These database files have a logical name and the physical file name. Below we can view the simple architecture of a database in SQL Server.
Helpful Linux commands for SQL Server DBAs – top December 11, 2018 by Rajendra Gupta SQL Server 2017 and SQL Server 2019 supports both the Linux operating system. As part of performance troubleshooting or monitoring resources in Windows system, we need to check certain things like disk space, CPU or Memory consumption, check running processes, uptime etc. We can get the information, on a windows based SQL server, from the task manager.
SQL Server 2019 installation on Ubuntu without a Docker Container December 10, 2018 by Rajendra Gupta Until now, we learned to install and configure SQL Server 2019 using the Docker container. In this article, we will directly install SQL Server on the Ubuntu Linux and explore more on this.
SQL Server 2019 on Linux with Ubuntu November 29, 2018 by Rajendra Gupta In my previous articles, we installed SQL Server 2019 on the windows environment (vs Linux / Ubuntu). We also explored some of the important enhancements in SQL Server 2019
SQL Server 2019 on Linux with a Docker container on Ubuntu November 29, 2018 by Rajendra Gupta In the first article of the series on SQL Server 2019 and Ubuntu, we prepared the virtual machine environment and installed Ubuntu 18.10 in it. In this part of the article, we will install the latest SQL Server 2019 Preview CTP 2.1. Read more »
SQL Server 2019 on Linux with Ubuntu and Azure Data Studio November 29, 2018 by Rajendra Gupta In the previous articles of this series on using SQL Server 2019 on Ubuntu, we have explored the following Read more »
How to setup cross-platform transactional SQL Server replication for database reporting on Linux August 31, 2018 by Prashanth Jayaram In most cases, an organization can either use the existing out-of-the-box database replication features offered by their database software provider or invest in custom solutions to execute and manage database replication processes. The latter option sometimes allows greater flexibility to create data replicas across multiple types on multiple platforms. Read more »
Backup Linux SQL Server databases using PowerShell and Windows task scheduler May 22, 2018 by Prashanth Jayaram This article is an in-depth guide on how PowerShell can be used to maintain and manage SQL backup on Linux and Windows machines. Here’s an outline of what this article is all about: Introduction Technical specifications How to load SQL Server modules on Windows machine Security – Credential Management The objectives of Backup and Restore Library Linkage How SQL Server 2017 backup feature is used on Linux And more … Read more »
How to configure SQL Server 2017 on Linux with mssql-conf and other available tools December 13, 2017 by Prashanth Jayaram Configuration of any system plays a vital role in its working efficiently. However, configuring a system needs not necessarily be a daunting task. There are several tools that help with the process. SQL Server on Linux provides a wide range of options for configuration, management and administration. mssql-conf Transact-SQL SQL Server Management Studio PowerShell Read more »
How to set up SQL Server Log Shipping on Linux November 13, 2017 by Prashanth Jayaram Log shipping is a high-availability configuration that perhaps most of us are familiar with. It’s one of the oldest techniques wherein we ship transaction logs from a Primary database to a Secondary database. Log Shipping is still a vital feature used in case of applications that use warm standby for Disaster Recovery. We can see many articles which discuss the process of configuring Log shipping using T-SQL or SSMS. Read more »
How to install SQL Server on Ubuntu May 18, 2017 by Stefan Veselinovic Introduction With an increasing number of new servers running on Linux, and even a third of Microsoft’s Azure virtual machines running Linux, they have made a choice to bring SQL Server to Linux in order to increase their market share and attract new customers. Read more »
Migrate an SQL database from Windows to Linux using backup-and-restore and SMB Protocol May 16, 2017 by Prashanth Jayaram In an attempt decouple systems, we may modularize them. In most cases, we would need to move databases from one server to another—sometimes, even move them from Windows to Linux. Read more »
Installation of SQL Server vNext CTP on Linux Distribution CentOS 7 May 10, 2017 by Prashanth Jayaram It was a paradigm shift in December 2016, when Microsoft made their SQL Server database available for Linux; it was the first time in history that Microsoft ever designed SQL Server to run on a non-Windows operating system. SQL Server vNext was released for public preview so the user community could test and deploy SQL Server on a Linux operating system. Microsoft took a major step in diversifying the database technology into the non-windows platform for the first time. Read more »
SQL Server vNext – Does Microsoft love Linux? April 21, 2017 by Daniel Calbimonte Introduction In the 90s and at the beginning of the 21 century, Linux and Windows were decidedly working at cross purposes However, starting on 2009, Microsoft started to contribute with code in the Linux Kernel. On 2013, Azure supported Virtual Machines in Ubuntu and later came the support to .NET in Linux, Visual Studio for Linux, PowerShell in Linux, support to monitor Linux server to monitor in SCOM (System Center Operation Manager) and now, the support for SQL Server that is on the previous version when this article was published and it is planned to be released this year (2017). Microsoft is a Platinum member of the Linux Foundation now. Read more »
