DBMail on a cluster
I’ve always found clusters a pain in the neck. For my latest pain I just spent the last 2 days...
2012-09-26
641 reads
Blog Posts
Excel 2013 – Trouble Installing Silverlight for Power View
Last week during my 24 Hours of PASS session on Choosing a Reporting Platform I fielded a question that appeared...
2012-09-26
1,301 reads
How BETWEEN is inclusive
This is a old and simple one, but an important subtlety that TSQL developers must be aware of.
Using the BETWEEN...
2012-09-26
2,768 reads
Interviewing a DBA
I’m not a fan of trivia style interview questions. Yes, I ask a few because you have to in order...
2012-09-26 (first published: 2012-09-24)
3,358 reads
Log File Full–Availability Group Database
I run into an interesting issue with an Availability Group database recently. I was running a data load against a...
2012-09-26
5,013 reads
One More Reason for Portable Applications
I bet most of us don’t think about installing software that we need/want to try. We’re either running as local...
2012-09-26
828 reads
OVER() clause two simple ways on two different days
I’ve been aware of this clause in TSQL for a long time, but I’ve never really used it. Mainly because...
2012-09-26
1,106 reads
Participate in the PASS Election Process
Once again it is time for the Professional Association for SQL Server (PASS) Board of Directors election. This year there...
2012-09-26
1,072 reads
Running a document database on Sql Server
Running a document database on Sql Server.
Since Microsoft is slow to come out with a product of their own to...
2012-09-26
14,773 reads
SP_HELPTEXT showing old Store Procedure name after rename, is it a Bug?
Question : Today morning, I received a call from one of my old friend, with an query for SQL Server. He...
2012-09-26
1,441 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