Grumpy DBA (12/17/2015)

---

Detroit? Well, you can leave your snowboard at home unless you want to take on the challenging mountains... I mean hills of Mt. Brighton, Mt. Holly, Alpine...

There are spatial functions in SQL Server. These might help

http://www.sqlservercentral.com/articles/64601/

http://www.sqlservercentral.com/articles/64734/

https://www.mssqltips.com/sqlservertip/2690/calculate-the-geographical-distance-between-two-cities-in-sql-server/

#1 is correct.

If I have a table and do this:

CREATE CLUSTERED INDEX ix_mybigtable ON dbo.mybigtable (id, largechar) INCLUDE (largechar2)

I get this:

Msg 10601, Level 16, State 1, Line 1

Cannot specify included...

Why doesn't "IN" work? This works:

DECLARE @t TABLE (myid INT, mystring VARCHAR(20))

INSERT @t VALUES (1, '123456'), (2, '1234532'), (3, '345456'), (4, '12346')

SELECT * FROM @t WHERE mystring IN ('1234532', '345456')

If...

Jack Corbett (12/16/2015)

---

How about Portland, ME the first or second weekend in June? It isn't up on the SQLSaturday site yet, but I know David Klee and...

Nyteshades (12/14/2015)

---

No, we're not engineers. Software and the IT industry move to fast to allow for the rigor of an engineering discipline. It is both the beauty of the industry...

Wayne West (12/15/2015)

---

They've arrested the apparent VTech hacker: a 21 year old Brit. Apparently he is a bit of a hacker who stumbled upon some information, started scratching, and...

Yep.

Ditto. Was hoping to get there, but scheduling didn't work. I...

Last answer updated. I was thinking it wasn't a restriction, but I can see why this created confusion. I'll award back points to this time.

No, Cleveland is out. I've got a commitment with...

Redgate made some videos of SQL in the City. Noticed Rodney taking pictures in this one:

https://www.youtube.com/watch?v=aELQb1Trnz4

ThomasRushton (12/15/2015)

---

ThomasRushton (12/15/2015)

---

Steve Jones - SSC Editor (12/14/2015)

---

Any of you see the Advent of Code?

http://adventofcode.com/

I've been solving them in Python and PoSh, practicing some code. Thought some of you might...

jevitts (12/15/2015)

---

Great thoughts! I'd also like to add that the SQL Server certifications are an excellent way to gain exposure to technologies that you may not have an opportunity/desire to...

roger.plowman (12/15/2015)

---

It's all very well to say you should keep up with changing SQL Server stuff, but the reality for many of us is our companies either refuse to replace...