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 3 years, 4 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 3 years, 4 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...

SQL Server 2008 is out of support now (which was the reason we upgraded all of our SQL Servers) but your question is valid for SQL Server 2016.

For a few...

Hi Grant,

I have two central mottos (motti?) 'Always be learning' & 'Know something about everything and everything about something'. The problem for me is the direction: broaden the base or...

• This reply was modified 3 years, 6 months ago by  sean redmond.

Thanks for this, Grant. Given the push that Microsoft has made with Office 365, it seemed suddenly obvious that SQL Server was next.

My heart fell when you said that you threw the old floppies. They are a part of a younger you that got you started down this road. Secondly, there are...

There are two primary problems with software today:

1. Full-Stack Developer: everywhere full-stack developers are sought. No-one seems to think that the full-stack developers are commonly jack-of-all-trades and masters of none....

For small operations, that is, fewer than 5 people using it concurrently, Access (or FileMaker Pro) is excellent. It's relatively cheap and easy for someone with some experience to set...