I'm going by what the error message says : This SQL Server edition and/or Windows Server System does not meet one or more of the requirements.

This means you've got something...

READ ONLY on a database means it no longer bothers maintaining locks because there is not possibility of data modification.

The one thing I see missing are log backups. You don't list those as the types of backups, but you have databases in FULL recovery. If you're not running log...

If the Availability Group says you don't have the right configuration, then probably you don't have the right configuration. Do you have an outstanding reboot which will finish the install...

The vast majority is done through the provided interfaces and T-SQL. But if you're really interesting in automating administration of the servers and instances, PowerShell is your bestest friend in...

Assuming the WHERE clauses of the delete statements place the processing squarely within the partition, no, I wouldn't expect to see a table lock. But, you never know. If your...

It really depends on what you're trying to do. The basic table valued function's nickname is parameterized view. These functions work pretty well on their own. They can be somewhat...

I have not used the BI edition. Standard or Enterprise is all I've done. Yes, I've done SSIS & SSRS. They're the same, effectively, in terms of licensing, as the...

I'm not 100% certain, but it could be that your backup file is corrupt. Try removing the file before you rerun the backup. Even though you're running INIT, it doesn't...

I've done a number of upgrades to 2012. There's no special things you need to do going from Standard to Standard in 2012. The upgrade process is pretty similar to...

The Availability Group functionality is not set up to move instances around. It's focused exclusively on a database or a group of databases. Now, you can make all the databases...

Take a look at the properties on the other operations. I'll bet you they're ordered operations. This is all good. An ordered seek or scan with a merge can be...

I don't see anything wrong with asking about the salary range. The thing is, the employer wants to get you for as little money as possible, so they're going to...

That's a very large topic and I'm not going to be able to tell you everything now.

First, be sure you know what the anticipated load on the system will be....

Pinal is a great guy. But, I wouldn't rely on those lists of questions and answers. I...