Daily Coping 20 Dec 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-12-20
27 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-12-20
27 reads
This is our current setup shown below. There is not much to failing over with Managed Instances, from experience it is similar to that of Azure SQL Database. Let’s...
2021-12-17 (first published: 2021-12-07)
287 reads
Yesterday, I had about 30 existing queries (and some multi-query processes) that I needed to turn into individual stored procedures. […]
The post SQL Server meta-development (with regular expressions and...
2021-12-17 (first published: 2021-10-13)
492 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-12-16
32 reads
Our holiday gift to the Microsoft Data Platform Continuity Virtual Group is to have a massive panel of industry-leading experts answer YOUR questions with no strings attached! Bring your...
2021-12-16
53 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-12-15
28 reads
This week’s blog post will help you check your SQL Servers up-time. There are numerous reasons I can think of that you would want to know how long your...
2021-12-15 (first published: 2021-12-07)
577 reads
There is a setting / feature in Managed Instance worth talking about, it is called SQL Trust Groups. What is this? At a basic level it’s a way to...
2021-12-15
130 reads
Something I’ve been thinking about recently is that DBAs are best when they are invisible. Now, this is also true ... Continue reading
2021-12-15 (first published: 2021-12-07)
375 reads
Prior to 2017, the only way to get SQL Server running on a Mac was through a virtual machine running some version of Windows that supported some version of...
2021-12-15
76 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