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.
The Lock Escalation Threshold – Part 3
The examples so far in this series have all used repeatable read isolation to acquire shared locks on qualifying rows and hold them to the end of the transaction. This was convenient for the demos but repeatable read isolation isn’t common in everyday use.
Calling Procs from PowerShell with Parameters
Building on his last article, Frank shows how to add parameters to your stored procedure calls from PoSh.
Cloud First Software
Many software packages are moving to the cloud, but Steve doesn't like to see this without some ability to extract data.
Improving Skills at Work
A large part of the success I've had in my career has come from growing my skills, both technical and soft, throughout the years. I've always been driven to learn more and improve my ability to accomplish the tasks I've been assigned. Or those that I've sought out and tackled. A little initiative has been […]
Investing in Another's Career
Would you invest in someone else's career? An actual investment? Would you sell shares in yourself? Steve talks about this today.
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 […]
Flyway Desktop in Database Development Work: An Overview
For those new to Flyway Desktop, this article takes a strategic overview of the components of a Flyway Desktop project, how to set up a project for team-based development work, and how we can use the tool in conjunction with a version control system and CI servers to manage a database development and release process.
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.
Blogs
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers