If you know there are better practices you should follow, then take the few extra moments to implement them. If you don't know of good practices, start compiling a list,...

• This reply was modified 4 years, 7 months ago by will 58232.

Thanks Jeff

That and control characters 28 thru 31.

I'm writing them how I would decode them in JavaScript -

Row split:

data.split("\u001e")

column split:

data.split("\u001f")

It is possible to define a whole set of JavaScript functions...

• This reply was modified 4 years, 7 months ago by will 58232.
• This reply was modified 4 years, 7 months ago by will 58232.
• This reply was modified 4 years, 7 months ago by will 58232.
• This reply was modified 4 years, 7 months ago by will 58232.
• This reply was modified 4 years, 7 months ago by will 58232.

With the proliferation of file formats, perhaps it is time to revisit the delimited file and how its problems can be overcome.

CSV stands for comma separated values. As we know...

For a sceptical and very knowledgeable view of the current state of AI and robotics I can recommend Rodney Brooks' blog

https://rodneybrooks.com/predictions-scorecard-2021-january-01/

Brooks was the director of the AI lab at MIT...

David.Poole

Graph databases are ones where I feel there is a lot of potential but now we have graph capabilities in SQL Server. I think we need some really good examples...

a relational store is likely better

It is important to remind everyone that a relational DBMS is not a way of "storing" data. The relational model provides a logical interface to...

Dr Codd described a relation in a way that described what we think of as a record or tuple

A relation (in the relational model) is more equivalent to a table...

Although ERD are typically used to visualize relational models, it could also apply to multi-dimensional and other models, so long as you have a more flexible definition of what an...

Despite the apparent complexity at the mathematical level

The mathematical level is much simpler than SQL. The mathematical definition of a function is much simpler than the programming language definition -...

any restrictions on the level of temporal resolution

Is there ever a business case for having the time expressed down to microseconds? I recommend reading Flash Boys - A Wall Street...

• This reply was modified 4 years, 8 months ago by will 58232.

It just because data is related to other data.

Codd called his invention relational because it is based on the mathematical construct of a relation. This represents a relation between sets....

• This reply was modified 4 years, 8 months ago by will 58232.
• This reply was modified 4 years, 8 months ago by will 58232.
• This reply was modified 4 years, 8 months ago by will 58232.
• This reply was modified 4 years, 8 months ago by will 58232.

Anyone yet to take me up on explaining why a relational DBMS is called "relational"? It's a pretty fundamental question for a DBA.

CURRENT_TIMESTAMP is an ISO Standard supported by Oracle and DB2 so that's not an excuse.

Which would explain why they don't know about getdate() - thanks by the way, I prefer...

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 to...

Ask them about real situations or problems. See if they teach you anything or approach a problem in a better way. See if they bother to ask me for more...