SQL Homework – October 2018 – Time for an upgrade
When you created your home lab last September you probably installed a version of SQL 2016. Well, SQL 2017 was...
2018-10-01
318 reads
When you created your home lab last September you probably installed a version of SQL 2016. Well, SQL 2017 was...
2018-10-01
318 reads
It’s been a few weeks since i have blogged as I have been busy with a lot of other things....
2018-10-10 (first published: 2018-09-29)
1,969 reads
Picture the scene….. DBA Doug is sitting in his cubicle minding his own business when App Dev Allister gives him...
2018-09-29
178 reads
Picture the scene….. DBA Doug is sitting in his cubicle minding his own business when App Dev Allister gives him...
2018-09-29
150 reads
(last updated: 2018-12-26 @ 16:20 EST / 2018-12-26 @ 21:20 UTC )
(NOTE: For recent update, please see “Update for CTP 2.2” section)
For some...
2018-09-28
10,850 reads
One of the very interesting parts of my job is that I run into UK keyboards on a regular basis....
2018-09-28
1,028 reads
In this final post of my Azure Cognitive Services week of Azure Every Day, I’ll focus on the Vision APIs...
2018-09-28
318 reads
I’ve never been to Pittsburgh. Actually, in all of my speaking and traveling, I don’t think I’ve even flown through...
2018-09-28
992 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-09-27
1,155 reads
This week in my Azure Every Day posts, I’ve been focusing on Azure Cognitive Services and what these features can...
2018-09-27
336 reads
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
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