Category Archives: Microsoft SQL Server
-
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 -
What is (local)?
Leave a commentApril 27, 2020 by Kenneth Fisher
When connecting to a SQL Server instance sometimes you’ll see (local), localhost or even just a single period (hard to …
Continue reading -
Is there an easy way to tell what pricing tier my Azure SQL DB/DW is using T-SQL?
3April 22, 2020 by Kenneth Fisher
I ran into an interesting problem today. I needed to find out the pricing tier of an Azure SQL DB …
Continue reading -
Be warned: The way I’m feeling right now I might actually give you sysadmin when you ask for it.
4April 20, 2020 by Kenneth Fisher
You want sysadmin permissions in production? And your manager has approved it so I shouldn’t have any problems giving it …
Continue reading -
What is the datatype SQL_VARIANT
3April 16, 2020 by Kenneth Fisher
The SQL_VARIANT data type is an interesting beast. It is a data type that can store most types of data. …
Continue reading -
A culture of testing : T-SQL Tuesday #125
2April 14, 2020 by Kenneth Fisher
Happy T-SQL Tuesday again! Number 125. I can’t believe how long this thing has been running. In case you weren’t …
Continue reading
