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
Code reviews are a part of many developers' lives, but is there a limit to what you can do effectively?
2017-01-27
91 reads
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
Read and document multiple SSIS packages in an Excel file. The document can be used to do further code analysis.
2016-11-04 (first published: 2015-09-01)
16,193 reads
Code must be checked, but how? Phil Factor shares his thoughts on automating SQL code reviews.
2015-07-27
5,104 reads
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
Today we have a guest editorial from Hakim Ali. Today Akim talks about why holding back out of politeness in code reviews may be a self-defeating practice.
2012-08-06
343 reads
It is possble if both server are on. open package in design mode. go in package and use save as option. There you give new server name, username & password. hope this will solve your problem
2005-05-18
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 […]
2004-12-17
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
By Steve Jones
Today’s coping tip is to find a new way to tell someone you appreciate...
I was given 4.5 months notice this past June and was fortunate to find...
By Kamil
Problem The first issue that developers in my team noticed was when they tried...
I am getting the following error when I try to use the Expression below....
Hi all, i have to refactor an existing database multi-tenant. All tables should be...
To understand the concept of transaction log shipping, in below case, will it work:...
Ask SSC