Webinar on Data Security and Compliance
Tomorrow, July 13, 2021, I will be giving a webinar on data security and compliance. Here’s the sign-up link: SQL Server Data Security and Compliance sign-up (free, but registration...
2021-07-12
50 reads
Tomorrow, July 13, 2021, I will be giving a webinar on data security and compliance. Here’s the sign-up link: SQL Server Data Security and Compliance sign-up (free, but registration...
2021-07-12
50 reads
When someone older than you dies, it’s sad, though I feel that I can cope. I hold memories dear, I appreciate the time I had with an individual, and...
2021-07-11
238 reads
I recently was a part of GestaltIT’s AI Field Day and have been thinking heavily about artificial intelligence (and by extension, machine learning and deep learning) lately. I put...
2021-07-09 (first published: 2021-06-28)
272 reads
I wrote recently about the use of the command line in SQL Compare 14 to find differences for specific items. Now I want to actually see the changes to...
2021-07-09 (first published: 2021-06-28)
196 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-07-09
30 reads
In the last post we built an image of SQL server 2019 Linux hosted in Azure Container Instance for fast access to SQL server. So, your next question is...
2021-07-08
79 reads
Azure Resource Manager (ARM) Template is a cloud automation API for deploying Azure resources such as VM, database, network and storage services repeatedly with little(more...)
2021-07-08
68 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-07-08
59 reads
Running DBCC CHECKDB or DBCC CHECKTABLE on a database may report error 8961. Such a situation could occur while changing the data type of a table column from “ntext...
2021-07-08
39 reads
A command I like to use when performance tuning is DBCC INPUTBUFFER. If you have ever run sp_whoisactive or sp_who2 to find out what sessions are executing when CPU...
2021-07-07
29 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
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