36 articles
SQL Server 2016 (13.x) supports upgrade from the following versions of SQL Server: SQL Server 2008 SP4 or later SQL Server 2008 R2 SP3 or later SQL Server 2012 (11.x) SP4 or later SQL Server 2014 (12.x) SP2 or later…
SQL Server 2019 (15.x) supports upgrade from the following versions of SQL Server: SQL Server 2012 (11.x) SP4 or later SQL Server 2014 (12.x) SP2 or later SQL Server 2016 (13.x) SP2 or later SQL Server 2017 (14.x) Windows 10…
Upgrade your SQL Server 2017 to SQL Server 2019 seamlessly without the hassle of reinstalling! In this step-by-step tutorial, I show you the entire process, ensuring you can take advantage of the latest features and improvements in SQL Server 2019. Whether you’re a database administrator, IT professional, or tech enthusiast, this post will help you upgrade your SQL Server quickly and efficiently. Make sure to follow along and enhance your database management experience!
SQL Server 2019 (15.x) supports upgrade from the following versions of SQL Server: SQL Server 2012 (11.x) SP4 or later SQL Server 2014 (12.x) SP2 or later SQL Server 2016 (13.x) SP2 or later SQL Server 2017 (14.x) Windows 10…
The SQL Server evaluation edition is free for 180 days but when the evaluation period has expired, the SQL Server shutdown and remains offline. Open SSMS SQL Management Studio then connect to SQL Server. Select New Query then Execute bellow…
I have SQL Server installed, but I’m not sure what license was installed. Is there an easy way to find this out? You can using SSMS SQL Management Studio to find it. SELECT SERVERPROPERTY('LicenseType') as Licensetype, SERVERPROPERTY('NumLicenses') as LicenseNumber, SERVERPROPERTY('productversion')…
Before we get started, I want to cover the two ways that SQL Server authenticates logins. The two ways are: Windows Authentication Mode. Windows and SQL Server Authentication Mode (Mixed Mode). Windows Authentication Mode: In Windows authentication mode, we can…
Installing SQL Server Evaluation is not overly complicated, but it is helpful to know what to expect before you walk through the installation process. This article will show you the various screens and options that are part of the install…
The SQL Server Evaluation Edition is a great way to get a fully functional and free instance of SQL Server for learning and developing solutions. The edition has a built in expiry of 6 months from the time that you…
Changing SQL Server Instance name is not a routine task. Although, sometimes we get requirements to change SQL Instance name. There are multiple scenarios in which we need to rename SQL Server Instance like: If you have changed database server…