Identity Gaps–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2019-01-04 (first published: 2018-12-26)
2,311 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2019-01-04 (first published: 2018-12-26)
2,311 reads
How to correlate all of your favorite trace/profiler options into the shiny new XE equivalents.
As luck would have it, there is a means to correlate trace/profiler events to Extended...
2018-12-26
15 reads
I just shared an article describing how to use Extended Events to perform your SQL Server Profiler duties. If not,...
2018-12-26
1,042 reads
Despite the controls in place there always seems to be some change that is unknown or even some cowboy that makes changes as s/he sees fit and forgets to...
2018-12-25
25 reads
A common excuse for not delving into extended events seems to be the jump from Profiler to extended events. There...
2018-12-25
783 reads
Wish you all a Merry Christmas and may this festival bring abundant joy and happiness in your life!
From
Technology with Vivek Johari
2018-12-24
40 reads
Wish you all a Merry Christmasand may this festival bring abundant joy and happiness in your life!
From Technology with Vivek Johari
2018-12-24
184 reads
I enjoy when the Avent of Code comes around each year. I seem to make this a December (or sometimes...
2018-12-24
331 reads
Just for fun I decided to spend Christmas Eve getting Windows and Linux SQL containers running together.
WARNING
This is NOT a...
2019-01-04 (first published: 2018-12-24)
1,905 reads
This is a very simple introduction into the creation of an Extended Event session using a template for Azure SQL DB. I demonstrate the use of the GUI to...
2018-12-24
28 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