Dynamics 365 AX – Creating Data Entities for BYOD Azure Database including those without a natural key
We, BI professionals, sometimes take for granted that we can access the database of an ERP system quite easily, especially...
2017-07-29
767 reads
We, BI professionals, sometimes take for granted that we can access the database of an ERP system quite easily, especially...
2017-07-29
767 reads
You're thinking of starting a blog, or teaching, or training videos. Will it pay off? Will it be worth it?...
2017-07-29
696 reads
Continuation from the previous 107 parts, the whole series can be found at http://www.nikoport.com/columnstore/
As we are approaching the RTM (release...
2017-07-29
857 reads
One of the recent tasks that I have undertaken seemed rather like an experiment to me. I set out to...
2017-07-28
717 reads
Wow, I can hardly contain my excitement. I was selected to speak at SQL Saturday Denver on September 16, 2017. I’ll...
2017-07-28
323 reads
For the past few years I’ve combined my love of professional football and analytics by releasing a series of Power...
2017-07-28
576 reads
For the past few years I’ve combined my love of professional football and analytics by releasing a series of Power...
2017-08-17 (first published: 2017-07-28)
3,521 reads
By Steve Bolton
…………This long-delayed series of amateur self-tutorials has been in the works ever since I began writing my A...
2017-07-28
551 reads
I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and...
2017-07-28
473 reads
Hope you all had a good week. Been pretty chilled out here so I’ve been reading…
Announcing Azure Container Instances
Microsoft blog...
2017-07-28
392 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