Tag Archives: microsoft sql server

  1. RBAR vs Batch

    5

    August 17, 2016 by Kenneth Fisher

    Many years ago Jeff Moden (of SQL Server Central fame) came up with the concept of RBAR. Row-By-Agonizing-Row. At it’s …
    Continue reading

  2. Write-Only permissions

    3

    August 11, 2016 by Kenneth Fisher

    Yep, that’s right, you heard me. Write-Only not Read-Only. I was presenting SQL Server Security Basics at NTSSUG the other …
    Continue reading

  3. What’s the difference between LEFT and RIGHT OUTER JOINs?

    Leave a comment

    August 3, 2016 by Kenneth Fisher

    A DBA walked into a bar, saw a couple of tables, and asked “Can I JOIN you?” There are several …
    Continue reading

  4. Using impersonation to allow a task without granting the required permission.

    7

    August 1, 2016 by Kenneth Fisher

    I use impersonation on a regular basis for a number of different tasks. This one is pretty basic but can …
    Continue reading

  5. When was this database restored?

    2

    July 27, 2016 by Kenneth Fisher

    I frequently need to know where backups went and I restore those backups for operational recovery on a regular basis. …
    Continue reading

  6. Blogger Questions: What should I blog about?

    2

    July 25, 2016 by Kenneth Fisher

    Over the last four years I’ve blogged almost 400 times. It’s become a refuge, a resource, a source of pride, …
    Continue reading

  7. Want to be able to read your database between restores?

    Leave a comment

    July 20, 2016 by Kenneth Fisher

    When restoring a database there are times when it would nice to restore a bit, check what’s been restored so …
    Continue reading

  8. Is the network your last performance bottleneck?

    6

    July 18, 2016 by Kenneth Fisher

    Let’s say your company relies on the cloud for its servers (or maybe not, on premise networks have more options …
    Continue reading

  9. Altering a column in a large table: A case study

    20

    July 14, 2016 by Kenneth Fisher

    Fair warning, this is a discussion piece. I had a task, I went through several possibilities and I’m going to …
    Continue reading

  10. Default database file sizes

    5

    July 12, 2016 by Kenneth Fisher

    It’s Chris Yates (b/t) birthday! (I think he just tured 19.) And in honor of his birthday we are writing …
    Continue reading

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 1,232 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013
Follow

Get every new post delivered to your Inbox.

Join 1,232 other followers