The Side Project
When I first started working as a technologist some 17 years ago, I was doing fairly low-level stuff: moving and...
2017-01-11 (first published: 2017-01-04)
1,367 reads
When I first started working as a technologist some 17 years ago, I was doing fairly low-level stuff: moving and...
2017-01-11 (first published: 2017-01-04)
1,367 reads
Data warehouse projects are among the most visible and expensive initiatives an organization can undertake. Sadly, they are also among...
2017-01-10
1,112 reads
Key performance indicators, or KPIs, are at-a-glance metrics for simple insight into the business. These are each designed to provide...
2016-12-30 (first published: 2016-12-22)
1,754 reads
In designing a proper ETL architecture, there are two key questions that must be answered. The first is, “What should...
2016-12-28
779 reads
Last week I posted a brief survey about working the holiday. To those who normally are not required to work...
2016-12-27
392 reads
For a little pre-holiday fun, I’ve got a simple scenario to present to you, and I am interested in your...
2016-12-23
386 reads
In my ongoing series on ETL best practices, I recently wrote about the importance of logging in extract-transform-load processes. For...
2016-12-22
492 reads
Being disruptive is a powerful way to conduct business. Steve Jobs and Bill Gates insisted that computers belonged not just...
2016-12-20 (first published: 2016-12-05)
1,738 reads
SQL Server Reporting Services benefits from a major update in SQL Server 2016, which is obvious from the first interaction...
2016-12-20
579 reads
Over the weekend I got an email from have i been pwned, a website that tracks data breaches and notifies...
2016-12-19
354 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