Daily Coping 18 Jan 2022
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...
2022-01-18
28 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...
2022-01-18
28 reads
The Windows application logs are used by various applications to write new events. This blog exporting these logs into CSV format
2022-01-18
58 reads
How to disable current line highlight in SQL Server Management Studio(SSMS)?
2022-01-18
52 reads
A while back I had to help a customer update their naming standard for their Managed Service Accounts, so I thought I would share some of those details. The...
2022-01-18
166 reads
SQL Server - The following T-SQL statement helps find the SQL Database age based on the created date and number of tables.
2022-01-18
33 reads
The T-SQL script takes a full backup of all databases(System databases and user databases) in the format of DataaseName-YYYY-MM-DD-HH-MM-...
2022-01-18
62 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...
2022-01-17
34 reads
Every Database has a DBO or database owner set. Sometimes the owner is invalid, while most of the time the DBO is perfectly normal. It is easy to ignore...
2022-01-17 (first published: 2022-01-05)
748 reads
This topic describes how to change the availability mode of an availability replica in an Always On availability group in SQL Server by usin
2022-01-17
74 reads
Friends, the MidnightDBAs have a plan for 2022. A capital-P Plan. And it involves writing and teaching a lot. The […]
The post Learn some critical SQL Security with the...
2022-01-17
74 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