PASS Election Questions Answered
As we continue through the campaign period for this year’s PASS Board of Directors Election (Voting opens tomorrow morning), I...
2015-09-16
521 reads
PASS Summit Precon – The Complete Primer to SQL Server Virtualization – UPDATE
I am very pleased to announce that Argenis Fernandez, (now including)Jimmy May, and I will be presenting a new precon...
2015-09-16
575 reads
SQL Prompt 7 by RedGate
RedGate unleashed their newest version of SQL Prompt recently. It is no secret to those of you who know me...
2015-09-16
300 reads
SQL Prompt 7 by RedGate
RedGate unleashed their newest version of SQL Prompt recently. It is no secret to those of you who know me...
2015-09-16
2,185 reads
Storing Event Data
Among the several core concepts of Extended Events is the concept of storing event payloads / data.
Related Posts:
How to: File Target use in Extended Events December 27, 2018
Dynamics...
2015-09-16
10 reads
Storing Event Data
Among the several core concepts of Extended Events is the concept of storing event payloads / data. When an event fires, it...
2015-09-16
797 reads
Ryan Adams For PASS 2016-2018 Board
Ladies and Gentlemen, I would love to announce my support for Ryan Adams running for the PASS Board in 2016-2018....
2015-09-16
499 reads
Using @@ROWCOUNT can be a bit tricky
@@ROWCOUNT is a very useful system variable that returns the number of rows read/affected by the previous statement. It’s frequently...
2015-09-16
746 reads
The Trouble with Rules
I love running. I wake up at 5am three times a week, run for an hour, and by 6:30am I’m...
2015-09-16
598 reads
Columnstore Indexes – part 66 (“More Clustered Columnstore Improvements in SQL Server 2016”)
Continuation from the previous 65 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Continuing writing about the improvements added to...
2015-09-15
544 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...
Helping an English Student with R
Comments posted to this topic are about the item Helping an English Student with...
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