Search For:
- Home
- Search For:
Wildcards in SQL Server
This article will guide to use #Wildcards in #SQL server. Also you will learn how to use and escape wildcards SQL-based databases.
To use a wildcard character within a pattern: Open your #query in Design view. In the Criteria row of the field that you want to use, type the #operator Like in front of your criteria. Replace one or more characters in the criteria with a wildcard character.
i. The wildcard is an advanced search technique that can be used to maximize your search results in library databases.
ii. Wildcards are used in search terms to represent one or more other characters.
iii. The two most commonly used wildcards are: An asterisk (*) may be used to specify any number of #characters.
DNN reindexing crawling
This article will guide you on how to resolve DNN #websites not #indexing. When the DNN site re-indexing is not #crawling properly, we delete the files in \App_Data\Search folder and we click the re-index button.
1. You may clear the search tables and re-index, but I suggest upgrading to DNN 7.3.4 or 7.4.1, where a log of issues with new (#DNN 7.1) search engine).
2. You might Need to remove all Content of /app_Data/search Folder, if there are issues with indexing.
Disable ModSecurity for a domain
This article will guide you on how to disable Mod_Security for a specific domain. Basically, ConfigServer #Modsecurity Control allows us to disable the #rules that are blocking access to a specific #domain.
1. Mod_security module helps to protect your website from various #attacks.
2. ModSecurity is an open-source web-based firewall application (or #WAF) supported by different web servers: Apache, Nginx and IIS. The module is configured to protect web #applications from various attacks.
3. If mod-security is disabled on your account, your website will be at risk from vulnerabilities.
4. To disable modsecurity, all we need to do is remove/rename that file and restart apache. Remove the include line loading mod_security (or more likely mod_security2) from your Apache config.
Automate Windows Server 2019 Administration with Ansible
This article will guide you on steps to automate Windows Server 2019 #Administration with Ansible.
Ansible can be used to manage and execute core functions in Windows #environments, from security updates to remote management using #WinRM. Although Ansible must be run on #Linux, Windows administrators can use Ansible to manage and automate their systems without needing to know how to use a Linux #terminal.
To Connect Ansible on Windows from #Ubuntu:
1. Create Ansible Windows User. Create a new user for the Ansible windows connection setup.
2. Setup Libraries and WinRM.
3. Update the Ansible Inventory file.
4. Update the Ansible Group Variables.
5. Configure #Windows Servers to Manage.
6. Test Connectivity to the Windows Server.
SQL error 825 How to fix it
This article will guide you on methods to resolve SQL error 825 which indicates a major disk problem and not a SQL server problem.
The connection to #SQL server cannot be established or is no longer usable. There can be various causes of this #error. The most common causes are that Microsoft Dynamics NAV Server has stopped or the connection to SQL #Server is not configured correctly.
To find SQL errors:
i. In SQL Server Management Studio, select Object Explorer.
ii. In Object Explorer, connect to an instance of SQL Server, and then expand that instance.
iii. Find and expand the Management section (assuming you have permissions to see it).
iv. Right-click SQL Server Logs, select View, and then choose SQL Server Log.
Every SQL Server #database has a transaction log that records all transactions and the database modifications made by each transaction. The transaction log is a critical component of the database. If there is a system failure, you will need that log to bring your database back to a consistent state.
To get SQL query history in SQL Server:
1. In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.
2. Expand SQL Server Agent, and then expand Jobs.
3. Right-click a job, and then click View History.
4. In the Log File Viewer, view the job history.
5. To update the job history, click Refresh.
Powershell to enable script execution
This article will guide you on how to fix #Windows script error via PowerShell. Basically, we used #PowerShell to enable script #execution by running some #commands.
PowerShell is a cross-platform task automation and configuration management framework, consisting of a command-line shell and scripting language. Unlike most shells, which accept and return text, PowerShell is built on top of the . #NET Common Language Runtime (CLR), and accepts and returns . NET objects.
To enable script execution in PowerShell:
i. Open Start.
ii. Search for PowerShell, right-click the top-result and click the Run as administrator option.
iii. Type the following command to allow scripts to run and press Enter: Set-ExecutionPolicy RemoteSigned.
iv. Type A and press Enter (if applicable).
