Install

SQLServerCentral Article

Change the Instance Collation by Rebuilding Databases in SQL Server 2017

  • Article

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 […]

5 (1)

2020-08-03

10,179 reads

Blogs

Daily Coping 4 Jul 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

SQLServerCarpenter Tools

By

Over the past couple of years, I’ve developed several tools that I’ve been using...

usp_SQLServerCarpenter_Tools_Get_Procedures_Triggers_Missing_SET_NOCOUNT_ON

By

/* Author:Brahmanand Shukla (SQLServerCarpenter.com) Date:27-May-2022 Purpose:To get all the stored procedures and triggers missing the use of...

Read the latest Blogs

Forums

Drop database on Secondary Node from Primary for automatic restore job

By dennis.miller 20021

hi all We've ventured into the world of AAG's as we have now moved...

Which table design is better ?

By Johnson330

Hi, I have a scenario where a worker can do multiple training courses each...

Combine tables with SQL in power bi

By pedroccamara

Hello everyone, i hope everyone is fantastic!! I've done some SQL queries in power...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers