SQL Server
CREATE PROC dbo.spSQLPerf
AS
DBCC SQLPERF(logspace)
GO
CREATE TABLE dbo.logSpaceStats
(
id INT IDENTITY (1,1),
logDate datetime...
Mon, 9 Nov, 2015 at 6:37 PM
SP2 CU8 includes the following: Restores of compressed encrypted backups fail Data masking doesn’t DAX query needs memory 200x larger than the database ...
Thu, 1 Aug, 2019 at 5:14 PM
Announcing SQL Server 2019 Cumulative Update 1 By Brent Ozar on Jan 07, 2020 01:37 pm The first cumulative update for a brand new version of SQL Server is...
Fri, 17 Jan, 2020 at 9:49 AM
Cumulative Update 19 for SQL Server 2017 Applies to: SQL Server 2017 on Windows (all editions)SQL Server 2017 on Linux (all editions) This...
Fri, 7 Feb, 2020 at 9:32 AM
Server 2016 SP2 Cumulative Update 12 Bugs Fixed: SQL Server can shut down when you hit the max number of sessions SQL Server can shut...
Wed, 26 Feb, 2020 at 7:31 PM
Announcing SQL Server 2019 CU7, and Work Continues on Contained Availability Groups Among the fixes, Microsoft slipped in a new message ...
Fri, 4 Sep, 2020 at 5:44 PM
SQL Server 2017 Cumulative Update 22 Updates in this CU include: FIX: Managed backup is not backing up the database when SQL Agent system jobs are ch...
Sat, 12 Sep, 2020 at 6:57 AM
In this article, we will review how to migrate the data from on-premises SQL Server to AWS RDS for SQL Server using transactional replication. There are ...
Thu, 1 Oct, 2020 at 1:20 PM
Remember SQL Server 2019 CU7? Forget it. Here’s CU8. October 1, 2020 SQL Server 2019 CU7 didn’t go so well, and Microsoft pulled it. Ol...
Sat, 3 Oct, 2020 at 9:00 AM
Announcing 2016 Service Pack 3 and 2017 CU26 September 15, 2021 Brent Ozar SQL Server 2016, SQL Server 2017, Updates No Comments F...
Thu, 16 Sep, 2021 at 6:24 PM