Hi Eights......I'm actually getting my feet wet with this kind of job and this is a legacy cube. The database has older cubes and dimensions that no longer process and...

I'm glad to see this is not just a rant. When I first saw the topic, I though uh-oh!:w00t:

I work for a company that has been running lean and mean...

I liked this article and in fact I just leveraged a CLR RegEx in one of the databases our team supports, in order to generate an XML extract.

In a...

corey lawson (5/9/2012)

---

I'll bite, as I use regex's much for cases like this ...

The patindex is fine, but now, isolate the matched substring ...

Me, personally, I'd rather modify a regex...

With the number of blog sites I see that say the same as the next, verbatim, it's no surprise to me that work gets lifted and posted under somebody else's...

Nice Article! I first started working with XML and .Net web services about 10 years ago as a developer.

These days I wear a DBA hat and just had to...

I'm curious as to what monitoring system you found running? I'm getting ready to retire a server and while profiling some of the databases to determine usage, I found this...

Thanks.....I had managed to do something very similar once I understood the nature of the issue! :hehe:

You know, I really don't know about the permission level for adding/reading the properties. As I mentioned in my post, it is still just an idea I'm toying with. I...

In lieu of using extended properties, I've done something similar with a table that maps 1-1 to the sysmanagment_shared_registered_servers, creating a central repository for all the server meta-data.

We're still...

I realize this is an old thread, but I just wanted to add a couple of things. This is the second cluster where we have run into this same issue....

It makes sense with the use of the AD SID, though technically without a server login the users are orphaned. Thanks for explaining that. At least I know I'm not...

But shouldn't sp_change_users_login @Action='Report' be returning to me everything in sys.database_principals that does not join to syslogins? I have 257 database logins, but only 26 of them join to syslogins...

Has anyone come across some tips for optimizing report exports to PDF, particularly in the case of large batch reports?

We just ran into performance issues with exporting a 10,000...

FYI.....Response from MS Connect:

Greetings from Microsoft Connect!

This notification was generated for feedback item: User How-To Guide/Training Report Builder which you submitted at the Microsoft Connect site.

Thank you for using SQL...