Is It Possible To Conditionally Index JSON Data?
Check out this week’s episode on YouTube.
Recently I received a great question from an attendee to one of my sessions...
2018-05-07 (first published: 2018-05-01)
1,989 reads
Check out this week’s episode on YouTube.
Recently I received a great question from an attendee to one of my sessions...
2018-05-07 (first published: 2018-05-01)
1,989 reads
Watch this week's video on YouTube
Recently I received a great question from an attendee to one of my sessions on JSON (what's up Nam!):
At first glance it sounds like...
2018-05-01
18 reads
Watch this week's video on YouTube
Recently I received a great question from an attendee to one of my sessions on JSON (what's up Nam!):
At first glance it sounds like...
2018-05-01
16 reads
At the fabulous PowerShell Conference EU I presented about Continuous Delivery to the PowerShell Gallery with VSTS and explained how...
2018-05-01
485 reads
Well, three SQL Saturdays down for April. Raleigh which was local for me and I helped organize, Philadelphia where I...
2018-05-01
82 reads
Well, three SQL Saturdays down for April. Raleigh which was local for me and I helped organize, Philadelphia where I...
2018-05-01
276 reads
It is very common to see in a relational database that stored procedures are using many Tables, Views, Sequence Object,...
2018-05-01
1,902 reads
Hello!
I’m currently working on a project that requires building and deploying SSDT-based projects. So it’s been a great opportunity of making use of PoshSSDTBuildDeploy and work through any issues....
2018-05-01
42 reads
When running aggregations for reporting in some situations outliers can throw out the numbers.
For example lets say we have a...
2018-04-30
390 reads
Problem
If you been reading this series you are used to looking at Windows and SQL Server but who knows what...
2018-04-30
215 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