How I Continuously Learn About SQL Server
Watch this week's video on YouTube
In order to stay current in a technology you have to immerse yourself in community content.
Documentation is good for knowing the specification of a...
2019-07-16
16 reads
Watch this week's video on YouTube
In order to stay current in a technology you have to immerse yourself in community content.
Documentation is good for knowing the specification of a...
2019-07-16
16 reads
Watch this week's video on YouTube
In order to stay current in a technology you have to immerse yourself in community content.
Documentation is good for knowing the specification of a...
2019-07-16
10 reads
[read this post on Mr. Fox SQL blog] The “modern data platform” architecture is becoming more and more popular as organisations shift towards identifying, collecting and centralising their data...
2019-07-16
66 reads
[read this post on Mr. Fox SQL blog] The “modern data platform” architecture is becoming more and more popular as organisations shift towards identifying, collecting and centralising their data...
2019-08-06 (first published: 2019-07-16)
1,420 reads
Pragmatic Works is hosting a 2-day Power Platform online conference. If you are unable to get out to onsite conference but need some help with Microsoft Flow, PowerApps, or...
2019-07-15
65 reads
I’ve been slowly working my way through the 50 days of Kubernetes (K8s). As you might have guessed if you remember my first post, this has been more than...
2019-08-08 (first published: 2019-07-15)
438 reads
sp_RestoreScript 1.4 is now out and ready for download from our GitHub, https://github.com/SQLUndercover/UndercoverToolbox/blob/master/sp_restorescript.sql New Features Compatible with case sensitive collations Now accepts wild cards in the @DatabaseName string, (‘Database1,Database2,SQL%’)...
2019-07-15
233 reads
When you are in charge of databases with tons of objects, making a small change over an object can be difficult to replicate if you have a lot of...
2019-07-15
23 reads
When you are in charge of databases with tons of objects, making a small change over an object can be difficult to replicate if you have a lot of...
2019-08-02 (first published: 2019-07-15)
1,312 reads
The other day I did a post on how an OR short circuts. It was a somewhat unusual type of ... Continue reading
2019-08-06 (first published: 2019-07-15)
727 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
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