The Last SQL Server Service Pack
SQL Server 2016 SP3, the last service pack ever is out. Steve comments on how the world of software patches has changed.
2021-10-08
477 reads
SQL Server 2016 SP3, the last service pack ever is out. Steve comments on how the world of software patches has changed.
2021-10-08
477 reads
A failed SQL Server Service Pack upgrade is fixed with a trace flag.
2020-07-27
5,353 reads
Learn a few possible solutions to a frustrating issue when you attempt to patch a SQL Server installation.
2018-12-07 (first published: 2016-01-11)
8,470 reads
Microsoft has continued to release Cumulative Updates, with each one specifying that customers should wait for the next service pack if they don't experience an issue. However, no Service Packs have been released for some time. Let Microsoft know we want Service Packs.
2014-03-06 (first published: 2014-02-28)
4,471 reads
2010-09-30
5,572 reads
2010-01-04 (first published: 2009-12-30)
1,691 reads
2010-01-15 (first published: 2009-12-28)
82 reads
2008-04-24 (first published: 2008-02-28)
1,846 reads
Service Pack 3 for SQL Server 2000 is huge. There are significant changes in it and they apply to all three products: the core SQL Server, MSDE, and Analysis Services. Because there are so many changes, this first article in the series will only focus on the security changes.
2007-09-22 (first published: 2003-06-05)
30,074 reads
There may be more ways than you realize to determine the version and service pack of SQL Server. This quick article by Dinesh Priyankara will show you 3 of those methods.
2003-02-28
22,044 reads
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on...
Hi, I have SQL Server 2019 installed and when go the Clear Trace database...
Hello I need to get txt files from directory and send email, when I...
Hello, I have a question regarding Availability group server architecture. A little background: We...
Let’s consider the following script that can be executed without any error on both SQL Sever and PostgreSQL. We define the table t1 in which we insert three records:
create table t1 (id int primary key, city varchar(50)); insert into t1 values (1, 'Rome'), (2, 'New York'), (3, NULL);If we execute the following query, how will the records be sorted in both environments?
select city from t1 order by city;See possible answers