SQLStudies

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

16 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

57 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

366 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

66 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,563 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

105 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

What is (local)?

• by Kenneth Fisher

• SQLStudies

When connecting to a SQL Server instance sometimes you’ll see (local), localhost or even just a single period (hard to ... Continue reading

2020-05-12 (first published: 2020-04-27)

351 reads

Is there an easy way to tell what pricing tier my Azure SQL DB/DW is using T-SQL?

• by Kenneth Fisher

• SQLStudies

I ran into an interesting problem today. I needed to find out the pricing tier of an Azure SQL DB ... Continue reading

2020-05-06 (first published: 2020-04-22)

427 reads