CTO March 2023 articles and resources

These are the good reads found in this month.

Tech for a sustainable future: The challenges and opportunities ahead

What is the fate of technological civilizations?

How does technology contribute to climate change?

What are companies doing to improve sustainability?…

https://www.zdnet.com/home-and-office/sustainability/tech-for-a-sustainable-future-the-challenges-and-opportunities-ahead/

Hackers are using this new trick to deliver their phishing attacks

Cyber criminals are trying a new method to help ensure phishing attacks are successful – here’s what to watch out for…

https://www.zdnet.com/article/hackers-are-using-this-new-trick-to-deliver-their-phishing-attacks/

Top 24 RPA tools available today

What is RPA?

RPA benefits

Top RPA tools…

https://www.cio.com/article/219904/top-rpa-robotic-process-automation-tools.html

10 reasons to worry about generative AI

Plagiarism

Copyright

Uncompensated labor…

https://www.infoworld.com/article/3687211/10-reasons-to-worry-about-generative-ai.html

Does Gamified Training Get Results?

Corporate training isn’t all fun and games, but maybe it should be. Most of us have (often grudgingly) used corporate learning systems. We skim through 50-slide PowerPoint decks hoping to correctly guess enough answers to pass so that we can get back to our “real work.” Much of what we learn is often forgotten by the time we receive our certificate of completion….

https://hbr.org/2023/03/does-gamified-training-get-results

These experts are racing-to protect AI from hackers time is running out

Fooling AI even if you can’t fool humans

How do we stop attacks on AI?

Why data poisoning could ruin AI…

https://www.zdnet.com/in-depth/innovation/these-experts-are-racing-to-protect-ai-from-hackers-time-is-running-out/

Resources:

Robotic Process Automation (RPA) and Power Automate Desktop Learning Resources

https://chanmingman.wordpress.com/2022/09/17/robotic-process-automation-rpa-and-power-automate-desktop-learning-resources/?WT.mc_id=DP-MVP-36769

Posted in Uncategorized | Leave a comment

MySql ODBC Connection not appearing SSIS

This blog article, a short one, shows you one of the possible reasons why MySql ODBC Connection does not appear in SSIS connection. This article expects you to have basic knowledge of SSIS. When I right click on the Connection Manager and create a New Connection. I chose ODBC. Click Add.

Click New…

Select User connection string then click on Build. Click New.

In the Create New Data Source window I could not find MySQL.

Also: Migrate MySQL to Microsoft SQL Server

The is because Visual Studio 2019 is 32 bit. When I was installing the MySQL the 32 bit ODBC driver was not automatically installed. So, I have download the 32 bit ODBC driver from https://dev.mysql.com/downloads/connector/odbc/ and installed it.

Then I could see MySQL in SSIS.

Reference: https://stackoverflow.com/questions/51769240/odbc-connection-not-appearing-ssis/?WT.mc_id=DP-MVP-36769

https://learn.microsoft.com/en-us/sql/integration-services/connection-manager/odbc-connection-manager?view=sql-server-ver16/?WT.mc_id=DP-MVP-36769

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Servers | Leave a comment

React Native vs Ionic Curation

This blog article provides the curation of React Native vs Ionic.

Article:

React Native vs Ionic: Comparing Performance, User Experience, and much more!

https://www.simform.com/blog/react-native-vs-ionic/

Ionic vs React Native: Head-to-Head Comparison

https://hackr.io/blog/ionic-vs-react-native

React Native vs Ionic: The Battle to Choose the Best Cross-platform Framework

https://radixweb.com/blog/react-native-vs-ionic

Also: Android Emulator run on AMD chip

Video:

What’s the Difference? What’s Better?

https://www.youtube.com/watch?v=I6mCTKst9II

React Native vs IONIC

https://www.youtube.com/watch?v=OgtwuanZK8o

Ionic vs React Native : Choose the best for your app development

https://www.youtube.com/watch?v=ItZDxl3aFUs

Infographics:

Ionic V/S React Native – Infographics

https://walkingtree.tech/ionic-vs-react-native-infographics/

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | Leave a comment

Migrate MySQL to Microsoft SQL Server

This blog article shows you how to migrate from MySQL to MSSQL. In MySQL, I have a default database named world, for more details see, Install MySQL in Windows Server. Firstly, I created an empty database names world in MSSQL.

Install and open SQL Server Migration Assistant for MySQL.

Choose File then New Project. You can leave everything to default.

Click Connect to MySQL and type in the credential.

You can see the MySQL is connected.

Click Connect to SQL Server and type in the credential.

Select the destination database for the migration, world.

At the MYSQL, right click the database Tables under the MySQL and select Convert Schema.

At MSSQL end, right click the world database and select Synchronize with Database.

