Forum Replies Created

Viewing 15 posts - 601 through 615 (of 1,111 total)

  • RE: Ignoring Database Version Control

    Chiefly Confused (9/12/2016)


    Having the schema's and sprocs in a VCS helps immeasurably when you are trying to figure out what, where, why a change was made. Even just knowing...

  • RE: What kind of Fact table is this

    ps_vbdev (9/12/2016)


    thats great info but can i ask whats the benefits in having a row for every event that im wanting to track as opposed to a row for every...

  • RE: What kind of Fact table is this

    ps_vbdev (9/5/2016)


    New to DW and still having trouble switch my brain over to it. Im wanting to report on the journey a user has from registering on our site, creating...

  • RE: Ignoring Database Version Control

    However, the reason I think version control is important is that database development is often disconnected between the database and application. Changes might occur in the database long before they...

  • RE: Copying file from AWS S3 to my SQL Server

    Yep, I would go with the python option. Saved as a script, can be executed by anything.

  • RE: Does Log Data Belong in a Table or a File?

    After years of corrupted flat files with highly transactional video game logs, I stick to tables if I can. But then again, it really just depends. Most of the data...

  • RE: Who can afford Senior DBA?

    Yeah, I'm wondering the same thing. I'm also wondering what you consider a DBA as well.

    In my area, which is much smaller than a large city, I know some senior...

  • RE: Indexed Views and Reporting

    Aye, I would take that approach, especially in building a reporting data mart on a separate server or just using another database on the existing server. That would give me...

  • RE: Avoiding Stored Procedures

    David.Poole (9/2/2016)


    I can remember when vb.net came out. I was in a development role at the time and two of my colleagues had honours degrees in software engineering. ...

  • RE: Avoiding Stored Procedures

    David.Poole (9/1/2016)


    My definition of good enough would be significantly lower if the"we promise to fix this if it causes problems" was a firm commitment rather than an outright lie.

    There's nothing...

  • RE: Avoiding Stored Procedures

    Aaron N. Cutshall (9/1/2016)


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

  • RE: Are the posted questions getting worse?

    Sean Lange (8/31/2016)


    GilaMonster (8/31/2016)


    So, I got roped into doing a professional development session for the local SQL Saturday.

    "Becoming a successful SQL Developer"

    Never done a professional development session before. Not sure...

  • RE: Avoiding Stored Procedures

    I haven't read every reply in this rather long thread, but here is my 2 cents.

    As a data architect who also develops applications in Python, the rapid development aspect of...

  • RE: Parallel insert in a table

    Wouldn't just having multiple staging tables or databases across multiple physicals be good enough to parallel load the data and process it before merging into one primary table? You're still...

  • RE: Up, Up, and Away

    Eric M Russell (8/26/2016)


    xsevensinzx (8/25/2016)


    Hope you enjoy Oslo, Norway. I was able to relocate there for the company I worked for 4 years ago. It was also my longest business...

Viewing 15 posts - 601 through 615 (of 1,111 total)