Nice one to start the week, thanks.

Steve Jones - SSC Editor (7/5/2013)

---

Hope everyone had a good Fourth. My day?

We leave late for the mountains (1), hit traffic (2), Tia's hungry, but everywhere in Idaho Springs is...

bpoirier (7/5/2013)

---

Good day everyone,

One Microsoft conference I went to was very good. Two speakers with a mock real life scenario where one speaker was the IT Pro and the...

I assume while flying, otherwise that would just be plain silly 😛

That's true. So you better watch out!

(maybe I'll add an off-topic warning next time, to not confuse anyone else)

You don't need to add the credential as a principal.

You need to specify the credential in the credential name box.

See the screenshot in attachment.

select POWER(convert(bigint,2),31) as val into #temp

I see what you did there 😉

Recycling is good for the environment 😀

These are temporary tables.

Basically it means they are stored in tempdb (one of the system databases) and are dropped when the connection is terminated or when SQL Server is restarted.

They...

2^31-1 bytes.

Maximum Capacity Specifications for SQL Server

jasona.work (7/5/2013)

---

Koen Verbeeck (7/5/2013)

---

jasona.work (7/5/2013)

---

You *KNOW* it's going to be a slow day when you get in at your normal time, and get front-row parking...

I could've driven a golf ball...

Such a round table style session is a good idea.

Although I can imagine not everyone is comfortable with being bombarded with questions. 🙂

Finding Last Backup Time for All Database[/url]

First Google result for sql server calculate days since last backup.

jasona.work (7/5/2013)

---

You *KNOW* it's going to be a slow day when you get in at your normal time, and get front-row parking...

I could've driven a golf ball across the parking...

Can you post some sample data and desired output?

SSIS cannot handle changing metadata, at least not out-of-the-box.

And SSIS has issues with the data types as well (actually it is the ACE OLE DB provider which gives the issues).

I...