Forum Replies Created

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

  • RE: Change tracking without snapshot isolation?

    Did you ever get a response to your initial question?  I'm in the same position and really don't want to enable Snapshot Isolation if I don't have to.

    Kurt

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

  • RE: Tier 1 database experiencing accelerated growth after conversion

    A bit more background.... We are self-hosting a vendor supplied application so I didn't think about changing with the physical database attributes. Additionally because the vendor is rather tight...

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

  • RE: Tier 1 database experiencing accelerated growth after conversion

    OK so my initial post may have been somewhat inaccurate. What I did was put a report showing at what times the data file grew. I saw several...

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

  • RE: Stairway to Advanced T-SQL Level 3: Understanding Common Table Expressions (CTEs)

    I agree 100% There are a lot of constructs available in SQL Server. A lot of developers don't really understand the importance of using the right construct to...

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

  • RE: Migration of SQL Server 2008 R2 to AWS cloud

    EdVassie (2/6/2015)


    The DBA is left with finding creative ways to push the data to RDS

    Kurt, I am assuming you have a VPN between your current data centres and AWS. ...

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

  • RE: Migration of SQL Server 2008 R2 to AWS cloud

    Greetings all;

    Well this past weekend I was able to successfully move a VLD from a VM environment to the Amazon RDS.

    To highlight the tool...

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

  • RE: Setup SQL Server on Amazon RDS

    Solomon Rutzky (1/22/2015)


    Kurt W. Zimmerman (1/21/2015)


    Solomon, just wondering how much difference in performance is your DB_BulkCopy compared to creating an SSIS EXPORT/IMPORT package?

    Kurt, I have no idea what the difference...

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

  • RE: Setup SQL Server on Amazon RDS

    Solomon, just wondering how much difference in performance is your DB_BulkCopy compared to creating an SSIS EXPORT/IMPORT package?

    Kurt

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

  • RE: Setup SQL Server on Amazon RDS

    Solomon Rutzky (1/21/2015)


    Kurt W. Zimmerman (1/20/2015)


    I need to run some benchmarks with SSIS and BCP to see which one is going to perform quicker. My working time window is...

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

  • RE: Setup SQL Server on Amazon RDS

    Great Tim;

    That is basically what I did. The only issue I had was with SQL Data Compare. Now that I got feedback on how to relocate...

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

  • RE: DBmirroring in AWS RDS Cloud

    Does your instance utilize true mirroring? and is it configured the same way as one would configure the mirror from one host to another?

    Kurt

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

  • RE: Migration of SQL Server 2008 R2 to AWS cloud

    Have you done this? Can you further explain where I can move the database backup then access it via SSMS to restore it? It was my understanding one...

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

  • RE: Setup SQL Server on Amazon RDS

    Thanks Steve.

    Kurt

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

  • RE: Setup SQL Server on Amazon RDS

    Great article, I should have come here first.

    This thread may be a little old and there may be new features added to the Amazon RDS. But here...

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

  • RE: Today's Random Word!

    djj (7/1/2014)


    Revenant (7/1/2014)


    crookj (7/1/2014)


    Stuart Davies (7/1/2014)


    Sean Lange (7/1/2014)


    jcrawf02 (7/1/2014)


    futbol

    Diving

    scuba

    Snorkeling

    reef

    reefer

    USS

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

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