Best Hidden Feature in SQL Server 2019
With Microsoft’s Ignite conference this week a lot of new features are being advertised all over the internet. Most likely...
2018-09-26
601 reads
With Microsoft’s Ignite conference this week a lot of new features are being advertised all over the internet. Most likely...
2018-09-26
601 reads
We are introducing a new workshop focused on Cloud ETL. ETL, or Extract, Transfer and Load, is nothing new and...
2018-09-26
369 reads
On Monday 24 September 2018, Microsoft announced a slew of stuff at their annual Ignite conference that is going to...
2018-09-26
385 reads
In today’s post focusing on Azure Cognitive Analytics, I’ll look at the Language Analytics APIs that are available. These language...
2018-09-26
353 reads
I’ve got FOUR sessions coming up in October. These sessions will each be 30 minutes. Redgate Sessions Wed, Oct 3, 9AM PT / 12PM ET: How to Lead DBAs...
2018-09-26
28 reads
As I first mentioned in my blog Microsoft database migration tools, the Azure Database Migration Service (DMS) is a PaaS solution that makes it easy to migrate from on-prem/RDS to Azure...
2018-09-26
53 reads
As I first mentioned in my blog Microsoft database migration tools, the Azure Database Migration Service (DMS) is a PaaS solution that...
2018-10-08 (first published: 2018-09-26)
2,762 reads
I have a #sqlhelp question that requires some code. So hey, blog post time! TL;DR: the geometry::STGeomFromText graph provides too wide...
2018-09-26
386 reads
If you read the Microsoft White Paper on SQL Server 2019, there’s a gem buried on page 17. It mentions...
2018-10-09 (first published: 2018-09-26)
3,377 reads
The Opportunity Earlier this year I received an email from Jonathan Gennick, an editor at Apress books. The subject of the email was “Tech edit a book” and he...
2018-09-26
21 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