SQLStudies

#PowershellBasics: Get-Help -Online

• by Kenneth Fisher

• SQLStudies

One of the other things I learned from the Powershell class I’m taking this week is that there is an ... Continue reading

2019-10-21

5 reads

#PowershellBasics: Multiple run spaces in ISE

• by Kenneth Fisher

• SQLStudies

As you know from the last few posts, I’m in a class on Powershell. One of the first things we ... Continue reading

2019-10-23 (first published: 2019-10-16)

9 reads

#PowershellBasics: The Windows Powershell icon in the task bar also lets you run Powershell ISE.

• by Kenneth Fisher

• SQLStudies

I don’t know about you, but I like having the tools that I’m likely to use on my taskbar. That ... Continue reading

2019-10-14

10 reads

#PowershellBasics: Powershell vs Powershell Core

• by Kenneth Fisher

• SQLStudies

I’m taking a Powershell class this week and I have to say the teacher is one of the best I’ve ... Continue reading

2019-10-10

234 reads

Using 3rd party tools. T-SQL Tuesday #119

• by Kenneth Fisher

• SQLStudies

It’s that time again! Alex Yates (b/t) has asked us to discuss a time in tech when we’ve changed our ... Continue reading

2019-10-11 (first published: 2019-10-08)

416 reads

SQL Homework – October 2019 – Code review (self and peer)

• by Kenneth Fisher

• SQLStudies

Every database person I’ve ever met writes at least some code at some point in their career. That code might ... Continue reading

2019-10-14 (first published: 2019-10-02)

468 reads

See SQL Run 2

• by Kenneth Fisher

• SQLStudies

Note: I am perfectly aware of my ability as an artist so let the ribbing begin ??

2019-09-30

16 reads

Blogging and coding best practices

• by Kenneth Fisher

• SQLStudies

I had a discussion a while back, I think it was with Grant Fritchey (b/t) but I just can’t remember. ... Continue reading

2019-09-25

12 reads

Debugging techniques (focusing on T-SQL)

• by Kenneth Fisher

• SQLStudies

tl;dr; Add PRINT and/or SELECT statements. Comment/uncomment out pieces of code to isolate problems. Change INSERT/UPDATE/DELETE statements to SELECTs. Disclaimer: ... Continue reading

2019-10-07 (first published: 2019-09-23)

713 reads

When using Powershell to control Azure the Cloud Shell doesn’t require an additional login.

• by Kenneth Fisher

• SQLStudies

When studying Azure one of the things you’ll be asked to learn is the Powershell commands that can control, well, ... Continue reading

2019-09-18

28 reads