So, it looks like perhaps v.Next just a re-branding of the Community Technology Preview (CTP) program?

I'd rather work in an organization where the DBA is expected to be a part time developer than I would work with developers who are part time database administrators.

Windows itself doesn't really need that 150 GB, does it?
The data space previously allocated by the dropped index will simply be re-allocated as the remaining tables and indexes grow...

For a performance reasons, if you're going to code a query with multiple conditional predicated in the WHERE clause, then understand it probably would not be 'sargable', so make the...

Your background sounds typical of most BI professionals. Don't forget to read Kimball's data warehouse toolkit book, and also try to focus less on database administration and more on ETL...

My periods of unemployment have been brief and far between, but what it has taught me is the following:

- If you're not interviewing, eating, or sleeping, then you...

Assuming you're using a version control system, a visual difference comparison across commits helps tremendously. Also, it helps when each commit has a descriptive comment, because (at least in TFS...

I've dealt with BigInt identifiers a lot when I worked in the healthcare industry, and I've seen Entity-Attribute-Value modeled tables accumulate several billion rows within the first couple years of...

I may look back at this 10 years from now and laugh, but I can't imagine uniquely identifying 9,223,372,036,854,775,807 of anything, unless you're doing click stream analysis on every global user...

The short answer is: No, you can't assign execution priority to a SQL Server request the same way you can a Windows process. Also, the issue isn't just CPU and...