How Effective Is Your Data Load Monitoring in SQL and Python?
Learn how you can use monitor your data warehouse load process with Python code and a structured process.
2023-10-06 (first published: 2023-09-20)
1,700 reads
Learn how you can use monitor your data warehouse load process with Python code and a structured process.
2023-10-06 (first published: 2023-09-20)
1,700 reads
Credit card fraud detection is an important application of machine learning techniques, including Decision Trees. The goal is to identify and detect fraudulent transactions and separate them from valid transactions to prevent financial loss and protect user accounts.
2023-09-08
BeautifulSoup (sometimes referred to as Beautiful Soup library) is one of several widely used screen scraping packages for a web page. It is highly regarded for its ease of use and power.
Screen scraping enables developers to create solutions that permit comparative analyses from all over the internet, such as web applications that look for the best price on an item from many different online stores.
2023-08-25
Very often there is a need to create test data manually. This script will provide a mix of names that will make more sense rather than randomly generating meaningless names.
2023-09-11 (first published: 2023-08-24)
573 reads
This article looks at manipulating data using Python to unpivot data received in a cross tab format.
2023-06-30
2,708 reads
This article describes the N+1 problem that we often find when developers use row by row solutions for querying related data in a database.
2023-06-21
3,564 reads
Learn how to use the Plotly library to visualize time series data in Python in this step-by-step article.
2023-06-16
Introduction In this article, we will learn how to generate images with AI. This time we will work with DALL·E. DALL·E is an image generator using AI. You just need to provide a description and DALL·E will generate the image: In this article we will learn these topics: First, we will learn what is DALL·E […]
2023-05-22
3,284 reads
This Python 3 script is designed to take CSV file data pasted into the csv_data variable and generate SQL insert statements that can be used to insert the data into a MySQL database. The script is easy to use and can save you a lot of time when working with large amounts of data.
2023-05-08 (first published: 2023-05-05)
3,323 reads
We may need to share our Python desktop or console applications with business users or deploy these applications to multiple machines. However, there are some challenges in the delivery of Python applications.
2023-04-24
Today I was having a nice discussion with some colleagues about Fabric and pricing/licensing...
By Steve Jones
As I’ve been working with SQL Saturday and managing changes to events, I’ve accumulated...
By James Serra
Starting last week is a rollout of the public preview of a new and...
By Stewart "Arturius" Campbell
Comments posted to this topic are about the item Read Only Replica in SQL...
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
I've had some backups of my encrypted databases failing with the error "BACKUP 'DBName'...
Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?
See possible answers