2014-11-11
510 reads
Power Testing ETL with Power BI – The Process
This is a short blog series on using Power BI tools to support testing ETL processes. I have presented on...
2014-11-11
1,297 reads
T-SQL Tuesday #60 – Something New Learned
It’s been five years, and that’s amazing. Not many things last for a year, much less five, but the T-SQL...
2014-11-11
916 reads
I’m Still Not on the Board
I’m just back from the PASS Summit 2014. What a great event. But this year, it was a little different....
2014-11-11
704 reads
Join me in DC for a full day of Biml
I’m excited to announce that my Linchpin People colleague Reeves Smith and I will be delivering a full day Biml...
2014-11-11
620 reads
T-SQL Tuesday #60 Something New Learned
So, here it is. I put the challenge out to discuss something new learned last week. I was fortunate enough...
2014-11-11
614 reads
TSQL Tuesday #60: Something New Learned – What permissions does have?
What have I learned recently? Well as it happens I learned something rather interesting recently and was actually trying to...
2014-11-11
1,674 reads
How To Use the Unpivot Transform in SSIS
Moving data from columns to rows can be a tricky task and accomplished in a variety of ways. That may be...
2014-11-17 (first published: 2014-11-11)
8,036 reads
PASS Summit 2014 – It’s not you, it’s me
After an exciting week at the PASS Summit, I’m back home with my family. This was my first ever PASS...
2014-11-11
616 reads
Consuming the Output of an SSIS Package in a Client Application
Typically, making the output of an SSIS Package available to a client application for further processing is achieved by outputting...
2014-11-11
4,874 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