Category Archives: SQLServerPedia Syndication

  1. SQL Homework – October 2022 – Replication part 2

    Leave a comment

    October 4, 2022 by Kenneth Fisher

    In August we started taking a look at replication. We learned some of the terms used, and set up a …
    Continue reading

  2. Conversion Precedence

    1

    September 20, 2022 by Kenneth Fisher

    Recently I talked about the difference between implicit and explicit datatype conversions. In it I ran this code: With the …
    Continue reading

  3. Putting counters in names

    6

    September 13, 2022 by Kenneth Fisher

    It’s not all that unusual, or unreasonable to put a counter in a name. For example let’s say you need …
    Continue reading

  4. What’s next 4th time

    6

    September 8, 2022 by Kenneth Fisher

    It’s now been about two and a half months since I was given notice and decided to blog about my …
    Continue reading

  5. Creating a SERVER ROLE created a LOGIN as well.

    1

    September 6, 2022 by Kenneth Fisher

    One of my co-workers came to me the other day and told me that they found their network id as …
    Continue reading

  6. SQL Homework – September 2022 – Query window challenge

    Leave a comment

    September 1, 2022 by Kenneth Fisher

    I had every intention of doing Replication Part 2 this month but had a thought I liked better. I will …
    Continue reading

  7. When good enough is good enough

    3

    August 30, 2022 by Kenneth Fisher

    Any time I’ve learned about the optimizer there is always one important thing that’s brought up. The optimizer is not …
    Continue reading

  8. Explicit and implicit datatype conversions

    2

    August 25, 2022 by Kenneth Fisher

    Did you know that 1/2=0? If you didn’t you could be in for some interesting surprises. 1/2 returns 0 because …
    Continue reading

  9. Why is security important in a dev environment?

    6

    August 23, 2022 by Kenneth Fisher

    I was asked a rather interesting question during an interview recently. It went something like this: Your resume says you’ve …
    Continue reading

  10. New parameter in sp_DBPermissions and sp_SrvPermissions: @CopyTo

    Leave a comment

    August 18, 2022 by Kenneth Fisher

    I’ve added a new parameter to my permissions scripts (well, just the main two for now). Fair warning, it’s in …
    Continue reading

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

Join 3,755 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013