User Profile
Gohulan
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
ChatGPT — Let’s chat with Artificial Intelligence Assistant
ChatGPT is a one of text based digital intelligence assistant developed by OpenAI which is trained to optimize language models for dialog through artificial intelligence. Why they named as GPT instead of ChatBOT : GPT stands for Generative Pre-Trained Transformer, it means they programmed to work together with AI and the capable of understanding natural human language and generating impressively detailed information like a human being reply. GPT captured the human language and convert it to computer language, again decoder decodes the computer language and dividing it to several sequences. Each sequence predicts the probable through trained AI mechanism which is trained on a massive dataset. Also, this AI trained to reward in several process, Rewards algorithm is designed to learns through trial and error to maximize the rewards. Let’s Start with ChatGPT :To start with ChatGPT visitOpenAI(https://openai.com) andTry Here Before you start talking with ChatGPT, you must create a login using your email address or Google SSO. When you login to the ChatGPT you will be able to see the examples, Capabilities and Limitations of ChatGPT AI Here I am getting a sample text to ask sorry from my girlfriend, Let’s do that Click onNew Threadand Type what you need to interact with Awesome! here we go with the results I got, Here I am going to try a translation with ChatGPT, I have translated the below sentence from English to Sinhala Sentence: I Love you Let’s check ChatGPT have enough knowledge on computer programing language, Will try to create a C# console line application to display Hellow World. See What I have asked What ChatGPT have provided Awesome results, like a lecturer or developer replies. Hope everyone immediately starts exploring with ChatGPT AI and help them to develop more with your requirements. Happy Chat !!Generate your imagination with Midjourney
Have you heard about generating pictures with the words, imagine you need a picture of vintage camera in the background with Dj lights and the quality should 4k. Normally what we can do is googling the above requirement and download the picture from the internet if it’s already existing somewhere. If it was not there in the planet, we have to download the vintage camera and DJ back lights background separately and start merging those with the help of photo editing software and to export in the quality of 4K. Are there any possibilities to get the image as you want and further edit until you satisfied with the image, it’s just like chatting with a graphic designer and do the modification in the chat box. Yes, do we have an AI bot called Midjourney. What is Midjouney ?Midjouney is an AI bot which is developed to understand human requirements and to provide the imaginative results to expand the power of the human species. Simply an AI image generation tool, with the input given from human texts. Get Started with Midjourney To get started with Midjourney just you need only your browser and go toMidjourney(https://www.midjourney.com/) Join the Beta to explore the AI image generation, it will direct you to a different page to connect you with their official Discord channel, accept the invite to join Midjourney Once accepted you will be directed to the Discord channel new Commer rooms, it will be named as #newbies-xxxx How to Generate the image with Midjourney Bot —Soon after you joined in the Discord rooms, you need to generate the image with Message or text, Every text should start with - /imagine and the parameters needs to be entered. /Imagine [parameters] Ex: I am going to generate a Vintage camera image with the DJ Lights background, Image Resolution is 4K There was not any coding or any scripts, just typed the requirement as in the plain text format. Now it’s accepted the challenge and waiting to start, it will generate the image and provide you the results, generating results will be took some time to display in the room. Here are some results generated with Midjourney AI. Wow! It’s pretty good, what are U1,U2,U3,U4 & V1,V2,V3,V4 U1, U2, U3, and U4 are buttons for Upscaling your chosen image & in the bottom row: V1, V2, V3, and V4 are buttons for creating Variations of your chosen image. Creating variations will generate four new images, similar in overall style and composition to the image you selected. How can I save the images to local computer? I am going to save the image no 3 to my local computer. Select on U3 I have selected the image no 3 and it’s upscaling the image. It’s upscaled and the image is in the preview mode now, if you need to do Make Variations, Light Upscale Redo or Beta Upscale Redo you are free to do it here. without any modifications I am going to save this image to local computer. Clink on the image and save to computer as how you save the picture from internet or else if you want to open the original click the Open Original option to view the original image in the web to save. You can find my original image here:Gohulan_Vintage_Camera_in_the_background_of_Dj_Lights_4K_fe864ba5–14fa-4024-bdf5–51852e6e3345.png (1024×1024) (discordapp.com) Learn more about Midjourney :Quick Start Guide — Midjourney Documentation (gitbook.io) How to get the information about your discord profile Type /info in the message box and send to receive the information about Can I upload my own image and generate a custom edit: Yes, it’s possible here the way how you can do it. Go to Message box and upload the file to chat room I am going to upload my own image and to convert me as a cartoon character with Midjourney bot Once the picture is uploaded, get the link by right click the image and select copy image link Oh! Here my cartoon character has been released Limitation in the free tier: In the free tier whatever the images you are generating is public, so if you want to generate images privately use the parameter /private to switch the chat bot to private mode. Here I am unable to do it since I am on the free tier. Subscriptions can be found here:Midjourney Subscription Hope you are in the Midjourney to start your AI journey with generating images.Create PowerApps Application with On-premises SQL Server
PowerApps is a one of the powerful low code applications from Microsoft, which helps to develop millions of applications within a minute. Only platform which allows technical and non-technical to implement application with their requirements. Power platforms can be developed to receive data from different data sources like Excel, SQL server, share point resources and data from different cloud storages like Google, OneDrive, etc. Considering OnPrem data sources we do traditional coding to connect the application with the data source. But here we have a possibility to develop a PowerApps and receive data from On Prem SQL server. In this article I will show you how to connect OnPrem SQL to PowerApps. Pre-Requites 1)OnPrem SQL Server 2) PowerApps Subscription 3) On-Premises Data Gateway 4) Internet Connection On-Premises Data gateway for Power Apps On-Premises gateway is a bridge which provides most secure communication in between local sources to cloud applications. To know and learn more about On-Premises data gate way:What is an on-premises data gateway? — Power Apps | Microsoft Learn SQL Server on Windows 10 Machine I have SQL database installed on my Windows 10 machine, which is a local machine with the active internet connection. If you are new to SQL server installation and configure, I have shared some other posts which will show you how to install and configure SQL server 2022 in your test environment. Download SQL Server 2022:SQL Server 2022 Trial (microsoft.com) To Confirm your Installed Version: SELECT @@VERSION I have created a table named Demo Data and inserted some sample data Let’s configure the On-Premises Data Gateway To Download the On-Premises Data Gateway for PowerApps please download the Gateway from below link —Downloads | Microsoft Power Apps. Once it’s downloaded install it to the local machine, it will take some time to install. When installation succeed it will prompt a dialog box to enter the Microsoft account details. Use the same account which you used to create PowerApps. In the next step create a Gateway with the valid security and recovery key. Here I named my gateway as DEMOPOWERAPPS Create Configure button to apply the configurations and close the dialog box, now it’s done. Now it’s time to build the app in PowerApps Go to PowerApps portal to make the app — make.powerapps.com I am going to create the PowerApps with SQL data source Click the SQL and add the New Connection and select the connection source as SQL database (SQL Server). In the authentication type select SQL Server Authentication from the drop-down list. In the source selection pane select Connect using on-premises data gateway as data source for SQL server SQL Server Name — Windows 10 Local PC Name SQL Database Name- POWERAPPSDEMO Username- demouser Password-[Your SQL User Password Here] In the bottom you need to select the installed gateway, here it will show the gateways you installed with the Microsoft account which you used to create the PowerApps. Here my installed DEMOPOWERAPPS gateway is listed and it’s showing, if your gateway is not listed, please refresh the gateway list. Once you select the correct gateway click create to link the data source to PowerApps. It will show the available tables once the gateway connection is succeeded, here my table DemoData is showing. I am going to use the DemoData table to connect with PowerApps. In case in the same database if you want to change or create new table you can either create it from here or choose different one. Click connect to link the On Prem database with PowerApps, It’s done and app is automatically created now. Without doing any additional changes in the app I will see the preview of the app to check to see whether it’s communicating correctly with the SQL database available at my laptop. The data which I entered manually using SQL commands are appearing here, it means it’s perfectly connected with the on prem SQL database. By adding an edit form in the PowerApps you can be able to insert the data from PowerApps to On Prem SQL Server. Just try this by yourself and let me know if you have any issues in connect On Prem SQL server to Power apps. Happy Coding!!Access Microsoft SQL Server remotely with command prompt - Remote SQLCMD
One of my clients recently had an issue with their Microsoft SQL server which runs on top of Server 2012, we are unable to get the remote connection to the server but while the database installation I have configured the remote access to the database server. That is make so easy to troubleshoot and get the backup to the external drive via remote SQL command prompt. Here I will explain how we can easily configure the SQL server to allow remote connections from client machine which is available on the same network. In this demo I have SQL server 2019 installed in my laptop. Allow TCP/IP Connections in the SQL Configuration manager. Open SQL Server configuration manager in the server and open SQL Server Network Configuration. Expand it and find the protocols for your instance, here I am using the default SQLEXPRESS instance. In the right pane you will find the protocols called TCP/IP, by default status will be set to disabled, open TCP/IP by double click on the name. TCP/IP properties will open in a new window and enable it by set the drop down to Yes to the Enabled field. Then go to IP Addresses tab next to the protocol tab in the same properties window open. You will find number of IP addresses available in the configuration, it’s not a good secure practice to enable all the IP address but here I am going to use the IPALL for remote connection. In the bottom of the windows, you will find IPALL configuration with a default dynamic port. Clear it and set an available port in the TCP Port. I am using 5068 port. To find the established and available port number you can use the netstat -a -n -o command in the command prompt. Once done, enable the firewall rules for the port used in the previous step and restart the firewall. If you are testing in demo environment, simply turn off the firewall. Restart the SQL Server Services to apply the changed made in the configuration. The configuration in the server part has completed now. Below installation must be need in the client machine/s to access the SQL server database. Client SQL CMD Installation SQL CMD Utility is a tool with command line interface which helps to access the MS SQL database. Before install, the SQLCMD utility there are some other prerequires must be installed in order to install the sql cmd successfully otherwise you will encounter some errors as below. Here it’s requiring Microsoft ODBC Driver 17 for SQL Server, which helps to communicate between database and the applications. It can be downloaded from the following link – Download Microsoft® ODBC Driver 17 for SQL Server® - Windows, Linux, & macOS from Official Microsoft Download Center If your windows is not in up to date the following update will be require in order to install the ODBC Driver, update can be downloaded from the below link Download Visual C++ Redistributable for Visual Studio 2015 from Official Microsoft Download Center If the client machine fulfilled the above two prerequires you can start installing SQLCMD utility tool in the client machine, SQLCMD can be downloaded from the below link. Download Microsoft® Command Line Utilities 14.0 for SQL Server® from Official Microsoft Download Center Once Command Line utility installed, we can connect to the database using the below command. sqlcmd -S DESKTOP-0AB9P2O,5068\sqlexpress -U sa -P yourpasswordhere The format should like this sqlcmd -S [Servername where SQL Installed], [Port Number configured earlier in the SQL Server Configuration Manager to allow remote connections] \ [SQL Server instance name] -U [Username] -P [Password] Now I am going to take the backup of Datastore database to my external drive (here my external drive is G). backup database DataStore to disk='G:\BackupDatastore.bak' So now without logged into the actual server I have copied the current backup to the external drive, so by configuring this method you can save the data incase if you get any Windows failures. Also by this you can make sure the database is running or not by following any kind of queries remotely.Hello .NET 5.0 & What’s New in .NET 5.0
All the .NET developers are so excited to use .NET 5.0 from today, released couple of minutes before in .Net Conf 2020 (10th November 2020). They have skipped the name “Core” and “Framework” to avoid the confusion, this version supports both Core and Entity Framework Simply download the SDK from here and install - https://dotnet.microsoft.com/download/dotnet/5.0 Once installed verify the version by - dotnet --version .NET 5.0 development is supported in Visual Studio 2019, 16.8 update. What’s new in .NET 5.0? support for building high-performance cloud applications. High performance. Side-by-side installation. Small project files (SDK-style). Java interoperability will be available on all platforms. Roadmap of upcoming .NET Releases .NET 5.0 2020 NOVEMBER .NET 6.0 2021 NOVEMBER .NET 7.0 2022 NOVEMBER .NET 8.0 2023 NOVEMBER Benefits of Windows Desktop application with .NET 5.0 Benefits of Xamarin Forms application with .NET 5.0 Compatibility matrix of .NET 5.0Deploying .NET Application for Oracle Autonomous Database
Hello Everyone, in these days I am working with some multiple projects on developing applications for Oracle Cloud database so thought to make a content on how to deploy the .NET applications for Oracle Autonomous Database, when we consider about the Oracle Cloud Infrastructure there are so many resources ready to deliver services like Azure platform, I have chosen Autonomous Transaction Processing Database as workload type for my development purposes. The unique is same in developing when we compare with Oracle on premises application development, but some alternative things needs to be done before the deployment. Will start working with Deploying my application in C# .NET now, for my development I planned to use our traditional Oracle Managed Data Access library from NuGETpackages. Visual Studio (Solution Explorer >> Reference >> Manager NuGET Packages) Once it's downloaded to our Program, just call the reference using statement using Oracle.ManagedDataAccess.Client; As the usual manner define the connection string for the Oracle Cloud DB, OracleConnection conn = new OracleConnection(); conn.ConnectionString = "User ID=ADMIN; Password=Demo@123; Data Source=demooradb_high"; conn.Open(); So in the connection string I have highlighted the Data Source, so where it's came from, normally we can find the source name in the TNSNAMES.ORA file on premise database instance. Here to we are going to use the same procedure but to getting know about source name we have to download the tns and other files from the ATP service console. In the ATP service console there are some set of files available for download which are the files going to serve our applications to connect ATP outside from the cloud. These are the files are creating the secure connections in between our applications and ATP in the cloud. These file set can be downloaded as a ZIP file from the console. ATP Cloud ( DB Connection >> Download Mobile Wallet (Instant Type) >> Download Client Credentials In the downloaded ZIP file, you can see TNSNAMES.ORA file, open the file in the text editor. In the cloud there are five predefined service names available to connect with database. High,Law,Medium,TPUrgent and TP depends on your processing and workload type you can use any of these service names. In my workspace my db name is demooradb and using the high service name to connect with ATP Also in the Autonomous instances, we are only using the ADMIN credentials not the sysdba or system users. In the same extract or unzip the wallet files to the location where your program is debugging from, here my debug location is (...\ATPDEMO\ATPDEMO\bin\Debug) Extracted all the files in the location, actually for the .NET we do not want to copy some other files but for the time being I just copied all the files. Wallet location or directory must be the same locationwhere the program is running from , I changed the location as current root. (./) Save the sqlnet file and close the editor. Now the coding part, using Oracle Command and Oracle Command Reader send the query and get the results to our .NET application. OracleCommand oraCmd = new OracleCommand("your query here", conn); OracleDataReader oraReader; oraReader = oraCmd.ExecuteReader(); Finally get the results or display the results in your Windows form application, I am getting my results and displaying in Messagebox in my application. while (oraReader.Read()) { MessageBox.Show(oraReader.GetString(0)); } Close the connections of orareader & Oracle connections. oraReader.Close(); conn.Close(); Debugthe program and Have Fun with Coding !!! For Detailed coding refer this video tutorial -https://www.youtube.com/watch?v=gUxGyoSrg4gMigrate Data from Oracle to MS SQL Server
Nowadays people in IT are considering to migrate here and there, on premises to cloud sometimes cloud to on premises base on their requirements and resources. When we come to database maintenance here also we are facing the same problems. In the database world there are lot of databases available in the market based on their requirement they will move over to different plat form, the issues when then plan to move over is the data. Whatever the data they used in the past since they can't easily wipe off. In this document I am showing you the way of migrating the Oracle 12c database to latest Microsoft 2019 SQL server without any lost, at the same when we considering the migration we have to make sure that our application also supported with Microsoft SQL server, As I am working on my own application I am pretty sure that I have written the same code to Microsoft as well. Will start the migration, before starting this I am requesting you to these prerequisites done earlier to the migration Oracle Database 12c Installed Microsoft SQL Server 2019 Installed Microsoft Data Migration Assistant tool downloaded Please allow the following ports through your firewall 1521 - Oracle , 1443 - MS SQL Here from my Oracle Database I have several schema, but only migrating the COREDB schema, as we know thatAn Oracle database contains schemas. An instance of SQL Server contains multiple databases, each of which can have multiple schemas. Creating the COREDB database in the SQL Server Create New database in the Destination Server Login to the SQL Management Studio and Create the new database Login with your server name, user credentials and create new database named COREDB Fresh COREDB database is created, It's blank database Will Migrate the Data from the Source Oracle database now Open Migration Assistant tool and create a new project Connect the Oracle database to the project using Oracle database parameters Once it's connected it will load all user schema to the project In the mete data explorer will confirm that all the schemas has been loaded to the project Now select the schema which you need to migrate and select all other objects as well, if your database is connected with application sever you must select the all objects Views, Functions, Tables and etc Now we need to connect the destination SQL server with Server credentials, Once it's connected check with the meta data explorer on the database Once done click on the source Oracle schema and convert the schema to SQL server After it's finished on the destination server click the database and synchronize the schemas with source database verify that the Arrow is correctly showing from where it needs to be synchronize Once done login to Management studio and verify that some of the system tables and schema views has been created After verified, we have finished all the schema creation and the other part of system function views. Now it's time to migrate the tables and data. Go to the source server schema and click on the migrate data It will ask the Oracle and Microsoft credentials again, give the correct parameters and click on ok After verified the source and destination server credentials, it will start the migration of the tables with the data See the logs and report to verify is there any migration errors or failures Login to Management studio and see the tables and data has been migrated successfully To make sure all the data from the source server has been migrated successfully, I have ran a query on the both databases, On the source server, On the destination server, Yes, I'm done. Both the results are same means its migrated succesfully. Happy Migration!!Getting Started with BOT Framework
The Microsoft Bot Framework (preview),framework enables organizations to build intelligent agents, known as Bots. The Framework provides developers with a developer portal and SDK to build Bots, a Bot Connector service to connect to social channels such as Twitter and Slack, and a Bot Directory to discover and use existing bots. Bots (or conversation agents) are rapidly becoming an integral part of your digital experience. Getting Started with BOT Firstly, you have to download and extract the Bot template, System Requirements Visual Studio 2015 Update 1 or Visual Studio 2017. Bot Emulator (Downloaded from the Website). You can download from the following links Bot Template —http://aka.ms/bf-bc-vstemplate: Bot Emulator —http://emulator.botframework.com/ Visual Studio —https://www.visualstudio.com/downloads/ Once Bot Template downloaded copy the Zip file to following location The Visual Studio 2017 project templates directory is typically located here: %USERPROFILE%\Documents\Visual Studio 2017\Templates\ProjectTemplates\Visual C#\ Open Bot Template As usual open New Project in Visual Studio and go to Templates >> Visual C# In the bottom you can find the template namedBot Application Give a meaningful name and click on OK Interface of Bot Bot Interface is not like other interfaces it won’t show anything until you open something In the Solution Explorer bar you can see some kind of files Installing Bot Emulator Once bot emulator is downloaded from the web just double clicked on it, it will start installing Bot Emulator will looks like this Until we developed a error free program we won’t be able to see anything here Configuring Dev.Bot Once everything finished locally if you are trying to upload your bot and connect with the channels you have to configure the web site also Direct tohttps://dev.botframework.comand sign in with your Microsoft account, once done Click on Create Bot It will direct to the following sitehttps://dev.botframework.com/bots/new Display Name — Your Bot Name Handle — Used in the URL for your bot. Alphanumeric and underscore only. Cannot be changed once registered. If you are trying to develop for your web site Message Endpoint URL will be there And Microsoft App ID and Password is necessary to use this app globally if you are debugging locally it’s not necessary to get those. Generate Microsoft App ID & Password App Name — Meaningful Name of your Bot App ID- Automatically generated by Microsoft Click on the Generate App password to continue New Password will be generated online. Click on OK Once all finished click on Agree and Register you Bot Thanking you, Happy CodingKali Linux is Available in Windows now, How to Enable it?
This header is remains shocking for me, Powerful penetration testing and the security tool comes to the Microsoft Store for Windows 10. Linux open source was as a longtime enemy of both Microsoft & Apple, that is no longer true. Kali Linux Kali Linux one of the most powerful penetration testing operating system with over hundreds of default testing tools. It is maintained and funded by Offensive Security Ltd. Utilized by security experts in an extensive variety of specializations, including penetration testing, forensics, reverse engineering, and vulnerability assessment. Since the Ubuntu and Open SUSE are available in the Windows store, as same we need to customize our windows environment before we start working on Linux. Setup the Environment Enable the optional feature “Windows Subsystem for Linux” Click Start button and Search Turn Windows features On/Off Select and checkEnable -Windows Subsystem for Linux & Restart Alternative Way Open PowerShell and type or copy the following command Enable-WindowsOptionalFeature -Online -FeatureName Microsoft-Windows-Subsystem-Linux Reboot the workstation. Now move to the Microsoft Windows Store and Install Kali Linux Once installation is finished update the following via command prompt. apt update apt dist-upgrade reboot Let’s start your penetration testing with Kali Linux in Windows 10, Happy Hacking !!Power of Data Scientists & IoT to create a Smart World
Now and in the future most of the companies are investing in IoT to improve their business activities, However, the long-term goal of many IT companies are to develop a Artificial Intelligence solutions to each and every problems. Data Scientists are the most valuable people on making effective use of the data by analyzing the old big data and produce a powerful summary. Business organizations that plan to invest on IoT should consider the old data before they invest on it. Also the job of Data Analysis and Analytics are highly in-demand. Big Data & Analysis Big data is a number of huge data sets structured and unstructured data that has sensitive or simply but cannot be processed with community or relational database engines, it’s demands different procedure to process and stores in different storage. Data analysis is the process of inspecting, cleaning, transforming, and modeling data with the goal of discovering useful information, suggesting and supporting decision making. Most common tools used to analyzing areR-Programming, Spark, Cloudera, Orange, RapidMiner, Weka, NoSQL, Qlik, Infogram. Algorithms Computer Algorithms are producing mathematics calculations or formulas to searching, sorting, recursion, and coding challenges. An encryption algorithm transforms data according to specified actions to protect it.When a person becomes specialized in algorithms or can handle powerful algorithms means he/she is master in IT world. How do IoT connected with Big data and Algorithms When a analysis analyze the big data and summarize the final reports, Developer will create the Algorithms to make the IoT device, where we can discover the previous errors, usage, incomes and some meaning full information from the big data analyse and suggest a new improved design for upcoming projects. Artificial Intelligence = Big Data + Algorithms Artificial intelligence describes machine which able to do what we expect from human intelligence. Since this definition is subjective, artificial intelligence may change as our expectations of computers evolve. Most successful projects by AI areSiri, Tesla, Boxever, Amazon Go Store.AI system becomes better than humans at all cognitive tasks.Google’s Waymoself driving project is the upcoming AI major project. How can IoT and Big Data Analyse be dangerous ? This can happen whenever we fail to secure our data. If sometimes hackers able to change the data or misuse the packets of commands from the users. As these examples illustrate, the concern about advanced AI isn’t malevolence but competence. Since the researcher has to find a way to verify the data and secure the way of accessing data by third parties. Whats is Smart World ? Smart World is a solution to all necessary things happens day to day in the world by machine learning, understanding solving threads without human attempts but use many data collection sensors to complete the task. Data scientists who are working with IoT and AI will need to know how to analyze massive data sets, what to look for in the data, and how to make productive business decisions based on findings. In future we may see so many greater need for data scientists to work on IoT projects.
