Forum Replies Created

Viewing 15 posts - 2,041 through 2,055 (of 9,725 total)

  • RE: import data from an excel to sql server

    You may have to format the Excel worksheet before loading it. If the column in question is formatted as General, you'll need to change the entire column's data type to...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    February 12, 2016 at 6:04 am

    #1858311

  • RE: Audit which users can perform destructive tasks

    A great way to impress your boss is to create a daily or weekly "Entitlement" report that documents these permissions in all environments. Have the report dumped to a secure...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    February 12, 2016 at 6:01 am

    #1858310

  • RE: Help Needed in Inserting data from SQL Server to DB2

    Part of your problem may be the distance between data centers / server locations. Especially if they're in different domains.

    Sometimes doing batches can help speed things up, but I don't...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    February 12, 2016 at 5:59 am

    #1858308

  • RE: How do we get the definition of tables via sql

    mw112009 (2/12/2016)

    In SSMS you can get the def of a table by:

    Right Click on table, Script Table as, CREATE to, New Query Editor Window

    Question1:

    Is there any way I could do...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    February 12, 2016 at 5:56 am

    #1858303

  • RE: Adding quotes to dynamic SQL

    So apparently I didn't go far enough on my quotes. I was doing 4 / 5 instead of 6. At least it works now.

    Thanks, everyone.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    February 11, 2016 at 10:39 am

    #1858101

  • RE: Adding quotes to dynamic SQL

    Jacob Wilkins (2/11/2016)

    So, the trick is that in the innermost quoted command, the EXEC sp_helptext, you want single quotes around schema.object. Since it's inside a string, each of those single...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    February 11, 2016 at 10:35 am

    #1858098

  • RE: SSIS package upgrade confusion - VS verses Data Tools

    Shawn Melton (2/11/2016)

    at least I would suggest that version instead of VS 2012.

    You say that as if I have a choice about what version of VS I can use at...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    February 11, 2016 at 9:04 am

    #1858059

  • RE: SSIS package upgrade confusion - VS verses Data Tools

    jasona.work (2/11/2016)

    Yeah, this gets fun...

    SSDT is the "upgraded" BIDS in 2012. In 2014, SSDT is now a completely separate download, either as a stand-alone (I hope as I just...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    February 11, 2016 at 6:25 am

    #1857994

  • RE: Are the posted questions getting worse?

    Grumpy DBA (2/8/2016)

    Brandie Tarvin (2/8/2016)

    Heading to Seattle soon and wondering if MS gives campus tours or not. Because... why not?

    Anyone know if they do?

    Not exactly what you're looking for but...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    February 8, 2016 at 12:05 pm

    #1857212

  • RE: Are the posted questions getting worse?

    Sean Lange (2/8/2016)

    Ack what a rough start to the week. My dog went for "last outs" about midnight last night and found a skunk. This is the second time in...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    February 8, 2016 at 12:03 pm

    #1857211

  • RE: Are the posted questions getting worse?

    Heading to Seattle soon and wondering if MS gives campus tours or not. Because... why not?

    Anyone know if they do?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    February 8, 2016 at 11:15 am

    #1857192

  • RE: Are the posted questions getting worse?

    Alvin Ramard (2/5/2016)

    SQLRNNR (2/5/2016)

    WayneS (2/5/2016)

    Lynn Pettis (2/5/2016)

    jasona.work (2/5/2016)

    So the other day I was paying bills, and got curious about my electric bill. It was easily 2x what it had...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    February 5, 2016 at 10:58 am

    #1856945

  • RE: Are the posted questions getting worse?

    Luis Cazares (2/4/2016)

    Phil Parkin (2/4/2016)

    Grant Fritchey (2/4/2016)

    Grumpy DBA (2/4/2016)

    In the past I worked with a couple developers (SQL and Oracle) who used Select * quite often. At every code...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    February 4, 2016 at 8:47 am

    #1856572

  • RE: Are the posted questions getting worse?

    Just found an interesting article on ethics in data science. What do you think?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    February 4, 2016 at 8:27 am

    #1856561

  • RE: Are the posted questions getting worse?

    So we were talking about Safe Harbor and data laws the other day, yes?

    And now Slate.com has this article about a new data transfer agreement.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    February 4, 2016 at 5:40 am

    #1856501

Viewing 15 posts - 2,041 through 2,055 (of 9,725 total)