I had been dreading this one, but I passed this morning with an 857. 😀

It should be noted that SSL connection encryption is baked-in to all editions (including Express), which is the key player...

Mike C (4/14/2010)I also prepend the binary length of the string to each column, which provides additional differentiation and provides a useful method for dealing with NULLs. For instance:

"a...

Nice to see this article come around again. Great stuff.

SqlDateTime still maps to the SQL Server datetime data type, yes. If I remember correctly,...

KT8177 (7/17/2009)

---

The issue I have is that when I run a sproc, it calls a spreadsheet and loads the data into tables and then uses that data the in the...

I'd seen XML string splitting and concatenation before, but ran into issues with characters that aren't valid in XML. I found that just escaping all the invalid characters prior...

This has been my experience as well. I love the...

The editor is treating the commented text like a plain text editor, and leaves off of the @ like most any text editor will when you double-click the word. ...

I've been running SQL2008 on Windows 7 a couple weeks now without issue.

I cheated.

select cast( newid() as binary(4) )

😛

I count myself fortunate that I'm using SQL08.

select * from etl.exceptions

where convert( date, datetimestamp ) between '2009-01-01' and '2009-02-06'

Not only returns the correct results, but does so with an index...

The only issue I've run into with using mount points is during replication setup (creating the replication database on my MP throws an error), but that's easy enough to work...

The role of the trigger may certainly be changing, but they're certainly not legacy by any means. They're often the easiest way to audit (I have a DDL trigger...