Redgate at SQLBits
Redgate and the Advocates are attending SQL Bits next week in London. I’m excited to see Grant and Kathi in person, as it’s been far too long since I...
2022-03-03
76 reads
Redgate and the Advocates are attending SQL Bits next week in London. I’m excited to see Grant and Kathi in person, as it’s been far too long since I...
2022-03-03
76 reads
The other day a friend of mine mentioned that they were questioned on one of the scripts they ran recently ... Continue reading
2022-03-03
295 reads
The other day a friend of mine mentioned that they were questioned on one of the scripts they ran recently ... Continue reading
2022-03-03
32 reads
Watch this week's video on YouTube
I like solving the daily New York Times crossword on paper. However, logging in to download the PDF every day and printing it is...
2022-03-03
26 reads
Watch this week's video on YouTube
I like solving the daily New York Times crossword on paper. However, logging in to download the PDF every day and printing it is...
2022-03-03
39 reads
In IT, commonality is an accelerator. When I say commonality, I mean commonality of: Components, like libraries Object models Interface definitions Tools Let me give you an example. Imagine...
2022-03-02
205 reads
Many companies are seeing the value in collecting data to help them make better business decisions. When building a solution in Azure to collect the data, nearly everyone is...
2022-03-02
650 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-03-02
32 reads
This is part of a series on my preparation for the DP-900 exam. This is the Microsoft Azure Data Fundamentals, part of a number of certification paths. You can...
2022-03-02
130 reads
Since we’re on a recent theme of revising long-held best practices that are not, here’s a timely one for you: Don’t change your default SQL Server port for security...
2022-03-02
258 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