A tSQLt Mistake – Debugging a Test
While I was working on a test the other day, it kept failing. Not a big surprise, but I couldn’t...
2015-10-12
446 reads
A tSQLt Mistake – Debugging a Test
While I was working on a test the other day, it kept failing. Not a big surprise, but I couldn’t...
2015-10-12
753 reads
Attending PASS Summit? Take a great Tuesday precon!
We’re just two weeks away from the PASS Summit in Seattle, and there is most definitely still time to get...
2015-10-12
618 reads
Argenis Without Borders: Fun For a Good Cause
This is the second year of Argenis Without Borders and the second year that I’m taking part. Last year we...
2015-10-12
527 reads
Thank You for Attending my #SQLSatOrlando Session! Slides, Resources, Recording
SQL Saturday #442 in Orlando, FL has come and gone but what a turn out! The event was excellent, we...
2015-10-12
479 reads
Simplified Session Backups
I have demonstrated how to backup a deployed session to a script previously. In this article I demonstrate how to create Simplified Session Backups.
Related Posts:
PowerShell to Backup XE Session...
2015-10-12
13 reads
Simplified Session Backups
PowerShell exposes scads of information and provides the professional with a formidable tool for the tool-belt. Over the past several...
2015-10-12
490 reads
How to create a database on a network share
If for any reason you need to place the database on a network share and by default this option is off you can follow the way described below: A...
2015-10-12
44 reads
How to create a database on a network share
If for any reason you need to place the database on a network share and by default this option is off you can follow the way described below: A...
2015-10-12
44 reads
How to create a database on a network share
If for any reason you need to place the database on a network share and by default this option is...
2015-10-12
1,415 reads
Blogs
A New Word: Semaphorism
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
SQL Server Linux Container Images Got Smaller: Image Size and Startup Time Across Cumulative Updates
This week I was at PASS Data Community Summit in Seattle, and I attended...
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan BCA KCP Mahendradata Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Mahendradatta Selatan No. 99 AX, Padangsambian, Kec. Denpasar Bar., Kota Denpasar, Bali...
Alamat Telp BCA KCP Sesetan Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Raya Sesetan No.301, Sesetan, Denpasar Selatan, Kota Denpasar, Bali 80223
Question of the Day
Adding Bits I
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