Download: http://www.iis.net/downloads/microsoft/url-rewrite Update web.config file: <?xml version=”1.0″ encoding=”UTF-8″?> <configuration> <system.webServer> <rewrite> <rules> <rule name=”HTTP/S to HTTPS Redirect” enabled=”true” stopProcessing=”true”> <match url=”(.*)” /> <conditions logicalGrouping=”MatchAny”> <add input=”{SERVER_PORT_SECURE}” pattern=”^0$” /> </conditions> <action type=”Redirect” url=”https://{HTTP_HOST}{REQUEST_URI}” redirectType=”Permanent” /> </rule> </rules> </rewrite> </system.webServer> </configuration>
Read moreAuthor Archives: jwebber
How to transfer logins and passwords between instances of SQL Server
https://support.microsoft.com/en-us/help/918992/how-to-transfer-logins-and-passwords-between-instances-of-sql-server
Read moreSSRS Find Reports using a Stored Procedure
Find SSRS report designs that reference a specific stored procedure: SELECT CAST(CAST(content AS VARBINARY(MAX)) AS XML), Path, Name, CreationDate, ModifiedDate FROM dbo.Catalog where cast(CAST(CAST(content AS VARBINARY(MAX)) AS XML) as varchar(max)) like ‘%spRptPMWIP6%’
Read moreCreate views for all the tables in a Database with Column Names not *
SELECT ‘IF EXISTS(SELECT 1 FROM sys.objects WHERE name = ”vw’ + t.name + ”’ AND type = ”V”) BEGIN DROP VIEW [v_’ + t.name + ‘] END CREATE VIEW [vw’ + t.name + N] AS SELECT ‘ + STUFF( (SELECT N’,[‘ + c.name+’]’ FROM sys.columns AS c WHERE c.OBJECT_ID = t.OBJECT_ID ORDER BY column_id FOR […]
Read moreNextCloud – Rasberry Pi
Just got Nextcloud running on a Rasberry Pi I had laying around. Pretty cool. Just need to configure the home network now to pass traffic to it and will be all set. Already using the iPhone app on the internal network. Nextcloud – a safe home for all your data
Read more