#TSQL2Day – A Day in the Life of A Service DBA
Today I am excited to join in with my #sqlfamily and participate in this months #tsql2day throw down. This month Erin...
2012-07-18
459 reads
Where in the World is…
You may or may not have noticed that over the past several months I have been somewhat absent from my blog. Very few articles if any have been produced....
2012-07-18
14 reads
Where in the World is…
You may or may not have noticed that over the past several months I have been somewhat absent from my...
2012-07-18
944 reads
What’s been happening in Wayne’s World
Late last year, my life got strange. Well, it’s always been strange, so let’s just say it became stranger than...
2012-07-18
753 reads
Enabling "Open Project Folder" for project types that don't support it
One annoying thing about SSIS (2008) and some of the other project types in Visual Studio is the lack of...
2012-07-18
773 reads
The Hollywood DBA
I’m delighted to welcome a fellow Brit to the blog to share their story in today’s guest post. Many of you will...
2012-07-18
1,036 reads
SQL Saturday #171 Pittsburgh!
It's official, there's going to be a SQL Saturday in Pittsburgh this year!
The date is October 6th, and the...
2012-07-18
621 reads
Windows Cluster : Understanding the Quorum settings
In my earlier post, I have explained about the windows cluster and how Sql server works on cluster environment. In...
2012-07-18
4,022 reads
Excel 2013 Will Impact BI Users
As noted in that great text, The Hitchhiker’s Guide to the Galaxy, “Don’t panic!” Excel 2013 will make even more...
2012-07-17
825 reads
Puzzling TVFunctions
I had the opportunity to tune a highly-used function the other day, and was most puzzled by the difference between...
2012-07-17
922 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