Introducing… Data On Rails!
Data On Rails is a Data On Wheels project designed to give a platform for up and coming data professionals in the data community. This project is the brainchild...
2023-02-01
46 reads
Data On Rails is a Data On Wheels project designed to give a platform for up and coming data professionals in the data community. This project is the brainchild...
2023-02-01
46 reads
If you don’t have the backups of the certificate and private key from the old server, as well as the password used to encrypt the private key backup then...
2023-02-01
220 reads
In this post we look at a method using Extended Events (XE) to identify what parent objects are calling a given SQL function and how often. The background is...
2023-02-01 (first published: 2023-01-23)
496 reads
A question I get asked frequently from customers when discussing Data lake architecture is “Should I use one data lake for all my data, or multiple lakes?”. Ideally, you...
2023-02-01 (first published: 2023-01-23)
506 reads
Today’s coping tip is to take a small step towards and important goal. One of my goals this year was to work on a way to score myself with...
2023-01-31
16 reads
In a previous post, I set up the basic databases for the PoC project I’m working on. In this next post, we’ll get the Flyway Desktop projects set up...
2023-01-31 (first published: 2023-01-30)
40 reads
Hello Dear Reader! It's been a while since I had time to sit down and write out a Monday re-capThis past week was my birthday week. With all the...
2023-01-31
39 reads
Today’s coping tip is to plan something fun and invite others to join you. The fun thing is actually skiing today. My wife and I wanted to get some...
2023-01-30
27 reads
EightKB is back! The biggest online SQL Server internals conference is back in 2023…happening on May 24th. We’ve open our call for speakers, you can submit here: – https://sessionize.com/eightkb-may-2023/...
2023-01-30 (first published: 2023-01-23)
174 reads
I have a Logic App that reads out a SharePoint library and stores all the documents found into Azure Blob Storage (ADF only supports Lists). I was trying to...
2023-01-30 (first published: 2023-01-18)
87 reads
This is my late response to T-SQL Tuesday #204. I almost always forget about...
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
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