2019-04-04
678 reads
Editorial
I'm In Charge of Books Online
Today Steve has an announcement about his role in moving Books Online forward.
2019-04-01
571 reads
Containers Are The Present, Not the Future
Last week was the MVP Summit. This year included a bunch of very technical discussions about some of the future of the Microsoft Data Platform (a big thank you goes to Slava Oks, Bob Ward, and all the team for a great job). I can’t share much since it was all under NDA. All I […]
2019-03-30
536 reads
Trunk Based Database Development
Trunk based development is what many of us do with shared database servers.
2019-03-29
755 reads
Giving Computers Ethics
There is a need to ensure we decide what ethics a computer system ought to have.
2020-02-10 (first published: 2019-03-27)
298 reads
No More SQL Server Installs
Today, Steve wonders when we'll stop installing SQL Server on a host machine.
2019-03-26
1,295 reads
What's Worse than Announcing a Data Breach?
Steve has a few thoughts on what is worse than telling your boss about a data breach.
2019-03-25
182 reads
Query Tuning Assistant: A Tool for Upgrades
If you have been working with SQL Server long enough, you have probably been involved with a SQL Server 2000 to 2005 upgrade. It was painful for many shops due to the deprecation of some features like DTS and the removal of old-fashioned comma joins with the plus operator. It was worth the pain as […]
2019-03-25
1,320 reads
2019-03-22
160 reads
The V1 Team’s Doomed Redesign
A new version of an existing application doesn't always provide an upgrade.
2019-03-18
126 reads
Blogs
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Helping an English Student with R
Comments posted to this topic are about the item Helping an English Student with...
Adding Bits I
Comments posted to this topic are about the item Adding Bits I
Question of the Day
Adding Bits I
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