In terms of moving data, I know this link is Azure, but I'd think some of this would be similar in Amazon. I'll have to try it at some point:...

I tend to agree with Solomon here. The .NET tools are widely known, though perhaps not by DBAs. This is advanced tooling, and rather than have MS build something else,...

For those of you concerned about costs, if you paid by the CPU/RAM instead of standard/enterprise, would that work?

Let's say that it was something like $800/core and $100/8GB of RAM....

Eric M Russell (1/20/2015)

---

I'm sure the folks in Microsofts accounting department took Econ 101 while in university. If enterprise level customers keep switching to other database platforms primarily on the...

Hmmm, nothing we have set up for a discussion, but probably need it. I know it's working in 2012 (just tested). Will fire up a VM and check 2014.

Which version...

david.gugg (1/20/2015)

---

We're on 2008 R2 Enterprise at my shop and we've cancelled plans to upgrade to 2012 because of the costs. Once Microsoft stops supporting 2008 R2 I believe...

If you start to extend this to lots of potential items, then a trigger grows to slow things, or cause issues. A trigger might work in production, but potentially if...

😀

Apologies. Not sure why I had numeric as 17 and not 38 for the scale.

Points awarded back, answers changed.

In T-SQL, you'd use dateadd, with getdate() like this:

dateadd(dd, -1, getdate())

to get yesterday. In SSIS, if you are doing this, you'd use the Expression language, it's slightly different.

DATEADD("dd", -10,...

😛

I'd tend to use odbc/ado/oledb to try a connection from code and see if it works.

If you're debugging manually, copy sqlcmd.exe over there and run it.

Second vote for a table.

Strange. Just one database?

Have you tried something as simple as

backup database x to disk = 'test.bak'

and see if that works? Rebooted the Windows host?

I've never heard of this. I...

I actually think the CLR has worked well. MS used it internally to add things like HierarchyID to the native product (along with Spatial and other items). It gives them...