You can then see the tables are created in MSSQL.

At MySQL end, right click and select Migrate Data.

Click Close when done.

The data now is migrated from the MySQL to MSSQL.

Video: https://youtu.be/44vnS5x3jJg/?WT.mc_id=DP-MVP-36769

Reference: https://learn.microsoft.com/en-us/sql/ssma/mysql/sql-server-migration-assistant-for-mysql-mysqltosql?view=sql-server-ver16/?WT.mc_id=DP-MVP-36769

https://www.microsoft.com/en-my/download/details.aspx?id=54257/?WT.mc_id=DP-MVP-36769

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | 1 Comment

Three Ways Sales and Marketing Alignment Reduces Costs

Lead management may slow down and cost more when sellers and marketers operate separately. So it’s important to align data and processes, helping you to focus on qualified prospects and reduce your business costs.

Read the eBook, Three Ways Sales and Marketing Alignment Reduces Costs, to learn how bringing sales and marketing together with Dynamics 365 helps you:

  • Cut unnecessary expenses and keep your teams connected with unified data.
  • Prioritise high-revenue leads and plan complex buyer journeys.
  • Automate routine tasks to give sellers more time to close more deals.
  • Respond quickly to customer needs with automated request routing.
  • Improve efficiency and connect with customers in a cohesive way.

