Category Archives: SQLServerPedia Syndication
-
Running Azure from my android phone
1May 13, 2020 by Kenneth Fisher
The other day I had a random thought. I wonder if there is a version of Azure Portal for Android. …
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.
5April 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 -
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 -
Has this login been used recently?
10April 8, 2020 by Kenneth Fisher
I get asked this every now and again, along with the companion When was the last time this login was …
Continue reading
SQL Studies 