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.

2019-02-05

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!

2015-09-15

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.

2014-01-14

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

You rated this post out of 5. Change rating

2004-12-17

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 Member.id, Member.name FROM ((Member LEFT JOIN Activity ON […]

2004-08-12

Blogs

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Snowflake + Azure blob

By

Let’s go back to data platforms today and I want to talk about a...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers