Speaker of the Month: May 2015
When I attend sessions at events, I try to mix it up. I’ll go to a session that, really, I...
2015-06-09
531 reads
T-SQL Tuesday #67 – Extended Events for DBCC
It’s the second Tuesday of the month and time for another T-SQL Tuesday. This time it’s #67 from Jes Borland...
2015-06-19 (first published: 2015-06-09)
1,941 reads
SQL Saturday Albany (#sqlsat386) – Look Who’s Speaking!
So on June 3rd I got this email from Edward Pollack.
I had submitted a few weeks earlier and had been...
2015-06-09
750 reads
A walk-through of creating the Activity Tracking template using Extended Events.
It’s the second Tuesday of the month and that means T-SQL Tuesday time! T-SQL Tuesday is a blog party started...
2015-06-15 (first published: 2015-06-09)
2,339 reads
Talking TypeScript on the .NET Rocks! Podcast
I appeared on the .NET Rocks podcast show #1149 this week. I had a blast talking about TypeScript, the new...
2015-06-09
811 reads
Columnstore Indexes – part 55 (“New Architecture Elements in SQL Server 2016”)
Continuation from the previous 54 parts, the whole series can be found at http://www.nikoport.com/columnstore/
The architectural changes in the upcoming SQL...
2015-06-08
617 reads
Installing and upgrading default scripts automation – part one – Introduction
First I must say thank you to all of the wonderful people who have put time and effort into providing...
2015-06-16 (first published: 2015-06-08)
1,766 reads
Sysmail_help_profileaccount_sp – SQL Server Database Mail Stored Procedure – Part 8
Hi folks, in our previous blog of SQL Server Database Mail stored procedure we added database mail account to database...
2015-06-08
420 reads
SQL Server 2016 features to look for -2
In Previous post we have seen the new features of SQL server 2016 in short and had a brief discussion...
2015-06-11 (first published: 2015-06-08)
4,977 reads
Behavior of ORDER BY + UNION Can Be Confusing
This is an interesting example and it exposes a quirk with the concept of a UNION, which is, that the...
2015-06-10 (first published: 2015-06-08)
3,433 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