Menu
How to create a user and grant permissions in Oracle
01/22/2024
| No Comments
| Oracle, PL/SQL

As always, begin by connecting to your server where Oracle is hosted, then connect to Oracle itself as the SYSTEM account. The SYSTEM account is one of a handful of predefined administrative accounts generated automatically when Oracle is installed. SYSTEM is capable of most administrative tasks, but the task we’re particularly interested in is account management. Creating a user Once connected as SYSTEM, simply issue the CREATE USER command to generate a new account. Here we’re simply creating a books_admin account that is IDENTIFIED or authenticated by the specified password. The Grant statement…

Read More

Posted in Oracle, PL/SQL Tagged Comments Off on How to create a user and grant permissions in Oracle
Add IDENTITY or Unique number to a table – T/SQL
10/03/2023
| No Comments
| Microsoft SQL, SQL, T-SQL Code

I want to update my table records. However, my existing table does not have any unique columns. So, I need to append Identity column and update all the records based on that Identity column. For example, If my temp table has 1000 records without any unique column values. I need to number all these 1000 records and update the values. There is no need to do an UPDATE. The identity column is going to be populated when it is created….

Read More

MySQL my.ini Performance and Optimization Tips
02/10/2023
| No Comments
| MySQL

The major advantage of identifying the performance-driving factor for a database is that it allows you to avoid over-provisioning and reduce costs by right-sizing your servers. It also gives you insights into whether moving data storage or adding server capacity will improve performance and, if so, how much it will be. The tuning database for MySQL query performance optimization doesn’t come with pale challenges. However, once tuned properly, the database gives worthwhile performance results with great functionalities. It lowers…

Read More

Posted in MySQL Tagged , Comments Off on MySQL my.ini Performance and Optimization Tips
How to Install an SSL/TLS Certificate In Microsoft IIS 7
08/30/2022
| No Comments
| IIS

The following instructions will guide you through the SSL installation process on Microsoft IIS 7. If you have more than one server or device, you will need to install the certificate on each server or device you need to secure. If you still have not generated your certificate and completed the validation process, reference our CSR Generation Instructions and disregard the steps below. What You’ll Need 1. Your server certificate This is the certificate you received from the CA for your…

Read More

Posted in IIS Tagged , Comments Off on How to Install an SSL/TLS Certificate In Microsoft IIS 7
How to run .msi files as an administrator
07/26/2022
| No Comments
| Windows Tools

Starting in Windows Server 2012 the “Run as administrator” option no longer appears when right-clicking a .msi file. This may be a required step when installing certain applications onto your Windows Server. Below are some options to be able to run a .msi file as an administrator. As a single-use solution, you can run the .msi as an administrator from the Windows command prompt. Open elevated Command Prompt. To do so, type “CMD” in the Start menu or Start screen search box,…

Read More

MSSQL – Query to Find Column From All Tables of Database
07/14/2022
| No Comments
| Microsoft SQL

How many tables in the database AdventureWorks have column names like ‘EmployeeID’? It was quite an interesting question and I thought if there are scripts that can do this would be great. I quickly wrote down the following script which will go return all the tables containing specific columns along with their schema name.

Read More

Check If IEnumerable<> or List<> Type is Empty / Null
07/13/2022
| No Comments
| Visual Studio

There are three ways to check whether IEnumerable<> or List<> type is empty / null or not. == NULL .Any() .Count() In any case, you always want to combine “== null” and, either “.Any()” or “.Count()”, with OR (“||”) operator. In addition, you want to put “== null” before the other condition. The reason for this is, “if” condition goes from left to right. So, if the list object is null, it will not go to the second check,…

Read More

How to search in Outlook
07/13/2022
| No Comments
| Microsoft Outlook

Outlook provides you with a number of built-in search filters. To use the built-in filters, click in the Search box. Based on your preference, you can use Advanced Search by clicking the filter button on the right side of the search box. Alternatively, the Outlook ribbon will change to show the Search tab and you use any of the options in the Refine group to refine your search results. You can find the search box at the top of…

Read More

Visual C# Code Snippets
07/13/2022
| No Comments
| Visual Studio

By default the following code snippets are included in Visual Studio. Name (or shortcut) Description Valid locations to insert snippet #if Creates a #if directive and a #endif directive. Anywhere. #region Creates a #region directive and a #endregion directive. Anywhere. ~ Creates a destructor for the containing class. Inside a class. attribute Creates a declaration for a class that derives from Attribute. Inside a namespace (including the global namespace), a class, or a struct. checked Creates a checked block. Inside a method, an indexer, a property accessor, or an event…

Read More

© 2019 www.myw0.com . All Rights Reserved
Design www.tenemaza.com