TSQL Tuesday #127 Invite – Non SQL Tips and tricks
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
24 reads
Kenneth Fisher
Use session_context to create a “variable” that lasts between batches.
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
128 reads
Explain CROSS APPLY like I’m 5.
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,822 reads
Connecting to Azure SQL Database: Requested tenant identifier ‘00000000-0000-0000-0000-000000000000’ is not valid.
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
99 reads
Negative (-) is an operator and will affect the order of operations.
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
412 reads
Running Azure from my android phone
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
72 reads
What is (local)?
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)
374 reads
Could not obtain information about Windows NT group/user
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
155 reads
Is there an easy way to tell what pricing tier my Azure SQL DB/DW is using T-SQL?
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)
453 reads
SQL Homework – May 2020 – Forum Lurking.
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
25 reads
Blogs
The Benefits of Teaching
By Brian Kelley
Even preparing for a class or seminar with set materials takes a lot of...
Power BI, Excel, OneLake – Dreams Do Come True!
By DataOnWheels
I can’t believe it’s finally here! A way to have Excel live in OneDrive...
The Book of Redgate: What Our Staff Says
By Steve Jones
This image is from 2010, and it goes along with my last post of...
Forums
Help! MEMORY_ALLOCATION_EXT wait stalls
Hi I have an overnight process that moves allot of claims records Been working...
Unlocking Data Transformation: My journey with dbt (Data Build Tool) on SQL Server
Comments posted to this topic are about the item Unlocking Data Transformation: My journey...
Putting the Player with the Number
Comments posted to this topic are about the item Putting the Player with the...
Question of the Day
Putting the Player with the Number
In SQL Server 2025, what does this return?
DECLARE @player varchar(20) = 'Bo Nix', @num VARCHAR = '10' SELECT @player || @numSee possible answers