Microsoft SQL Server Utilities and Tools
Useful free and paid utilities and tools for Microsoft SQL Server - complete list of 275 Utilities
2020-06-02 (first published: 2020-05-26)
23,192 reads
Konstantin Taranov
SQL Server Name Convention and T-SQL Programming Style
There are only two hard things in Computer Science: cache invalidation and naming things -- Phil Karlton The recommendations in this article are not the ultimate truth. Please consider this article as a rule template that you can adapt to your needs. A naming convention is a set of rules for choosing the character sequence to […]
2019-12-10
9,023 reads
SQL Server Management Studio Tips
A complete guide to the hidden gems of SQL Server Management Studio (SSMS), covering shortcuts, tips and tricks, useful scripts, and more.
2019-03-22 (first published: 2017-08-14)
11,982 reads
SQL Server Trace Flags - Complete list
This article is a complete list of all SQL Server trace flags - 593 trace flags.
2019-02-14 (first published: 2017-02-23)
29,374 reads
SQL Server Management Studio add-ins
Complete list of useful and must have add-ins for SQL Server Management Studio - 34 SSMS add-ins
2019-01-31 (first published: 2017-07-21)
16,849 reads
Blogs
Daily Coping 18 Sep 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Optimize for Unknown for Inline Table-Valued Functions
I had a curious performance issue today. An inline table-valued function (iTVF) was performing...
Daily Coping 17 Sep 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
SQL Server 2016 seeding automatic stuck
Hi all, Problem help please, I have 2 servers in sql server 2016 and...
will this get replicated to secondary replica
Dear Experts, In Availability Group, if we move ndf file to another drive on...
slow query performance
Hi All, I have a SELECT query which is taking more 8 mins. Can...
Ask SSC