Quickstart: Connect SQL Server machines to Azure Arc
Get started with Azure Arc-enabled SQL Server to manage and govern your Windows and Linux SQL Server instances hosted across on-premises, edge, and multicloud environments.
2023-09-06
Install
Change the Instance Collation by Rebuilding Databases in SQL Server 2017
As a part of my DBA activities, I do a lot of SQL Server installations every week. Most of the time, I install the instance with the default collation. A collation is a configuration setting in SQL Server that determines how the database engine should read the data. SQL Server has huge list of collations […]
2022-12-26 (first published: 2020-08-03)
15,647 reads
SQL Server 2012 does not come up after service pack upgrade SP4
A failed SQL Server Service Pack upgrade is fixed with a trace flag.
2020-07-27
5,000 reads
2011-07-29
2,429 reads
Blogs
Get Configuration Change History From the SQL Server Error Logs
By SQLPals
Get Configuration Change History From the SQL Server Error Logs There...
A NEW’er Solution For An Old Problem: How To Gain Access To SQL Server When No DBA Around
By SQLPals
How To Gain Access To SQL Server When No DBA ...
Forums
Gentlest of Reminders, Don't Stop Learning
Comments posted to this topic are about the item Gentlest of Reminders, Don't Stop...
table with varcahar(max)
Gurus, there is a table which is very slow to query , it has...
Query goes crazy.
Hi. I have a query that returns few rows (out of 7 table join,...
Ask SSC