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 moreHow 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 moreSSRS Logs
Need to know the stats of what is going on in SSRS. Query ExecutionLog, ExecutionLog2, or ExecutionLog3 and get the time for data retrieval, processing, and time rendering.
Read moreSSRS – Report Data Window – Shortcut
sure why I lose this window sometime, but here is how to get it back: With a report file selected: View -> Report Data. It is a shortcut of Ctrl+Alt+D
Read moreSSRS – Alternate Row Colors
Set Background property of the detail to: = IIf(RowNumber(Nothing) Mod 2 = 0, “#EEEEEE”, “Transparent”)
Read moreSQL Server – Find all tables that have a column with a specific name
SELECT t.name AS table_name, SCHEMA_NAME(schema_id) AS schema_name, c.name AS column_name FROM sys.tables AS t INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID WHERE c.name =’FindColumnName’ ORDER BY schema_name, table_name;
Read moreStored Procedures Modified in last 7 Days
SELECT name, create_date, modify_date FROM sys.objects WHERE type = ‘P’ and modify_date>=DateAdd(Day,-7,GetDate())
Read more