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: July 2017

Acids and Databases: A look at ACID and transactions

Relational database management systems (RDBMS) such as SQL Server, Oracle, MySQL, and PostgreSQL use transactions to allow concurrent users to select, insert, update, and delete data without affecting everyone else. An RDBMS is considered ACID-compliant if it can guarantee data integrity during transactions under the following conditions: ACID Atomic –… Read more

0 comments, 134 reads

Posted in Born SQL with Randolph West on 26 July 2017

What is a good Disaster Recovery Plan?

During a Q&A session I hosted at our local Calgary SQL Server User Group last month, one of the attendees mentioned an interview question he’d had and wanted to hear my thoughts. How would you design a disaster recovery solution for a 1 TB database, using Simple Recovery Model? Replication… Read more

5 comments, 139 reads

Posted in Born SQL with Randolph West on 19 July 2017

Be Wary of Date Formatting in T-SQL

Today’s public service announcement is a reminder to be wary of date formatting in SQL Server. On a recent mailing list discussion, one person demonstrated the following code (which I’ve adapted for this post): SET LANGUAGE 'us_english'; GO DECLARE @StartDate DATETIME = '2017-07-12'; SELECT @StartDate; GO DECLARE @StartDate DATE =… Read more

2 comments, 142 reads

Posted in Born SQL with Randolph West on 12 July 2017

Balanced Power Saving T-SQL script

We can easily spend tens of thousands of dollars on core licences for SQL Server, and then we go and install the product on an operating system with the default Balanced Power Plan, which is, well, idiotic. Imagine buying one of the fastest road cars money can buy (a Bugatti… Read more

2 comments, 156 reads

Posted in Born SQL with Randolph West on 5 July 2017