Randolph West

Randolph West is the Microsoft Docs content lead for SQL Server on Linux, and SQL migrations. A former Microsoft Data Platform MVP who has worked with SQL Server since the late 1990s, Randolph solves technology problems with a focus on SQL Server and C#. You can also see Randolph acting on the stage and screen, or doing voices for independent video games.

Twitter: @_randolph_west
Website: https://bornsql.ca/blog/
LinkedIn: https://linkedin.com/in/rabryst/

Dates and Times in SQL Server: more functions you should never use

by Randolph West

Born SQL with Randolph West

Previously we looked at four built-in functions to get the current date and time in SQL Server and Azure SQL...

2018-05-23 (first published: 2018-05-16)

3,879 reads

Virtual Log Files: 200 or 1000?

by Randolph West

Born SQL with Randolph West

Last week I had the privilege of reviewing possibly the best SQL Server production environment I’ve seen in Canada. During...

2018-05-23

470 reads

A big thank you

by Randolph West

Born SQL with Randolph West

Thank you! Thank you for reading my blog. Thank you for buying my book. Thank you for attending my sessions...

2018-05-09

244 reads

Dates and Times in SQL Server: What about TIMESTAMP?

by Randolph West

Born SQL with Randolph West

It occurred to me that we haven’t covered the TIMESTAMP data type in this series about dates and times. TIMESTAMP...

2018-05-02

260 reads

Dates and Times in SQL Server: T-SQL functions to get the current date and time

by Randolph West

Born SQL with Randolph West

We have come on quite a journey so far. SQL Server and Azure SQL Database provide date and time data...

2018-04-25

382 reads

Dates and Times in SQL Server: the science of time redux

by Randolph West

Born SQL with Randolph West

Last time, we began an in-depth look at how time is measured. This post continues our journey. If any of...

2018-04-18

478 reads

Dates and Times in SQL Server: the science of time

by Randolph West

Born SQL with Randolph West

Now that we have covered the various date and time data types (see the post from last time) in SQL...

2018-04-11

851 reads

Speaking at SQLSaturday #710 in Edmonton on May 5th, 2018

by Randolph West

Born SQL with Randolph West

I will be presenting twice at SQLSaturday #710 in Edmonton, on 5 May 2018. You can join me for two...

2018-04-04

277 reads

Dates and Times in SQL Server: DATETIMEOFFSET

by Randolph West

Born SQL with Randolph West

This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data...

2018-03-28

701 reads

Dates and Times in SQL Server: DATETIME2

by Randolph West

Born SQL with Randolph West

This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data...

2018-03-21

333 reads

Blogs

My 2024 in Data: Music

This is my last week of the year working (I guess I come back...

A New Word: Suente

suente– n. the state of being so familiar with someone that you can be...

Side Projects

By Andrew Pruski

Anyone (everyone?) who has ever tried to learn a programming language knows that to...

Read the latest Blogs

Forums

Automating Export of PowerQuery to SQL Server using DAX Studio...?

I wrote a PowerQuery that parses a table from a PDF, and I want...

Attaching an SQL Server database without Transaction Log Files through SQL Server Management Studio.

Comments posted to this topic are about the item Attaching an SQL Server database...

Superseded Indexes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Superseded Indexes

Visit the forum

Question of the Day

Superseded Indexes

Which of these indexes is superseded by another?

See possible answers