Forum Replies Created

Viewing 15 posts - 1 through 15 (of 219 total)

  • Reply To: Metadata-Data-Ratio in a table

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

  • Reply To: Metadata-Data-Ratio in a table

    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 5 days, 4 hours ago by  sean redmond.
  • Reply To: Metadata-Data-Ratio in a table

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

  • Reply To: A Lack of Error Handling

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

  • Reply To: A Lack of Error Handling

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

  • Reply To: How Often Do You Patch?

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

  • Reply To: How Often Do You Patch?

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

  • Reply To: Importing a CSV into SQL Server Shouldn't Be This Hard

    Steve Jones - SSC Editor wrote:

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

  • Reply To: Importing a CSV into SQL Server Shouldn't Be This Hard

    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 2 months, 2 weeks ago by  sean redmond. Reason: Poops. Big omission in my second formula
  • Reply To: Do We Need to Learn Linux?

    Thanks for this Steve & pailwriter.

    This will keep me occupied for a while.

    • This reply was modified 2 months, 2 weeks ago by  sean redmond.
  • Reply To: Do We Need to Learn Linux?

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

  • Reply To: What counts for a DBA: Foresight

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

  • Reply To: Non-Stop Learning

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

  • Reply To: Non-Stop Learning

    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 4 months, 2 weeks ago by  sean redmond.
  • Reply To: Future of SQL Server

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

     

Viewing 15 posts - 1 through 15 (of 219 total)