Women in technology
Earlier this week a friend of mine (Lynn Swayze (Hall) (b/t)) posted this great article on women in technology. It’s...
2015-11-25
636 reads
Blog Posts
Changing case of T-SQL Keywords
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5… Bert likes his T-SQL keywords in UPPERCASE, Ernie likes his in lowercase which causes...
2015-11-24
54 reads
Changing case of T-SQL Keywords
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5… Bert likes his T-SQL keywords in UPPERCASE, Ernie likes his in lowercase which causes some internal struggle as it is actually one person...
2015-11-24
15 reads
Changing case of T-SQL Keywords
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5… Bert likes his T-SQL keywords in UPPERCASE, Ernie likes his in lowercase which causes...
2015-11-24
61 reads
Database Mirroring Error 1418
Database Mirroring Error 1418
Hello Everyone.
This post will be helpful in resolving the error 1418 that we may come across when...
2015-11-24
2,813 reads
Identity Column Increment Value (EVEN/ODD)
As always I’m sitting at my desk, minding my own business, when an email comes in from a developer.
“Hey DBA’s,...
2015-11-24 (first published: 2015-11-18)
4,893 reads
In-Memory OLTP in SQL 2016
With SQL server 2016 around the corner, I would like to share some of my thought on the usage for...
2015-11-24
752 reads
Quickly deploying procedure/functions from SSDT (Bypass Publish)
SSDT is great but one thing that is not so great is the performance of the publish. I am not...
2015-11-24
58 reads
Quickly deploying procedure/functions from SSDT (Bypass Publish)
SSDT is great but one thing that is not so great is the performance of the publish. I am not...
2015-11-24
27 reads
Quickly deploying procedure/functions from SSDT (Bypass Publish)
SSDT is great but one thing that is not so great is the performance of the publish. I am not...
2015-11-24
58 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