1. Collation: Expression

    Leave a comment

    March 26, 2014 by Kenneth Fisher

    I had a recent run in with collation problems and it got me started reading. As I read I started …
    Continue reading

  2. Collation: Location

    Leave a comment

    March 24, 2014 by Kenneth Fisher

    I started reading about collations after I had a recent run in with them. As I read I started to …
    Continue reading

  3. Thank you!

    Leave a comment

    March 19, 2014 by Kenneth Fisher

    I won’t be able to make it to the PASS Summit this year but I still consider myself part of …
    Continue reading

  4. Collation: Definition

    5

    March 19, 2014 by Kenneth Fisher

    I had a recent run in with collation problems and it got me started reading. As I read I started …
    Continue reading

  5. Start with stupid

    2

    March 17, 2014 by Kenneth Fisher

    True story: I worked in a computer lab many years ago and one day this guy (a grad student) checked …
    Continue reading

  6. :CONNECT in SSMS

    7

    March 13, 2014 by Kenneth Fisher

    Those people who are familiar with SQLCMD will recognize this command. It is used to connect to an instance from …
    Continue reading

  7. T-SQL Tuesday #52: Keep your head down!

    2

    March 11, 2014 by Kenneth Fisher

    It is T-SQL Tuesday again and this month we are taking the road less traveled. Michael J Swart (b/t) has …
    Continue reading

  8. Characters you should never ever use in an object or schema name!

    Leave a comment

    March 5, 2014 by Kenneth Fisher

    You can put pretty much any character you want into an object or schema name by enclosing the name in …
    Continue reading

  9. Using SQLFiddle

    2

    March 3, 2014 by Kenneth Fisher

    SQL Fiddle is a free website that you can use to demonstrate and save a query example in any one …
    Continue reading

  10. Impersonating a server level permission

    12

    February 26, 2014 by Kenneth Fisher

    Warnings up front, this has some serious security implications. The method I’m going to use minimizes that somewhat but it’s …
    Continue reading

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

Join 3,975 other subscribers

Follow me on Twitter

Archives

ToadWorld Pro of the Month November 2013