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)

551 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)

307 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

18 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)

870 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)

405 reads

Common commands and tasks to make dealing with Windows Core easier.

by Kenneth Fisher

SQLStudies

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)

438 reads

Permissions required for row counts to show up on Object Explorer Details

by Kenneth Fisher

SQLStudies

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)

392 reads

My experiences with Imposter Syndrome: T-SQL Tuesday #122

by Kenneth Fisher

SQLStudies

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)

566 reads

Help! My restore has finished but the database still has a status of recovering.

by Kenneth Fisher

SQLStudies

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)

696 reads

What is the program_name in sys.dm_exec_sessions?

by Kenneth Fisher

SQLStudies

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)

633 reads

SQLStudies

#PowershellBasics: Get input using Read-Host

SQL Homework – February 2020 – Write a blog post.

Insperation

CREATE TABLE MyTable (Col1 CHARACTER VARYING (50))

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

Common commands and tasks to make dealing with Windows Core easier.

Permissions required for row counts to show up on Object Explorer Details

My experiences with Imposter Syndrome: T-SQL Tuesday #122

Help! My restore has finished but the database still has a status of recovering.

What is the program_name in sys.dm_exec_sessions?

Blogs

5 Starter Projects for Your AI and Data Engineering Portfolio

The Book of Redgate: Taking Breaks

Database AI Agents: The Read-Only Rule

Forums

BCA KCU RUNGKUT HUBUNGI CS (0817-839-777)

BCA KCU KEDIRI HUBUNGI CS (0817-839-777)

BCA KCU GALAXY HUBUNGI CS (0817-839-777)

Question of the Day

Running SQLCMD II