sql server 2019 Archives - {coding}Sight https://codingsight.com/tag/sql-server-2019/ Blog for SQL Server DBAs and Developers Fri, 07 Oct 2022 07:53:33 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://codingsight.com/wp-content/uploads/2021/10/cropped-Soсial_-Fb_180х180-1-32x32.png sql server 2019 Archives - {coding}Sight https://codingsight.com/tag/sql-server-2019/ 32 32 What is SQL Server? (Definition, Versions, Editions) https://codingsight.com/what-is-sql-server-definition-versions-editions/ Thu, 07 Oct 2021 13:37:46 +0000 http://codingsight.com/?p=16843 Excited? That’s how it feels to learn a new skill on your first day. It can also feel a bit overwhelming. You have lots of questions. You don’t know where to start. Learning SQL Server for the first time feels the same. And that’s what this article is about. It will answer the very first …

The post What is SQL Server? (Definition, Versions, Editions) appeared first on {coding}Sight.

]]>
MS SQL Server on Linux vs Windows Performance Test to Spot the Difference https://codingsight.com/sql-server-2019-windows-vs-linux-and-simple-test-scenario-to-spot-difference/ Fri, 30 Apr 2021 09:11:19 +0000 http://codingsight.com/?p=13434 Since the release of SQL Server 2017 for Linux, Microsoft has pretty much changed the entire game. It enabled a whole new world of possibilities for their famous relational database, offering what was only available in the Windows space until then. I know that a purist DBA would tell me right away that the out …

The post MS SQL Server on Linux vs Windows Performance Test to Spot the Difference appeared first on {coding}Sight.

]]>
Install SQL Server 2019 Ubuntu Linux Server Step by step https://codingsight.com/how-to-install-sql-server-on-linux-system-step-by-step/ Fri, 30 Apr 2021 08:34:08 +0000 http://codingsight.com/?p=13322 After exploring the processes of building a virtual machine to install Ubuntu Linux 18.04 (refer to the step-by-step guideline about installing Ubuntu 18.04 on a virtual machine if necessary), we come to the primary goal. It is to install MS SQL Server on Ubuntu. A side note before we proceed: This article focuses on using …

The post Install SQL Server 2019 Ubuntu Linux Server Step by step appeared first on {coding}Sight.

]]>
Install and Configure SQL Server 2019 on Windows Server 2016 https://codingsight.com/install-and-configure-sql-server-2019-on-windows-server-2016/ Mon, 28 Dec 2020 10:05:10 +0000 https://codingsight.com/?p=11176 SQL Server 2019 was introduced in November 2019. The RTM version of SQL Server 2019 is 15.0.2000.5. To learn about the new features presented in this version, you may refer to SQL Server 2019 New Features. The current article briefly explains the process of SQL Server 2019 installation on Windows Server 2016. Installation process: step …

The post Install and Configure SQL Server 2019 on Windows Server 2016 appeared first on {coding}Sight.

]]>
Manage MDF Files in SQL Server 2019 https://codingsight.com/manage-mdf-files-in-sql-server-2019/ Wed, 23 Dec 2020 14:07:48 +0000 https://codingsight.com/?p=11322 An SQL Server database contains primary data files, secondary data files (optional), and transaction log files. The primary and secondary datafiles contain tables, database objects, schema, and data. The file extension of the primary database file is *.mdf, and the file extension of the secondary data file is *.ndf. The transaction log files store all …

The post Manage MDF Files in SQL Server 2019 appeared first on {coding}Sight.

]]>
SQL Server Express Edition: Installation, Benefits, and Limitations https://codingsight.com/sql-server-express-edition-installation/ Fri, 04 Dec 2020 15:35:38 +0000 https://codingsight.com/?p=11205 The SQL Server Express edition is a free version of SQL Server 2019. You can use it to deploy small applications and websites and monitor the database mirroring instances. It also serves as a back-end of the third-party software. For example, if you plan to set up an SQL Server monitoring tool, and the data …

The post SQL Server Express Edition: Installation, Benefits, and Limitations appeared first on {coding}Sight.

]]>
How to Install Ubuntu 18.04 and SQL Server 2019 on Linux https://codingsight.com/how-to-install-ubuntu-18-04-and-sql-server-2019-on-linux/ Mon, 30 Nov 2020 19:18:15 +0000 https://codingsight.com/?p=10700 The previous article explained the creation of a virtual machine using Oracle VM Virtual machine. Now, we will learn how to install Ubuntu 18.04 and SQL Server 2019 on Linux. Install Ubuntu Linux First, we need an operating system ISO file. Once the file is downloaded, we mount it on a virtual disk drive: Launch …

The post How to Install Ubuntu 18.04 and SQL Server 2019 on Linux appeared first on {coding}Sight.

]]>
SQL Server 2019 New Features https://codingsight.com/sql-server-2019-new-features/ Thu, 14 Feb 2019 08:44:45 +0000 https://codingsight.com/?p=6220 Microsoft’s leading database is an essential tool, with in-cloud and on-premises versions providing incredible storage and analytic tools. It’s additionally turned into an essential application for data scientists, giving a structure to building and testing machine learning models. There is more in SQL Server, and the new release version can indicate where Microsoft thinks your …

The post SQL Server 2019 New Features appeared first on {coding}Sight.

]]>