Worst Day As A DBA
I remember the day pretty vividly, it was in the summer months and I was as green as green can...
2014-06-26
446 reads
Why Is your datetime saved as a bigint anyway?
Yet another issue I had never seen before - thankfully this time I was able to find a relatively quick answer.
On...
2014-06-26
741 reads
T-SQL Window Functions – Part 1: The OVER() Clause
This is a reprint with some revisions of a series I originally published on LessThanDot. You can find the links...
2014-06-26
2,756 reads
It's not Business, It's Personal
Hello Dear Reader. I find myself at this late hour unable to sleep. Yesterday the slate of speakers for the...
2014-06-26
883 reads
Finding the last successful CHECKDB
One very important part of your SQL Server maintenance procedure should be running consistency checks on a regular basis using...
2014-06-26
3,267 reads
Finding the last successful CHECKDB
One very important part of your SQL Server maintenance procedure should be running consistency checks on a regular basis using...
2014-06-26
443 reads
Passion
I know I tend to be overly passionate. It’s something that has gotten me into trouble in the past. It’s...
2014-06-26
862 reads
PASS Summit – What Does It Mean To Me?
PASS Summit – what does it mean to me? So listen, I’m not perfect. I will never claim to be and...
2014-06-26
409 reads
SQL Server 2014 – How to add features to existing instance ?
SQL Server 2014 – How to add features to existing instance ? :-
1) Start installation center
2) Run Global Rule, You need to...
2014-06-26
13,454 reads
SSIS Parent-Child Architecture in Package Deployment Mode
This is the second in a series of posts about SSIS parent-child architecture. You can find the index page here.
In...
2014-06-26
6,191 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