Category: sqlserverpedia-syndication

T-SQL: How many bananas tall are you?

Post author By Jen McCown
Post date September 6, 2018
Categories In Beginner, Dev, Fluffy Stuff, Random helpfulness, sqlserverpedia-syndication, SSC, Tech and Learning
4 Comments on T-SQL: How many bananas tall are you?

So today, this happened: Now I suddenly want to know how many bananas tall I am… https://t.co/7geupBzXDj — MidnightDBA (@MidnightDBA) September 6, 2018 And I realized it would be really easy to find that out, via a calculator, or – more amusingly – with SQL: DECLARE @feet FLOAT = 5.0, @inches FLOAT = 5.0, @bananaIN […]

Fix: When an Availability Group listener’s IP is stolen

Post author By Jen McCown
Post date September 5, 2018
Categories In Admin, Advanced, sql server, sqlserverpedia-syndication, SSC, Tech and Learning
1 Comment on Fix: When an Availability Group listener’s IP is stolen

When you can connect to the individual nodes of a SQL Server Availability Group (AG), but not the AG listener, you may have a duplicate IP situation. Resolving this isn’t QUITE as straightforward as I’d hope, so here’s our solution.

Vote for a new SSMS feature: Pin files in SQL Server Management Studio

Post author By Jen McCown
Post date August 3, 2018
Categories In Admin, Dev, News, sql server, sqlserverpedia-syndication, SSC, Tech and Learning

So, this just happened: That’s a p good idea. I’ll upvote it if you put it in User Voice. Or we just pull rank and nag @vickyharp 😀 — Kerry Tyler #BLM 🚴 (@AirborneGeek) August 3, 2018 And so, I did. Post the idea, I mean…I didn’t nag Vicky. Vote here.