Switching blog website
For quite some years now I have been active on my blog over at www.dotnine.net. While there was nothing wrong with...
2018-11-14
230 reads
For quite some years now I have been active on my blog over at www.dotnine.net. While there was nothing wrong with...
2018-11-14
230 reads
The title says it all, this year I have been selected as a speaker at the world’s largest Microsoft Data...
2018-10-31
271 reads
I am pretty hyped to be able to finally announce a new project of mine that I have been working on for...
2018-03-13
385 reads
In a previous article I discussed the various methods available in SQL Server 2016 & 2017 to perform in-database analytics. In...
2017-12-25 (first published: 2017-12-11)
2,055 reads
Starting from SQL Server 2016 Microsoft put a lot of effort into integrating various languages used in machine learning and...
2017-10-17
2,070 reads
When you are working with Machine Learning there are many things you need to keep an eye on. You need...
2017-07-21
2,301 reads
With Azure Machine Learning (AzureML) you have access to a cloud based, flexible and friendly method to perform machine learning...
2017-05-24 (first published: 2017-05-14)
4,032 reads
Good news!
The recording of my session “Introducing the SQL Server 2016 Query Store” at the GroupBy conference 2 weeks ago...
2017-05-19 (first published: 2017-05-05)
1,448 reads
I remember writing an article about Query specific wait statistics being available inside execution plans in SQL Server 2016 SP1....
2017-05-01 (first published: 2017-04-23)
1,849 reads
In case you didn’t know this already, dbatools is an awesome collection of Powershell functions that will help you immensely...
2017-03-08 (first published: 2017-02-27)
2,514 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