SQL Change Automation v4 Puts Migrations in SSMS
I’ve been waiting for this a long time. Over the years, as Redgate has improved and changed the SQL Change Automation product in Visual Studio, I’ve been wanting to...
2019-09-23
75 reads
I’ve been waiting for this a long time. Over the years, as Redgate has improved and changed the SQL Change Automation product in Visual Studio, I’ve been wanting to...
2019-09-23
75 reads
Data exploration is an essential piece of any new ETL (extraction-transformation-load) process. Knowing the structure, type, and even the semantics of data sources can help the ETL developer or...
2019-10-01 (first published: 2019-09-23)
423 reads
I reviewed a set of wireless headphones this summer, and I continue to use them when traveling. They work well for me and have good battery life. The company...
2019-09-23
29 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2019-09-23
221 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2019-10-02 (first published: 2019-09-23)
737 reads
‘Shortest path’ is by far the most feature of SQL Graph for now. What does this even mean? ‘Shortest path’ is the term accorded to the shortest distance between...
2019-10-08 (first published: 2019-09-22)
781 reads
Hello #datafolks! Let’s review what happened last week in Data World. It’s hard to admit but I missed last week’s post due to my visit to Sweden (SQLSaturday) and...
2019-09-22
18 reads
In this post we saw how to create some graph tables with data. In this I will explore simple queries off of this data and how they compare with...
2019-10-01 (first published: 2019-09-21)
477 reads
I don't normally drop users and logins in production, but when I do, and it goes wrong, I do this.
2019-09-20
57 reads
One of the top reasons I love PowerShell so much is that from the beginning, it was designed to let you, yes you, make it run better for the...
2019-09-19
23 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