User Profile
Gohulan
Brass Contributor
Joined Nov 07, 2019
User Widgets
Recent Discussions
Re: Investigating Storm-0558 security issue?
As customers using enterprise applications or app registrations, your control over the app's internal security mechanisms might be limited. In such cases, the responsibility for implementing remediation measures generally falls on the app developer or the service provider offering the application.Re: Investigating Storm-0558 security issue?
Examine suspicious authentication attempts using OpenID tokens signed by the compromised key. To do this, unpack the access tokens used against the application and search for the string "1LTMzakihiRla_8z2BEJVXeWMqo" within the "kid" field of the JOSE Header.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 visit https://openai.com/ (https://openai.com) and https://chat.openai.com/chat 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 on New Thread and 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 to https://www.midjourney.com/ (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: https://cdn.discordapp.com/attachments/1008571080300052482/1057173671749361794/Gohulan_Vintage_Camera_in_the_background_of_Dj_Lights_4K_fe864ba5-14fa-4024-bdf5-51852e6e3345.png Learn more about Midjourney : https://midjourney.gitbook.io/docs/ 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: https://www.midjourney.com/checkout/plans/?hash=a92a8db2f304b9e3cfe07e4eeef3fe8e7c6423f0a7c4718a80e548f8b28aa2fa5a67b57cb7c935cb63189c22d165bd86IobdFZxuwCejOHoPvuynTf7se6DY0+qf/kyAdB7kkSXs5SWDtDUrtZlxecd3b6FSAXmpknc3VdYK3NrmoqQFlgcDkZse10B/uMfn0DXkIoWh/2JAigaBKsfENzvWI+I+EgM0Ypnq/q8x8LwsBS+czsWTx1TcfIbfFcdZbRO68jnAByGcIl6Jo7+BQeWyNnTPIwv2nYeB4nBdQdcbSY6OP3QH+1FoTB/Zz8v9z8PeFVFddAyysTxxeCj0g8NWY8Z6FPa/G1lHpbQCeiPlXEMRdeRes6OYokiU3hOev1ymd4U= 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: https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/gateway-reference 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: https://info.microsoft.com/ww-landing-sql-server-2022.html?culture=en-us&country=us 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 — https://powerapps.microsoft.com/en-us/downloads/. 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 – https://www.microsoft.com/en-us/download/confirmation.aspx?id=56567 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 https://www.microsoft.com/en-us/download/confirmation.aspx?id=48145 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. https://www.microsoft.com/en-us/download/details.aspx?id=53591 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.0Re: Missing Resources in Azure - All Resources
If your internet browser page hangs, try each of the following steps until you can get to the Azure portal. Refresh the page. Use a different internet browser. Use the private browsing mode for your browser. For Internet Explorer: Click Tools > Safety > InPrivate Browsing, and then browse and sign-in to the https://portal.azure.com/ or https://account.azure.com/Subscriptions. Make sure that the correct Azure directory is selected by clicking your account at the top right. If the right Azure directory is selected but you still receive the error message, have your account https://docs.microsoft.com/en-us/azure/cost-management-billing/manage/add-change-subscription-administrator. This problem occurs if you selected at the wrong directory, or if your account doesn't have sufficient permissions.BIPONRe: azure setup
You can Indicate with Appachi Hive on HDInsight or Deploy through Hadoop, Have a look on the following articles for more details https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/data-warehousing https://docs.microsoft.com/en-us/azure/hdinsight/hadoop/hdinsight-use-hive Parthiban101193Deploying .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 location where 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(); Debug the 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 that An 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 named Bot 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 to https://dev.botframework.com/ and sign in with your Microsoft account, once done Click on Create Bot It will direct to the following site https://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 check Enable -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 are R-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 are Siri, Tesla, Boxever, Amazon Go Store. AI system becomes better than humans at all cognitive tasks. Google’s Waymo self 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.Make Splash Screen for C# Windows Applications
What is Splash Screen? A splash screen usually appears while a application or program launching, it normally contains the logo of the company or sometimes some helpful information about the development. It can be an animation or image or logo or etc. You can see lot of mobile application developers has done it but it's not common in Windows desktop applications. Making the splash screen is not a big deal if you are familiar with C# application development. Here I ll show you the steps of creating it. As usual idle is Visual Studio 2019 Create new Project - C# Windows Form Application Give a friendly name for your project and Create Once done add a new form to your project where we are going to add our splash screen logo or image Once done, I am adding a progress bar and image to the screen, also change the following in the form properties Auto Size Windows Screen - False Control Box - False Windows Startup Location - Center In the progress bar properties change the style to Marquee Marquee animation speed to - 50 Now we have finished the designing of the splash screen form, will continue to add the screen in the startup of the project and debug now Go to the main screen form coding cs file Here I have used the following System libraries which available in .NET 4.0 on wards using System.Threading; using System.Threading.Tasks; Now in the public start the Splash screen form by calling like this method, public void StartForm() { Application.Run(new SplashScreen()); } In the Main screen Initialize the component thread function for the splash screen form like this Thread t = new Thread(new ThreadStart(StartForm)); t.Start(); Thread.Sleep(5000); InitializeComponent(); t.Abort(); Total coding will be as following using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Threading; using System.Threading.Tasks; using System.Windows.Forms; namespace Splash_Screen_nTest { public partial class MainScreen : Form { public MainScreen() { Thread t = new Thread(new ThreadStart(StartForm)); t.Start(); Thread.Sleep(5000); InitializeComponent(); t.Abort(); } public void StartForm() { Application.Run(new SplashScreen()); } private void MainScreen_Load(object sender, EventArgs e) { } } } Once u debugged the application it will run as expected Source code can be downloaded from here - https://github.com/Gohulan/C-_Splash_Screen Happy Coding !!Implement database in the oracle Cloud
Databases are the most important part of the application development, there are a variety of different ways that data can be stored for different database types. The most common ways of implementing database servers are On premises and Cloud. As we all have good practices in implementing databases in on premises servers this time has preserved to move from on premises to cloud. Many organizations perform the migration of on-premises applications and data from their local data center to public cloud infrastructure to take advantage of benefits such as greater elasticity, self-service provisioning, redundancy and a flexible, pay-per-use model. Public cloud providers offer vast resources for security and recovery plan. Mostly enterprise users now migrating their data to Azure, AWS, Google and Oracle clouds. Since we are dealing with Oracle databases here I am showing you how I have implemented the Oracle Database (18c) in the cloud and access from out side local pc with the database tools. Prerequisites - You'll need to signup with your account to Oracle Cloud, on the first signup you will get SGD 400 and 30 days trial. Once you successfully signed please follow the steps. Once u signed in you will get identity domain, tenant, and the data center location. Identity Domain - set of rules to user details or user authentications to access the data outside without sharing the user credentials. After you logged into the Oracle Cloud you will get a index page like this, On the Selection menu select Oracle Database Cloud Services (DBAAS), it will direct you to the following page Now I am ready to create the Instance of the database cloud, Start with Create Instance button on the left and will be directed to the following page Instance Name - Main Global database name Region - Data center location ( it will be automatically assigned) Availability Domain - If you are using multiple region compute domain, select the appropriate domain Software Release - Database Version (In my case i have selected the 18c) Software Edition - Enterprise Edition / Standard Edition depends on your requirement Database Type - Single Instance / If you are using different backup plans please changed to Data guard or RAC On the Next few steps I am going to Configured the database and Recovery plans, on the first left pane database needs to be configured and the right pane recovery needs to be configured DB NAME - Global Database Name PDB Name - Since it's a plugged database I am giving a pdb name as well Administration Password - SYS or SYSTEM user passwords to access the database through developer tools. Usable Database Storage - As 18C I m configuring as 50GB Compute Shape - The compute shape specifies the number of Oracle Compute Units (OCPUs) and amount of memory (RAM) for the virtual machine SSH Public Key - It's will used to access the database from outside machine, or to use tools such as Putty On the Advanced Settings Listener Port - 1521 (Usual Oracle Port) Timezone - As same as database used location Character Set & National Character Set Should be default Crete SSH Public Key Let's we create the public token to allow access through external applications, on the SSH Public Key Edit it will open another windows to create SSH Key Select Create a NEW Key and click Enter Now the SSH key created successfully, downloaded the key pair to external use. It will download a zip file. Backup & Recovery Configuration Backup Destination - for backup and recovery, you would enter your choice of destinations Cloud Storage Container - Paste the cloud storage container location and name Username & Password -It must be the cloud storage user credentials. Once the database and recovery configuration completed, click next to create the database in the cloud. Please note since it's a sample database I have used the BYOL for the licence purposes and not enabled the data guard. Confirm everything and click Create to complete the database creation. Once submitted, database creation is in the progress Wait until the process completed, to start the instance successfully Now almost all the cloud database creation has completed successfully, Check the public IP to access the database externally Open the side pane to open the SQL developer web navigate to SQL monitor page and it will show the database is up and running Let's play with some queries with SQL Web Developer & SQL Developer Open SQL developer in the local machine and test the connection with the following public IP credentials, Connected the database with SQL Developer and ran this query to verify the Global database name Created a tablespace in the cloud instance Enjoy !! Playing with some queries in the Cloud..SQL Migration to Azure Cloud
I have implemented a basic C# application connected with On premises SQL Server, I am going to migrate the same database and the data to Azure cloud using Microsoft Migration Tool, After the migration without touching the coding part I am debugging the same application (Changed the connections string only). On premises sql database connected with SQL Server, In the database I am running this query through management studio and I am getting the following results, Same query I am deploying through my developed C# application, I am testing the connection with sql authentication credentials String source = @”Data Source =” + textBox1.Text; Initial Catalog = CheckPostingDb; User Id =” + textBox2.Text;; Password=” + textBox3.Text; SqlConnection con = new SqlConnection(source); con.Open(); MessageBox.Show(“Db Connected”); Once it’s succeeded, I’m running the same query through sqlcommand function in C#, got the same results in the text box String sqlSelectQuery = “SELECT COUNT(*) AS MREQUESTS FROM MREQUESTS WHERE REQSTATE=1”; SqlCommand cmd = new SqlCommand(sqlSelectQuery, con); if (dr.Read()) { textBox4.Text = Convert.ToString(dr[“MREQUESTS”]) } con.Close(); Let’s migrate to Cloud I have deployed a sample database in the Azure Cloud with SQL authentication, It’s just a blank database and it doesn’t have any tables Tried the same query here and returning with failed errors, Start ab new project type as Migration In this step I am specifying the source and target server details In my scenario Source server is in localhost and target sql server is in Azure could Source Server — localhost , Target Server — gohulan.database.windows.net Select the Correct database from the source server to Migrate to cloud, In the target server select the correct database from Azure cloud, in my Azure cloud I have only one database named CheckPostingDb Once its’s connected I am going to select the objects or tables from the source database that I would like to migrate In my testing environment I am selecting only one table, my table is MREQUESTS since I am targeting the results only from this table through my C# application. Once the table is ticked, I have generated the SQL script Once the script is generated, I am deploying the schema, /******** DMA Schema Migration Deployment Script Script Date: 2/24/2020 12:50:55 PM ********/ /****** Object: Table [dbo].[MREQUESTS] Script Date: 2/24/2020 12:50:55 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N’[dbo].[MREQUESTS]’) AND type in (N’U’)) BEGIN CREATE TABLE [dbo].[MREQUESTS]( [ID] [bigint] IDENTITY(1,1) NOT NULL, [RID] [uniqueidentifier] NOT NULL, [ReqTime] [datetime] NOT NULL, [ReqState] [tinyint] NOT NULL, [RecordType] [int] NOT NULL, [Data1] [bigint] NULL, [ServiceID] [int] NULL, [FirstRequestTime] [datetime] NULL, [OfflinePosting] [bit] NULL, [ServiceHostInfo] [nvarchar](80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, CONSTRAINT [PK_MREQUESTS] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ) END GO IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N’[dbo].[MREQUESTS]’) AND name = N’AK_MREQUESTS_RID’) CREATE UNIQUE NONCLUSTERED INDEX [AK_MREQUESTS_RID] ON [dbo].[MREQUESTS] ( [RID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) GO IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N’[dbo].[MREQUESTS]’) AND name = N’IX_MREQUESTS_2') CREATE NONCLUSTERED INDEX [IX_MREQUESTS_2] ON [dbo].[MREQUESTS] ( [ReqTime] ASC, [ReqState] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) GO After I deployed the generated script in the previous step, it doesn’t give any errors or warnings. Successfully Executed. Once the script is migrated, I can see my table was created in the Azure cloud. But my query was returning with 0 results, it means that MREQUESTS table has been deployed but not the data yet. I am migrating the data as well in my next step Once after I started the migration it will start the process to send the data to cloud, time depends on the data capacity and the network speed. Since my table doesn’t have huge data it finished with in short time without any warning or errors. Running the same query in the Query Editor in Azure to check my data, it’s succeeded and returned with same value as on-premise query returns earlier. Returning to my C# application and no changes made in the application but changing the connection string by changing the server name and sql authentication credentials, Debugging the application to confirm it’s functioning properly, tested my connection with correct sql credentials Wow the results as expected, means Migration is succeeded.
