Watch the State of SQL Server Monitoring tomorrow
Tomorrow Redgate is running a webinar on the State of SQL Server Monitoring with Grant, Chris Yates, Annette Allen, and Tony Maddonna. You can register now and attend on...
2019-06-24
38 reads
Tomorrow Redgate is running a webinar on the State of SQL Server Monitoring with Grant, Chris Yates, Annette Allen, and Tony Maddonna. You can register now and attend on...
2019-06-24
38 reads
One of the bugs features of the bbPress forum software is that all posts were shown in a time zone, which for us was a default of UTC. Not...
2019-06-22
55 reads
One of my favorite events, in a wonderful place to spend the weekend. I’ve been to Pensacola a few times (3?), including a couple times with my daughter. It’s...
2019-06-20
51 reads
I’m traveling back from Australia today. A few weeks ago I lost a day when I flew West across the Pacific. Today I get it back, with a different...
2019-06-16
43 reads
I needed to generate some load for a demo and wasn’t looking forward to doing it. I was in a hurry, and didn’t want to deal with a lot...
2019-06-27 (first published: 2019-06-12)
496 reads
I didn’t attend the //build/ conference this year and am slightly disappointed. Only slightly, since I was in these cities in May already and didn’t need another trip: London,...
2019-06-21 (first published: 2019-06-05)
451 reads
After our SQL in the City Summit in Brisbane last week, Hamish Watson () asked me if I’d do a short version of my keynote talk at the upcoming...
2019-06-02
21 reads
I was recently doing some work on Always Encrypted in SQL Server 2019 and needed to set up an HGS server. I went through most of the setup, and...
2019-06-14 (first published: 2019-05-30)
338 reads
I’m writing this in advance, as I usually recommend for all bloggers, because this is a lost day for me. I’m not going to experience May 27th, 2019 on...
2019-05-27
50 reads
Give it a try, as the beta is out. I’ve been watching this product and getting updates for the last six months or so and lately I’ve been pushing...
2019-05-23
161 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