AlwaysOn_health Extended Event Session
The AlwaysOn_health XEvent session is installed by SQL Server by default, and started by the Create Availability Group wizard when...
2018-07-25
3,076 reads
The AlwaysOn_health XEvent session is installed by SQL Server by default, and started by the Create Availability Group wizard when...
2018-07-25
3,076 reads
I hope to see you all at this year’s VMworld 2018 USA conference where I’m lucky enough to have been...
2018-07-24
750 reads
Speaking at SQLSaturday Sacramento!
I’m proud to announce that I will be speaking at SQL Saturday Sacramento on July 28th 2018! And wow, 757 SQL Saturdays! This one won’t let you...
2018-07-24
10 reads
Speaking at SQLSaturday Sacramento!
I’m proud to announce that I will be speaking at SQL Saturday Sacramento on July 28th 2018! And wow,...
2018-07-24
287 reads
Be sure to check out this week’s video on YouTube.
This week I was fortunate enough to film a video in...
2018-07-24
329 reads
Watch this week's video on YouTube
This week I was fortunate enough to film a video in collaboration with Pinal Dave, the SQL Authority himself. Pinal is creative, hilarious, and...
2018-07-24
13 reads
Watch this week's video on YouTube
This week I was fortunate enough to film a video in collaboration with Pinal Dave, the SQL Authority himself. Pinal is creative, hilarious, and...
2018-07-24
13 reads
The AlwaysOn Dashboard is an excellent tool in SQL Server Management Studio that allows you to monitor Replica status, Availability...
2018-07-24
680 reads
This month I continued my series with my friend Manuel Quintana [Blog | Twitter] as we guide you through some of...
2018-07-23
882 reads
In my previous Database Fundamentals post, I showed you how to use the Query Designer to build a query. That...
2018-07-23
830 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