Author: Jen McCown

Be in the SQL Yearbook

Post author By Jen McCown
Post date September 6, 2018
Categories In Community, Fluffy Stuff, News, People and Opinions, sqlserverpedia-syndication, SSC

I’ve been thinking about this for years, and I’m finally doing it. I’m making a SQL Yearbook, and I want you to be in it. Since first writing this, I have realized that a “yearbook” is primarily an American phenomenon. M-W defines yearbook as “school publication that is compiled usually by a graduating class and that serves as a record […]

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.