Compare Patch levels across all installed sql instances
This script allows you to compare patch levels across instances.
2021-10-25 (first published: 2021-10-21)
1,138 reads
This script allows you to compare patch levels across instances.
2021-10-25 (first published: 2021-10-21)
1,138 reads
Recently I was installing SQL Server 2017 and I could not believe a simple installation took up my whole day. I was installing an instance on one newly built Windows 2012 R2 server. After clicking next a few times, I got an error: a rule failure, for KB2919355. I downloaded the KB2919355 as mentioned in […]
2020-09-14
7,058 reads
Learn how to get Windows Authentication working on an Ubuntu SQL Server on Linux instance.
2020-09-08
3,814 reads
Learn how to build a SQL Server Configuration file from the Installation Center and then use this configuration file for subsequent installations.
2020-05-21
2018-05-31
680 reads
2018-04-17
748 reads
2018-03-20
713 reads
2018-03-19
804 reads
2018-03-15
812 reads
The steps required to create an Amazon Web Services EC2 instance and install the latest SQL Server version on the EC2.
2017-03-16
826 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers