Forum Replies Created

Viewing 15 posts - 181 through 195 (of 380 total)

  • RE: Avoiding Stored Procedures

    xsevensinzx (9/1/2016)


    At what point do you stop and launch? When is done, done?

    Don't get me wrong. I'm not saying that we need to spend lots of time in planning...

  • RE: Avoiding Stored Procedures

    chrisn-585491 (9/1/2016)


    Design choices that impact the database matter.

    I totally agree. As a data architect, I get frustrated when development managers are only concerned with right now and eschew data...

  • RE: Avoiding Stored Procedures

    Ralph Hightower (8/30/2016)


    Switching the patient lookup to a stored procedure increased the performance of that phase of the application by 25%.

    Ralph, it's all in how the stored procedure was written...

  • RE: Avoiding Stored Procedures

    One of the issues I've found with ORM frameworks is that it trains one into a particular way of thinking. For example, I worked on a project that was...

  • RE: Up, Up, and Away

    Have a safe, enjoyable trip Steve and I hope to run into you at Summit! 😎

  • RE: An object lesson about what is really important

    RonKyle (8/11/2016)


    I would tell my kids that "Family comes first, but not always." There would be times in life where work temporarily came first. Had it remained permanently...

  • RE: An object lesson about what is really important

    Good reminder Ben. I had to learn a long time ago that you work to live, not live to work. If your life is out of balance, so...

  • RE: Complex View Inserts

    This highlights the issues of confusing views with tables and views referencing other views. In my 30+ years, I've found that such practices lead to more problems than solutions.

  • RE: How Far Have You Traveled for a SQL Saturday?

    Steve Jones - SSC Editor (7/29/2016)


    Ha, we have a living quarters as well. Maybe we can roll together to an event? Or you can swing by the ranch when you...

  • RE: How Far Have You Traveled for a SQL Saturday?

    First off Steve, I completely agree with you about the new ruling for the 600 mile radius. Having SQL Saturdays in close proximity back-to-back allows many to attend who...

  • RE: Independence Day

    It never ceases to amaze me just how easy movies and TV make complex computing tasks like hacking unknown systems (what if the aliens didn't have a binary system?), high-speed...

  • RE: Have You Designed a Database from Scratch?

    pietlinden (6/30/2016)


    I guess if you're forced to do something "clever" then you have to document your code inside the code... not in some "book" somewhere that nobody can find. (Yeah,...

  • RE: Email or Username

    Jeff Moden (6/29/2016)


    I treat SSN as one of the most sacred of all pieces of PII even if the Social Security Administration and the medical/financial/general community at large does not.

    Yeah,...

  • RE: Email or Username

    Personally, I prefer using an account name as email addresses are much more subject to change. I've had issues where I could not change my email account (not on...

  • RE: Have You Designed a Database from Scratch?

    xsevensinzx (6/24/2016)


    I think by far the biggest hurdle for me in designing a new data warehouse or even a new database is clearly outlining the ERD and all the ETL...

Viewing 15 posts - 181 through 195 (of 380 total)