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,255 reads
This script allows you to compare patch levels across instances.
2021-10-25 (first published: 2021-10-21)
1,255 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,831 reads
Learn how to get Windows Authentication working on an Ubuntu SQL Server on Linux instance.
2020-09-08
3,923 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
686 reads
2018-04-17
756 reads
2018-03-20
721 reads
2018-03-19
814 reads
2018-03-15
820 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
863 reads
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
By alevyinroc
It seems like no matter how long you work with a system beyond a...
By Steve Jones
I started a short thread on Twitter/X and Bluesky recently after leaving the Tesla...
I have an execute task(has server list from a table) pointing to foraeachloop foreachloop...
In the ss below you can see that I have a table (dbo.clan.spouses) with...
hi i imported a tabular model from production into vs 2022, changed the data...
I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).
BACKUP DATABASE [complex] FILE = N'thirdone' , FILE = N'thirdtwo' , FILEGROUP = N'second' TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak' WITH NOFORMAT, NOINIT, NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10 GOSee possible answers