This post is to answer the question: “You are used to seeing in the format of yyyy-MM-dd right?” that I have raised on my blog post Don’t cutoff yourself with dates in T-SQL – Did you know… .
As you could see from that blog post, my screen shots were from VSCode and in this case using mssql extension, but this happens also on SQL Server Operations Studio .
“But why are my datetimeoffset values on VSCode being showed in that format?
This month’s T-SQL Tuesday is brought by Steve Jones ( b | t ) and he wants to know if triggers causes headaches or happiness to us.
This is the 106nd edition of TSQL2sDay - an Adam Machanic ( b | t ) brainchild.
Triggers are those kind of database objects that sometimes are the best bet but most of the times they will strike back.
“Why?” - You may ask.
On 29th September we will have SQL Saturday Porto and I’m proud to announce that I will be speaking!
I will be speaking about dbachecks PowerShell module - dbachecks - Checking SQL Server environments with PowerShell .
The event will be held at ISEP, Rua Dr. António Bernardino de Almeida, 431, 4249-015 Porto, Portugal and you can see the full schedule here .
Register , it’s free!
Hope to see you in Porto!
Almost all the applications we use have a lot of options. And, sometimes we even stumble across them by accident. Who’s ever heard something like “Normal user don’t even use 5% of Excel capabilities!”?
Other options, we know they exist but because the default value it’s ok (so far) we tend to forget it. It is just sitting there, waiting for the day we want/need to change it.
The oddity Few days ago I was talking with a friend that show me some “odd behavior” when working with dates on SQL Server.
I’m working on a project where I need to convert Firebird SQL code into T-SQL code. No schema, just the modules. There are more than 1000 objects between stored procedures, views, triggers, user-defined data types, etc.
First - the pain… While checking the Firebird reference manuals I saw a lot of different concepts (Selectable Stored Procedures - Yes you can do SELECT FROM StoredProcedure) and different functions names with different syntax compared to T-SQL.