IIS - Cache Control must-revalidate"

Reference : Deploying to Microsoft Internet Information Server (IIS) | Gatsby (gatsbyjs.com)

<?xml version="1.0" encoding="UTF-8"?>

<configuration>

    <location path="static">

        <system.webServer>

            <httpProtocol>

                <customHeaders>

                    <remove name="cache-control" />

                    <add name="cache-control" value="public, max-age=31536000, immutable" />

                </customHeaders>

            </httpProtocol>

        </system.webServer>

    </location>

    <location path="page-data">

        <system.webServer>

            <httpProtocol>

                <customHeaders>

                    <remove name="cache-control" />

                    <add name="cache-control" value="public, max-age=0, must-revalidate" />

                </customHeaders>

            </httpProtocol>

        </system.webServer>

    </location>

    <system.webServer>

        <staticContent>

            <mimeMap fileExtension=".webmanifest" mimeType="application/manifest+json" />

        </staticContent>

        <rewrite>

            <outboundRules>

              <rule name="AdjustCacheForDontCacheFiles" preCondition="IsDontCacheFile" stopProcessing="true">

                <match serverVariable="RESPONSE_Cache-Control" pattern=".*" />

                <action type="Rewrite" value="public, max-age=0, must-revalidate" />

              </rule>

              <rule name="AdjustCacheForCachePermanentlyFiles" preCondition="IsCachePermanentlyFile" stopProcessing="true">

                <match serverVariable="RESPONSE_Cache-Control" pattern=".*" />

                <action type="Rewrite" value="public, max-age=31536000, immutable" />

              </rule>

              <preConditions>

                <preCondition name="IsDontCacheFile">

                  <add input="{REQUEST_FILENAME}" pattern="(.*\.html)|(sw\.js)|(app\-data\.json)|(page\-data\.json)" />

                </preCondition>

                <preCondition name="IsCachePermanentlyFile">

                  <add input="{REQUEST_FILENAME}" pattern="((.*\.js)|(.*\.css))$" />

                </preCondition>

              </preConditions>

            </outboundRules>

        </rewrite>

    </system.webServer>

</configuration>

SQL Server - Kill all Connected connection

Reference : https://stackoverflow.com/questions/7197574/script-to-kill-all-connections-to-a-database-more-than-restricted-user-rollback 

 For MS SQL Server 2012 and above

USE master;

DECLARE @kill varchar(8000); SET @kill = '';  

SELECT @kill = @kill + 'kill ' + CONVERT(varchar(5), spid) + ';'  

FROM master..sysprocesses  

WHERE dbid = db_id('MyDB')

EXEC(@kill);

 For MS SQL Server 2000, 2005, 2008

 USE [master];

DECLARE @kill varchar(8000) = '';  

SELECT @kill = @kill + 'kill ' + CONVERT(varchar(5), session_id) + ';'  

FROM sys.dm_exec_sessions

WHERE database_id  = db_id('MyDB')

EXEC(@kill);

SQL Server - find users connected to databases

Reference: https://jimsalasek.com/2019/01/09/sql-server-find-users-connected-to-databases/

SELECT @@ServerName AS server

 ,NAME AS DatabaseName

 ,COUNT(STATUS) AS number_of_connections

 ,GETDATE() AS Query_Run_Time

FROM sys.databases sd

LEFT JOIN sysprocesses sp ON sd.database_id = sp.dbid

WHERE NAME not in ('master','model','msdb','tempdb')

GROUP BY NAME

With actual usernames and machines that are connected

SELECT @@ServerName AS SERVER

 ,NAME

 ,login_time

 ,STATUS

 ,hostname

 ,program_name

 ,nt_username

 ,loginame

FROM sys.databases d

LEFT JOIN sysprocesses sp ON d.database_id = sp.dbid

WHERE  NAME not in ('master','model','msdb','tempdb')

 AND loginame IS NOT NULL order by 2