Category Archives: Microsoft SQL Server
-
T-SQL Tuesday #56: Assumptions
6July 8, 2014 by Kenneth Fisher
I assume that since it’s the second Tuesday of the month that it’s time for T-SQL Tuesday. And you can …
Continue reading -
Argenis and the unicorn hoodie
1July 2, 2014 by Kenneth Fisher
Early yesterday Kirsten Benzel(b/t) announced something very exciting, at least exciting to me. Argenis Fernandez(b/t) has agreed to wear a …
Continue reading -
Make BOL your friend
2June 30, 2014 by Kenneth Fisher
One of the most powerful tools we have as users of SQL Server is Books Online (BOL). Whether you work …
Continue reading -
Dealing with a long string
4June 25, 2014 by Kenneth Fisher
Every now and again you have to put a really long string (more than 8000 characters). Dynamic SQL is the …
Continue reading -
Aliasing a SQL Server: When it works, when it doesn’t and when it may be your problem.
17June 18, 2014 by Kenneth Fisher
Creating an alias for a SQL Server is fairly easy and there are several ways to do it. Configuration Manager …
Continue reading -
What is this default trace you speak of?
4June 12, 2014 by Kenneth Fisher
I frequently see the default trace mentioned in answers to forum questions, blog posts, articles, even training sessions. My knowledge …
Continue reading -
MJ Swart offers free technical editing
1June 9, 2014 by Kenneth Fisher
A little while back Michael J Swart(B/T) offered to help you become a better writer. This was exciting for me …
Continue reading -
15 years of experience with Identity columns
51June 4, 2014 by Kenneth Fisher
An identity column is an auto incrementing column An identity column is typically used as a primary key A primary …
Continue reading
SQL Studies 