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.
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers