SQL Server – Calculating elapsed time from DATETIME
Elapsed time can be calculated from DATETIME field by extracting number of hours/minutes and seconds. You can use below query...
2013-12-31 (first published: 2013-12-23)
6,039 reads
Blog Posts
VMware vNUMA and SQL Server
Jonathan Kehayias (b | t ) posted a fantastic write up today on VMware’s vNUMA interactions when the operating system feature ‘CPU...
2013-12-31
1,221 reads
A New Year is Right Around the Corner
If you read my 2013 Year In Review you may be here today wondering why I haven’t posted anything despite...
2013-12-30
1,556 reads
Day 6 – Lost in Space
This is the sixth installment in the 12 day series for SQL tidbits during this holiday season.
Previous articles in this...
2013-12-30
1,203 reads
Day 6 – Lost in Space
This is the sixth installment in the 12 day series for SQL tidbits during this holiday season. Previous articles in this mini-series on quick tidbits: SQL Sat LV announcement...
2013-12-30
2 reads
Entity Data Modeling with Visual Studio
While there are a lot of tools out there for data modeling, there is one option that is free if...
2013-12-30 (first published: 2013-12-26)
13,057 reads
Final December Giveaway!
Today I'm giving away the book Professional SQL Server 2012 Internals and Troubleshooting. If you live outside the continental US,...
2013-12-30
504 reads
Installed SQL SERVER 2012? maybe you’d like to re-set your shortcuts!
TweetG’day,
Just a quick post on a seemingly trivial matter that others may find useful.
The post was prompted by the Simple-Talk...
2013-12-30
1,363 reads
Kissing 2013 Goodbye
The end of the year is here, which means it’s time to look back and review my goals and reflect...
2013-12-30
1,217 reads
Last Weeks Top “Reading” Links #64
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2013-12-30
1,175 reads
Blogs
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Forums
query to track time spent on individual tasks in SSIS
Hi everyone I am looking at building a query to determine how much time...
SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Hidden Heroes
Comments posted to this topic are about the item Hidden Heroes
Question of the Day
Identities and Sequences I
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers