maryanne_e_2000 (12/2/2014)

---

Does this same stored procedure (msdb.dbo.sp_purge_jobhistory) also clean up SQL Server Reporting Services (SSRS) subscriptions managed by the SQL Server Agent Jobs?

Please see attached snapshot for more information on...

I've had SSDT Solutions with multiple Projects with cross-Project (cross-Database) references and they work fine but I've never tried refactoring across Projects. It may be worth a look.

I looked into Azure blob storage backups for a client to satisfy offsite back requirements and found it relatively easy to setup, however the bandwidth requirements were strict and high....

Reasons not to use sp_msforeachdb:

http://sqlblog.com/blogs/aaron_bertrand/archive/2010/12/29/a-more-reliable-and-more-flexible-sp-msforeachdb.aspx

https://connect.microsoft.com/SQLServer/feedback/details/752629/disable-sp-msforeachdb-by-default-or-fix-it

Read up on the Foreach Loop Container and the Execute SQL Task. You'll want to make a call to your database to insert the details of each file within the...

massoud-1045248 (10/23/2014)

---

Hi Orlando,

Great article. Thank you.

The script seems to have an issue finding a server path. I am not sure why it's not finding the folder.

Please see...

sprasannamsbi (10/18/2014)

---

Hi,

I feel this is a great article. It is very useful to me.

I want to know about when the multiple files arrived in drop directory, all files should be...

Please put xp_cmdshell down, and back away, now. If you are opposed to exhibiting some control around the implementation of xp_cmdshell then you should not be using it at all....

It's a bit more than a few when you...

Note that xp_create_subdir is undocumented so you may want to avoid it anyway.

I recently implemented these SQLCLR objects from CodePlex with some modifications to suit my environment, and they work...

SQLSeTTeR (10/9/2014)

---

looking to coalesce a WHERE clause with XML data.

I cannot supply test data. Can someone look at the COALESCE syntax and let me know what I'm...

@colin and @jeff,

This was article 2 of 3 that I wrote on this topic. Article 3 offers a solution to the problem case using only a Script Task. At the...

The major advantage of THROW over RAISERROR is true support for "re-raising" errors, which is aligned with the TRY/CATCH...

That's the intent. From http://support.microsoft.com/kb/2958696

This update contains hotfixes for issues that were fixed after the release of SQL Server 2008 SP3.

It's encouraging that you were able to get things working. Kerberos has made me rethink my chosen career path on occasions where I was lost somewhere between what the proverbial...