Viewing 15 posts - 1 through 15 (of 219 total)
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...
September 21, 2021 at 2:58 pm
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...
September 21, 2021 at 2:30 pm
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...
September 20, 2021 at 2:36 pm
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...
August 23, 2021 at 1:26 pm
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.
August 23, 2021 at 7:12 am
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...
July 23, 2021 at 12:56 pm
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...
July 23, 2021 at 6:52 am
Hence why I wrote this. Maybe someeone at MS will pay attention
Microsoft is only interested in Azure now. It is the favoured child while on-premises software has been sent...
July 14, 2021 at 3:06 pm
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...
July 14, 2021 at 8:24 am
Thanks for this Steve & pailwriter.
This will keep me occupied for a while.
July 13, 2021 at 4:51 am
Does anyone have a good book/website to recommend learning Linux as a beginner? If so, what is it?
July 12, 2021 at 7:12 am
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...
May 17, 2021 at 5:25 am
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...
May 12, 2021 at 7:30 am
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...
May 10, 2021 at 6:15 am
Thanks for this, Grant. Given the push that Microsoft has made with Office 365, it seemed suddenly obvious that SQL Server was next.
April 22, 2021 at 11:26 am