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

Repair Visual Studio for Mac: Extension node not found in path

A few months ago I ran into a problem after updating Visual Studio for Mac, where it would not start. The actual error message (which I retrieved from a log file) said: Extension node not found in path: /MonoDevelop/Core/WebCredentialProviders Knowing what I know about complex software, it was unlikely that… Read more

0 comments, 201 reads

Posted in Born SQL with Randolph West on 30 August 2018

A software architect replaces a relational database with a relational database

Content warning: This is the second (and final) rebuttal essay about why someone is wrong on the Internet. It is no doubt biased. It might go into technical detail. Parts of it may be wrong. It may contain flippant remarks and editorialising. There are links to external references that may… Read more

2 comments, 208 reads

Posted in Born SQL with Randolph West on 29 August 2018

Relational databases aren’t the problem

Content warning: This is the first of two rebuttal essays, about why someone is wrong on the Internet. It is no doubt biased. It might go into technical detail. Parts of it may be wrong. It may contain flippant remarks and editorialising. There are links to external references that may… Read more

14 comments, 3,104 reads

Posted in Born SQL with Randolph West on 22 August 2018

Do you even PowerShell, bro? An ode to dbatools and dbachecks.

Shall I compare thee to Management Studio? Thou art more scriptable and consistent. Those out-of-memory errors do tend to lose hours of work. And I mean, SSMS doesn’t run from the command line. Sometimes I get those line-endings errors, Not to mention IntelliSense bombing out; And figuring out which tab… Read more

0 comments, 269 reads

Posted in Born SQL with Randolph West on 15 August 2018

Why you should not use SELECT *

A shorter post this week, but an important one. Last week, Erik Darling commented on my post saying that we shouldn’t use SELECT *, which was both amusing and accurate. Amusing, because a number of the example T-SQL queries in that post made use of this construct. Why not? Why… Read more

2 comments, 429 reads

Posted in Born SQL with Randolph West on 8 August 2018

Don’t do these things in SQL Server

Recently Brent Ozar posted a link to the PostgreSQL “Don’t do this” page, which I am shamelessly reproducing below, re-tailored for a SQL Server audience. Don’t use -P with sqlcmd sqlcmd is a cross-platform interactive command-line utility that allows you to connect to a SQL Server (or Azure SQL Database)… Read more

7 comments, 474 reads

Posted in Born SQL with Randolph West on 1 August 2018