Is It Possible To Conditionally Index JSON Data?
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
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
Problem
If you been reading this series you are used to looking at Windows and SQL Server but who knows what...
2018-04-30
1,826 reads
It is important to have a secure environment, enforcing the least privilege principle in your servers and databases, but this...
2018-04-30
5,449 reads
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
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...
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