SQL Server

Posts related to SQL Server (on-prem and cloud)

No new SQL Server CUs till the end of 2020

Reading Time: < 1 minute

SQL server team announced today that they will not be releasing any new cumulative update for SQL server products (SQL Server 2019, 2017, and 2016SP2) until the end of this year.

As written in this blog post, it’s been a tough year and is now a good time, around the holidays, for people to spend time with their families.

I personally find this move very kind and supportive and I wish for more companies to follow this paradigm.

So cheers to Microsoft, once again, and happy -early- Christmas holidays to everyone.

News & announcements SQL Server
Tagged: Announcement CU maintenance sqlserver

SQL Server Management Studio new release

2020-10-21
Comments Off on SQL Server Management Studio new release
By Vassilis Ioannidis

Reading Time: < 1 minute Microsoft released SQL Server Management Studio (SSMS) 18.7 and is now generally available with 3 key changes.

SQL Server
Tagged: management release sqlserver SSMS tools

Azure Data Studio October Release

2020-10-16
Comments Off on Azure Data Studio October Release
By Vassilis Ioannidis

Reading Time: < 1 minute Latest release of Azure Data Studio is here. Check the list of new and improved functionalities and download the latest version.

Azure Data Platform SQL Server
Tagged: azure data studio management release tools

Always start with the basics

2020-10-14
Comments Off on Always start with the basics
By Vassilis Ioannidis

Reading Time: 3 minutes Today I was called in to check what seemed a SQL Server performance problem, in one client-owned datacenter in Asia. I will share with you some details, in order to help you better understand the context…

SQL Server
Tagged: performance sqlserver talesFromTheTrenches troubleshooting

Microsoft recalls CU 7 for SQL Server 2019

2020-09-26
Comments Off on Microsoft recalls CU 7 for SQL Server 2019
By Vassilis Ioannidis

Reading Time: < 1 minute

Microsoft is recalling CU7 for SQL 2019 because of a known reliability issue with the database snapshot feature.

If you haven’t installed it yet, it is advised not to install it, even if you don’t make use of this feature, as DBCC CHECKDB also uses it. Instead wait for the CU 8 which is scheduled for the week of October-12.

You can read more here.

slippery slope SQL Server
Tagged: CU maintenance recalls release sqlserver