SQLStudies

TSQL Tuesday #127 Invite – Non SQL Tips and tricks

• by Kenneth Fisher

• SQLStudies

How about for this months TSQL Tuesday let’s do another month of tips and tricks. But just to be a ... Continue reading

2020-06-02

7 reads

What I learned from “The boy who cried wolf”

• by Kenneth Fisher

• SQLStudies

I was thinking about the story The boy who cried wolf earlier today and realized that it has some lessons ... Continue reading

2020-05-28

3 reads

Use session_context to create a “variable” that lasts between batches.

• by Kenneth Fisher

• SQLStudies

The other day I had a brief conversation with Itzik Ben-Gan (about|twitter) on twitter and I have to tell you ... Continue reading

2020-05-26

8 reads

Connecting to Azure SQL Database: Requested tenant identifier ‘00000000-0000-0000-0000-000000000000’ is not valid.

• by Kenneth Fisher

• SQLStudies

The other day I got this rather interesting error while connecting to an Azure SQL DB. I was connecting using ... Continue reading

2020-05-20

51 reads

Negative (-) is an operator and will affect the order of operations.

• by Kenneth Fisher

• SQLStudies

An interesting question came to my attention the other day. A strange operation problem in SQL Server: -100/-100*10 = 0 ... Continue reading

2020-05-18

250 reads

Running Azure from my android phone

• by Kenneth Fisher

• SQLStudies

The other day I had a random thought. I wonder if there is a version of Azure Portal for Android. ... Continue reading

2020-05-13

64 reads

Explain CROSS APPLY like I’m 5.

• by Kenneth Fisher

• SQLStudies

A good friend of mine (Randolph West (blog|twitter) asked that someone Explain CROSS APPLY like they are 5. So, here’s ... Continue reading

2020-05-25 (first published: 2020-05-11)

1,478 reads

Could not obtain information about Windows NT group/user

• by Kenneth Fisher

• SQLStudies

This is an interesting error that you’ll occasionally get when accessing an AD/Windows ID. Msg 15404, Level 16, State 11, ... Continue reading

2020-05-06

102 reads

SQL Homework – May 2020 – Forum Lurking.

• by Kenneth Fisher

• SQLStudies

A few months ago I suggested writing blog post(s) as a great way to learn and document your progress (among ... Continue reading

2020-05-04

6 reads

Call to action: What do you own?

• by Kenneth Fisher

• SQLStudies

You restored that database, did you remember to change the owner or is it still you? How about that job ... Continue reading

2020-04-29

7 reads