The Voice of the DBA

The Cost of SQL Bits v the PASS Summit

• by Steve Jones

• The Voice of the DBA

UPDATE: This post originally priced Charlotte, NC, but the Summit is in Houston, TX. I have corrected costs and locations. The difference is about $300 less for a flight...

2020-01-22 (first published: 2020-01-13)

319 reads

Knocking Off for Six Weeks

• by Steve Jones

• The Voice of the DBA

This won’t be the last blog I write for six weeks, but it is the last one I’ll syndicate and in which write about technical stuff. Today is my...

2020-01-21 (first published: 2020-01-10)

341 reads

Running Powershell Scripts – #SQLNewBlogger

• by Steve Jones

• The Voice of the DBA

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. When you install Windows, by default, the execution...

2020-01-08

23 reads

Installing PowerShell for SQL Server – #SQLNewBlogger

• by Steve Jones

• The Voice of the DBA

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. PowerShell is the hot new scripting language for...

2020-01-09 (first published: 2019-12-27)

940 reads

Backwards Compatible Symmetric Keys in SQL Server 2017+

• by Steve Jones

• The Voice of the DBA

I discovered recently that there was a change made in SQL Server 2017 to the way that symmetric key passphrases are hashed. There’s a KB article that notes the...

2020-01-06 (first published: 2019-12-23)

312 reads

Using Parameters in #SQLPrompt

• by Steve Jones

• The Voice of the DBA

I am a big fan of snippets in SQL Prompt, often using them in demos to quickly get code written. However, I’ve liked the idea of snippets and templates...

2019-12-20

22 reads

Using a PoSh variable in a string- #SQLNewBlogger

• by Steve Jones

• The Voice of the DBA

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is something I haven’t quite understood or...

2019-12-18

68 reads

Unprepared for Travel

• by Steve Jones

• The Voice of the DBA

I’ve had a month off from travel, which has been nice. It’s been an interesting time catching up on things at home, and a nice break from the disruption...

2019-12-17

10 reads

A Smooth Laptop Setup

• by Steve Jones

• The Voice of the DBA

A little over a week ago, I got a new laptop. This was late on a Sunday afternoon, and I went home to spend time with me wife. After...

2019-12-16

200 reads

Prompt in ADS

• by Steve Jones

• The Voice of the DBA

Ever since VS Code and Azure Data Studio came out, people have been asking for SQL Prompt to port over. I’ve been right there with you, though unsure of...

2020-01-02 (first published: 2019-12-13)

226 reads