as far as I know, nothing built in. you could accomplish this with some queries:

for data compare, this will give you all rows that dont match

select * from db1.dbo.table

except

select *...

Adam Bean (5/25/2015)

---

You can substitute 463 with 411 (as well as two others).

https://www.microsoft.com/learning/en-us/mcsa-sql-certification.aspx - note "additional options".

Will try practice tests for both, but was trying to see...

Being that you can substitute 70-463 for 70-411 (Administering Windows Server 2012), I'm curious if anyone here has any feedback on the matter that has done either or? I'd like...

I do have nimble in my environment which is not used it for SQL server but I can give some insight on how it works.

we're looking to separate out our...

The first thing to check is whether the linked server user haas the correct permissions on the remote server.

you can use the following to find which user is being used...

you could also use powershell: Backup-ASDatabase and Restore-ASDatabase

I dont know how you can check group membership of a group that is not a login but you could check all group membership for a given login with sys.login_tokens

execute...

I just wanted to add something about the multi-instance setup. I think it is only valid for multiple instances of the same version. If you had a 2014 and a...

with enterprise you have some options with virtualization . You can still buy per-core for each server but if you purchase a core license for all physical cores then you...

If you are buying SQL Standard core-based licenses then I'm pretty sure it doesn't matter whether is...

it appears that if you buy four core licenses for a server you could put multiple SQL server instances on that server. this is from the SQL Server 2014 Licensing...

CTEs can be nested, they just all have to be defined at the same time

with cte1 as(select name From sys.databases),

cte2 as(select name from cte1),

cte3 as(select name from cte2)

select *...

I do believe you are correct that the minimum licenses you could buy would be four cores so licensing would be the same whether 4vCPU or 2vCPU dual-core.

As for performance,...

For SSIS, there was definitely a change from 2008 to 2012. I upgraded my packages although I dont know if this was a requirement (dont know if they would not...

assuming this is not a production table, you could update all the index key values, that should give you a high level of fragmentation.

here is an example

CREATE TABLE frag(id int...