An Introduction to Azure SQL Databases
This David's SQL Server Saturday talk titled an introduction to Azure SQL Databases
It does pretty much what is says on...
2017-12-08 (first published: 2017-11-28)
2,257 reads
This David's SQL Server Saturday talk titled an introduction to Azure SQL Databases
It does pretty much what is says on...
2017-12-08 (first published: 2017-11-28)
2,257 reads
In this module you will learn how to use the Venn Diagram Custom Visual by MAQ Software. The Venn Diagram...
2017-12-05 (first published: 2017-11-28)
1,638 reads
Hello!
Late on Friday I published a PowerShell Module that gives working examples of using DataToolsMSBuild. All very interesting, go and...
2017-11-28
334 reads
Now I’m all for making my life easier and one thing that makes life easier for me is having a...
2017-11-27
543 reads
One of the things that I believe strongly in is that we need better testing of software. Actually, what we...
2017-11-27
742 reads
I wrote a piece on SQL Compare and customizing the Automap feature. This was handy for me in a small...
2017-12-07 (first published: 2017-11-27)
1,244 reads
The preferred method for modifying your data within a database is T-SQL. While the last Fundamentals post showed how to...
2017-12-11 (first published: 2017-11-27)
1,836 reads
In this post I'll show you how to create new users in your Azure Active Directory so you can use them as service accounts or to grant other users...
2017-11-27
33 reads
Doing a database restore may not be the most common task a database professional will ever do, but it’s a...
2017-12-07 (first published: 2017-11-27)
7,749 reads
Security is very much on our minds these days. Scarcely a day goes by without hearing of a yet another...
2017-12-06 (first published: 2017-11-27)
1,601 reads
This is my late response to T-SQL Tuesday #204. I almost always forget about...
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
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