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.
2023-09-08
5,295 reads
You will learn how a blockchain works and then use a SQL database to analyze data from a series of transactions.
2023-09-08
5,295 reads
In this article, we will discuss the purpose and use of the WHERE LIKE clause in SQL Server and how it can help you construct more efficient queries.
2023-06-02
Learn how to get started with Google Cloud MySQL and PostgreSQL databases by creating and configuring a database.
2023-05-26
1,105 reads
As we continue into the era of supporting more and more database platforms in our data estates, self-monitoring goes from being a very difficult task to a truly daunting task. I am personally advanced at diagnosing Microsoft SQL Server performance issues, but when that PostgreSQL server gets added, I just have to hope nothing goes wrong for a few years while I learn.
2023-04-10
Deploy resources in Azure using reusable code with Terraform modules.
2026-02-16 (first published: 2022-10-10)
13,263 reads
Learn the basics of using Terraform to declaratively specify how to configure resources in infrastructure.
2022-10-17 (first published: 2022-08-26)
15,081 reads
Step-by-step guide to solve the "INSERT EXEC cannot be nested" problem by using a CLR when unit testing stored procedures using the tSQLt framework.
2022-08-19
40,526 reads
Microsoft provides many ways to run SQL Server in Azure, but which do you choose? In this article, Robert Sheldon explains the Azure SQL options.
2021-09-20
Oracle has built-in functionality to analyze text. Sanil Mhatre demonstrates how to perform a sentiment analysis on data stored in a table using Oracle Text.
2021-09-15
Instant file initialization can speed up database creation, file growth, and restores. Greg Larsen explains how to configure it and how it works.
2021-08-18
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers