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

Price increase for Azure in Canadian dollars

On 1 December 2018, Microsoft is increasing Azure subscription prices in Canadian dollars by 5%. The following is taken directly from the email I received on 1 November 2018. Starting December 1, 2018, prices for Azure services in the Canadian dollar will increase by 5 percent to more closely align… Read more

0 comments, 226 reads

Posted in Born SQL with Randolph West on 28 November 2018

Dates and Times in SQL Server: DATEDIFF() and DATEDIFF_BIG()

Last time we looked at adding or subtracting date parts using the DATEADD() T-SQL system function. This week we see how to calculate the difference between two date-time values using DATEDIFF() and DATEDIFF_BIG(). The syntax for both functions is identical: [crayon-5c993dfbaae77411786716/] The only functional difference between them is that the… Read more

0 comments, 346 reads

Posted in Born SQL with Randolph West on 21 November 2018

Dates and Times in SQL Server: DATEADD()

We are now in the home stretch of the long-running series about dates and times in SQL Server and Azure SQL Database. This week we look at one of my favourite T-SQL functions when it comes to dates and times: DATEADD(). Syntax As with similar functions, DATEADD can do arithmetic… Read more

0 comments, 211 reads

Posted in Born SQL with Randolph West on 14 November 2018

PASS Summit Speaker Idol 2018

This scheduled post is coming to you from Seattle, where the PASS Summit 2018 has just kicked off. Because it is a scheduled post, I have no idea what announcements from the convention will be made today and tomorrow, but rest assured that they will be worth looking at. In… Read more

0 comments, 185 reads

Posted in Born SQL with Randolph West on 7 November 2018