What do you do or think about on the way to work?
I recently changed jobs and my commute time doubled, I found myself with more time to think and I started asking questions.
Working with NULL Values in SQL
In SQL and relational databases, NULL values are an important part of managing data and information stored in SQL tables. A NULL value is used as a placeholder for missing values or values that are unknown in a database column or cell.
The Impact of Small Changes
A year ago, I started a monthly blogging event for the PostgreSQL community, inspired by T-SQL Tuesdays. I decided to call it PGSQL Phriday. (Time will tell if my insistence on trying to use a literation was a good idea or not.) Like the event for the SQL Server community, we ask someone to be […]
How to Use SQL to Analyze the Bitcoin Blockchain
You will learn how a blockchain works and then use a SQL database to analyze data from a series of transactions.
The Team You Want
Steve asks about your team at work today. What you like, what you need, even what you want to see in those with whom you work.
Decision Tree - Credit Card Fraud Detection
Credit card fraud detection is an important application of machine learning techniques, including Decision Trees. The goal is to identify and detect fraudulent transactions and separate them from valid transactions to prevent financial loss and protect user accounts.
A Brief Introduction to PowerShellAI, an Intelligent Command-line
Learn how you can interact with ChatGPT from PowerShell.
Rogue Colleagues
Can you trust your colleagues? We all want to, but there are always temptations, especially when life gets hard. Steve wonders today how we look at the issues of security inside of our organizations.
PASS Data Community Summit 2023 - Sessions are available to view!
As hosts, Redgate are delighted to announce PASS Data Community Summit 2023 sessions are now live and available to view!
Quickstart: Connect SQL Server machines to Azure Arc
Get started with Azure Arc-enabled SQL Server to manage and govern your Windows and Linux SQL Server instances hosted across on-premises, edge, and multicloud environments.
Blogs
The Intersection Between DevOps and FinOps
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers