Category Archives: SQLServerPedia Syndication
-
Stop #AzureDataStudio from opening a connection screen on startup
1February 24, 2020 by Kenneth Fisher
When I’m working with a tool I like a clean startup. And by that I mean don’t automatically open anything. …
Continue reading -
Set a variable and update a column at the same time.
11February 19, 2020 by Kenneth Fisher
The other day I saw a weird option for the UPDATE command in a stack overflow answer. Basically it looked …
Continue reading -
#PowershellBasics: Run a file and pass it a parameter.
Leave a commentFebruary 17, 2020 by Kenneth Fisher
I realized in my last #PowershellBasics post that I was talking about running a file and passing in an optional …
Continue reading -
Configure your tools : T-SQL Tuesday #123
5February 11, 2020 by Kenneth Fisher
Happy T-SQL Tuesday! Thanks for hosting this month Jess Pomfret (blog|twitter) and great topic. Life Hacks. There is one thing …
Continue reading -
#PowershellBasics: Get input using Read-Host
Leave a commentFebruary 5, 2020 by Kenneth Fisher
Conditions are the life blood of programming. This condition is met so now I need to do this task. That …
Continue reading -
SQL Homework – February 2020 – Write a blog post.
1February 3, 2020 by Kenneth Fisher
Following along with last month’s documentation homework this month I want you to write a blog post. But Ken, what …
Continue reading -
Insperation
2January 29, 2020 by Kenneth Fisher
Inspiration: The process of being mentally stimulated to do or feel something, especially to do something creative. a person or …
Continue reading -
CREATE TABLE MyTable (Col1 CHARACTER VARYING (50))
Leave a commentJanuary 27, 2020 by Kenneth Fisher
If you read the title to this post and your first thought was That’s not SQL is it? then you …
Continue reading -
Changing the owner of a schema removes all direct permissions of objects owned by the schema.
1January 22, 2020 by Kenneth Fisher
This is one of those things that probably doesn’t happen all that often, but bit me in the … elbow …
Continue reading -
Common commands and tasks to make dealing with Windows Core easier.
2January 20, 2020 by Kenneth Fisher
I don’t know how many of you are working with Windows Core these days but personally I think it’s a …
Continue reading
SQL Studies 