SQL Server – Reading BACPAC Files
If you have been reading my blog for a while now you would know that a common technique to move...
2018-10-19
282 reads
If you have been reading my blog for a while now you would know that a common technique to move...
2018-10-19
282 reads
In this article I continue to explore the ways to secure the data via contextual views and describe the technique...
2018-10-18
558 reads
Windows Performance Counter Alerts can be configured to be triggered on any Performance Monitor (Perfmon) Counter through the use of...
2018-10-18
1,684 reads
In this post we will discuss how to fetch data from a large dataset for web applications using pagination technique....
2018-10-17
434 reads
Tempting headline, isn’t it? It might even seem like clickbait, but that’s not the intention. The SQL Server default configuration...
2018-10-17
307 reads
I still use sp_help_revlogin to transfer logins between servers. I know there are other options, including a set of Powershell...
2018-10-30 (first published: 2018-10-17)
7,810 reads
For a long time there I would see the Object Explorer Details tab show up when I opened SSMS (SQL...
2018-10-17
293 reads
At the last few events I attended, I’ve gotten into conversations on how to begin as a speaker. So I...
2018-10-17
347 reads
2018-10-17
210 reads
This post helps in deciding between choosing foreign key and check constraints in case we need to constraint the data...
2018-10-16
469 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