Connect Windows 10 client to a VPN on Windows Server 2012 R2
I got a strange request in a Slack channel the other day. A colleague in South Africa, who uses Windows,...
2017-09-06
406 reads
I got a strange request in a Slack channel the other day. A colleague in South Africa, who uses Windows,...
2017-09-06
406 reads
This is the next in a series of blogs I am going to create talking about useful tools (mostly scripts)...
2017-09-13 (first published: 2017-09-06)
3,606 reads
Schemas are a very useful tool for managing the objects in your database. From security through process, through placement, schemas...
2017-09-14 (first published: 2017-09-06)
2,330 reads
There have already been many posts/articles/books written about the subject of how CALCULATE and FILTER works, so I’m not going...
2017-09-13 (first published: 2017-09-06)
2,030 reads
Please, please, please Admins do not leave your default index fill factor at 0. This means you are telling SQL...
2017-09-18 (first published: 2017-09-06)
3,908 reads
By default, on a SQL Server Database, statistics are updated automatically when one hits a threshold of changes. If the...
2017-09-19 (first published: 2017-09-06)
2,069 reads
Last week I went through how to run SQL Server in Kubernetes on Azure Container Services (ACS)
This week I want...
2017-09-06
854 reads
Write-Output "What are you going to automate today?"
Welcome to T-SQL Tuesday for September 2017!
T-SQL Tuesday is a chance for you...
2017-09-05
357 reads
Last year Andy Warren and I worked out a deal with the PASS organization to sponsor a game night on...
2017-09-05
788 reads
Protecting against SQL Injection Part 2
Watch this week's video on YouTube
Last week we talked about building dynamic SQL queries and how doing so might leave you open to SQL injection...
2017-09-05
36 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