Thoughts on the 2015 PASS Election
We had a decent election this year. Thanks to all four candidates – Argenis Fernandez, Jen Stirrup, Ryan Adams, and Tim...
2015-09-25
682 reads
Blog Posts
Assembling a Session
With the core concepts in place as a good foundation to Extended Events, we start pushing these things together to help with assembling a session in Extended Events.
Related Posts:
Short...
2015-09-24
12 reads
Assembling a Session
Up to this point, I have taken a lot of time to discuss the various components of Extended Events. There is...
2015-09-24
561 reads
Database Mirroring Isn’t Going Anywhere
AlwaysOn Availability Groups is a great technology that centralizes the management of High Availability, Disaster Recovery and Scale-Out. However, in...
2015-09-24
1,341 reads
Excel as a Database Professional
People ask me all the time how to become a DBA. This is a topic that so many colleagues of
mine...
2015-09-24
2,164 reads
HammerDB Performance Collection with SQL Server – Updated
A while back, my friend Mike Fal ( b | t ) released a PowerShell script that can sample the counter inside SQL...
2015-09-24 (first published: 2015-09-13)
2,419 reads
How to use SORT control in SSIS ? TIP #115
Dear Friends,
In the series ofLearn SSIS step by step this is the 5th post. Now from this post we are...
2015-09-24 (first published: 2015-09-12)
2,315 reads
I Was Once a Very Crappy Carpenter + SQL Bolts to Buzzwords
Tonight I spoke to Dr. Alkadi's CMPS 411 class, which was hijacked by the Hammond .NET User Group onsite at...
2015-09-24
675 reads
SQL Server Enterprise Edition Advanced Scanning
It is widely known that SQL Server Enterprise Edition contains a range of improvements, which under certain conditions allow you...
2015-09-24
1,618 reads
SQL Server Enterprise Edition Advanced Scanning
It is widely known that SQL Server Enterprise Edition contains a range of improvements, which under certain conditions allow you to perform operations in a more optimal way in...
2015-09-24
15 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