The Heart of DevOps Webinar
One of the things that I think about DevOps is that it’s really hard to focus on the hard things...
2019-01-23
263 reads
One of the things that I think about DevOps is that it’s really hard to focus on the hard things...
2019-01-23
263 reads
One controversial topic in database development is how to properly store and deploy database changes. This is generally described as choosing between two options, which are approximately as easy...
2019-01-23
36 reads
Today we’ll begin taking a look at the buffer pool in SQL Server and how it’s normally used. Before we...
2019-01-23
217 reads
We’re all spending much more time in the digital world. Ecommerce continues to grow in popularity and we all benefit from the convenience of booking holidays and paying bills...
2019-01-23
57 reads
We’re all spending much more time in the digital world. Ecommerce continues to grow in popularity and we all benefit...
2019-01-23
232 reads
It’s a somewhat late addition, but I have an all-day Training Day at SQLBits. It takes place on Thursday, February...
2019-01-23
252 reads
In general, SQL Server TDE certificates will expire at some point. In SQL Server, if we have setup TDE using...
2019-02-08 (first published: 2019-01-23)
1,849 reads
With the release of SQL Server Always on came the ability to query replica’s and offload read only requests. This...
2019-02-12 (first published: 2019-01-23)
2,707 reads
Of the different basic types of backups (full, differential and log) I find the differential the most interesting, and frequently...
2019-02-12 (first published: 2019-01-23)
2,173 reads
A key part of the SQL Server Agent is the ability to schedule jobs. While you can create one schedule...
2019-02-08 (first published: 2019-01-23)
2,761 reads
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