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)
25,291 reads
Konstantin Taranov
- Interests: SQL, R, Reading
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
10,478 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)
12,458 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)
32,470 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)
18,024 reads
Blogs
Goal Progress–November 2020
By Steve Jones
This is my report, which continues on from the Oct report. It’s getting near...
Azure Synapse Analytics is GA!
By James-Serra
(Note: I will give a demo on Azure Synapse Analytics this Saturday Dec 5th...
5 Things You Should Know About Azure SQL
By John
Azure SQL offers up a world of benefits that can be captured by consumers...
Forums
Get data from last line and merge into data stream before removing
This script reads thru a file and removes the last line, but before it...
Firewall access for Availability Group listeners
Hello experts, I have a noob question as I never feel like I understand...
conversion of excel formula to case statement in tsql
Hi all, need your help on conversion of excel formula into case statement. i...
Ask SSC