Kevin Feasel – Page 470

Deleting Data from MySQL

Published 2022-11-15 by Kevin Feasel

In the last few articles in this series, you learned about three important data manipulation language (DML) statements: SELECT, INSERT, and UPDATE. The statements make it possible to retrieve, add, and modify data in a MySQL database. Another DML statement that is just as important is DELETE, which lets you remove one or more rows from a table, including temporary tables. In this article, I focus exclusively on the DELETE statement to help round out our discussion on the core DML statements in MySQL. Overall, the DELETE statement is fairly basic, but one that’s no less necessary to have in your arsenal of DML tools.

Read on to see how the DELETE statement works and the minor differences from SQL Server.

Comments closed

Monitoring Azure SQL DB Restore Progress

Published 2022-11-15 by Kevin Feasel

Sudhir Raparia doesn’t have time to wait:

Database Backup & Restore capabilities are crucial for ensuring Business continuity and Disaster recovery. Restore database operation is usually done in critical situations like hardware failure, application errors, ransomware attacks, accidental deletion of database etc., to restore a production database to latest known stable state. In such critical situations users would want to track the progress of restore operation accurately so that they can plan for subsequent actions and/or alternatives.

Currently in Azure SQL DB, you can view the database restore progress either using Portal or using T-SQL as follows:

Click through for information on that DMV, as well as a recent change to it in Azure SQL DB (though not yet Azure SQL Managed Instance).

Comments closed

Troubleshooting I/O Issues in SQL Server

Published 2022-11-15 by Kevin Feasel

Ajay Dwivedi shares some advice:

Storage performance is something that puzzles a lot of SQL Server professionals. So in this blog, I will cover the basic steps I perform to ensure I get the best performance from the underlying storage.

Read on for some thoughts on storage testing prior to SQL Server installation, as well as what to do to ensure your SQL Server instance is up and at them.

Comments closed

New Query Tuning Book

Published 2022-11-15 by Kevin Feasel

Grant Fritchey has a book for us:

If you’re interested in getting a digital copy, my brand spanking new book is now available here.

It’s in the intro, but let me tell you a little bit about the new book. It’s really new. Some of the older versions of the book were simply updated, a bunch of changes to most chapters, a couple of new chapters, fixes for old mistakes, ta-da, new book. Not this time. This time, I rewrote it all. From scratch.

Looks like I’ll need to get a copy.

Comments closed

Sending Messages to Event Hub via Python

Published 2022-11-14 by Kevin Feasel

Kiril Nikolov has a message for us:

Recently I needed to create an Azure Function app that would connect to an API and send data to an Event Hub as part of a real-time data streaming solution.

Azure functions are the perfect connectivity option for a task like this, allowing you to focus on the trigger and the resulting output message you want to capture in the event stream, while Azure handles the maintenance of the cloud infrastructure and hosting to run it.

Azure functions can be written in multiple languages. I needed to write mine in python, meaning that I had to set up a configuration file to connect to the Event Hub (as I will explain in further detail below).

Click through to see how it all works.

Comments closed

AT TIME ZONE Performance and an Alternative

Published 2022-11-14 by Kevin Feasel

Joe Obbish looks at time zones:

Queries that use the AT TIME ZONE operator may perform worse than desired. For example, Jonathan Kehayias blogged about performance struggles with AT TIME ZONE at sqlskills.com. One key difference between Jonathan’s opinion and my own is that I enjoy writing these kinds of posts.

Read on for the details and check out some work Joe has done around time zone friendly functions as an alternative to AT TIME ZONE.

Comments closed

Swapping Integer Digits with R

Published 2022-11-14 by Kevin Feasel

Tomaz Kastrun shuffles things around:

The problem is described as:

Given a signed 32-bit integer x, return x with its digits reversed. If reversing x causes the value to go outside the signed 32-bit integer range [-2^31, 2^31 – 1], then return 0.

For example:

x = 120; reversed_x = 21
x = -2310; reversed_x = -132

Read on to see how you can implement this in R.

Comments closed

Properties of Production-Grade Code

Published 2022-11-14 by Kevin Feasel

David Wiseman has a list:

Security

Production code needs to be secure, following industry best practices. A security incident can cause severe reputational damage and financial impact.

Maintainability

Production code should be maintainable. Avoiding duplication and striving for simplicity.

Read on for a list of properties which production-grade code should have.

Comments closed

Azure SQL DB Performance: Business Critical Tier

Published 2022-11-14 by Kevin Feasel

Reitse Eskens continues the comparison:

My last blog was about the Hyperscale tier, this week we’re back at more regular designs with Business Critical. This design is aimed at performance, local SSD storage and better CPU’s. But that’s not all. Besides this high-speed design, it also has high availability implemented by having a secondary replica ready to take over when the primary fails for any reason. And not just one but three replicas. So, your data should be accessible at all times. To make it even better, you can make one of these replica’s the read-only replica for reporting purposes. I’ve tested most tiers, again I didn’t test the 80 cores SKU because of the price. I also did some testing with and without replica’s but there wasn’t much of a difference. But again, my testing setup is quite simplistic, for your heavier read and write loads it might make a huge difference.

Read on for this and see how it compares to some of the other Azure SQL DB tiers.

Comments closed

Schedule a Power BI Dataset Refresh

Published 2022-11-14 by Kevin Feasel

Gilbert Quevauvilliers keeps to the schedule:

Below are the steps on how to use Power Automate to schedule a refresh of a Power BI dataset at the time you want it to.

I have recently seen some questions in the Power BI Community with regards to refreshing Power BI datasets. I thought it would be a good idea to blog on how to use Power Automate (Flow) to schedule a refresh of a Power BI Dataset.

Read on to see what the limitation is in Power BI and how you can use Power Automate to get around it.

Comments closed

Author: Kevin Feasel