#PowershellBasics: Get input using Read-Host
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)
544 reads
SQLStudies
SQL Homework – February 2020 – Write a blog post.
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)
303 reads
Insperation
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
13 reads
CREATE TABLE MyTable (Col1 CHARACTER VARYING (50))
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)
864 reads
Changing the owner of a schema removes all direct permissions of objects owned by the schema.
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)
398 reads
Common commands and tasks to make dealing with Windows Core easier.
I don’t know how many of you are working with Windows Core these days but personally I think it’s a ... Continue reading
2020-01-29 (first published: 2020-01-20)
431 reads
Permissions required for row counts to show up on Object Explorer Details
I ran into a rather obscure permissions problem the other day. Since I wasn’t able to figure it out on ... Continue reading
2020-01-23 (first published: 2020-01-16)
389 reads
My experiences with Imposter Syndrome: T-SQL Tuesday #122
Jon Shaulis (blog|twitter) is hosting T-SQL Tuesday this month. Thanks Jon! And the subject is obvious if you read the ... Continue reading
2020-01-21 (first published: 2020-01-14)
561 reads
Help! My restore has finished but the database still has a status of recovering.
I’ve been thinking about writing this for a bit and then a co-worker actually had this problem recently, so, well, ... Continue reading
2020-01-17 (first published: 2020-01-08)
687 reads
What is the program_name in sys.dm_exec_sessions?
If you’ve ever looked at the output for sys.dm_exec_sessions you may have noticed the column program_name. Frequently you’ll see entries ... Continue reading
2020-01-13 (first published: 2020-01-06)
626 reads
Blogs
T-SQL Tuesday #190–Mastering a New Technical Skill
By Steve Jones
It’s time for T-SQL Tuesday again and this time Todd Kleinhans has a great...
Getting Started with the MSSQL AI Agent in VS Code
By Steve Jones
Recently I was working in VS Code and I saw a walkthrough for the...
Summer Speaking Summary 2025
By alevyinroc
In the blink of an eye, summer has passed. I don’t know about you,...
Forums
Azure elastic query credential question
I am trying to check out elastic query between two test instances we have...
Change Tracking Data Retention Options
Comments posted to this topic are about the item Change Tracking Data Retention Options
Requiring Technical Debt Payments
Comments posted to this topic are about the item Requiring Technical Debt Payments
Question of the Day
Change Tracking Data Retention Options
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=4 xxx);What are the possible choices for xxx? See possible answers