For an organization (like DropBox, Google, or Microsoft) who hosts personal data, I think they should respect privacy in a way similar to apartment building managers. First, the data is...

djackson 22568 (11/17/2015)

---

Microsoft? Come on. They currently are the absolute worst vendor for spying! Sounds like a false flag argument.

"Look at us, we value your privacy." ...

I agree, do your data scrubbing and transformation as near upstream as possible. Transform it once in staging, or transform it 1,000x in the application layer. Many organization don't get...

Gary Varga (11/16/2015)

---

Definitely!!!

We cannot apply a universal rule to learning except that keeping ones skills...

Some of us don't have the professional version of Windows on our personal laptops. In my case, I use DiskCryptor, an open source full disk encryption solution. Once installed, it...

Even with a declarative set-based language like SQL, some developers (well, more like a lot of them) still manage to produce big piles of incomprehensible spaghetti code. Fortunately, however, it's...

A foolish man builds his business on top of a million lines of source code.

It helps if all the team members on a project attend a 15 minute stand-up meeting each morning, and then if someone needs additional information from someone, then they break...

Indeed. If you read an autobiography or listen to an interview given by any successful person in any realm (business, politics, science, technology, writing,...

The domains that the user is a member of, have any of these domains been granted a login? Also, if this user is a member of IT in any capacity...

Jason A. Long (10/31/2015)

---

I think that's an over generalized...

In an OLTP database, you want to minimize recompiles, so you don't want to leave RECOMPILE hint in production. However, in a DW database where tables are bulk loaded, statistics...

When executing a distributed select between two SQL Server instances, especially of the same version, the optimizer has some smarts about whether joins are performed locally or remotely for best...

mwpowellhtx (10/30/2015)

---

Brandie Tarvin (10/30/2015)

---

Eric M Russell (10/29/2015)

---

Maybe I'm missing something, but the table appears to lack a unique index on the natural key, which would allow duplicates. This would normally...

On the server running SSIS, have you installed the Microsoft.Jet.OLEDB provider (.XLS) or Microsoft.ACE.OLEDB provider (.XLSX) ?

http://microsoft-ssis.blogspot.com/2014/02/connecting-to-excel-xlsx-in-ssis.html

Also, I'm not sure if the proxy account SQLAgent is running under needs some...