Introduction Just like every other database, PostgreSQL has its own set of basic datatypes, like Boolean, Varchar, Text, Date, Time, etc. We can easily store data like numbers, characters, date, time, etc. using these supported datatypes, but what if we need to store multiple data elements in a single column? Suppose we are storing the […]
2021-09-10
13,376 reads
Oracle added several enhancements to the sequence object in version 12c, including an “identity” column feature. Jonathan Lewis explains how to work with these new features.
2021-09-10
Registration is now open for our free and online data platform conference. Join 1000s of your data peers at PASS Data Community Summit and get access to up to 5 days of training, sessions, networking activities, and events. This year's program has been carefully designed to help you achieve your goals, wherever you are in your data career.
2021-09-10 (first published: 2021-09-03)
In this article we look at a PowerShell script that you can use to centrally enable and disable any SQL Server Agent Job on any instance of SQL Server.
2021-09-08
How to create a single set of SQL migration scripts for Flyway that we can use across multiple database systems, or for all regional variants of a database.
2021-09-08
This article presents a way that finds a perfect match in any bipartite graph or shows why one cannot exist.
2021-09-06
2,940 reads
Learn how to plot a financial time series using SQL Server data and Python to reveal the value of exponential moving averages and make decisions about time series values.
2021-09-06
Communities of practice bring people together to share ideas and learn from each other about a common interest. In this article, Robert Sheldon explains and gives some advice on starting them.
2021-09-06
SSIS stands for SQL Server Integration Services and is a solution for building data integrations and workflow applications that integrate with SQL Server databases. As data integration processes increase in importance, organizations are looking for ways to simplify integration and manage workflows. In this article, we'll walk you through how to design a data flow that adds new HubSpot contacts to a MailChimp list using CData SSIS Components for HubSpot and MailChimp. Connecting to HubSpot and MailChimp The […]
2021-09-03 (first published: 2021-08-17)
708 reads
In this article we demonstrate how to transfer data via a CSV file from a SQL Server database to a Pandas dataframe and then subset the dataframe in Python.
2021-09-03
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item The Problem Isn't Always Your...
Comments posted to this topic are about the item Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers