Making Software Decisions
The process of building software for others involves lots of decisions. Ensuring that you are making good decisions can impact how others view your final product.
Working with the Delete Activity in Azure Data Factory
Introduction We can use the delete activity in Azure Data Factory to delete files from both on-premises and cloud storage. In this article, we will discuss the delete activity with the various options available for the file deletion. I will show the following operations with the Delete Activity: Delete files from a folder. Delete contents […]
SQL Server VM Best Practices
In this article we look at some of the things you should be aware of when building a VM to run SQL Server, such as vCPUs, disks, memory and more.
Why pay for open-source software?
The very definition of open-source software means that developers can change the code, which means that exclusive, paid, licensing is not a part of the deal. In short, open-source is free. Free of licensing anyway. So, why might you choose to pay for an open-source software like Flyway? Grant Fritchey explores.
Volunteer For Something
I spent a chunk of the day yesterday, after work, but before working on a new book (yeah, I've got two jobs now), playing with my radios. I was programming the digital one to get it to use my Raspberry Pi as a hotspot (it used to work, now it doesn't). I also spent some […]
Create an RPA Flow that Connects to Oracle Data in UiPath Studio
If your company uses legacy technology systems, you can use the UiPath RPA platform to extend your process automation capabilities to these systems and eliminate repetitive, error-prone tasks of manually updating them. By using UiPath Studio, you can build an RPA program just like drawing a diagram. With the CData ODBC Driver for Oracle, users can embed Oracle data in the workflow. Let’s […]
Thank a Mentor
There is almost always someone that helps us in our career with mentorship. Today Steve suggests you thank them.
How LAG compares to other techniques
LAG pulls a column from another row without a self-join. In this article, Kathi Kellenberger shows how LAG compares to other techniques
PostgreSQL Date And Time Part 2
In the second part of this PostgreSQL date time series, we examine a number of commonly used functions for getting current dates and times and converting strings to dates and times.
To Inifinity and Beyond With 1=1
There is some code that might work, but could lead others astray in the future. Today Steve notes that we ought to write code that sets a good example, and a loop that potentially runs forever isn't that type of code.
Blogs
T-SQL Tuesday #192 Invitation: SQL Server 2025 Excitement
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
The Book of Redgate: What Our Customers Say
By Steve Jones
This is from 2010, but I loved that people felt this way about Redgate...
Export a Power BI Report that cannot be Downloaded
Yes, you’re reading that right, we’re going to download a report that cannot be...
Forums
Is Adenoz Injection safe for patients with low blood pressure?
Adenoz Injection is used to treat specific heart rhythm disorders, but it must be...
Economics of AI: What is the Real Cost to Profit?
Comments posted to this topic are about the item Economics of AI: What is...
Poor Name Choice
Comments posted to this topic are about the item Poor Name Choice
Question of the Day
Getting the Indexed Columns
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers