This category could include helpful tips and best practices for working with SQL, as well as common pitfalls to avoid.
Finding the SQL Server version can be done in many ways. Three effective methods are given below. Using SQL Server Instance Properties Use the following steps to find SQL version using SQL Server Management Studio (SSMS) Graphical User Interface (GUI). Run SQL Server Version Query or T-SQL Script You can run a simple query or T-SQL …
Discover How To Find SQL Version in SSMS: 3 Useful Solutions Read More »
This error message occurs when you are trying to change the database encryption key for Transparent Data Encryption (TDE) in SQL Server, but TDE has not been enabled on the database. TDE is a feature in SQL Server that provides encryption for the entire database, including the transaction log. To resolve this error, you must …
Can’t change the database encryption key because no database encryption key set Read More »
Here you can find the Microsoft SQL Server key license of all versions. Microsoft SQL Server 2019 Microsoft SQL Server 2017 Microsoft SQL Server 2016 Microsoft SQL Server 2014 Microsoft SQL Server 2014 R2 Microsoft SQL Server 2012 Microsoft SQL Server 2008 R2 Microsoft SQL Server 2014 R2 Related Topic: