Finding the Visual Designer in Azure DevOps Builds
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
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
I’ve always felt responsible for making such a big deal about the differences between estimated and actual plans. I implied in the first edition of the execution plans book...
2019-09-18 (first published: 2019-09-09)
560 reads
SQL Server Integration Services is equipped with tasks and containers to make it easy to design and maintain the flow of ETL: which logic should be executed, when should...
2019-09-18 (first published: 2019-09-09)
475 reads
This month’s T-SQL Tuesday invitation comes from Kevin Chant and he’s asking us about a fantasy feature that we’d love to see in SQL Server. I had a little...
2019-09-09
47 reads
Hello all and welcome after my one month of my absence. What was I doing? Thank you for asking! I have been on holiday. ONE month of very relaxing,...
2019-09-08
36 reads
Using a Shared Access Signature (SAS) is usually the best way to control access rights to Azure storage resources (like a container for backups) without exposing the primary /...
2019-09-08
102 reads
This is Part 3 in a three-part series. Please see Part 1 and Part 2 for more. There we go! Thank you Jon for sending in your questions. This...
2019-09-06
19 reads
This is Part 3 in a three-part series. Please see Part 1 and Part 2 for more.
What does your average day look like?
I’m going to punt to my “A...
2019-09-06
28 reads
In SQL Server Integration Services, the lookup component is one of the most frequently used tools for data validation and completion. The lookup component is provided as a means...
2019-09-05
287 reads
This is Part 2 of a series. Please see Part 1 for the background and more. Stay tuned for the thrilling conclusion in Part 3, coming soon!
The post Q&A:...
2019-09-05
25 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