Automation Archives - {coding}Sight

Machine Learning {.NET} Image Classification

Tue, 07 Sep 2021 04:05:48 +0000

One of the best scenes from Silicon Valley is Jian Yang demoing his “Hotdog, not hotdog” application. In this article, we will build our own “Hotdog, not hotdog” solution using ML.NET. After all, who would not want to determine if that dish is, or is not a hot dog? Just take a picture, upload it …

The post Machine Learning {.NET} Image Classification appeared first on {coding}Sight.

]]>

How to Use AI for SQL Tuning for a Real Automated Process

Thu, 26 Aug 2021 07:19:40 +0000

The rapid evolution in development from rigidly structured data to responsive, flexible databases allows database administrators (DBAs) to work closely with developers. DBAs are often tasked with finding ways to make applications run faster and more efficiently. Utilizing artificial intelligence (AI) for SQL tuning helps DBAs create a truly automated process that significantly streamlines their …

The post How to Use AI for SQL Tuning for a Real Automated Process appeared first on {coding}Sight.

]]>

ML{.NET} Introduction

Thu, 29 Jul 2021 09:08:55 +0000

Machine Learning (ML) has come from a buzzword that is nice to have in your application to a must-have feature that works and adds value. Data scientists develop ML models in various ML Frameworks like TensorFlow, Scikit-learn, PyTorch, Azure ML, etc. Before ML.NET became available to all developers, adding the ML functionality to .NET applications …

The post ML{.NET} Introduction appeared first on {coding}Sight.

]]>

How to Connect Python to SQL Server to Automate Backend Process

Fri, 30 Apr 2021 10:41:19 +0000

Automating backend processes in your SQL Server instance is a common task. Whether it is refreshing the statistics, rebuilding indexes, reading, or deleting data, it is extremely valuable to integrate other programming frameworks with your RDBMS. This article will consider these types of tasks specifically integrated with Python. We won’t focus on such fundamental questions …

The post How to Connect Python to SQL Server to Automate Backend Process appeared first on {coding}Sight.

]]>

How AI Will Change Software Development and Testing

Tue, 12 Jan 2021 16:24:40 +0000

Artificial intelligence is the fuel for what we know as the fifth industrial revolution. Its capacities to impact and disrupt numerous industries are virtually unparalleled. It is no less true regarding software development and testing. While self-writing code is not yet a broadly commercialized technology, automation is more prevalent in writing and testing software. This …

The post How AI Will Change Software Development and Testing appeared first on {coding}Sight.

]]>

Automated testing of the desktop application: expediency and frameworks overview

Tue, 29 Oct 2019 00:55:54 +0000

Introduction You have certainly heard about regression and acceptance testing. But do you know how much is actually spent on acceptance testing in a project? We can quickly get an answer to this with the help of a time tracking system like TMetric. On our project, acceptance-testing a desktop application of around 100 assemblies took …

The post Automated testing of the desktop application: expediency and frameworks overview appeared first on {coding}Sight.

]]>

Automating the Tabular Model Processing of Analysis Services (SSAS) Databases in SQL Server

Mon, 07 Oct 2019 23:36:47 +0000

This article talks about automating the processing of the Analysis Services database in SQL Server. Automation is one of the most important tasks managed by database administrators or DevOps engineers. Additionally, we’ll get an overview of Analysis Services databases and how they differ from SQL Server databases. This article also highlights the importance of automating …

The post Automating the Tabular Model Processing of Analysis Services (SSAS) Databases in SQL Server appeared first on {coding}Sight.

]]>

Automate Database Test Restore in SQL Server

Mon, 30 Sep 2019 22:57:22 +0000

This article talks about automating the database restoration process which is often done manually by the DBA or the infrastructure team responsible for the management of database server(s) and database(s). This article also highlights the importance of automating database administration tasks such as database backup and restoration to ensure that consistency and reliability of production …

The post Automate Database Test Restore in SQL Server appeared first on {coding}Sight.

]]>

Basics of SQL Server Task Automation

Tue, 24 Sep 2019 22:57:19 +0000

This is an introductory article about automation in SQL server primarily focused on the basic concepts. We will discuss some standard practices and a few examples to help beginners get started with SQL server automation. This article also highlights the importance of automating SQL server tasks to save time and effort required to do these …

The post Basics of SQL Server Task Automation appeared first on {coding}Sight.

]]>

Hosting Package on Chocolatey

Wed, 31 Jul 2019 23:06:48 +0000

In this article, we will take a brief look at the key stages of Chocolatey package creation. Prerequisites Before getting started with the creation of a Chocolatey package, make sure you need to: have Chocolatey installed; read the What are Chocolatey Packages? section of the Chocolatey documentation; know how a package works. Specifically, you are …

The post Hosting Package on Chocolatey appeared first on {coding}Sight.

]]>