The Invalid Synonym

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.

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 12 days of Christmas

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 […]

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.

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.

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.

The SQL Server Upgrade Targets

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.