Did you know…you can’t do arithmetic operations with datetime2 like with datetime?
I’m currently working on a SQL code migration from Firebird to SQL Server and I hit an error that I...
2018-04-11 (first published: 2018-04-06)
2,672 reads
I’m currently working on a SQL code migration from Firebird to SQL Server and I hit an error that I...
2018-04-11 (first published: 2018-04-06)
2,672 reads
(last updated: 2018-04-28)
Recap
In Part 1 of this 2 part series, I started with the loose definition in Microsoft’s documentation for...
2018-04-11 (first published: 2018-04-06)
2,108 reads
A sad day for me.
A Memorial and Grief fund has been set up, if you’d like to contribute.
2018-04-05
455 reads
If I was a wizard I would make these 4 improvements to Azure SQL Database. They are in no particular...
2018-04-12 (first published: 2018-04-05)
2,202 reads
I’m giving a webinar today, April 5th, at 3 PM Eastern, on using Extended Events to audit your SQL Servers....
2018-04-05
338 reads
Today marks 3 days since we’ve lost Robert Davis a.k.a SQLSoldier, one of the pillars of SQL Family community.
I was...
2018-04-13 (first published: 2018-04-05)
3,132 reads
I had a template that deployed a premium managed disk and a virtual machine. I defined the disk like:
{ "comments":...
2018-04-05
134 reads
I had a template that deployed a premium managed disk and a virtual machine. I defined the disk like:
{ "comments":...
2018-04-05
199 reads
I had a template that deployed a premium managed disk and a virtual machine. I defined the disk like:
{
"comments":...
2018-04-05
338 reads
I had a template that deployed a premium managed disk and a virtual machine. I defined the disk like:
{ "comments": "Managed Disk.", "type": "Microsoft.Compute/disks", "name": "[variables('diskName')]", "apiVersion": "2016-04-30-preview", "location":...
2018-04-05
15 reads
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
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...
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