Category: Tech and Learning

More PowerShell for fun (and profit) – filter files by date

Post author By Jen McCown
Post date September 24, 2018
Categories In Powershell, sql server, sqlserverpedia-syndication, SSC, Tech and Learning

PowerShell provides an easy way to search for and/or delete just the files you want. Let’s look at navigating in the PowerShell window, and filtering by name, and by date last modified.

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.