When you need something scheduled in Windows, the Task Scheduler is the tool at-hand. Running PowerShell (.ps1) scripts as Scheduled Tasks is done differently than differently than running regular .bat scripts.
This is a quick guide on how to check which features are installed on a SQL Server. Open your SQL Server installation files.
A post on installing SQL Server on Linux, following the Microsoft SQL Server 2019 Guide (Red Hat). # Install SQL Server.# Install the SQL Server Command-Line Tools.# Connect to SQL Server Locally.# Connect to SQL Server Remotely.
This post contains installation notes for installing Firewalld on an Amazon Linux 2 EC2 instance. Firewalld is a Linux firewall tool that makes it easy to create custom firewall rules.
Some network protocols are not enabled by default in SQL Server. We need to enable the option and restart the SQL Service to allow TCP connections.
The release of SQL Server 2019 happened during the first day of Microsoft Ignite (4th November). Up until now, I’ve been using the release candidates for tests… so it’s good to have it all officialised!
In order to join a Windows Server to a domain, you may need to request that the network team open certain firewall rules.
This blog post is a guide on how to create databases and tables in MySQL, from a Windows and Linux computer.
When your machine is upgraded to a newer version of Windows, it leaves behind a C:\Windows.old directory which can be quite large.
A simple run-through of installing MySQL Community Server 8.0, including MySQL Workbench on Windows. Don’t forget to checkout the MySQL Installation documentation, and here’s a link to prerequisites.
Running scheduled tasks in SQL Server Express has to be done differently due to the limitations of the Edition. As well as having a maximum database size of 10GB and 1GB consumable RAM, Express does include the SQL Server Agent.
The sqlcmd utility allows Transact SQL to be run at the command prompt using ODBC to execute SQL batches for MS SQL Server.
