 | A community of more than 1,600,000 database professionals and growing |
| | | How Much Code Can You Review? When I was in college, I mostly wrote my own code for assignments (and fun), turning it in when I thought it was done. At some point I had a class that started to adopt more software engineering practices, and I was forced to get my code reviewed by a peer before handing it in. This was an interruption to my workflow (and more work since I had to review other code), but it did allow find mistakes I had made and seemed to improve my grade. In one of my first development positions, I had to get two people to review my code before I could submit it for deployment. A humbling and painful process at first, but over time I became used to the idea. I'm not sure the quality of code improved, but it was more readable, more in-line with everyone else's code, and as we learned techniques that worked well, all developers adopted them quickly. These days as I talk with various customers and clients, I find that code reviews are handled very inconsistently. Some companies require them, some have automated processes, some have ad hoc reviews, and everyone has ways to circumvent the system. Certainly emergency patches need to be made at times, often with little review, but I will say that it seems the more common a set process and practice is, the less issues a customer has. If you review code, or have your own code reviewed, on a regular basis, I have question for you. How much code can you review for a deployment? The question I'm asking is about your process and habits. Is it worth reviewing every bit of code? Perhaps there are objects that you don't worry about as much as others, or certain developers that receive more (or less) review of their code. Perhaps seniority makes a difference as to the level of scrutiny. If there are problems found in QA and changes made, is there a way to re-review code? I'm wondering today about your process. Share what you can, and if you want to do it anonymously, please feel free to send me a note at sjones (at this domain). Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
| The Voice of the DBA Podcast Listen to the MP3 Audio ( 5.0MB) podcast or subscribe to the feed at iTunes and Libsyn.  The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. |
|
|
|
| | ADVERTISEMENT |  | | Find SQL in your database for free For example, want to rename one of your table columns but are not sure what stored procedures reference it? Using Redgate’s free SSMS add-in, SQL Search, you can search for the column name and find all the stored procedures that use it. Find out more and download now. |
| |  | | Watch SQL in the City Streamed session videos Redgate’s recent virtual event broadcast to over 3000 database professionals worldwide. If you didn’t manage to tune-in, or you’d like watch again, the video recordings are now available. Find out more and watch the session videos on demand. |
|
|
|
| | |  | Additional Articles from SimpleTalk Because it is important with maintaining Virtual Machine environments to be able to repeat routine tasks completely accurately, Windows PowerShell has grown in importance for the job. Now you can manage the Hyper-V environment via PowerShell without needing to use the Hyper-V Manager console. It opens up many opportunities for automation. More » |
 | Tim Mitchell from SQLServerCentral Blogs The FTP protocol is one of the oldest methods for sharing and moving files. Although frequently considered to be an “old-school”... More » |
| | Dear All, After a short break, we are back with the 3rd interview on #DataChannel. Mr.Hamish Watson, Community Lead from Christchurch,... More » |
|
|
| | | Today's Question (by Steve Jones): There are a number of enhancements in SQL Server 2016 that speed up the instance and improve performance. What is an improvement on the secondary that helps keep the secondaries in sync with the primary? |
Think you know the answer? Click here, and find out if you are right.
We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: Availability Groups (AG). We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center. |
|
|
| |
| ADVERTISEMENT | | Power Query for Power BI and Excel Power Query for Power BI and Excel is a book for people who are tired of copying and pasting data into Excel worksheets. Power Query, part of the Microsoft Power BI suite, is a tool that automates the process of getting data into Excel and will save you hours of dull, repetitive, and error-prone work! Power Query makes it easy to extract data from many different data sources, filter that data, aggregate it, clean it and perform calculations on it, finally loading that data into either your worksheet. Get your copy from Amazon today. |  |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I have a SQL Server production instance that crashed and Windows rebooted. When the host restarts, SQL Server does not start. The error in the error log says that the T:\SQLServer\Tempdb\tempdb.mdf file cannot be found. As I examine the system, I realize that the T: drive is corrupted and is no longer accessible. I cannot replace this drive right now, but I do have enough space on my d: drive to host the tempdb files. How can I move the tempdb location?
Answer: Start SQL Server in single user mode with -f as a startup parameter, connect to the instance and issue an ALTER DATABASE command to move the files. Explanation: The way to solve this quickly is by starting SQL Server in minimal configuration mode with the -f parameter. Then you can connect with a single connection and alter the tempdb database. Ref: Start SQL Server with Minimal Configuration - https://msdn.microsoft.com/en-us/library/ms186400.aspx
» Discuss this question and answer on the forums |
|
|
| Database Pros Who Need Your Help |
| Here's a few of the new posts today on the forums. To see more, visit the forums.
Help with ranking functions - Greetings all :). Ranking/Row functions always seem to throw me off. Hoping I can get a hand in what is probably... Update flags to values - I've been off sick for a few days and it seems to have taken a toll on my problem-solving skills.... Get data into a table - Hi I have two tables create table Students (StudentID int not null , Name nvarchar(20)) insert into Students values (101111 , 'XYZ'), (101112 , 'Ben') , (101113... Query with multiple conditions (SQL 2016) - Experts i am getting error while i execute the query , error " Msg 144, Level 15, State 1, Line 17" Cannot use... JSON from within a table - Hi there, I can successfully parse JSON from a file based on some examples that are out there. However, I'm having a...
Int vs Bigint - Hello Everyone, Quick question, we are building a new OLTP system and for all transaction tables i am declaring the primary... Semantics of simple-seeming UPDATE statement with FROM clause - Dear Experts I am very unhappy with my current understanding of the UPDATE T-SQL statemet in SQL Server. Specifically, there are... After an in place upgrade, what next? - I have done many in place upgrades but never was asked this question as I never thought about it. Can...
Convert number stored as text to number - Hi, I am very new when it comes to T-SQL. I need some assistance. Another person wrote a query to extract... Parent child hierarchy - Hi, I want the TaskName field to show Hierarchy in the order with further indentation of the child . + SuperTask -- SubTask ... Create SQL FullText statement via VB.Net - I am trying to create a dynamic SQL statement that uses CONTAINS but I am stuck with double quotes ('"') issue. Here... Restore database with move - Hi everybody, I have a script to restore a database with move. I do not have a database yet for this... Comma separated list - Hi, I need a comma separated list . CREATE Converting Stored Procedure to Function - Is it easy to convert SP to Function ,vice versa Function to SP ? What are the limitations for that? Can...
TSQL - Aggregate Bitwise - Greetings all - I have a query I need to write and was wondering if anyone could give me a suggestion... SQL Server Error S1T00 - Hello there. My company converted to SQL Server 2008 R2 as the backend for its inventory database about a month...
Error converting data type nvarchar to numeric - I am at my wits end. I have a stored procedure that gives me the error converting data type nvarchar...
Log Shipping across two non-domain related networks - restore error - Hi, I have a need to setup log shipping across two networks thathave no domain relationship. They aretwo separate work groups....
SSIS - Stop parent based on child data - It's been a few years since I've done any real SSIS; back when 2008 was new, so really 2005 was...
SSC Forum Updates - Hi all Can you post questions, issues, etc. with the revised forums in this thread? We're going to keep track of... |
|
| This email has been sent to newsletter@newslettercollector.com. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com.
| This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.
| This transmission is ©2015 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com |
|
|
