Public and Demo Data Coming Soon!
Any database professional that has been around the Microsoft world for more than about 3 minutes will be familiar with the old, faithful sample dataset created and published by...
2019-08-22
32 reads
Any database professional that has been around the Microsoft world for more than about 3 minutes will be familiar with the old, faithful sample dataset created and published by...
2019-08-22
32 reads
Any database professional that has been around the Microsoft world for more than about 3 minutes will be familiar with the old, faithful sample dataset created and published by...
2019-08-22
23 reads
Any database professional that has been around the Microsoft world for more than about 3 minutes will be familiar with the old, faithful sample dataset created and published by...
2019-09-02 (first published: 2019-08-22)
311 reads
Yesterday, some new views were made available in the Azure portal that will be helpful to those of us who create or manage Azure SQL resources. First, a new...
2019-09-03 (first published: 2019-08-22)
321 reads
We spread my Fathers ashes over the past weekend. It was one of the hardest things...
2019-09-06 (first published: 2019-08-22)
546 reads
Some 2019 tips for other SQLSat organizers from my last year as lead organizer of SQLSatBR. I hope as a fellow organizer, you can pull some ideas and inspiration...
2019-09-06 (first published: 2019-08-21)
372 reads
One of the powerful aspects of Query Store is the ability to directly query the DMVs for details of historical executions and performance. A key view for this is...
2019-09-04 (first published: 2019-08-21)
327 reads
Based on the great post and script from Wayne Sheffield I decided to try again pre-printing the SpeedPASS for everyone this year. I dislike the line of shame and...
2019-09-05 (first published: 2019-08-21)
241 reads
An exciting new feature in SQL Server 2019 is Accelerated Database Recovery (ADR). Resulting from a combination of magic beans and smart software developers (I might be wrong about...
2019-08-21
61 reads
In a previous post, I explained how to get Jenkins running in a container for your local CI work. In this one, I’ll expand on the process for database...
2019-08-30 (first published: 2019-08-21)
538 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