Forum Replies Created

Viewing 15 posts - 5,206 through 5,220 (of 6,041 total)

  • RE: Data Mining Data Warehouse For Beginners

    n00bDBA (4/3/2012)


    Hey,

    So do you all like the books Andy Hyslop suggested. Looking on Amazon there's a fair few Kimball books!

    Thanks again!

    If you are building this data warehouse...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Data Mining Data Warehouse For Beginners

    n00bDBA (3/31/2012)


    Hello!

    We have a lot of database used in 3rd party apps. Things like shop sales. and marketing data.

    As i understand it. The best way to Analyse the data...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Auto Increment

    Sean Lange (4/2/2012)


    Eric M Russell (4/2/2012)


    jamesforest (3/21/2012)


    In testing with auto increment I havde noticed the ID field gets incremented even when the insert fails resulting in missing entries. I...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Auto Increment

    jamesforest (3/21/2012)


    In testing with auto increment I havde noticed the ID field gets incremented even when the insert fails resulting in missing entries. I have tested on 2 build...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: How to create a database backup using visual studio

    wayne.mcdaniel (3/30/2012)


    I've been working on something similar to this for a while. We wanted our database update utility to do an automatic backup before it started changing tables and...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: How to create a database backup using visual studio

    Really, this article could be more of a general primer on how to call a stored procedure from a windows form application. If it included a best practive example of...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: How to create a database backup using visual studio

    I think the best way to kick off backups would be to schedule them via SQL Server Agent job. If you're going to kick off your backups from something like...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: The Mechanical Turk

    The Mechanical Turk may be the first documented case of a slick salesperson showcasing Vaporware.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Detect data changes in a "read-only" database?

    One option for detecting table inserts, updates, and deletes is to implement a server side trace on perhaps the StmtStarting event and also filtering TextData.

    To create a trace, the...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Attracting Talent

    Truth be told, some IT guys are probably intimidated by the prospect of a new hire to the department who will be doing the same or similar job. They're afraid...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Dealing with custom date formats in T-SQL

    Gianluca Sartori (3/23/2012)


    Eric M Russell (3/23/2012)


    Formatting dates in the presentation layer is best, because how the application wants dates formatted and how reporting wants dates formatted will be different, even...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Dealing with custom date formats in T-SQL

    Formatting dates in the presentation layer is best, because how the application wants dates formatted and how reporting wants dates formatted will be different, even if you get them to...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: best book for sql server

    If someone is looking for free books, the "Best of SQL Server Central" volumes 1 - 7 can be downloaded. It contains a mix of dba, developer, and BI topics.

    http://www.sqlservercentral.com/Books/

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: missing mdf and ldf files

    I'm curious to know how or if you were able to see those mdf and ldf files again from SSMS. Even if the files were in use by another process,...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Attracting Talent

    jfogel (3/21/2012)


    It should also be noted that this can cut both ways. Many times when a developer is asking questions of a DBA applicant they will not ask Administration based...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Viewing 15 posts - 5,206 through 5,220 (of 6,041 total)