Code Review

External Article

Better Code Reviews with GIT

  • Article

As more dev teams move their code to Git, it’s important to understand the differences between it and other tools they have used in the past. In this article, Michael Sorens provides some good advice about doing code reviews with Git.


3,221 reads

External Article

The Zen of Code Reviews: Best Practices

  • Article

If you don't feel that you are getting helpful and comprehensive feedback from code reviews, it may well be your fault. Unless you are considerate to your reviewers in a number of ways, they might find it difficult to check your code and provide helpful advice. What ways? Michael Sorens outlines the eight golden rules that, if you follow them, might even even make your code a pleasure to review!


6,927 reads

External Article

SQL Enlight for SQL Server Management Studio

  • Article

The process of doing SQL code-reviews used to be tedious and error-prone. Until SQL Enlight, it was a process that was difficult to automate for release and deployment. As it is now both a Command-line utility and an SSMS add-in, the database developer can see immediately the parts of the code that would raise eyebrows with the vigilant production DBA.


4,134 reads

Technical Article

Using Case in a Where Clause ???

  • Topic

I get this error when trying to execute the following code:Server: Msg 245, Level 16, State 1, Line 7 Syntax error converting the nvarchar value 'Nancy' to a column of data type int.DECLARE @Name varchar(30), @Firstname varchar(30), @ID intSET @Name = 'y' -- 'y' = get info by firstname, 'n' = get info by employeeid […]


Technical Article

RE: query join, two many-to-many relationships

  • Reply

Here you want a member that has Activity code Coordinator and Business codes code1 AND code2. The way to do this is to LEFT JOIN to Business twice, in effect to two 'copies' of Business, once to look for code1 and once to look for code2:SELECT DISTINCT, FROM ((Member LEFT JOIN Activity ON […]



Daily Coping 6 Dec 2022


Today’s coping tip is to find a new way to tell someone you appreciate...

What’s next: Job search burnout


I was given 4.5 months notice this past June and was fortunate to find...

InvalidAbfsRestOperationException in Azure Synapse notebook


Problem The first issue that developers in my team noticed was when they tried...

Read the latest Blogs


SSRS Expression Error

By Jeffs1977

I am getting the following error when I try to use the Expression below....

Multitenant architecture

By mto89

Hi all, i have to refactor an existing database multi-tenant. All tables should be...

log shipping restore from primary server backup directory

By sqlfriend

To understand the concept of transaction log shipping, in below case, will it work:...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers