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,362 reads
Version
Get Server version Info
Yet another Script To get Sql server version Info. Run From Central Management server to get all your environment servers
2015-09-29 (first published: 2015-09-10)
1,738 reads
All SQL Version info in one function
This function returns all the necessary version information in a table.
2012-05-28 (first published: 2012-03-21)
3,165 reads
Blogs
A New Word: La Guadière
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
Microsoft Purview data governance best practices
By James Serra
Microsoft Purview can be the best data governance tool in the world, but it...
AI Insights for Database Monitoring: A DBA’s Perspective
By Arun Sirpal
Second in a series on Ai and databases. One Story, three signals – I...
Forums
PolyBase Trace Flags
Are there any good articles on all the trace flags that are enabled on...
The Data Model Matters
Comments posted to this topic are about the item The Data Model Matters
Understanding SQL Server PARTITION BY with Examples
Comments posted to this topic are about the item Understanding SQL Server PARTITION BY...
Question of the Day
Running SQLCMD I
I run the SQLCMD utility as follows:
lcmd -S localhost -EI then type this (the 1> is the prompt):
1> select @@version goIf I hit enter, what happens? See possible answers