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
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
Tomorrow I get to chat with another giant in the world of DevOps: Jez Humble. I actually met Jez years ago at a conference, and I was honored to...
2019-09-17
26 reads
Not something you’ll do too often, but you might find yourself doing this if you are setting up PoCs and removing them. A reminder for me, since I stumbled...
2019-09-16
86 reads
It’s two weeks to our next SQL in the City Summit, this time in Sydney. I’m excited to be going back, though it’s a quick trip for me. Likely...
2019-09-13
60 reads
This post will explain how to change the connection in your masking set when using SQL Data Masker from Redgate. I’m writing this more for myself than anyone else....
2019-09-11
53 reads
This post is really a reminder to me, since I don’t create pipelines all that often, and I’ve forgotten a few times how to do this. Plus, while YAML...
2019-09-09
915 reads
Today is SQL in the City Streamed!!! Only three of us, , as Kendra has other commitments. Still, it’s exciting for Kathi, Grant, and myself to be presenting the...
2019-09-04
29 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One common task that you might need to...
2019-09-11 (first published: 2019-09-02)
315 reads
I’m off to the UK this weekend, for a few commitments next week. One of those is SQL in the City Streamed, which is taking place on Wednesday September...
2019-08-30
27 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