Building a SQL Computational Framework for MACD Indicators
This article looks at how to calculate MACD indicators using a set of T-SQL code and data stored in a SQL Server database.
2022-12-26
Uncategorized
2022-12-23
624 reads
Merry Christmas and Happy Holidays 2022
This weekend is Christmas, and likely many of you are not working hard today and will enjoy a long weekend until Tuesday. There are many other holidays at this time of year as well, and I hope you are enjoying the season with loved ones. I want to take a moment to wish everyone a […]
2022-12-23
75 reads
Heapq Module in Python: Using Heaps and Priority Queues
In this tutorial, learn about Python priority queues and heaps, how do they relate, and how to use the heapq module in Python.
2022-12-23
CPU Upgrades
Does your database server need an upgrade? Steve notes that you might learn a bit about the best hardware to ensure a good ROI. Even if you wouldn't make a change for your own desktop machine.
2022-12-21
160 reads
The Basics of Deleting Data from a SQL Server Table
n my last article “Updating SQL Server Data” I discussed using the UPDATE statement to change data in existing rows of a SQL Server table. In this article I will be demonstrating how to use the DELETE statement to remove rows from a SQL Server Table.
2022-12-21
2022-12-21
337 reads
Stairway to DAX and Power BI - Level 20: Time Intelligence – Date Functions: ENDOFMONTH(), ENDOFQUARTER(), ENDOFYEAR()
Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces three DAX Time Intelligence functions related to the End of Periods: ENDOFMONTH(), ENDOFQUARTER(), and ENDOFYEAR(). He discusses the syntax, uses and operation of each, and then provides hands-on exposure to the function in Power BI.
2022-12-21
1,258 reads
Artificial Intelligence with Power BI
Get a brief introduction to using the AI features in Power BI.
2022-12-19
18,983 reads
SSIS Bad Habits: Decreasing SSIS Package Performance
This tip will explain some mistakes SSIS developers usually make when designing ETL and how they should be avoided to help improve performance.
2022-12-19
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
Question of the Day
RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers