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.

How will you run it?

You could schedule it with SQL Agent, but the Agent would need to be able to access the folder.

It doesn't matter how you write a SQL...

We did something similar in a financial system by putting in data and fields that marked as "as of" a certain date. This allowed us to join tables together based...

In addition to Eugene's notes, you can use a CASE statement to change things around.

case

When x = 5 then 1

when x = 4 then 2

end