Feeds:
Posts
Comments

Posts Tagged ‘SQL Server 2022’

SQL Server – Fix – Error – This backend version is not supported to design database diagrams or tables

Posted in Errors, SQL SERVER, Uncategorized, tagged , , , , on April 6, 2023| 1 Comment »

Recently, I was working on one of the databases and I tried to insert a table through SQL Server Management Studio (SSMS) and I came across the following error.

Error:

The backend version is not supported to design database diagrams or tables.

Reproduce Error:

Let me reproduce this error step by step.

Step 1:

Let’s create a new database namely ‘TestDB’ as shown below.

 
CREATE DATABASE TestDB;
GO

Step 2:

Now, lets expand the database TestDB, then right click on the Tables option and then select New and then select Table… as shown below.

Step 3:

This will display the following error.

Solution:

This error occurs when you have the older version (18) of SSMS installed on your device. To check the version installed on your device, navigate to the Help menu and click on About menu in the menu bar as shown below.

A new window will pop up with all the version details of the SSMS.

In order to solve this error, you need to install a new version (19 or higher) of SQL Server Management Studio (SSMS). You can download it from here

Conclusion:

Make sure you have updated version of SSMS all the time to avoid such errors.

Read Full Post »

SQL Server 2022 is released on 16 Nov 2022

Posted in Raresql News, SQL SERVER, tagged , , , , , , , , , , , , , , , on November 21, 2022| Leave a Comment »

The most Azure Enabled SQL Server is now being launched as SQL server 2022(16.x). It has a lot of new features and enhancements too. You can download it from here and use its express and developer edition for FREE.

New Features & Enhancements of SQL Server 2022:

  • Analytics:

In analytics, there are many new features and enhancements, few of them are shown below :

  1. Azure Synapse Link for SQL
  2. Object storage integration

Here is the full list of enhancements and new features in the Analytics.

  • Availability:

In Availability, there are many new features and enhancements, few of them are shown below.

  1. Link to Azure SQL Managed Instance
  2. Contained availability group
  3. Improved backup metadata

Here is the full list of enhancements and new features in the Availability.

  • Security:

In Security, there are many new features and enhancements, few of them are shown below.

  1. Microsoft Defender for Cloud integration
  2. Microsoft Purview integration
  3. Ledger

Here is the full list of enhancements and new features in the Security.

  • Performance:

In Performance, there are many new features and enhancements, few of them are shown below.

  1. Buffer pool parallel scan
  2. Ordered clustered columnstore index

Here is the full list of enhancements and new features in the Performance.

  • Query Store and intelligent query processing:

In Query Store and intelligent query processing, there are many new features and enhancements, few of them are shown below.

  1. Query Store on secondary replicas
  2. Query Store hints
  3. Memory grant feedback
  4. Parameter sensitive plan optimization

Here is the full list of enhancements and new features in the Query Store and intelligent query processing.

  • Management:

In Management, there are many new features and enhancements, few of them are as shown below.

  1. Manage Azure extension for SQL Server
  2. Max server memory calculations
  3. Accelerated Database Recovery (ADR) improvements

Here is the full list of enhancements and new features in the Management.

  • Platform:

In platform, there are many new features and enhancements, few of them are as shown below.

  1. Hybrid buffer pool with direct write
  2. Integrated acceleration & offloading

Here is the full list of enhancements and new features in the Platform.

  • Language:

In Language, there are many new features and enhancements, few of them are as shown below.

  1. Resumable add table constraints
  2. CREATE INDEX
  3. Transactional replication

Here is the full list of enhancements and new features in the Language.

Reference Links:

  1. What’s new in SQL Server 2022

Read Full Post »