1. Yes, you need git installed. You can install any version. I've used TFS Git, but installed from the open source git repo[/url].

2. Any path will work. This just needs...

Well, for me, it was just getting away. Family vacation in Ireland for a week, walking, renting a car, enjoying another country with little computer time. My wife and I...

Good advice above. I would recommend either Ola's scripts or the Minion scripts[/url].

That's weird. Haven't seen that. But I haven't gotten dev from the main site before, so maybe it's hooked into a sales workflow of some sort.

They are different versions as...

David.Poole (12/20/2016)

---

There are so many dimensions to "realistic" test data not least that data has natural hot spots. It's difficult to come up with test data that truly simulate...

Fried, but from being overseas for two weeks.

Got back last night, get the lineup set and things look good. If only Mr Rodgers, Mr. Ajayi, and Mr. Crabtree had shown...

Note that the primary key is unique to all records, so you can't say that the ID is the primary key.

You can say that the ID + UserID (or name)...

Weird. I'd think that you should be able. No matter what the spacing of the objects in the file.

Maybe try a reindex that might move things around and then...

Eirikur has good advice. You want to reindex, but when stats might get out of date, or fragmentation gets high. Ola's scripts, or the Minion scripts[/url], can help you here.

As mentioned, you should be able to restart the restore.

The database can't be moved to norecovery or standby if recovery has been run.

The script is

alter database mydb

set encryption off

go

DROP DATABASE ENCRYPTION KEY

go

use master

go

drop certificate mycert

You'll need to change the names to match your db and cert.

Audit works well, and you can keep the data, but it's hard to parse. It's more like it was built to track things for a human to review, which is...

I've edited the question to state Management Studio 2016.

As Grant mentioned, this has nothing to do with SQL Server versions, but the tools version. However, since these were linked prior...

Sean Redmond (12/13/2016)

---

A senior developer who recently left our company expressed the opinion to me that the DBAs should be in charge of the Data Access Layer.

He was very definite...

Markus (12/14/2016)

---

GeorgeCopeland (12/13/2016)

---

The release cadence may be increasing but the issues remain the same. I recommend upgrading vigorously, say 3-6 months after a release so there is enough time to...