Automation Archives - {coding}Sight https://codingsight.com/category/database-administration/automation/ Blog for SQL Server DBAs and Developers Mon, 21 Aug 2023 08:29:18 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://codingsight.com/wp-content/uploads/2021/10/cropped-Soсial_-Fb_180х180-1-32x32.png Automation Archives - {coding}Sight https://codingsight.com/category/database-administration/automation/ 32 32 Machine Learning {.NET} Image Classification https://codingsight.com/machine-learning-net-image-classification/ Tue, 07 Sep 2021 04:05:48 +0000 http://codingsight.com/?p=16798 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 https://codingsight.com/how-to-use-ai-for-sql-tuning-for-a-real-automated-process/ Thu, 26 Aug 2021 07:19:40 +0000 http://codingsight.com/?p=16381 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 https://codingsight.com/ml-net-introduction/ Thu, 29 Jul 2021 09:08:55 +0000 http://codingsight.com/?p=15814 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 https://codingsight.com/python-and-sql-server/ Fri, 30 Apr 2021 10:41:19 +0000 http://codingsight.com/?p=13428 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 https://codingsight.com/how-ai-will-change-software-development-and-testing/ Tue, 12 Jan 2021 16:24:40 +0000 https://codingsight.com/?p=11511 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 https://codingsight.com/automated-testing-of-the-desktop-application-expediency-and-frameworks-overview/ Tue, 29 Oct 2019 00:55:54 +0000 https://codingsight.com/?p=8082 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 https://codingsight.com/automating-the-tabular-model-processing-of-analysis-services-ssas-databases-in-sql-server/ Mon, 07 Oct 2019 23:36:47 +0000 https://codingsight.com/?p=7912 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 https://codingsight.com/automate-database-test-restore-in-sql-server/ Mon, 30 Sep 2019 22:57:22 +0000 https://codingsight.com/?p=7778 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 https://codingsight.com/basics-of-sql-server-task-automation/ Tue, 24 Sep 2019 22:57:19 +0000 https://codingsight.com/?p=7799 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 https://codingsight.com/hosting-package-on-chocolatey/ Wed, 31 Jul 2019 23:06:48 +0000 https://codingsight.com/?p=7497 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.

]]>