Daily Coping 1 Apr 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-04-01
45 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-04-01
45 reads
I’ve been asking for a way to compare SSIS packages for a long time, and finally Redgate has released an early access version. Years ago we had an internal...
2021-04-01
118 reads
I’ve been asking for a way to compare SSIS packages for a long time, and finally Redgate has released an early access version. Years ago we had an internal version, but the visual comparison format was a problem. Really, we couldn’t decide how to actually compare packages on screen in a way that makes sense for users.
2021-04-01
928 reads
In this month’s Power BI Digest Matt and I will again guide you through some of the latest and greatest Power BI updates this month.
2021-04-01 (first published: 2021-03-24)
436 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-03-31
25 reads
A couple of years ago I wrote a post on how to generate a random number in SQL Server. https://sqlundercover.com/2017/06/22/generating-random-numbers-for-each-row-over-a-specified-range-and-other-funky-stuff-you-can-do-with-them/ It’s ok and it works, it’s also a method...
2021-03-31
5,078 reads
(2021-Mar-22) I had an interesting Azure Data Factory (ADF) case last week while pulling a list of files from an Azure Storage account with the help of [Get Metadata] activity....
2021-03-31 (first published: 2021-03-23)
1,480 reads
This is part two in a five part series this week, Moving into Consulting 101.
Today's consulting topic is friendly advice on how to handle yourself in front of clients,...
2021-03-31 (first published: 2021-03-23)
972 reads
A quick PSA on the behaviour of Serverless Azure SQL DB space reporting in the Azure Portal. I recently had to shrink a large Azure SQL DB for cost...
2021-03-31
47 reads
Have you ever run across an issue that made you take a step back and scratch your head? Recently, I had this exact situation hit my Inbox. One of...
2021-03-31
461 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