The times they are ae-changing
I have been quite on this blog for a couple of weeks now, and there are a couple of reasons...
2017-08-03
382 reads
I have been quite on this blog for a couple of weeks now, and there are a couple of reasons...
2017-08-03
382 reads
I’ve been getting to grips with Docker SQL Containers on Linux (specifically Ubuntu 16.04) and have found that I’ve been...
2017-08-03
471 reads
In my previous blog we learnt to connect to Azure subscription by importing azure license setting file. In this blog...
2017-08-03
538 reads
In the last weeks, while I was preparing for one of the certification exams, I got a lot of questions from collegues, asking questions such as How do you...
2017-08-02
19 reads
Imagine we have the following table
Users
FieldTypeIdINTUsernameNVARCHARDeletedBITThen imagine we want Username to be unique for non deleted users. Normally we would...
2017-08-02
72 reads
Last week we looked at ACID compliance. This week we dive a little deeper into the Isolation portion, and what...
2017-08-02
147 reads
I saw a report of a problem building a database with ReadyRoll in Azure SQL Database. This person wanted to...
2017-08-25 (first published: 2017-08-02)
1,631 reads
Microsoft has released a preview of the Azure Analysis Services web designer. This is a browser-based experience that will allow...
2017-08-02
697 reads
In the last weeks, while I was preparing for one of the certification exams, I got a lot of questions...
2017-08-02
162 reads
If you didn’t see it last month I’ve started doing monthly SQL Homework. The first month was backups, this month...
2017-08-02
429 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