As a part of my DBA activities, I do a lot of SQL Server installations every week. Most of the time, I install the instance with the default collation. A collation is a configuration setting in SQL Server that determines how the database engine should read the data. SQL Server has huge list of collations […]
2022-12-26 (first published: 2020-08-03)
23,350 reads
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
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.
2022-12-26
Building on his last article, Frank shows how to add parameters to your stored procedure calls from PoSh.
2022-12-23 (first published: 2020-08-20)
29,419 reads
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.
2022-12-23
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
This article demonstrates how to manage these utilities from Flyway so that we can maintain and migrate them separately from the database objects.
2022-12-21
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
Get a brief introduction to using the AI features in Power BI.
2022-12-19
18,750 reads
Learn how to control which SQL Server transaction will get rolled back when a deadlock occurs by using DEADLOCK_PRIORITY.
2022-12-19
By Steve Jones
We’re a week late, once again my fault. I was still coming out of...
By Steve Jones
I ran across this article recently (https://www.gatesnotes.com/meet-bill/source-code/reader/microsoft-original-source-code) and it has a great opening piece...
By Steve Jones
I’m in the UK today, having arrived this morning in London. Hopefully, by this...
Hi there, Has anyone else had any trouble with Database Mail in Cumulative Update...
I have a script task that tries to execute a HTTP request, which seems...
Comments posted to this topic are about the item SQL Server 2025 Standard Developer...
If I use BASE4_ENCODE() in SQL Server 2025, is the output URL Safe by default?
See possible answers