Creating Time Calculations in Power BI
One of the current issues in Power BI is the inability to specify a Date table. The Date table is...
2015-09-15
945 reads
Blog Posts
Custom Placeholders in SQL Prompt 7
I love my snippets in SQL Prompt. Adding some snippets can make work go so much quicker. I add new...
2015-09-15
1,180 reads
Extended Events Objects
So far, I have talked about some of the metadata associated with Extended Events. But I have not yet started...
2015-09-15 (first published: 2015-09-08)
1,934 reads
Free SQL Training in Seattle
Free Training in Seattle!
Related Posts:
Seattle SQL Pro Workshop 2017 October 19, 2017
Seattle SQL Pro Workshop 2017 Schedule October 26, 2017
T-SQL Tuesday 109: Influence Somebody Invite December 4,...
2015-09-15
10 reads
Free SQL Training in Seattle
The annual SQL Server Professional migration is about to begin. Many of us will be descending upon the city of...
2015-09-15
683 reads
Hekaton Part 7 - Hash Collisions & Hash Buckets
As explained in the earlier post, a hash index places pointers to the rows in hash buckets, depending upon the value returned...
2015-09-15
708 reads
Load Testing Your Storage Subsystem with Diskspd
One of the primary activities I do before bringing SQL Server into production is load testing the storage subsystem. On a new system this is critical because I want...
2015-09-15
25 reads
Load Testing Your Storage Subsystem with Diskspd
One of the primary activities I do before bringing SQL Server into production is load testing the storage subsystem. On...
2015-09-15
2,860 reads
MDS 2016 CTP 2.3: tiles greyed out in Manager
I’m toying around with MDS 2016 CTP 2.3 in preparation of my SQLServerDays session about what is new for BI...
2015-09-15
829 reads
PASS Election Changes
The 2014 NomCom made some changes to how the election process works and it’s something you need to pay attention...
2015-09-15
527 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