This blog is originated form here (https://chanmingman.wordpress.com).

The content is extracted from a Microsoft email.

(Read it now, I am not sure how long Microsoft will leave the link alive).

Read: http://bit.ly/3Ts0krv

Posted in .Net, Cloud, Community, Computers and Internet, CTO, Data Platform | Tagged | Leave a comment

Install MySQL in Windows Server

This blog article shows you how to install MySQL Database Server into Windows Server. There are few reasons that you might want to install MySQL Server, one of them is because you have a legacy application that is using MySQL. To install MySQL, download the installer from MySQL website. Somehow, you will only see the x86 installer but that is the one for now even if you have 64-bit Windows. Run the installer after downloading, my version is 8.0.3 for the server.

The installer itself is version 1.6.

I have selected the Full installation. Despite you select Developer Default or Full installation you need to have either Visual Studio or Python installed. For my machine I have Visual Studio 2019 installed. Click Next.

As you can see, the machine is equipped with Visual Studio 2019.

Click Execute.

Once all completed, click Next.

Click Next on Product Configuration.

Mark the Port is 3306. I also selected the Named Pipe. Click Next.

I have selected Full access to members of an existing local group, means the Windows Login Account Group. In Local Group Name I selected Administrators.

I left the Authentication Method as default, Use Strong Password Encryption for Authentication.

Type the Password for root account and I clicked Add User to add another user.

The User Name is admin.

Click Next.

I have selected the Standard System Account as the Windows Service login. Click Next.

Select Yes, grant full access… Click Next.

Click Finish.

Click Next.

Click Finish for the Router Configuration.

Type in the User name and Password to connect to server.

Click Finish.

Click Next.

Click Finish.

You can see MySQL is working.

Video: https://youtu.be/ZF5I8n72Vto/?WT.mc_id=DP-MVP-36769

Reference: https://www.microsoft.com/en-us/download/details.aspx?id=54257/?WT.mc_id=DP-MVP-36769

https://superuser.com/questions/1584811/is-there-a-64-bit-version-of-mysql-for-windows

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | 1 Comment

Python using Visual Studio 2022 (Failed to launch debug adapter)

This blog article shows you how to run Python in Visual Studio 2022. This is not a silver bullet because the behavior might change from version to version of Visual Studio or Python. Somehow, this blog can give you a good idea on the workaround if you are facing a similar issue. When I tried to create a Python Application from Visual Studio 2022, it seemed easy.

When I click Run after typing the following line. It could not run.

Visual Studio led me to download the following version of Python. After I have installed Python and run again.

I got an error “Failed to launch debug adapter
“. I need to uninstall version 3.6.2 and download the latest Python from the Python website.

The Python can run after I install 3.11.2 for now.

Reference: https://visualstudio.microsoft.com/vs/features/python/?WT.mc_id=DP-MVP-36769

https://code.visualstudio.com/docs/python/python-tutorial/?WT.mc_id=DP-MVP-36769

Posted in Uncategorized | Leave a comment

Cannot uninstall Microsoft SQL Server Integration Services Projects SSIS for Visual Studio 2022

This blog article shows you a workaround for when you cannot uninstall Microsoft SQL Server Integration Services Projects SSIS for Visual Studio 2022. This blog article also expects you to have common SSIS knowledge.

My Visual Studio version is 17.5.0 and SSIS version 0.2 Suddenly I got an error from Execute SQL Task.

When I wanted to uninstall the SSIS, but I could not uninstall the SSIS, Setup failed.

ALSO: SSIS Azure Blob Source

The workaround that I did was I installed SSIS version 0.3. So ended you can see 2 Microsoft SQL Server Integration Services Project.

Unfortunately, the error still exists till I update Visual Studio 2022 to version 17.5.1.

Reference: https://learn.microsoft.com/en-us/sql/integration-services/sql-server-integration-services?view=sql-server-ver16/?WT.mc_id=DP-MVP-36769

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | Leave a comment

Azure Data Studio Script CRUD

This blog article shows you how to generate Insert, Update, Delete SQL statement using Azure Data Studio. In SQL Server Management Studio (SSMS) you can right click on the database table then select Script Table asInsert To.

Then you will get the template for inserting the data to that table.

In Azure Data Studio, you do not get scripting for CRUS (Insert, Select, Update, Delete) out of the box.

Go to Extension, on the left pane, select the Extra Sql Script As. Click Install.

Unfortunately, it does not install, and you need to download the vsix file and install it manually.

ALSO: SSIS Execute Stored Procedure using Execute SQL Task component

In Azure Data Studio, press Ctrl + Shift + P, type install then select Extensions install from VSIX. Select the vsix file that you have downloaded.

You will see the Script table as INSERT by right click on the table after the vsix installation.

Video: https://youtu.be/X9GrY79-9W0/?WT.mc_id=DP-MVP-36769

Reference: https://www.scarydba.com/2019/02/18/installing-extensions-to-azure-data-studio/

https://learn.microsoft.com/en-us/sql/azure-data-studio/extensions/add-extensions?view=sql-server-ver16/?WT.mc_id=DP-MVP-36769

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | Leave a comment

SSIS using Temp Table in SQL Server

This blog article shows you how to use the temporary table of SQL Server in SSIS. Firstly, create a physical database table for the temporary table to transfer data, my database name is poc.

CREATE TABLE Teams

(

    Team VARCHAR(255),

    Mascot VARCHAR(255),

State VARCHAR (2)

)

Create an SSIS Project. Drag the Execute SQL Task to the Control Flow. Paste the following SQL statement. The statements below create a temporary table and insert records.

IF OBJECT_ID(‘tempdb..##tmpTeams’) IS NOT NULL

    DROP TABLE ##tmpTeams

    CREATE TABLE ##tmpTeams

    (

        Team VARCHAR(255),

        Mascot VARCHAR(255),

State VARCHAR (2)

    )

    INSERT INTO ##tmpTeams VALUES

     (‘Auburn’, ‘Tigers’, ‘AL’),

     (‘Alabama’, ‘Crimson Tide’, ‘AL’),

     (‘Mississippi’, ‘Rebels’, ‘MS’),

     (‘Louisiana State’, ‘Tigers’, ‘LA’),

     (‘Mississippi State’, ‘Bulldogs’, ‘MS’),

(‘Arkansas’, ‘Razorbacks’, ‘AR’),

(‘Texas A&M’, ‘Aggies’, ‘TX’),

(‘Georgia’, ‘Bulldogs’, ‘GA’),

(‘Tennessee’, ‘Volunteers’, ‘TN’),

(‘Vanderbilt’, ‘Commodores’, ‘TN’),

(‘Florida’, ‘Gators’, ‘FL’),

(‘South Carolina’, ‘Gamecocks’, ‘SC’),

(‘Missouri’, ‘Tigers’, ‘MO’)


Drag a Data Flow Task to Control Flow. Go to the Data Flow tab. Drag the OLE DB Source to the Data Flow.

Configure a connection to database, in my case poc. Select SQL Command for Data access mode. Type the following statement and click OK.

SELECT * FROM ##tmpTeams

ALSO: An OLE DB Provider was not specified in the ConnectionString SSIS Script Task

Drag an OLE DB Destination to Data Flow pane. Connect the source. Configure the OLE DB connection manager. Select the physical table that you have created, in this case, Teams.

Two properties you must set. First the RetainSameConnection property in Connection Manager must set to True.

Second, the DelayValidation property of Data Flow Task must be set to True, not the Execute SQL Task.

Video: https://youtu.be/Q4ErpzHX6_U/?WT.mc_id=DP-MVP-36769

Source code download: https://github.com/chanmmn/ssis/tree/master/ssisTempTable/?WT.mc_id=DP-MVP-36769

Reference: https://www.mssqltips.com/sqlservertip/2826/how-to-create-and-use-temp-tables-in-ssis/

https://learn.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/faster-temp-table-and-table-variable-by-using-memory-optimization?view=sql-server-ver16/?WT.mc_id=DP-MVP-36769

https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-temporary?WT.mc_id=DP-MVP-36769

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | Leave a comment