Converting Data Across Time Zones: An In-Depth Primer
This article dives into all the math required to convert historical times between time zones.
2022-12-28
This article dives into all the math required to convert historical times between time zones.
2022-12-28
This article demonstrates how we can use a Flyway placeholder as a simple on/off switch for each task, during Flyway migrations.
2022-12-28
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
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
Learn how to control which SQL Server transaction will get rolled back when a deadlock occurs by using DEADLOCK_PRIORITY.
2022-12-19
This tip will explain some mistakes SSIS developers usually make when designing ETL and how they should be avoided to help improve performance.
2022-12-19
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...
Telp/Wa 62817825533 Jl. Cempaka No.17, Sukorejo, Kec. Sukorejo, Kota Blitar, Jawa Timur 66111
Telp/Wa 628217555651 Jl. Gajah Mada No.14-18, Kelurahan Jember Kidu, Jember Kidul, Kec. Kaliwates, Kabupaten...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
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