Technology Makes Us What We Are...!!!

Execute SQL Server Script Files with the sqlcmd Utility

August 30, 2023

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

Posted by jineesh uvantavida. Posted In : Tips & Ideas.

VS Code Extensions

February 22, 2023

VS Code extensions allow you to add languages, tools, and debugging support to your installation, which helps to streamline the development workflow. The VS Code is highly extensible, so developers can directly plug into VS Code UI and actively contribute to the coding requirements.

Best VS Code Extensions

1) Live Server :- Helps you launch a local development server with a live reload feature for static and dynamic pages.

2) Remote – SSH :- Create your development environment using the dual c...

Posted by jineesh uvantavida.

ChatGPT: The Most Advanced AI Chatbot

January 18, 2023

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...

Posted by jineesh uvantavida. Posted In : Tips & Ideas.

Top 5 Stored Procedure Performance Tips You Can Use

December 23, 2022

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...

Posted by jineesh uvantavida. Posted In : Tips & Ideas.

Protect a document with a password in Office365

December 8, 2022

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.
...

Posted by jineesh uvantavida. Posted In : Tips & Ideas.

Extracting urls from web page using chromedeveloper tools

December 6, 2022

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...

Posted by jineesh uvantavida. Posted In : Tips & Ideas.

Paste JSON as Classes

November 10, 2022

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": ...

Posted by jineesh uvantavida. Posted In : Tips & Ideas.

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

November 9, 2022

Some of the open source API Management Solutions are

WSO2 API Manager - http://wso2.com/products/api-manager/

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.

Response - http://www.openrepose.org/

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

Posted by jineesh uvantavida. Posted In : Tips & Ideas.

What is API Management?

November 9, 2022

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...

Posted by jineesh uvantavida. Posted In : Tips & Ideas.

How to Make Microsoft Teams Secure

November 9, 2022

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...

Posted by jineesh uvantavida. Posted In : Tips & Ideas.

Older posts »