Friday Flyway Tips–Quick Command Line Access
One of the things I had to do recently in a demo was access the Git command line. The way I did it impressed a customer, so I put...
2024-03-01
78 reads
One of the things I had to do recently in a demo was access the Git command line. The way I did it impressed a customer, so I put...
2024-03-01
78 reads
I’ve collaborated with two industry experts to design a transformative course for data leaders: “The Technical and Strategic Data Leader.” This six-week intensive learning journey is crafted to elevate...
2024-02-28 (first published: 2024-02-16)
377 reads
T-SQL Tuesday is a monthly blog party hosted by a different community member each month. I missed out on January 2024’s edition because I didn’t think I had anything...
2024-02-28 (first published: 2024-02-20)
212 reads
I try to keep an eye on the Humble Bundle bundles for books. The bundles serve two great purposes: I was able to grab the Cybersecurity bundle, but by...
2024-02-26
152 reads
For years I’ve assumed I knew the string defaults, but I realized that’s not right. This post looks at what I learned. Another post for me that is simple...
2024-02-26 (first published: 2024-02-14)
366 reads
I have been involved in countless database migrations. Most of the time I have access to the existing source servers and future destination servers. In cases where you have...
2024-02-26 (first published: 2024-02-15)
513 reads
It’s #TSQL2sday time! This month’s invitation has been sent out by Brent Ozar and he asks us to describe the most recent issue – or the last ticket –...
2024-02-23 (first published: 2024-02-13)
229 reads
proluctance – n. the paradoxical urge to avoid doing something you’ve been looking forward to – opening a decisive letter, meeting up with a friend who’s finally back in...
2024-02-23
54 reads
Last week, the Cybersecurity & Infrastructure Security Agency (CISA) put out an emergency directive which ordered federal agencies to pull Ivanti Connect Secure and Ivanti Policy Secure installations from...
2024-02-23 (first published: 2024-02-05)
206 reads
We have numerous Azure Analysis Services servers running in the cloud and needed a way to have near-real time monitoring of the queries being run. This KQL query will...
2024-02-21 (first published: 2024-02-06)
276 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