Add list of IP’s to storage Account Add list of IP’s to SQL Server Firewall
Nginx and PHP-FPM Setup
Setting up an Nginx web server with PHP-FPM can be a bit daunting for those who are new to web server administration. In this blog post, I will provide a step-by-step guide on how to set up an Nginx web server with PHP-FPM on a …
Monitoring Linux VM Resources
As a Linux administrator, it is important to monitor the resources of your virtual machines (VMs) to ensure they are running efficiently and effectively. In this blog post, we will go over some commonly used Linux commands for monitoring VM resources, along with examples of …
Setup SQL Server on Linux VM
### Troubleshooting References #### connection Troubleshootinghttps://learn.microsoft.com/en-us/sql/linux/sql-server-linux-troubleshooting-guide?view=sql-server-linux-ver15#connection #### Restore Database https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-backup-and-restore-database?view=sql-server-ver16 https://learn.microsoft.com/en-us/sql/relational-databases/tutorial-sql-server-backup-and-restore-to-azure-blob-storage-service?view=sql-server-ver16&tabs=SSMS wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add – sudo add-apt-repository “$(wget -qO- https://packages.microsoft.com/config/ubuntu/18.04/mssql-server-2019.list)” sudo apt-get update sudo apt-get install -y mssql-server sudo /opt/mssql/bin/mssql-conf setup ### Command line Tools sudo apt install curl curl https://packages.microsoft.com/keys/microsoft.asc | …
OctoberCMS Development Tips
Inspect curl Requests headers
Import DACPAC file to SQL Server
Import DACPAC File https://docs.microsoft.com/en-us/azure/sql-database/scripts/sql-database-import-from-bacpac-powershell # Login-AzureRmAccount # Set the resource group name and location for your server $resourcegroupname = “myResourceGroup-$(Get-Random)” $location = “westeurope” # Set an admin login and password for your server $adminlogin = “ServerAdmin” $password = “ChangeYourAdminPassword1” # Set server name – the …
SQL Server Performance Queries
SQL Server Performance Tuning — Top 10 sessions caused blocking SELECT TOP 10 r.session_id, r.plan_handle, r.sql_handle, r.request_id, r.start_time, r.status, r.command, r.database_id, r.user_id, r.wait_type, r.wait_time, r.last_wait_type, r.wait_resource, r.total_elapsed_time, r.cpu_time, r.transaction_isolation_level, r.row_count, st.text FROM sys.dm_exec_requests r CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) AS st WHERE r.blocking_session_id = 0 AND …
SQL Server IO Stall Statistics
— Read IO Stalls Statistics SELECT @@VERSION GO SELECT type, SUM(io_stall_read_ms) AS io_stall_read, SUM(io_stall_write_ms) AS io_stall_write, SUM(num_of_reads) AS num_of_reads, SUM(num_of_writes) AS num_of_writes FROM sys.dm_io_virtual_file_stats(NULL, NULL) fs JOIN sys.database_files df ON fs.file_id = df.file_id WHERE database_id = DB_ID() GROUP BY df.type
Azure – Troubleshooting
Azure – Troubleshooting AKS Recommended KeepAlive Settings sudo bash -c “echo 120 > /proc/sys/net/ipv4/tcp_keepalive_time” sudo bash -c “echo 30 > /proc/sys/net/ipv4/tcp_keepalive_intvl” sudo bash -c “echo 8 > /proc/sys/net/ipv4/tcp_keepalive_probes”