Daily Coping 23 Sep 2022
Today’s coping tip is to notice what you are feeling without any judgment. Today I’m stressed. I have been traveling a bit and trying to work remotely from my...
2022-09-23
10 reads
Blog Posts
Look Into Chocolatey
Just a suggestion, but I’d say you should look into Chocolatey. Let me explain why. Sabbatical For those who don’t know I was recently on a six-week sabbatical from...
2022-09-23 (first published: 2022-09-12)
318 reads
Snowflake – Where is the explain/execution plan?
Whatever your database background is you will have heard of an execution / explain plan. Snowflake is no different. Coming from a MS SQL background I was used to...
2022-09-23
16 reads
Using Snowflake – Hands On
Now let’s start the process of creating a snowflake account in the Azure Cloud. You can sign up for a free trial from here – https://signup.snowflake.com/ I am going...
2022-09-23 (first published: 2022-07-26)
348 reads
Daily Coping 22 Sep 2022
Today’s coping tip is to ask a trusted friend to tell you what strengths they see in you. On one hand this would seem easy. On the other, it...
2022-09-22
6 reads
Power BI Tracker
Znáte ten pocit, kdy jste si přepsali nějakou složitější measure a rádi byste jí vrátili do stavu, jak vypadala před hodinou? Nebo kolega něco upravil ve vašem modelu, ale...
2022-09-22 (first published: 2022-09-21)
8 reads
Checking Database Compatability = #SQLNewBlogger
Recently I needed to check the compatibility level of a database and SSMS didn’t work. This is what I did in T-SQL.https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-compatibility-level?view=sql-server-ver16 Another post for me that is simple...
2022-09-21
12 reads
Creating a SERVER ROLE created a LOGIN as well.
One of my co-workers came to me the other day and told me that they found their network id as ... Continue reading
2022-09-21 (first published: 2022-09-06)
274 reads
Daily Coping 21 Sep 2022
Today’s coping tip is to leave positive messages for yourself to see regularly. I could use post-its, or something else, but something that has worked well for me with...
2022-09-21
7 reads
Distributed Replay: The Little Engine That Almost Could
Honestly, sincerely, no kidding, I love Distributed Replay. Yes, I get it. Proof positive I’m an idiot. As we needed proof. To be a little fair to me, I...
2022-09-21 (first published: 2022-08-15)
173 reads
Blogs
Daily Coping 30 Sep 2022
By Steve Jones
Today’s coping tip is to find a new way to use one of your...
Why You Need Presentation Skills
And no, the answer is not because you want to be a Microsoft MVP....
Daily Coping 29 Sep 2022
By Steve Jones
Today’s coping tip is to avoid saying “I should” and make time to do...
Forums
TCP Provider: A connection attempt failed for target server
Hi. In source SQL Instance target linked server has been created and connection tested...
Get Part number and display in Header
Hello, so I have a part number, and I want to display it in...
BlobColumn to String
I have this column in sql server that has value of "dog,cat,mouse" so I...
Ask SSC