Monthly Archives: March 2014
-
Default nullability of a new column
Leave a commentMarch 31, 2014 by Kenneth Fisher
Ever assume that when you don’t specify NULL or NOT NULL on a new column it’s going to allow NULLs? …
Continue reading -
Collation: Expression
Leave a commentMarch 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 -
Collation: Location
Leave a commentMarch 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 -
Thank you!
Leave a commentMarch 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 -
Collation: Definition
5March 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 -
Start with stupid
2March 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 -
:CONNECT in SSMS
7March 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 -
T-SQL Tuesday #52: Keep your head down!
2March 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 -
Characters you should never ever use in an object or schema name!
Leave a commentMarch 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 -
Using SQLFiddle
2March 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