Showing category "Tips & Ideas." (Show all posts)

Execute SQL Server Script Files with the sqlcmd Utility

Posted by jineesh uvantavida on Wednesday, August 30, 2023, In : Tips & Ideas. 
sqlcmd -S "<servername>" -d <DBName>-i <scriptfile> -o <outputfile>

example:

sqlcmd -S "UV" -d TESTDB-i C:\Users\uvant\Downloads\script_02082023_dataonly\script.sql -o C:\Users\uvant\Downloads\script_02082023_dataonly\output_file.txt

Continue reading ...
 

ChatGPT: The Most Advanced AI Chatbot

Posted by jineesh uvantavida on Wednesday, January 18, 2023, In : Tips & Ideas. 



What is ChatGPT? ChatGPT is essentially a variant of OpenAI’s popular GPT-3.5 (Generative Pretrained Transformer 3.5) language-generation software that’s been designed to carry conversations with people. Some of its features include answering follow-up questions, challenging incorrect premises, rejecting inappropriate queries and even admitting its mistakes, according to an OpenAI summary of the language model. ChatGPT was trained on an enormous amount of text data. It learned to reco...


Continue reading ...
 

Top 5 Stored Procedure Performance Tips You Can Use

Posted by jineesh uvantavida on Friday, December 23, 2022, In : Tips & Ideas. 

Top five performance tips for Stored Procedures

In this post, we will dig into some super easy tips that can be used to speed up your stored procedures.

Knowing how to optimize stored procedures is important, so stick around and I’ll show top five stored procedure performance tips you can use today.

Let’s dig into some super easy tips you...


Continue reading ...
 

Protect a document with a password in Office365

Posted by jineesh uvantavida on Thursday, December 8, 2022, In : Tips & Ideas. 

Passwords are case-sensitive and can be a maximum of 15 characters long.

If you lose or forget your password, Word won't be able to recover it for you. Be sure to keep the a copy of the password in a safe place or create a strong password that you’ll remember.

For Windows :

  • Go to File > Info > Protect Document > Encrypt with Password.

  • Type a password, then type it again to confirm it.

    ...

Continue reading ...
 

Extracting urls from web page using chromedeveloper tools

Posted by jineesh uvantavida on Tuesday, December 6, 2022, In : Tips & Ideas.  

Step 1: In Chrome, go the website that you want to extract links from, like https://www.codeschool.com/.

Step 2: Open Chrome Developer Tools by pressing Cmd + Opt + i (Mac) or F12 (Windows) in the same tab.

Step 3: Click the Console panel near the top of Chrome Developer Tools.

Inside the Console panel paste the JavaScript below and press Enter:

var urls = document.getElementsByTagName('a');
for (url in urls) {
    console.log ( urls[url].href );
}

Now you will see all the links from tha...

Continue reading ...
 

Paste JSON as Classes

Posted by jineesh uvantavida on Thursday, November 10, 2022, In : Tips & Ideas. 
Paste JSON as Classes

When working with APIs we often send a request and receive JSON data. Using C#, we need to transform the data into an object tree. That’s where what I’m going to show you is a game-changer.

