A big issue when try to Alter user define table type structure TIP #108
I hope all of you aware of User define table type (a table value parameter) which we discussed earlier in...
2015-08-08
1,365 reads
HealthySQL – A Review
A quick look into the book by Robert Pearl: Healthy SQL.
Related Posts:
My Book Contributions November 30, 2018
Profiler for Extended Events: Quick Settings March 5, 2018
How to be...
2015-08-07
19 reads
HealthySQL – A Review
How well do you know the health of your SQL Servers and databases? Ever wonder about the current health or...
2015-08-14 (first published: 2015-08-07)
2,247 reads
SQL Sentry Grows in the UK and Beyond
Announcing two new UK-based SQL Sentry global technology evangelists. Please help me welcome John Martin and Richard Douglas.
The post SQL Sentry Grows in the UK and Beyond appeared first...
2015-08-07
34 reads
Another Career Podcast – Working at Microsoft
I have to admit, I had a lot of fun at SQL Saturday in Philly this last June; I mean...
2015-08-07
517 reads
Twitter Analysis with #PowerBI & Plus One
Earlier this week Christopher Finlan put together this awesome Datazen dashboard using Plus One. Christopher has been doing a lot...
2015-08-07
727 reads
Career Progression
Deciding to change jobs can be one of the most difficult decisions you can make. At Dell I was part...
2015-08-07
515 reads
SSDT-BI and Visual Studio Online
Recently I had to create a new business intelligence project at a client. However, there was no source control present....
2015-08-07
2,566 reads
Speaking at SQLSaturday Omaha
In just one week, I’ll be traveling west to Omaha to speak at SQLSaturday there. It’s been a while since...
2015-08-07
410 reads
SET NOEXEC is my new friend
Have never really played around with the option: SET NOEXEC ON
Turns out this can be a helpful way to validate...
2015-08-07
3,632 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