PASS Summit 09 Call For Speakers Deadline Extended

April 8, 2009 at 7:53 am (PASS, SQLServerPedia Syndication) (, , , , )

It’s now running until Friday April 24th. That’s good news if you couldn’t get yourself together by this Friday. However, I wonder if they’re also extending the time for the committee to make it’s decisions? That means extended worry and sweat for those of us who have already submitted abstracts. But, on the other hand, if they haven’t extended the committee’s deadlines, then that means those guys are going to be working their behinds off to meet the original date (end of May).

I also wonder if it means that they’re not getting enough abstracts or if the quality of the abstracts has slipped? New this year you can check out the abstracts to see what others have submitted. That makes for some interesting reading, but now I’m wondering if it’s scared people off. I mean, if you saw that Itzik Ben Gan had submitted a tips & tricks session for TSQL, are you going to put one in as well? Well you should! Last year I think there were two or three different sessions talking about “worst” practices for TSQL (Gail Shaw’s “The Dirty Dozen” was the best though). So you can submit abstracts that, on the surface, appear to be duplicates of others. You’re going to provide a unique point of view on the information and people may connect with you better than with some of the big name stars (yeah, I know it’s unlikely, but that’s what I keep telling myself).

Get out there and submit your abstract.

Permalink 15 Comments

SQL Server Standard Article Available

April 7, 2009 at 1:21 pm (PASS, SQL Server 2005, SQL Server 2008, SQLServerPedia Syndication, TSQL) (, , , )

Unfortunately PASS decided to put the SQL Server Standard to sleep right after I got an article published in it (and no, it wasn’t my fault). However, PASS, being the service oriented organization that they are, has decided to make back issues of the magazine available online. So, to read the article I wrote comparing various methods of retrieving versioned data using different TSQL constructs, click this link. Go to page 14. Oh yeah, and you can see other peoples articles here too.

There are other things coming out of the editorial committee soon (although I need to get one of them done myself… yikes).

Permalink 3 Comments

NULL Is Not NULL

April 7, 2009 at 7:55 am (SQL Server 2005, SQL Server 2008, SQLServerPedia Syndication, TSQL) (, , )

NULL as a concept seems so easy but it leads to so many problems for people. To put it as simply as possible, NULL does not equal anything. It does not “not equal” anything either. It can’t be compared to other values in any way. There was a recent post over at SQL Server Central where the user had a query problem that one of the great people over at SSC solved, handily. They also pointed out that the bit of code being used “WHERE nt.NullableString NOT LIKE ‘null%’” was also a problem. The user insisted that it was eliminating the NULL values. Well, yeah, sort of, it was, but not because it was actually applying a filter to the NULLs. Remember, a NULL does not equal or “not equal” anything and therefor when checking for the equality of something you won’t get NULL values.

Yeah, you’re thinking, so what’s the problem with the code then? This. It can lead to problems with your results. Here’s some sample code that illustrates the problem:

 CREATE TABLE #NullTest
(ID INT IDENTITY(1,1),NullableString NVARCHAR(50) NULL)

–I put the – next to the string NULL so you can see which one it is.
INSERT INTO #NullTest (
NullableString)
SELECT ‘Some Value’
UNION
SELECT
‘NULL-‘
UNION

SELECT NULL
UNION 
SELECT ‘NULL values are not allowed’
UNION 
SELECT ‘NOT NULL’

–returns the five rows available
SELECT * FROM #NullTest AS nt

–returns only two rows, although two other rows should be returned
SELECT *
FROM #NullTest AS nt
WHERE nt.NullableString NOT LIKE ‘null%’

–instead of returning three values, it only returns two, as it should
SELECT *
FROM #NullTest AS nt
WHERE nt.NullableString LIKE ‘NULL%’

— the real values that are not NULL, four of them
SELECT *
FROM #NullTest AS nt
WHERE NullableString IS NOT NULL

DROP TABLE #NullTest

As you can see, the wrong number of rows are returned depending on how the query is used. There are four rows in the table that are NOT NULL (notice the syntax) but running the query the other way only returns two values. There are ongoing debates about the utility, meaning and purpose of NULLs. I’m not getting into it. If you’re using them, you need to understand what they are and what they are not.

Permalink 4 Comments

MVP

April 1, 2009 at 9:30 am (Uncategorized) ()

I hate that these things come out on April Fool’s Day, but it’s true. I was awarded MVP. I’ve logged into the site & everything so it must be true.

Permalink 43 Comments

« Previous page