First, let’s assume we receive the following JSON data from an API:
{
  "squadName": "Super hero squad",
  "homeTown": "Metro City",
  "formed": 2016,
  "secretBase": "Super tower",
  "active": true,
  "members": [
    {
      "name": "Molecule Man",
      "age": 29,
      "secretIdentity": ...

Continue reading ...
 

What are the best free tools/approaches for API management?

Posted by jineesh uvantavida on Wednesday, November 9, 2022, In : Tips & Ideas. 

Some of the open source API Management Solutions are

WSO2 API manager is just one tool in the massive open source catalog that WSO2 brings in. The company provides a number of open source tools including Identity Server, ESB, Data, Application and API management solutions.

Can use to build stacks of reusable software components. These components can be leveraged by service developers to perform common A...


Continue reading ...
 

What is API Management?

Posted by jineesh uvantavida on Wednesday, November 9, 2022, In : Tips & Ideas. 
API management is the process of creating and publishing web application programming interfaces (APIs), enforcing their usage policies, controlling access, nurturing the subscriber community, collecting and analyzing usage statistics, and reporting on performance. 
API Management components provide mechanisms and tools to support developer and subscriber communities.

Components
While solutions vary, components that provide the following functions are typically found in API management products:

Ga...

Continue reading ...
 

How to Make Microsoft Teams Secure

Posted by jineesh uvantavida on Wednesday, November 9, 2022, In : Tips & Ideas. 
Microsoft Teams is convenient and powerful, but is it secure?

There are multiple layers of encryption at work within Microsoft 365. Encryption in Teams works with the rest of Microsoft 365 encryption to protect your organization's content.
End-to-end Encryption

For situations that require heightened confidentiality, Teams offers end-to-end encryption (E2EE) for one-on-one calls. With E2EE, call information is encrypted at its origin and decrypted at its intended destination so that no informatio...

Continue reading ...
 

Top Microsoft Teams Tips and Tricks

Posted by jineesh uvantavida on Wednesday, November 9, 2022, In : Tips & Ideas. 
Knowing how Microsoft Teams works is one thing. Knowing how to use it well is another. Fortunately, there are plenty of smart tricks experienced users rely on to make Teams more effective and efficient.

1. Use Keyboard Shortcuts
Keyboard shortcuts are a secret weapon to speeding up the most common tasks. It can take a while before you feel like you know your way around these essentials, but once you do, it becomes less than a second’s work to perform a command, instead of fumbling for a menu....

Continue reading ...
 

How to Remove 'Show More Options' From the Windows 11 Context Menu - Command Prompt

Posted by jineesh uvantavida on Thursday, June 30, 2022, In : Tips & Ideas. 
How to Remove 'Show More Options' From the Windows 11 Context Menu - Command Prompt

Open Windows Terminal, Command Prompt, or PowerShell.

Disable:
reg add "HKCU\Software\Classes\CLSID\{86ca1aa0-34aa-4e8b-a509-50c905bae2a2}\InprocServer32" /f /ve

Enable:
reg delete "HKEY_CURRENT_USER\Software\Classes\CLSID\{86ca1aa0-34aa-4e8b-a509-50c905bae2a2}" /f​

 Restart Explorer or reboot.

Continue reading ...
 

What Is Token-Based Authentication?

Posted by jineesh uvantavida on Friday, November 20, 2020, In : Tips & Ideas. 

Token-based authentication is a protocol which allows users to verify their identity, and in return receive a unique access token. During the life of the token, users then access the website or app that the token has been issued for, rather than having to re-enter credentials each time they go back to the same webpage, app, or any resource protected with that same token.


Auth tokens work like a stamped ticket. The user retains access as long as the token remains valid. Once the user logs out o...


Continue reading ...
 

How to only allow numbers in TextBox control in asp.net

Posted by jineesh uvantavida on Saturday, October 14, 2017, In : Tips & Ideas. 
You can simply use regular expression validator as

    <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
    <asp:RegularExpressionValidator ID="RegularExpressionValidator1"
        ControlToValidate="TextBox1" runat="server"
        ErrorMessage="Only Numbers allowed"
        ValidationExpression="\d+">

    </asp:RegularExpressionValidator>

Also you can use the below regular expression to make the text-field as 12 digit number to be added.(madatory)

    ^[0-9]{12}$

Also you can make the field ...

Continue reading ...
 

USB Modem not working on Windows 8 / 8.1

Posted by jineesh uvantavida on Sunday, October 12, 2014, In : Tips & Ideas. 

I have windows 8 RTM( Enterprise Edition ) running on Dell inspiron Laptop with Micromax MMX 300G.
well all versions of Micromax MMX modem will work fine.

Just follow the steps below:

Method 1 (Older Method works fine with Windows 8):

1. uninstall the software if already installed.2. open the modem in new windows and set its (modem_installation.exeand show_modem.exe ) compatibility to windows7 then         press OK.
3. Now install the software , then restart the system .
4. Connect the modem and st...


Continue reading ...
 

When some websites are not loading....

Posted by jineesh uvantavida on Friday, April 13, 2012, In : Tips & Ideas. 
I found in some computers, some websites are not loading (eg: microsoft.com ) . But in the network they are all loading easily. This may be due to some virus activities in that computer.  I suggest you one simple trick, that may work sometimes on yours too...

1. Completely Delete the Browser History. ( including cookies and all.. )
2. Right Click on MyComputer, and click on Manage.
3. Select Services under Services and Applications.
4. Find DNS Client Service.
5. Right click on DNS client service ...
Continue reading ...
 

Printer not working in Windows7

Posted by jineesh uvantavida on Friday, April 13, 2012, In : Tips & Ideas. 
When a printer is installed properly and it showing working properly. But the printer is not printing any document. What we can do..? Just try this.. If it does not solve your issue.. try a google search once more.. :-)

1. Remove the USB cable connected to the computer USB port.
2. Remove the Device from the Devices and Printers in Control Panel.
3. Open Print Management ( Click on Windows icon and search for Print Management ).
4. Select Print Servers from left window, Select local ( with our co...
Continue reading ...
 

Issue with installing Visual Studio 6.0 ACMBOOT.exe is damaged

Posted by jineesh uvantavida on Thursday, March 15, 2012, In : Tips & Ideas. 
1. make a copy of your installation cd in your hard drive
2. make a copy of the setup/VS98ENT.STF and name it acmsetup.STF
3. copy entire content of setup/ to previous folder (the one that has acmboot.exe file)
4. modify acmsetup.stf with acost.exe as you require and save it.
5. run acmsetup.exe instead of setup (the one that's on the same path as acmboot.exe)
6. that's it, your visual studio 6.0 will be installed.



--

Continue reading ...
 

Installing CKEditor & CKFinder in Drupal

Posted by jineesh uvantavida on Saturday, January 7, 2012, In : Tips & Ideas. 
1. Download CKEditor from http://ckeditor.com/download
 
Then Extract it and copy the ckeditor folder to 
- " c:/xampp/htdocs/drupal/sites/all/modules/ " folder if it is xampp
- " c"/wamp/www/drupal/sites/all/modules/ " if it is wamp
 
2. Enable CKEditor module in Modules.
 
- Go to  Configuration > Content authoring > CKEditor         
edit full profile and change File Browser to CKFinder.
 
3. Open  sites/all/modules/ckeditor/ckfinder/config.php and  Delete function CheckAuthentication()
 
- af...
Continue reading ...
 

Intermediate guide to bit torrent

Posted by jineesh uvantavida on Saturday, December 17, 2011, In : Tips & Ideas. 
http://lifehacker.com/286607/intermediate-guide-to-bittorrent
Continue reading ...
 

You can find out your total PC usage with a simple program...!!!

Posted by jineesh uvantavida on Thursday, October 20, 2011, In : Tips & Ideas. 
        We are all anxious to see the total usage time of our PC. Now it is simple. You only have to download a simple application named "PC On/Off Time". This free time tracking tool shows the times your computer has been active during the last 3 weeks, with no previous setup required. The software doesn't need to run in the background, because Windows OS tracks logon and logoff/standby times (working hours) by default, and the program analyses it.

Continue reading ...
 

Ever think of GodMod in Windows...?

Posted by jineesh uvantavida on Monday, September 5, 2011, In : Tips & Ideas. 
Some of you friends may know this....
Did you ever think of creating a control panel of windows by your own name.
There is tweak to create a shortcut or a control panel of your own name.
Just Create a folder in your desktop and name it as "GodMode.{ED7BA470-8E54-465E-825C-99712043E01C}."
This will create a folder with a name GodMod and it will have an icon of Control Panel.
Please try doing this in your PC...
You can also try with your own name...
Enjoy your time...

Continue reading ...
 

Control Panel Folder Path in Windows

Posted by jineesh uvantavida on Monday, September 5, 2011, In : Tips & Ideas. 
Some of you friends, will look sometime to know where this control panel is located.
So for you geek fellows, Its only an executable file under "windows/system32".
So enjoy your time with the control panel in windows. You can do so many things in this Panel.
Try to Enjoy the Panel of windows..........Be a geek.

Path to Control Panel-- "C:\Windows\System32\control.exe"

Continue reading ...
 

Assigning short-cut keys to open Application in Windows

Posted by jineesh uvantavida on Monday, September 5, 2011, In : Tips & Ideas. 
    The simplest method to assign short cut key to open programs or folders.
        1. Create a shortcut of the application or program in the Desktop
        2. Right click on the shortcut and select "Properties"
        3. Under Properties Window, Under "short cut" tab, assign a key in "Short Cut Key" field.
        4. Normally it will be "None". By assigning any key, that will be assign as "Alt+Ctr+Key"
        5. Enjoy your time by opening programs...

    Next method is to download and ...
Continue reading ...
 

Creating a Windows7 Bootable USB Drive

Posted by jineesh uvantavida on Wednesday, April 13, 2011, In : Tips & Ideas. 
Select a 4GB+ USB Drive.

1. Formatting the Drive using command prompt. Open the command prompt as Administrator. and run the following commands.

        diskpart
        list disk
        select disk 1    (Replace the number 1 with the number of your disk)
        clean
        create partition primary
        select partition 1
        active
        format fs=NTFS
        assign
        exit

2. Make the Drive Bootable

    Insert your windows 7 dvd into the drive or open the image using virtual drive and...
Continue reading ...
 

Making the USB Drive to Write Protect.

Posted by jineesh uvantavida on Thursday, February 24, 2011, In : Tips & Ideas. 
This can be done by adding a small entry to the Windows registry which acts as a switch that can be enabled to make use of the write protection or disabled to allow write access.

1. Open the Registry Editor (Open the “Run” dialog box, type regedit and hit “Enter”).

2. Navigate to the following Registry key:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\

3. Create a New Key named as StorageDevicePolicies. To do this right-click on Control, and click onNew->Key and name it as Storag...
Continue reading ...
 
« Back to posts
 

Translate This Page

 


, US

Make a free website with Yola