Fixing SQL AG Routing "Cannot find host" using packet analysis (and a spell checker)
I was setting up an availability group listener recently and when I tried to connect to the listener I got...
2017-11-30
235 reads
I was setting up an availability group listener recently and when I tried to connect to the listener I got...
2017-11-30
235 reads
I was setting up an availability group listener recently and when I tried to connect to the listener I got...
2017-11-30
217 reads
On 12/13 I’m presenting two, back to back, sessions on SQL Server on Linux online. So you can attend from anywhere!
Let’s go through both!
First, on 12/13 at 1PM Central,...
2017-11-30
15 reads
On 12/13 I’m presenting two, back to back, sessions on SQL Server on Linux online. So you can attend from...
2017-11-30
489 reads
In my previous posts about writing your first Pester Test and looping through instances I described how you can start...
2017-11-30
700 reads
Today I will write just a short blog post to do a quick reminder! I still hear a lot of...
2017-11-30
724 reads
I’ve blogged a while back on how SSIS 2017 was finally here. Not much has changed; there is still no...
2017-11-30
1,818 reads
Preattentive attributes are visual properties that we notice without using conscious effort to do so. Preattentive processes take place within 200ms...
2017-11-30
865 reads
Today I will write just a short blog post to do a quick reminder!
I still hear a lot of people suggesting CTEs because they think it works like a...
2017-11-30
25 reads
It's happened to almost everyone. Someone installs Evaluation Edition and now you need to upgrade
it to a licensed copy using...
2017-11-30
928 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