As a contractor, I don't get to play the 'sole DB resource' bit very often. What I do get to do is evaluate what has already been done in a place...

I have a question on the use of output with merge. If you have a stored proc that outputs the data to another table (lets say an audit table), is...

Great overview, looking forward to the rest of this series.

Yet Another DBA (8/4/2016)

---

Rick-153145 (8/4/2016)

---

Just an aside to this, under data protection laws (at least here in the UK), personal data should be stored encrypted, so if that is the...

Just an aside to this, under data protection laws (at least here in the UK), personal data should be stored encrypted, so if that is the case, it really doesn't...

No, no luck with that. I have instead used a WMI event task that runs...

For anyone trying to convert this into SQL 2008 R2, it seems the SSISScriptTaskEntryPointAttribute does not exist in the ScriptTask namespace. I am trying to figure out at the moment...

Thank you, I will have a read up on this as it seems to be everytime I add a variable into the WQL it decides to stop working, which is...

Thanks, yeah, I seem to be having trouble with the WITHIN statement, but it could be permissions on my end, theough I have tried setting control of the namespace to...

I have been trying to get this to work on SQL 2008 R2 on Windows 7 (servers are Windows 2008 Server, so should be the same), but I can't seem...

I know this post is a few months old, but what about using traceflags 8602, 8755 & 8722 ??

Obviously depending on what the hint is..

Martin Cremer (11/19/2011)

---

Rick,

Maybe I get your question wrong, but wouldn't it help to do a left join to the last query, so it would return the results of the first...

Thanks, nice article.

I have one issue of my own though and can't find a way around it. I have 3 mdx statements I am joining using openquery, setting a variable...

Dave Balsillie (10/25/2011)

---

Rick, help us out a little. Need more information:

Is the attribute on board or off board? What field do you have selected as the key? Are there any...

Question Guy (2/5/2010)

---

In trying to figure out my processing from BIDS issue, I decided to delete the SSAS database through Management Studio. I then tried to deploy throughtBIDS....and it...