How to Become a SQL Server Database Administrator
I wrote How to Become a SQL Server Database Administrator (email address required for download) a few years ago as a project...
2017-04-03
538 reads
I wrote How to Become a SQL Server Database Administrator (email address required for download) a few years ago as a project...
2017-04-03
538 reads
I have spent a fair amount of time researching the Olcot and Arratoon ancestry and I am very interested in the family tree, especially pre 1900 in India. If...
2017-04-03
41 reads
I am glad to announce thatTuga IT 2017 Tickets are finally on sale!
Wait a second, you might think – on sale?...
2017-04-03
347 reads
Last week Pass announced changes to how speakers are going to be selected for their annual conference (you can read...
2017-04-03
145 reads
Last week Pass announced changes to how speakers are going to be selected for their annual conference (you can read...
2017-04-03
284 reads
If you are attending this year’s SQL Nexus conference in Copenhagen, Denmark, from May 1st to 3rd this year, I...
2017-04-03
431 reads
I recently had a requirement to remove the last Carriage Return <CR> and Line Feed <LF> characters when outputting a...
2017-04-02
3,832 reads
Yip. You can.
I was originally going to write this post about tuning tempDB in our Azure SQL database. Which would...
2017-04-02
397 reads
Continuation from the previous 100 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blogpost will focus on warning you...
2017-04-01
410 reads
A quick video clip where I show two things. Firstly I show how since SQL Server 2014 SP1+ the snapshot...
2017-04-01
384 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Pay for Performance, which is...
Telp/Wa 62817825533 Jl. Brigjen Jl. Slamet Riyadi No.3, Kauman, Kec. Ps. Kliwon, Kota Surakarta,...
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