The cynical answer is that Atlassian is gently encouraging people to use their cloud services instead of on prem.

I've not designed this thing. I am nowhere near an SQL-expert either, but I do think this world is interesting and am trying to learn, that's why I'm in...

When you say adhob SQL do you mean that users can just free form write their own SQL to put into the reports or that this is SQL being generated...

I guess I don't understand two things...

1. Why you would ever want the documentation to be separate from the database.
2. Why on Earth you would want the result to...

If it would be OK to force the NULL value to be added to lowest date:

;WITH test_data AS (
    SELECT col1 = 7213
...

would you actually want to hire someone that claims to know T-SQL if you ask them how to get the current date and time using T-SQL and they HAVE...

 Developers routinely look to the DBA for advice about data modeling (often times after it's been deployed to production), but I don't get questions on the job about...

Hi Jeff,

By chance, do you have an example that I can take a look at in the script task calling the .exe file and pass and return the variable...

My basic trouble with hackathons in a company is... why do they actually need one to begin with?  It seems like that's an admission that they don't...

If you calculate the unix millisecond timestamp 30 minutes ago all you should need to do is look for time stamps greater than that.

For millisecond precision it would be something like,

SELECT DATEDIFF_BIG(ms, '19700101' ,DATEADD(minute, -30, getdate()))

I have a general issue with the idea that innovation comes from sitting people down cracking a whip and asking them to innovate.  Maybe some people can work like that...

Well SQL Server still has to access the table to do the inserts which is IO.

Hmm... that's nifty you can also do the other error action options like Inquire if you want a prompt when it hits the debug.

Technically you...