2014 Tribal Awards Are Open
Yesterday morning I opened my email and was very pleased to find that I have been nominated for the 2014 Tribal...
2014-12-17
405 reads
Building Your First Windows Azure Machine
Recently, I had the pleasure of writing another article that was included the Notes From the Field series that is hosted...
2014-12-17
579 reads
Outlier Detection with SQL Server, part 3.2: GESD
By Steve Bolton
…………In the last edition of this amateur series of self-tutorials on finding outlying values in SQL Server columns,...
2014-12-22 (first published: 2014-12-17)
6,626 reads
Playing with the log – VLF order while growing the log
The log file is one of those parts of SQL Server I find fascinating. For instance it is composed of...
2014-12-23 (first published: 2014-12-17)
5,853 reads
SQLSaturday Portugal 2015 – Above & Beyond
At the same day, 4 years ago me & my team were already in the process of organising the very first...
2014-12-17
447 reads
Azure Columnstore, part 2 – Snapshot Isolation & Batch Mode DOP
Welcome to the 2nd blog post in the Azure Columnstore series, as previously mentioned in the Azure Columnstore, part 1...
2014-12-16
665 reads
‘Twas 4:45 Friday
‘Twas 4:45 Friday, and all through the office
not a creature was stirring, not even the bosses.
The code was checked in,...
2014-12-25 (first published: 2014-12-16)
5,360 reads
Load Balanced IIS Machines
I noticed a contest this week while working on the Database Weekly newsletter. It’s the Cloud Hero contest, with the...
2014-12-16
731 reads
WordPress, Project NAMI, and Azure
I’ve been running WordPress for years now and find it to be a solid solution for what I want to...
2014-12-24 (first published: 2014-12-16)
6,395 reads
ROW_NUMBER SQL Server
Row_Number SQL Server
SQL Server includes several Ranking Functions that can be called in T-SQL. One of these is the Row_Number()...
2014-12-22 (first published: 2014-12-16)
8,865 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 Rembang Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Pemuda No.3 C, Tawangsari, Leteh, Kec. Rembang, Kabupaten Rembang, Jawa Tengah 59217
Layanan BCA KCP Blora Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Pemuda No.57B, Blora, Tempelan, Kec. Blora, Kabupaten Blora, Jawa Tengah 58211
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