Friday Reading 2018-05-04
Phew, busy week. In the middle of updating presentations and making sure demos work!
Here’s a few of the articles...
2018-05-04
353 reads
Phew, busy week. In the middle of updating presentations and making sure demos work!
Here’s a few of the articles...
2018-05-04
353 reads
Like other RDBMS MySQL also has similar architecture: Connection Layer/Application Layer Logical Layer (Processing) Storage Engine Layer (Physical) – special Connection...
2018-05-03
322 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-05-14 (first published: 2018-05-03)
2,955 reads
This post is a bit different from my usual SQL Serer posts, I recently hit a problem where a legacy...
2018-05-03
544 reads
It’s been exactly two years today, that I stood on an international “stage” as a speaker for the first time,...
2018-05-11 (first published: 2018-05-03)
1,902 reads
DAC or Dedicated Admin Connection is one of those things you don’t know you need until it’s too late.
What is...
2018-05-02
92 reads
Story of MySQL is very interesting and involved emotions in it. This is my understanding and my though on Journey...
2018-05-02
311 reads
Have you ever had the need to give elevated permissions via a stored procedure above that what the user calling...
2018-05-14 (first published: 2018-05-02)
2,434 reads
It occurred to me that we haven’t covered the TIMESTAMP data type in this series about dates and times. TIMESTAMP...
2018-05-02
289 reads
Monday was announced the general availability of the Compute Optimized Gen2 tier of Azure SQL Data Warehouse. With this performance optimized tier, Microsoft...
2018-05-02
203 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