Interviewed
I got sent an interview by Mohammad Darab, a fellow SQL Server professional in Northern Virginia. I thought the questions...
2017-12-08
1,279 reads
I got sent an interview by Mohammad Darab, a fellow SQL Server professional in Northern Virginia. I thought the questions...
2017-12-08
1,279 reads
From time to time we need to make changes to Always on Availability group Synchronization mode settings , this also includes...
2017-12-20 (first published: 2017-12-08)
1,499 reads
Tomorrow 12/09/2017 is SQL Saturday #694 in Providence, RI.
I will be presenting by SQL Server Health Check session first thing...
2017-12-08
372 reads
I was interviewed in Redmond a couple months ago and the video was just published. I show and demo some...
2017-12-22 (first published: 2017-12-07)
1,745 reads
Anyone who has been working with SQL Server for any length of time should be aware of the name Kalen...
2017-12-07
354 reads
I should write about my first one, but I just copied Rob’s test, so that’s not so exciting. Instead, I...
2017-12-20 (first published: 2017-12-07)
2,125 reads
I have moved many databases to Azure via different methods but I recently came across a new way. Well technically...
2017-12-19 (first published: 2017-12-07)
1,571 reads
The @@SERVERNAME Global Variable
The system global variable @@SERVERNAMEcan be used to return the name of the machine the SQL Server...
2017-12-19 (first published: 2017-12-07)
4,846 reads
(Part 1 of 2 -about and for Speakers.) The SQL Server community stands out as one of the most open, sharing, and giving technology communities. Around the world, there...
2017-12-07
17 reads
(Part 1 of 2 -about and for Speakers.) The SQL Server community stands out as one of the most open, sharing, and giving technology communities. Around the world, there...
2017-12-07
30 reads
This is my late response to T-SQL Tuesday #204. I almost always forget about...
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
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