SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Born SQL with Randolph West

Randolph West solves technology problems with a focus on SQL Server and C#. He is a Microsoft Data Platform MVP who has worked with SQL Server since the late 1990s. When not consulting, he can be seen acting on the stage and screen or doing voices for independent video games.

Archives: June 2017

Where To From Fundamentals?

The Database Fundamentals series is now done. We started with understanding what a database is, and then spent a little time understanding how databases store text, known as collation. The next step was understanding data types in general, and how SQL Server stores them. After that was understanding normalization, with… Read more

0 comments, 334 reads

Posted in Born SQL with Randolph West on 28 June 2017

Why You Need A Test Environment

In 2017, there’s no excuse not to have at least a testing environment, and preferably a development environment as well, in order to create and deploy code changes (software, database, you name it) outside of a production environment. If you’re making changes in a production environment without testing them first,… Read more

0 comments, 130 reads

Posted in Born SQL with Randolph West on 21 June 2017

How to write a DELETE query

My First DELETE Statement Here are the links to the previous posts in this series: My First SELECT Statement My First INSERT Statement My First UPDATE Statement This week is a much shorter post, where we will learn how to remove data from a table using a DELETE statement. We… Read more

2 comments, 132 reads

Posted in Born SQL with Randolph West on 14 June 2017

How to write an UPDATE query

My First UPDATE Statement Last week we covered how to put information into a table using an INSERT statement. This week we will learn how to make changes to data that is already in a table using an UPDATE statement. We are also going to learn all about why the… Read more

0 comments, 118 reads

Posted in Born SQL with Randolph West on 7 June 2017