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

Giving thanks in 2018

It’s the last post of 2018, and in years past I’ve recapped the year that has just been. This is a little different however. I want to talk a bit about community, and two unexpected interactions I’ve had this month. As some of you know, I have an interest in… Read more

0 comments, 187 reads

Posted in Born SQL with Randolph West on 26 December 2018

Infrastructure matters, even in the Cloud

I am still amused by terminology in the Information Technology field. Words like “Kubernetes,” “containers,” and the BASIC keywords PEEK and POKE, all bring a smile to my lips every time I read or say them. Equally amusing are marketing ideas, except they may have a little sting at the… Read more

0 comments, 269 reads

Posted in Born SQL with Randolph West on 19 December 2018

Some databases may show a NULL collation in the sys.databases DMV

While working on my Swart’s Ten Percent Rule post last week, I needed to test the Windows version of the script on my SQL Server 2016 instance. Just before removing all the databases, I noticed something interesting when querying the sys.databases Dynamic Management View (DMV). Because the process I had… Read more

0 comments, 180 reads

Posted in Born SQL with Randolph West on 12 December 2018

Flagrantly ignoring the 10% rule

My friend Michael J. Swart has a rule of thumb he calls Swart’s Ten Percent Rule. If you’re using over 10% of what SQL Server restricts you to, you’re doing it wrong. After a recent discussion on Twitter, I wondered what it would look like if I had 32,767 databases… Read more

0 comments, 197 reads

Posted in Born SQL with Randolph West on 5 December 2018