Event Files on Linux
For the most part, things work the way you might expect them to work in windows - except it is on Linux. Sure some things are different, but SQL...
2019-07-29 (first published: 2019-07-10)
210 reads
For the most part, things work the way you might expect them to work in windows - except it is on Linux. Sure some things are different, but SQL...
2019-07-29 (first published: 2019-07-10)
210 reads
I are thrilled to announce that I has been renewed for the sixth time as a Microsoft Data Platform MVP for 2019 to 2020. The MVP award remains incredibly...
2019-07-09
17 reads
Welcome to our continuing series that Erin Ostrowsky [Blog | Twitter] and I spend focusing on interviewing for a Power BI position. This series will
2019-07-30 (first published: 2019-07-09)
731 reads
It doesn’t look like this would affect SQL Server 2008 or SQL Server 2008 R2 since the earliest reported platform is SQL Server 2014, but in Microsoft’s release of...
2019-07-17 (first published: 2019-07-09)
1,770 reads
This month is an interesting invitation from Tracy Boggiano. It’s on Linux, which I like. I hadn’t thought about this in terms of T-SQL Tuesday, but I think it...
2019-07-29 (first published: 2019-07-09)
198 reads
Every so often I set out to create new resources in my Azure subscription using the command line tools (PowerShell or CLI) just to keep up to date on...
2019-07-25 (first published: 2019-07-09)
501 reads
Watch this week’s episode on YouTube! Today I want to share with you an interesting observation I made about SELECT expression execution order. I was working on writing a...
2019-07-23 (first published: 2019-07-09)
821 reads
Watch this week's video on YouTube
Today I want to share with you an interesting observation I made about SELECT expression execution order.
I was working on writing a dynamic SQL...
2019-07-09
23 reads
Watch this week's video on YouTube
Today I want to share with you an interesting observation I made about SELECT expression execution order.
I was working on writing a dynamic SQL...
2019-07-09
14 reads
I mentioned in earlier posts that I’m using Trello this year for managing SQLSaturday tasks and figured I might as well go all in and add some of the...
2019-07-26 (first published: 2019-07-09)
308 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