(Sergey Gigoyan) In the previous articles, we have learned how to create, configure and use SQL Server Maintenance Plans. Sometimes, it is needed to move these plans from one environment to another.
Editorials
SQL Server Backups and The Cloud
March 10, 2020It used to be that SQL Server backups were the topic of every other webinar that was hitting the airwaves. Nowadays, that’s not the case; so [...]
Analytics, Reporting and Fine Line of Privacy
February 21, 2020It can be very challenging to pull together reporting, analytics, data privacy expectations and support for legislation for information in your [...]
Bridges Between Servers
February 12, 2020Many times as you build out environments, you’re left pulling information from different SQL Servers and different sources, so you can assemble [...]
Other News
Creating and Playing Sounds using HTML5
(After2050) In this article, we are going to see how we can create and play sounds using the latest version v3 of musquito.
MySQL Security – Failed-Login Tracking and Temporary Account Locking
(Olivier Dasini) When thinking about security within a MySQL installation, you can consider a wide range of possible procedures / best practices and how they affect the security of your MySQL server and related applications.
Working With PyTorch Tensors
(James McCaffrey) PyTorch is a Python language code library that can be used to create deep neural networks. The fundamental object in PyTorch is called a tensor. A tensor is essentially an n-dimensional array that can be processed using either a CPU or a GPU.
Exclude Work Item Types in Azure DevOps Projects
(Abhijit Jana) We can exclude Work Item types in Azure DevOps projects by enabling or disabling them based on the business need. For any Azure DevOps Project. You can keep only work item types which makes sense for your project, and rest you can exclude from the project by hiding them.
EF Core In depth – what happens when EF Core reads from the database?
(Jon P Smith) This article gives an “under the hood” view of what happens when EF Core reads in data from a database. I look at two types of database read: a normal query and a query that contains the AsNoTracking method in it.
Migration methods to Autonomous Database (ADB) – Part IV (DBMS_CLOUD.COPY_DATA)
(Syed Jaffar Hussain) In this part of Migration methods to Autonomous Database (ADB) article series, we will see how to load data into ADB database using the DBMS_CLOUD package.
Oracle WINDOW FUNCTION XOR SDO_GEOMETRY
(Martin Berger) Recently a friend asked me how to write a query for a SQL query which was slightly above simple SQL demo cases you can find all around.
Setting up OCI Terraform Provider
(Bobby Curtis) Over the last few months, I’ve been working to convert my skills from a core DBA/Replication specialist into a from dynamic DevOps persona.
DB2 on Docker in Double Time
(James Cockayne) Recently I was running a workshop for some customers to demonstrate various features of DB2 on the Linux platform.