Tag Archives: microsoft sql server

  1. Collation: Correction -> Instance

    Leave a comment

    April 14, 2014 by Kenneth Fisher

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

  2. Collation: Correction -> Expression, Column, Database

    Leave a comment

    April 10, 2014 by Kenneth Fisher

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

  3. T-SQL Tuesday #53: Why so serious

    4

    April 8, 2014 by Kenneth Fisher

    Why so serious? If you ask anyone who knows me they will tell you I’m not a terribly serious person. …
    Continue reading

  4. 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

  5. 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

  6. Collation: Definition

    2

    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

  7. :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

  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

    Leave a comment

    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

    2

    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

Follow

Get every new post delivered to your Inbox.

Join 163 other followers