-->
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 2018

Update your production servers and stop making excuses about it

Folks, we all like to make sure we’re doing our level best to make things work smoothly. So why am I staring at someone’s server that has never been updated since it was first set up almost three years ago? Do better, so that I don’t have to yell at… Read more

0 comments, 167 reads

Posted in Born SQL with Randolph West on 27 June 2018

Dates and Times in SQL Server: DATENAME()

Last time we looked at DATEPART(). This post is all about the DATENAME() function. So many similarities There are many similarities between DATEPART and DATENAME. Where DATEPART returns the date or time part as an integer, DATENAME returns the part as a character string. This DATENAME function also takes two… Read more

0 comments, 681 reads

Posted in Born SQL with Randolph West on 20 June 2018

Dates and Times in SQL Server: DATEPART()

In my previous posts in this series we’ve seen reference to Transact-SQL (T-SQL) functions that are used to get the specific part of a date and/or time (year, month, day, hour, minute, second, etc.). This week we’ll go through one of them and see how it works. Introducing DATEPART, a… Read more

0 comments, 177 reads

Posted in Born SQL with Randolph West on 13 June 2018

T-SQL aside: replace PRINT with RAISERROR

I was minding my own business innocently reading a blog post by Erik Darling, when this tip smacked me in the proverbial forehead. I even learned something that had always bothered me but had been too lazy to investigate further. Tip #4: Know Your Place Don’t be afraid to use… Read more

2 comments, 990 reads

Posted in Born SQL with Randolph West on 6 June 2018