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: January 2019

Speaking at SQLBits in March 2019

I have been selected to speak for a second time at SQLBits, which is being hosted in Manchester UK this year from 27 February to 2 March 2019. My session is called An overview of SQL Server 2019 for the busy DBA / developer. Here is the abstract: SQL Server… Read more

0 comments, 216 reads

Posted in Born SQL with Randolph West on 30 January 2019

How does the buffer pool work?

Today we’ll begin taking a look at the buffer pool in SQL Server and how it’s normally used. Before we dive too deeply into the buffer pool, we need to remind ourselves of a few fundamentals of how computers process and store information, as that relates to how the buffer… Read more

0 comments, 174 reads

Posted in Born SQL with Randolph West on 23 January 2019

Database modelling in a post-SSMS world: dbForge Studio

A few months ago, Microsoft announced that SQL Server Management Studio (SSMS) will no longer include the visual Database Diagrams feature from v18.0 onward. When releasing a new version of a product, Microsoft has the luxury of referencing usage statistics, and obviously this is an underused feature of SSMS. I… Read more

3 comments, 213 reads

Posted in Born SQL with Randolph West on 16 January 2019

Back to the future

It’s January 2019 as I write this. I realized that I started on my journey with SQL Server in 1998, and I wanted to look at what’s changed through the lens of my career path. 1998 is the year I qualified as a Microsoft Certified Systems Engineer on the Windows… Read more

0 comments, 220 reads

Posted in Born SQL with Randolph West on 9 January 2019

AzCopy finally gets a sync option, and all the world rejoices

I consider Blob Storage to be the gateway drug to Azure, because it’s a really easy way to get going with offsite backups. One of the ways I’ve leveraged Blob Storage is with SQL Server backups. I even wrote a Sync and Restore command-line toolset to keep files and folders… Read more

0 comments, 203 reads

Posted in Born SQL with Randolph West on 2 January 2019