-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: September 2018

sqlhelp: limit the x-axis of a geometry line graph

I have a #sqlhelp question that requires some code. So hey, blog post time! TL;DR: the geometry::STGeomFromText graph provides too wide a range for the X-axis, for a large variance of Y-axis values. Is there a way to limit the X-axis range? Update: We have an answer! Thanks MJ! Yeah,… Read more

0 comments, 194 reads

Posted in SQL Awesomesauce on 26 September 2018

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

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.

The post More PowerShell for fun (and profit) – filter files by date appeared first on The MidnightDBA… Read more

0 comments, 608 reads

Posted in SQL Awesomesauce on 24 September 2018

All about PASS Summit 2018

Here are the things you must/should probably know about PASS Summit 2018, as told by me. First Timers Read this blog, of course. Register for Denny Cherry’s attendee orientation. Sign up for the PASS Buddy Program. And their advice about travel. Get on Twitter and meet people. Check out the… Read more

0 comments, 139 reads

Posted in SQL Awesomesauce on 19 September 2018

Be in the SQL Yearbook

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… Read more

0 comments, 160 reads

Posted in SQL Awesomesauce on 6 September 2018

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,… Read more

4 comments, 159 reads

Posted in SQL Awesomesauce on 6 September 2018

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.

The post Fix: When an Availability Group listener’s IP is… Read more

1 comments, 747 reads

Posted in SQL Awesomesauce on 5 September 2018