I’m Speaking at #SQLSatCleveland
I am so excited and honored to have been selected to speak at SQL Saturday Cleveland #930 on February 1, 2020. This will be my second time speaking at...
2019-12-27
31 reads
I am so excited and honored to have been selected to speak at SQL Saturday Cleveland #930 on February 1, 2020. This will be my second time speaking at...
2019-12-27
31 reads
As a follow-up to my last blog, Azure Synapse Analytics & Power BI performance, I wanted to focus on concurrency when using these two products. A common question I...
2020-01-07 (first published: 2019-12-27)
803 reads
Hello everyone! This is your SQL Server Consultant in Austin, TX and due to some posts on twitter about SQL PASS recordings costing $999 I wanted to share some...
2019-12-27
19 reads
Hello everyone! This is your SQL Server Consultant in Austin, TX and due to some posts on twitter about SQL PASS recordings costing $999 I wanted to share some...
2019-12-27
158 reads
Christmas was this week so nothing technical today, just a simple blog post wishing you and your family blessings and good tidings during this holiday time. May the holidays...
2019-12-27
79 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. PowerShell is the hot new scripting language for...
2020-01-09 (first published: 2019-12-27)
4,754 reads
This is a very simple version of a Xmas tree using T-SQL, also is a good example to learn how recursive CTE works.So, if you are in front of...
2019-12-27
23 reads
This is a very simple version of a Xmas tree using T-SQL, also is a good example to learn how recursive CTE works.So, if you are in front of...
2019-12-27
286 reads
This article shows a method to audit for index changes. The weak link in a solution such as this really boils down to the requirement that the solution needs...
2019-12-26
28 reads
This article shows a method to audit for index changes. The weak link in a solution such as this really boils down to the requirement that the solution needs...
2019-12-26
59 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...
Komplek Ruko Roxy Mas, Jl. Kh Hasyim Ashari No.6 Blok C.5 No, RT.6/RW.8, Cideng,...
Jl. Gajah Mada No.203 205, RW.207, Benua Melayu Darat, Kec. Pontianak Sel., Kota Pontianak,...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
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