Most of the times, I use the following scripts to get list of triggers SELECT sysobjects.name AS trigger_name ...
I was deploying a new website ovre IIS in Server 2016 DC edition. After deploying the site, it started throwing HTTP Error 500.19 - Inter...
I had to compare data between two different sheets, then fetch the data from a specific cell in sheet B and copy it to another cell in Sheet...
Convert yyyymmddhh24miss to dd/mm/yyyy hh24:mi:ss Recently came across an excel issue where pivot table was not recognizing the date importe...
Received the below error on running a power shell script in a windows 10 machine 64 bit, after a fresh install. I resolved the issue by upda...
Recently had an issue installing the .NET Framework 3.5 on a win 2016 server hosted in Azure. Tried adding it using Roles and Features, Fai...
IIS Error - 403 Forbidden Access is Denied Some users received this error after SSL was enabled. The self signed certificate wa...
Enabled SSL on a site. Post enabling SSL, the site was still accessible via http requests. In order to redirect all http request to https...
Run the shell command below to get the extract. Get-ADUser -Filter {SamAccountName -like "*_a"} | Select-Object Name,SamAccountNam...
Create a function in your database to remove html tags in SELECT statement. Use this function in select's to trim html tags. CREATE ...
There are various logics to convert bigint data type to datetime. I use different logic based on each data extraction YYYYMMDDHRMISS - MA...
INFORMATION_SCHEMA is a quick way to get around a database. Hope this helps. Generate list of all table and columns in the table. Select * ...
If you are missing the network drives on an enterprise workstation, you can use the following commands to publish the drives shortcuts. n...
Recently had a custom requirement to auto populate PASSWORD column, while considering each password must be unique and self understood by ...
I was trying to search for ways to list all columns where special characters are entered. If some one can help in doing a lookup in a certa...
We can fetch sequence number using 3 commands: DBA_SEQUENCES all sequences that exist ALL_SEQUENCES all sequences that you have permi...
Recently i had to fetch the list of AD users where PasswordNeverExpires was selected. I used the following powershell script's to f...
Use the following script to verify an oracle user lock status. select username, account_status, created, lock_date, expiry_date from dba_u...
Recently came across the error on running crystal report. The report was developed some time in 2009, using an older version of oracle. T...
I was recently working on date manipulation in oracle DB. I came across different scenarios and had to go back to basics. Used the followi...
Posts
