AKAWN

We’re a bit sports crazy here at AKAWN. There is nothing quite like the roller coaster of emotions that it delivers.

#BringTheCupHomeBoys

Here at AKAWN we’ve been busy working on our first application which we hope to release later this year.
 
Having purely been focused on SQL Server architecture, administration and consulting, it has been a real eye opener into the effort required to produce an application.
 
So to all those developers out there a big thanks for your efforts, you guys rock.
 
This post got a bit side tracked :) it was meant to advise that .NET Framework 4.7 is available on Windows Update, WSUS, and MU Catalog.

Wow, you never really grasp the meaning of plagiarism until it happens to you.
 
Recently a couple of AKAWN blog articles have appeared on a popular SQL Server website. The person has tweaked the wording and images but it is clearly a copy.
 
Copying other people’s work and passing it off as your own is NOT cool.
 
If this person, who I assume follows this blog, does it again, I won’t hesitate to out them. You’d think a MVP would know better.
 
As an absolute minimum, a reference should be made to the source of your content when using another person’s work.

When working with dates/times it can sometimes get a bit confusing when abbreviation options are introduced e.g. abbreviations may pad 0’s,use 24hr (HH) vs 12hr (hh) etc.
 
This post is simply a confirmation that abbreviations in datediff and datepart do return the same value.

DECLARE   @starts datetime = '2017-06-12 19:00:05'
		, @ends datetime = '2017-06-12 19:00:07';

SELECT    DATEDIFF(ss,@starts,@ends) AS diff_ss
		, DATEDIFF(s,@starts,@ends) AS diff_s
		, DATEPART(ss,@starts) AS part_ss	
		, DATEPART(s,@starts) AS part_s;