SQLStudies

Stop #AzureDataStudio from opening a connection screen on startup

• by Kenneth Fisher

• SQLStudies

When I’m working with a tool I like a clean startup. And by that I mean don’t automatically open anything. ... Continue reading

2020-02-24

3 reads

Set a variable and update a column at the same time.

• by Kenneth Fisher

• SQLStudies

The other day I saw a weird option for the UPDATE command in a stack overflow answer. Basically it looked ... Continue reading

2020-02-19

25 reads

#PowershellBasics: Run a file and pass it a parameter.

• by Kenneth Fisher

• SQLStudies

I realized in my last #PowershellBasics post that I was talking about running a file and passing in an optional ... Continue reading

2020-02-25 (first published: 2020-02-17)

311 reads

Is it really that hard to be polite, kind and respectful of those around you?

• by Kenneth Fisher

• SQLStudies

I dislike the term Politically Correct. Not because the original idea of it is a bad one, but it’s been ... Continue reading

2020-02-13

34 reads

Configure your tools : T-SQL Tuesday #123

• by Kenneth Fisher

• SQLStudies

Happy T-SQL Tuesday! Thanks for hosting this month Jess Pomfret (blog|twitter) and great topic. Life Hacks. There is one thing ... Continue reading

2020-02-18 (first published: 2020-02-11)

553 reads

#PowershellBasics: Get input using Read-Host

• by Kenneth Fisher

• SQLStudies

Conditions are the life blood of programming. This condition is met so now I need to do this task. That ... Continue reading

2020-02-11 (first published: 2020-02-05)

447 reads

SQL Homework – February 2020 – Write a blog post.

• by Kenneth Fisher

• SQLStudies

Following along with last month’s documentation homework this month I want you to write a blog post. But Ken, what ... Continue reading

2020-02-07 (first published: 2020-02-03)

265 reads

Insperation

• by Kenneth Fisher

• SQLStudies

Inspiration: The process of being mentally stimulated to do or feel something, especially to do something creative. a person or ... Continue reading

2020-01-29

8 reads

CREATE TABLE MyTable (Col1 CHARACTER VARYING (50))

• by Kenneth Fisher

• SQLStudies

If you read the title to this post and your first thought was That’s not SQL is it? then you ... Continue reading

2020-02-05 (first published: 2020-01-27)

794 reads

Changing the owner of a schema removes all direct permissions of objects owned by the schema.

• by Kenneth Fisher

• SQLStudies

This is one of those things that probably doesn’t happen all that often, but bit me in the … elbow ... Continue reading

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

336 reads