Last Week Reading (2019-03-03)
Hey everyone! I was very busy at the SQLBits conference last week, but it did not stop me to prepare...
2019-03-03
318 reads
Hey everyone! I was very busy at the SQLBits conference last week, but it did not stop me to prepare...
2019-03-03
318 reads
This is a trick I use in SQL Server Management Studio at least once a week.
Today’s scripts will be screenshots...
2019-03-18 (first published: 2019-03-02)
3,218 reads
Azure Data Factory (ADF) offers a convenient cloud-based platform for orchestrating data from and to on-premise, on-cloud, and hybrid sources...
2019-03-01
2,187 reads
(last updated: 2019-03-07 @ 15:40 EST / 2019-03-07 @ 20:40 UTC )
I ran across something the other day that I thought would be...
2019-03-15 (first published: 2019-03-01)
3,738 reads
As part of my learning goals for 2018, I wanted to work through various books. This is part of my...
2019-03-01
630 reads
In a previous post, I described how you can use Azure storage to store SQL Server database backup files. This...
2019-03-01
529 reads
In my effort to write more regularly, I’ve branched out a bit to write in the audit and compliance space....
2019-03-01
280 reads
(2019-Mar-01) The first time I heard about the Data For A Cause initiatives was at one of the Power BI meetups in Toronto....
2019-03-01
835 reads
Combining a few themes of recent posts today. I’ll mix in some sp_executesql, it’s always parameter sniffing, and the plan...
2019-02-28
969 reads
As you build your Power BI reports, you may want to use maps and custom visuals. Have you thought about...
2019-02-28
68 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