I believe that the problem is twofold: Microsoft's erratic & short release schedule as well as Microsoft's eagerness to release half-baked features.

Because Microsoft's need to release a new version of...

Hardcoding as a sin is all well and good, but what do you do in the case of a date-from-date-to pair of columns? When all entries but the last date-to...

I used to do a lot of volunteering when I was a child but I have since lost that charitable spirit. I do have much less free time but I...

The Comments column is a new development and I'm not sure how it will be used. My guess is that it will be used as an explanation only when the...

Thanks for your comments everybody and thanks especially for the presentation on YouTube, Jeff. I have started watching it.

@Mr. Brian Gale: The tables are normalised. By 'lean', I mean the...

• This reply was modified 4 years, 5 months ago by sean redmond.

The CreateBy, CreatedDate, UpdateBy, Updatedate & Comment columns are rarely accessed. They are only ever of use when a customer has a complaint or if one of the DBAs got...

It is better to re-phrase that as: of the people on this forum, how many are DBAs to systems that their developers prefer to use Entity Framework on rather than...

Stored Procedures? How nice. A memory of a bygone era.

Our developers almost exclusively use Entity Framework and I'm sure (and I hope) that this has error-handling in it for them.

I...

We upgrade our version of SQL Server every 7 years or so. We went from SQL Server 2008 to 2016. Almost all of our servers are on SQL Server 2016...

SJ» Amazing that it's been around for 15 years and has moved into Extended support. We'll still get security updates, but nothing will be fixed.

You might want to correct the...

Microsoft is only interested in Azure now. It is the favoured child while on-premises software has been sent...

My colleague prefers the SSIS-method of getting CSV/Excel-data into SQL Server.

Personally, I prefer to use generate VALUES entries with Excel formulas. I even have a IF-Statement to check if the...

• This reply was modified 4 years, 8 months ago by sean redmond. Reason: Poops. Big omission in my second formula

Thanks for this Steve & pailwriter.

This will keep me occupied for a while.

• This reply was modified 4 years, 8 months ago by sean redmond.

Does anyone have a good book/website to recommend learning Linux as a beginner? If so, what is it?

Oh, for the days when developers wrote in SQL!

Ours do it in Entity Framework and when a slow page needs debugging, there is 600 lines of [Entity1] to sift through...