Are your databases in full recovery mode? If so, are you performing log backups? If you are not performing log backups, you need to. If you don't...

I have a standard install for all of my SQL installations. My standard includes the service accounts for the engine, ssas, ssis, service account. Standard maintenance scripts, jobs,...

Nice script, however if you have any jobs disabled purposely, when the availability group fails over, it will re-enable those jobs. You'd have to always update this script and...

Given the scenario, if the first datacenter was to go down, I would manually have to failover to the second datacenter? That doesn't make sense for high availability. ...

So there isn't a need to script the entire contents of a database. Basically each developer would only script into their project those objects which they will utilize, correct?

Agreed. I was just writing a c# app using the TFS API to do the automatic check-ins and figured why can't they just do it themself.

So my question to...

Steve Jones - SSC Editor (2/5/2014)

---

Are you trying to get the CREATE statement checked into TFS every night? I'm not sure why you do this. Really you only check in...

Thanks for your responses. I've been doing this for many years (as I'm sure you have as well) and have implemented and developed high availability and high transaction transactional...

ben.reese (4/13/2011)

---

Ah yes, I see.

I had read an example where indexes of different collations were used on a column, but on revisisting this example I can see that the second...

Indexes don't have collations assigned to them, they just attached to columns. The column has the collation, whether the same as the database or different.

You can see...

Go into the SQL Configuration Manager, open up the TCP/IP protocol, and look at the TCP Port. Default is 1433.

Not sure I understand your question. Sounds like you purchased a license for SQL Server, and now want to turn that server off and bring up a new one,...

If you checked to install SSRS in SQL 2005, you need to have IIS installed and need to enable ASP.NET via control panel (add/remove apps). Sounds like this is...

If I understand your question correctly, you want to execute a specific query based upon the incoming parameter. If that's the case, sounds like you'll need to build a...

I highly recommend Idera Diagnostic Manager. I have used many of the tools out there (Spotlight, SCOM, etc.) and Idera's is the best out there. Besides it being...