To find queries that block others in Microsoft SQL databases, execute This returns the list of active sessions and indicates what session blocked it. To get the query of a session, execute
Category Archives: Not for home page
MSSQL database migration to another database server
When a database is migrated to another server by copying the database file or restoring it from a backup file, the original database user account references are also carried with it. Those accounts contain the account IDs specific to the original database server. To provide access to the restored database on the new database server …
Continue reading “MSSQL database migration to another database server”
RuntimeError: Volume vol-… attached at xvdf but does not conform to this resource’s specifications
When the Chef aws cookbook’s ebs_volume.rb resource tries to bring a volume online, partition, and format it we get the error message: RuntimeError: Volume vol-… attached at xvdf but does not conform to this resource’s specificationsC:/chef/cache/cookbooks/aws/resources/ebs_volume.rb:46:in `block in class_from_file’ Make sure the “size” attribute value in the aws_ebs_volume resource call matches the actual size of …
The installation of this package failed
When we tried to install the Microsoft Access Database Engine and Office 2007 System Driver on a Windows Server 2016 an error message popped up immediately: The installation of this package failed When we ran the installation with the logging option, we have found a message at the bottom of the file: Will create the …
Invoke-WebRequest : The request was aborted: Could not create SSL/TLS secure channel.
Older PowerShell versions do not use TLS1.2 as the default version during the SSL handshake. When the API requires TLS1.2 the error message appears: Invoke-WebRequest : The request was aborted: Could not create SSL/TLS secure channel. To force PowerShell to use TLS1.2 during the SSL handshake, issue this command before executing the Invoke-Webrequest
Extend a Linux partition
When the Linux disk drive is full, first we need to identify the reason for the drive overuse. Many times the drive is filled with one large log file, that can be identified and truncated. To list the directory sizes under the current directory execute To empty a file, overwrite it with nothing, so the …
Configure AWS Route 53 to host a web site in AWS
To be able to fully control the routing of a DNS name use Route 53 Create a new Hosted Zone In the Route 53 console click the Create Hosted Zone button Create a new public Hosted Zone Return to the domain registrars website and set the name servers to use the AWS Route 53 hosted …
Continue reading “Configure AWS Route 53 to host a web site in AWS”
Error: EPERM: operation not permitted, rename
Error: EPERM: operation not permitted, rename ‘C:\Users\MY_USERNAME\.config\configstore\update-notifier-nodemon.json.3604946166’ -> ‘C:\Users\MY_USERNAME\.config\configstore\update-notifier-nodemon.json’ In case of this error rename the C:\Users\MY_USERNAME\.config\configstore\update-notifier-nodemon.json to update-notifier-nodemon.json.ORIGINAL to allow NPM to use the file name as the target of a rename operation.
Test Socket.IO connectivity
To test the connectivity to the Express Socket.IO server use the following command from a terminal window npx: installed 11 in 4.89s0{“sid”:”vOQHhey-0EYPaAvVAAAA”,”upgrades”:[],”pingInterval”:25000,”pingTimeout”:5000}40 If the return value is 40, in the next 30 seconds the server is listening for new events (pingInterval ms + pingTimeout ms). You can send one with the command42[“EVENT_NAME”, “ATTRIBUTE1”, “ATTRIBUTE2”]
Blue-green deployment in AWS ECS Fargate with CodeDeploy
We will use CodeDeploy to automate the application deployment in our AWS ECS Fargate cluster. Create an AIM role for CodeDeploy to assume the ECS service role In the AWS console navigate IAM and click the Roles link Click the Create role button Click the CodeDeploy link Select CodeDeploy ECS Keep the default setting Enter …
Continue reading “Blue-green deployment in AWS ECS Fargate with CodeDeploy”