I agree the cost is an issue. Investing $400 v $1000 is different. If you can get MSDN for $700, that's good, but I thought it was always $1500+. I...

I'd argue these days we should have tools that reformat stuff for us. My company (Red Gate) makes one, but there are others.

We shouldn't have to worry about this stuff.

David Benoit (7/3/2013)

---

...

Somehow we need to get to the place where we are able to master data access in such a way that people, by job definition, only get to...

Craig-315134 (7/3/2013)

---

Very good article, Steve, thank you.

It may be of interest to know that Kamala Harris, the California State Attorney General, posts data breaches on the AG website. You can...

jasona.work (7/3/2013)

---

So, anyone else rather annoyed at MS for announcing that they're going to end the Technet Subscriptions?

For those of us who are either jack-of-all-trades or just geeks who like...

i'd say that you should definitely have a clustered environment in dev for the admins, so they can test changes or deployments and understand the impacts to production. It doesn't...

good to know it's not us :hehe:

what's monitoring? It's looking for the state of the system and returning it. Alerting lets you know when threshholds are crossed (up or down).

What's...

Run a trace, and look for the calls of the proc.

Get the data, run them manually, look for an error or other issue.

There's no quick/easy way to give you that...

I haven't tried it, but I believe you can. You'll have to live with orphans, because all the users have to be in every database (they're copies), but you could...

This isn't a stored proc, it's a view.

http://msdn.microsoft.com/en-us/library/ms175081.aspx

It's probably security.

do you mean install SQL Server 2008 R2 and use a SQL Server 2012 license for legal purposes? AFAIK, that is allowed under volume licensing rights

https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&ved=0CC4QFjAA&url=http%3A%2F%2Fsocial.msdn.microsoft.com%2FForums%2Fsqlserver%2Fen-US%2Fa9a8c9fc-e9b6-42fd-a7c2-be46722ee9cb&ei=AkPUUb3uAaXUygHro4GgCg&usg=AFQjCNFvytL176AWvlh8AmHdn9hHpVi9LQ&bvm=bv.48705608,d.aWc

I don't know what happens...

this doesn't make sense

I'm not sure what you mean....

I don't think there's a better way to do this in general. T-SQL isn't great at string manipulation.

In SQL Server, you have an instance that contains control information, scheduling, logins, etc. and then you can have multiple databases inside the instance. The instance is at a higher...

AFAIK, Gail is correct. If the columns in the NC index are not changed with an update, that index is not touched. No reason to, as there's nothing to update.