Steve Radich's Blog Steve Radich, Founder of BitShop.com, ASPDeveloper.Net, and numerous other resource sites primary Blog https://www.bitshop.com/Blogs/tabid/95/BlogId/7/Default.html en-US sales@bitshop.com stever@bitshop.com Sat, 30 Jan 2021 23:13:33 GMT Sat, 30 Jan 2021 23:13:33 GMT http://backend.userland.com/rss Blog RSS Generator Version 3.5.1.19887 Finding a Windows Service Account user it runs as <p> Finding a Windows Service Account user it runs as</p><a href=http://www.bitshop.com/Blogs/tabid/95/EntryId/154/Finding-a-Windows-Service-Account-user-it-runs-as.aspx>More...</a> http://www.bitshop.com/Blogs/tabid/95/EntryId/154/Finding-a-Windows-Service-Account-user-it-runs-as.aspx sales@bitshop.com http://www.bitshop.com/Blogs/tabid/95/EntryId/154/Finding-a-Windows-Service-Account-user-it-runs-as.aspx#Comments http://www.bitshop.com/Blogs/tabid/95/EntryId/154/Finding-a-Windows-Service-Account-user-it-runs-as.aspx Fri, 24 Mar 2017 23:48:00 GMT 0 https://www.bitshop.com/DesktopModules/Blog/Trackback.aspx?id=154 Filezilla using SSH keys <p> Sometimes people need to access a SFTP site using keys instead of passwords. This is a quick video you are welcome to use / share for how that can easily be done. </p><a href=http://www.bitshop.com/Blogs/tabid/95/EntryId/153/Filezilla-using-SSH-keys.aspx>More...</a> http://www.bitshop.com/Blogs/tabid/95/EntryId/153/Filezilla-using-SSH-keys.aspx sales@bitshop.com http://www.bitshop.com/Blogs/tabid/95/EntryId/153/Filezilla-using-SSH-keys.aspx#Comments http://www.bitshop.com/Blogs/tabid/95/EntryId/153/Filezilla-using-SSH-keys.aspx Wed, 22 Feb 2017 03:52:00 GMT 0 https://www.bitshop.com/DesktopModules/Blog/Trackback.aspx?id=153 Using Nagios to check unpingable hosts, like AWS Load Balancers ELB <p> Nagios tends to define a host with check_host which requires the host to be pingable. There are various solutions that can be implemented to change that behavior, but in the case of a load balancer the definition of is it up or not is does it respond to a https:// request.</p><a href=http://www.bitshop.com/Blogs/tabid/95/EntryId/152/Using-Nagios-to-check-unpingable-hosts-like-AWS-Load-Balancers-ELB.aspx>More...</a> http://www.bitshop.com/Blogs/tabid/95/EntryId/152/Using-Nagios-to-check-unpingable-hosts-like-AWS-Load-Balancers-ELB.aspx sales@bitshop.com http://www.bitshop.com/Blogs/tabid/95/EntryId/152/Using-Nagios-to-check-unpingable-hosts-like-AWS-Load-Balancers-ELB.aspx#Comments http://www.bitshop.com/Blogs/tabid/95/EntryId/152/Using-Nagios-to-check-unpingable-hosts-like-AWS-Load-Balancers-ELB.aspx Thu, 16 Feb 2017 00:18:00 GMT 0 https://www.bitshop.com/DesktopModules/Blog/Trackback.aspx?id=152 Getting Confluence to run under docker <p>Docker is handy, especially for testing or demonstrating things quickly.. It's handy for production but that's a more complicated topic than this quick post..</p> <p>The steps to get Confluence set up aren't QUTIE complete if you hand them to someone new with docker..</p><a href=http://www.bitshop.com/Blogs/tabid/95/EntryId/151/Getting-Confluence-to-run-under-docker.aspx>More...</a> http://www.bitshop.com/Blogs/tabid/95/EntryId/151/Getting-Confluence-to-run-under-docker.aspx sales@bitshop.com http://www.bitshop.com/Blogs/tabid/95/EntryId/151/Getting-Confluence-to-run-under-docker.aspx#Comments http://www.bitshop.com/Blogs/tabid/95/EntryId/151/Getting-Confluence-to-run-under-docker.aspx Tue, 31 Jan 2017 07:11:00 GMT 0 https://www.bitshop.com/DesktopModules/Blog/Trackback.aspx?id=151 Can't browse microsoft.com or visualstudio.com from Windows Server 2016.. <p>I had an interesting question come thru, an IT guy said I can't browse microsoft.com or visualstudio.com from Windows Server 2016 on a brand new server install and was tasked with installing Visual Studio Community Edition for a requirement..</p><a href=http://www.bitshop.com/Blogs/tabid/95/EntryId/150/Cant-browse-microsoft-com-or-visualstudio-com-from-Windows-Server-2016.aspx>More...</a> http://www.bitshop.com/Blogs/tabid/95/EntryId/150/Cant-browse-microsoft-com-or-visualstudio-com-from-Windows-Server-2016.aspx sales@bitshop.com http://www.bitshop.com/Blogs/tabid/95/EntryId/150/Cant-browse-microsoft-com-or-visualstudio-com-from-Windows-Server-2016.aspx#Comments http://www.bitshop.com/Blogs/tabid/95/EntryId/150/Cant-browse-microsoft-com-or-visualstudio-com-from-Windows-Server-2016.aspx Sun, 27 Nov 2016 21:04:00 GMT 0 https://www.bitshop.com/DesktopModules/Blog/Trackback.aspx?id=150 Auto Scaling Groups (ASG) and Default site SSL Certificate <p>When you create an ASG (Auto Scaling Group) you may want to have your SSL certificate auto isntalled and auto pointed to the main site.. However this doesn't export / import with the usual APPCMD methods..</p><a href=http://www.bitshop.com/Blogs/tabid/95/EntryId/149/Auto-Scaling-Groups-ASG-and-Default-site-SSL-Certificate.aspx>More...</a> http://www.bitshop.com/Blogs/tabid/95/EntryId/149/Auto-Scaling-Groups-ASG-and-Default-site-SSL-Certificate.aspx sales@bitshop.com http://www.bitshop.com/Blogs/tabid/95/EntryId/149/Auto-Scaling-Groups-ASG-and-Default-site-SSL-Certificate.aspx#Comments http://www.bitshop.com/Blogs/tabid/95/EntryId/149/Auto-Scaling-Groups-ASG-and-Default-site-SSL-Certificate.aspx Tue, 22 Nov 2016 02:12:00 GMT 0 https://www.bitshop.com/DesktopModules/Blog/Trackback.aspx?id=149 Snowflake odd datediff behavior if called with m <p>If you are moving from Microsoft SQL Server to Snowflake you'll likely be moving some datediff sql statements over, datediff(m, date, date) gives the number of months between dates in Microsoft SQL Server - However in snowflake ...</p><a href=http://www.bitshop.com/Blogs/tabid/95/EntryId/148/Snowflake-odd-datediff-behavior-if-called-with-m.aspx>More...</a> http://www.bitshop.com/Blogs/tabid/95/EntryId/148/Snowflake-odd-datediff-behavior-if-called-with-m.aspx sales@bitshop.com http://www.bitshop.com/Blogs/tabid/95/EntryId/148/Snowflake-odd-datediff-behavior-if-called-with-m.aspx#Comments http://www.bitshop.com/Blogs/tabid/95/EntryId/148/Snowflake-odd-datediff-behavior-if-called-with-m.aspx Wed, 05 Oct 2016 05:59:00 GMT 0 https://www.bitshop.com/DesktopModules/Blog/Trackback.aspx?id=148 RedShift: Weird hangs, horrible performance, just major issues.. <p>Using RedShift you may experience very odd hangs, horrible performance, think that queries aren't returning that you expect to be fairly simple.. </p><a href=http://www.bitshop.com/Blogs/tabid/95/EntryId/147/RedShift-Weird-hangs-horrible-performance-just-major-issues.aspx>More...</a> http://www.bitshop.com/Blogs/tabid/95/EntryId/147/RedShift-Weird-hangs-horrible-performance-just-major-issues.aspx sales@bitshop.com http://www.bitshop.com/Blogs/tabid/95/EntryId/147/RedShift-Weird-hangs-horrible-performance-just-major-issues.aspx#Comments http://www.bitshop.com/Blogs/tabid/95/EntryId/147/RedShift-Weird-hangs-horrible-performance-just-major-issues.aspx Wed, 21 Sep 2016 23:58:00 GMT 0 https://www.bitshop.com/DesktopModules/Blog/Trackback.aspx?id=147 RedShift: Year(column) causes [Amazon](500310) Invalid operation: function year(timestamp without time zone) does not exist <p>In Amazon's RedShift if you try to use the year() function from Microsoft SQL server you may often end up with:</p> <p>[Amazon](500310) Invalid operation: function year(timestamp without time zone) does not exist</p><a href=http://www.bitshop.com/Blogs/tabid/95/EntryId/146/RedShift-Year-column-causes-Amazon-500310-Invalid-operation-function-year-timestamp-without-time-zone-does-not-exist.aspx>More...</a> http://www.bitshop.com/Blogs/tabid/95/EntryId/146/RedShift-Year-column-causes-Amazon-500310-Invalid-operation-function-year-timestamp-without-time-zone-does-not-exist.aspx sales@bitshop.com http://www.bitshop.com/Blogs/tabid/95/EntryId/146/RedShift-Year-column-causes-Amazon-500310-Invalid-operation-function-year-timestamp-without-time-zone-does-not-exist.aspx#Comments http://www.bitshop.com/Blogs/tabid/95/EntryId/146/RedShift-Year-column-causes-Amazon-500310-Invalid-operation-function-year-timestamp-without-time-zone-does-not-exist.aspx Fri, 16 Sep 2016 18:46:00 GMT 0 https://www.bitshop.com/DesktopModules/Blog/Trackback.aspx?id=146 Using Roslyn and compiling assemblies for both .Net 4.5 and .Net Crore <p>During the transition phase from .Net 4.5 / 4.6 to .Net Core we will have many projects that need to compile under both frameworks. How do you go about this? </p><a href=http://www.bitshop.com/Blogs/tabid/95/EntryId/145/Using-Roslyn-and-compiling-assemblies-for-both-Net-4-5-and-Net-Crore.aspx>More...</a> http://www.bitshop.com/Blogs/tabid/95/EntryId/145/Using-Roslyn-and-compiling-assemblies-for-both-Net-4-5-and-Net-Crore.aspx sales@bitshop.com http://www.bitshop.com/Blogs/tabid/95/EntryId/145/Using-Roslyn-and-compiling-assemblies-for-both-Net-4-5-and-Net-Crore.aspx#Comments http://www.bitshop.com/Blogs/tabid/95/EntryId/145/Using-Roslyn-and-compiling-assemblies-for-both-Net-4-5-and-Net-Crore.aspx Wed, 14 Sep 2016 01:56:00 GMT 0 https://www.bitshop.com/DesktopModules/Blog/Trackback.aspx?id=145