spy86

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
    <system.webServer>
        <security>
            <requestFiltering>
                <requestLimits maxQueryString="3000" />
            </requestFiltering>
        </security>
    </system.webServer>
</configuration>

spy86

#!/bin/bash
for i in `ps -ax | grep httpd | awk '{print $1}'`; do kill -9 $i; done;

spy86

<VirtualHost myhost:80>
    ServerName myhost
    DocumentRoot /path/to/myapp/public
    ProxyPass / http://myapp:8080/
    ProxyPassReverse / http://myapp:8080/
</VirtualHost>

spy86

stream {
upstream mysql_read {
server read1.example.com:3306 weight=5;
server read2.example.com:3306;
server 10.10.12.34:3306 backup;
}
server {
listen 3306;
proxy_pass mysql_read;
}

spy86

upstream backend {
server 10.10.12.45:80 weight=1;
server app.example.com:80 weight=2;
}
server {
location / {
proxy_pass http://backend;
}
}

spy86

server {
    listen myhost:80;
    server_name  myhost;
    location / {
        root /path/to/myapp/public;
        proxy_set_header X-Forwarded-Host $host:$server_port;
        proxy_set_header X-Forwarded-Server $host;
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
        proxy_pass http://myapp:8080;
    }

spy86

Configuration SQLInstall
{
    param (
        [Parameter(Mandatory=$true)]
        [ValidateNotNullOrEmpty()]
        [String]
        $PackagePath,
 
        [Parameter(Mandatory=$true)]
        [ValidateNotNullOrEmpty()]

spy86

#$configData = @{
@{
    AllNodes = @(
        @{
            NodeName = "*"
            PSDscAllowPlainTextPassword = $true
         },
 
        @{
            NodeName = "fabfiberserver"

spy86

USE master
GO
PRINT ‘*******************************************************************************************’
PRINT ‘*******************************************************************************************’
PRINT ‘<SQL Server Instance Name>’
SELECT @@SERVERNAME
GO
PRINT ‘*******************************************************************************************’
PRINT ‘*******************************************************************************************’
PRINT ‘<SQL Server Version, Edition and Build>’

spy86

ALTER DATABASE mydb SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
GO
ALTER DATABASE mydb SET MULTI_USER WITH ROLLBACK IMMEDIATE;
GO
ALTER DATABASE mydb SET OFFLINE WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE mydb SET ONLINE WITH ROLLBACK IMMEDIATE
GO