-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: August 2016

Conference speakers: Why do you teach at events?

I’ve put up a Twitter poll to find some answers to the question: Why do speakers teach at events? Especially at events where there’s no compensation. I know more or less why I do this, but I’ll hold off on my answer. I want to hear about you. #SQLSaturday and… Read more

1 comments, 660 reads

Posted in SQL Awesomesauce on 29 August 2016

An MCM teaches COMMENTS at SQL Saturday OKC

Edit: SQL Sat OKC has come and gone, but the new session on comments is recorded and up on the MidnightDBA Events page! (Direct link to WMV.) Tomorrow (as of the blog’s publish date) at8:30am, I will be teaching “T-SQL’s Hidden Support Feature” at SQL Saturday Oklahoma City (totally free,… Read more

0 comments, 417 reads

Posted in SQL Awesomesauce on 26 August 2016

Tricky TSQL: NOT IN (NULL)

We’ve done this before, but we can go one better this time. Let’s take this step by step. NULL means “I don’t know”. It stand for an unknown value. Nothing can be equal to NULL. We simply can’t say that 1 = NULL, or ‘ABBA’ = NULL,  because we don’t… Read more

2 comments, 955 reads

Posted in SQL Awesomesauce on 11 August 2016

Slash star, dash dash: Be obsessive about comments

I’m working on a new session* that I’ve named “T-SQL’s Hidden Support Feature”. It’s about comments. I’ll get to the reasons why I’m writing and presenting an hour long session on /* */ and — a bit later, but first: Why am I calling comments a “hidden support feature”? Comments… Read more

6 comments, 1,909 reads

Posted in SQL Awesomesauce on 8 August 2016

Feasel’s Grand Analysis of the PASS 600 mile radius rule

UPDATE: Last week, PASS announced an update to the 600 mile radius announcement: “…we will be piloting the 600-mile driving radius distance for events in North America beginning January 1, 2017. We will not include the back-to-back weekend restriction during this pilot…” Last month, PASS – the professional SQL organization…

Read more

0 comments, 1,039 reads

Posted in SQL Awesomesauce on 1 August 2016