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.
Leave a commentFebruary 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.
Leave a commentJanuary 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
