Category Archives: Microsoft SQL Server
-
The Azure Portal search bar : T-SQL Tuesday #127
Leave a commentJune 9, 2020 by Kenneth Fisher
Happy T-SQL Tuesday! Number 127. Wow. Over 10 and a half years. Talk about incredible. I’m actually hosting this time …
Continue reading -
SQL Homework – June 2020 – DML Triggers
Leave a commentJune 4, 2020 by Kenneth Fisher
Triggers. Blech. Triggers are a really really cool feature of SQL Server, that are continuously misused and cause all kinds …
Continue reading -
TSQL Tuesday #127 Invite – Non SQL Tips and tricks
37June 2, 2020 by Kenneth Fisher
How about for this months TSQL Tuesday let’s do another month of tips and tricks. But just to be a …
Continue reading -
Use session_context to create a “variable” that lasts between batches.
10May 26, 2020 by Kenneth Fisher
The other day I had a brief conversation with Itzik Ben-Gan (about|twitter) on twitter and I have to tell you …
Continue reading -
Connecting to Azure SQL Database: Requested tenant identifier ‘00000000-0000-0000-0000-000000000000’ is not valid.
Leave a commentMay 20, 2020 by Kenneth Fisher
The other day I got this rather interesting error while connecting to an Azure SQL DB. I was connecting using …
Continue reading -
Negative (-) is an operator and will affect the order of operations.
7May 18, 2020 by Kenneth Fisher
An interesting question came to my attention the other day. A strange operation problem in SQL Server: -100/-100*10 = 0 …
Continue reading -
Explain CROSS APPLY like I’m 5.
5May 11, 2020 by Kenneth Fisher
A good friend of mine (Randolph West (blog|twitter) asked that someone Explain CROSS APPLY like they are 5. So, here’s …
Continue reading -
Could not obtain information about Windows NT group/user
Leave a commentMay 6, 2020 by Kenneth Fisher
This is an interesting error that you’ll occasionally get when accessing an AD/Windows ID. Msg 15404, Level 16, State 11, …
Continue reading -
SQL Homework – May 2020 – Forum Lurking.
Leave a commentMay 4, 2020 by Kenneth Fisher
A few months ago I suggested writing blog post(s) as a great way to learn and document your progress (among …
Continue reading -
Call to action: What do you own?
2April 29, 2020 by Kenneth Fisher
You restored that database, did you remember to change the owner or is it still you? How about that job …
Continue reading
