Some SQL Server Date and Time Examples
I had a question from a developer yesterday about how to calculate the difference between local time (on the database...
2010-05-06
1,507 reads
Blog Posts
SQL Saturday #49 – Call for Speakers
SQL Saturday #49 in Orlando just opened their call for speakers. I’m debating if I want to go out there....
2010-05-06
886 reads
Team Foundation Server 2010 and Visual Studio 2008
We recently decided to use Team Foundation Server as our source control and, really, project management system. This decision was...
2010-05-06
478 reads
Viewing the results before and after, during Update
DBAs & Developers using everyday UPDATE statement, and everytime before update they want to see what to update, after this they...
2010-05-06
3,491 reads
Where Do I Start with PowerShell?
This morning I set out to get some information about getting started in PowerShell for a coworker. Rather than spend a bunch of time searching for different sites I...
2010-05-06
4 reads
Where Do I Start with PowerShell?
This morning I set out to get some information about getting started in PowerShell for a coworker. Rather than spend a bunch of time searching for different sites I...
2010-05-06
3 reads
Where Do I Start with PowerShell?
Introduction
This morning I set out to get some information about getting started in PowerShell for a coworker. Rather than spend...
2010-05-06
3,216 reads
American Express PASS Card (Not What You Think)
Had logged in to American Express check my business account and noticed this on on the front page – a PASS...
2010-05-05
580 reads
Getting a Page of Results
The other day I was looking over a couple of articles on paging, looking to see if I could learn...
2010-05-05
408 reads
New SQL Server Standard: Resource Governor by Roy Ernest
The latest issue of the SQL Server Standard is available for download (login required, free registration). Volume 7 Issue 4...
2010-05-05
735 reads
Blogs
Visualising Vectors in High Dimensional Space
Following on from my previous post on building The Burrito Bot, I want to...
The Intersection Between DevOps and FinOps
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers