ETL Modularity
Imagine for a moment that you’ve built a software thing. In fact, we’ll call it Thing. You put a lot...
2016-07-18 (first published: 2016-07-11)
2,099 reads
Imagine for a moment that you’ve built a software thing. In fact, we’ll call it Thing. You put a lot...
2016-07-18 (first published: 2016-07-11)
2,099 reads
Question from someone in one my recent classes: “What tool do you use to send email from ETL processes?” My...
2016-07-14
682 reads
I’ve had a lot of luck in my career, especially as it pertains to my work environment. Although I can’t...
2016-07-01 (first published: 2016-06-23)
2,047 reads
Recently I’ve been talking a lot with clients and others about the involvement of cloud architecture in a data warehouse...
2016-06-29 (first published: 2016-06-27)
1,128 reads
It seems like it was just yesterday that we all said goodbye in Seattle at last year’s PASS Summit, but...
2016-06-22
357 reads
Bad data can kill. Literally. I’m not talking about the impact of bad data on the bottom line of business,...
2016-05-31 (first published: 2016-05-20)
1,973 reads
Before I began my technical career over a decade and a half ago, I spent several years working in law...
2016-05-06
1,278 reads
If you are looking for affordable, high-quality training on SQL Server Integration Services, you may be interested in one of...
2016-05-05
582 reads
Three years ago, I left the ranks of full-time employment to become an independent consultant. At the same time, I...
2016-05-04
464 reads
It happens far too often: Once an ETL process has been tested and executes successfully, there are no further checks...
2016-03-29 (first published: 2016-03-22)
2,304 reads
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