I doubt it 🙂

I believe you can generate a new encryption key and password. Do it before you upgrade/migrate though.

https://msdn.microsoft.com/en-us/library/ms156010.aspx

I am no SSRS expert but have been playing around a...

There are many other horrible configuration changes that have been made. I have been readjusting as I find them. Thanks much for your insight. I 100% agree...

When ever you say "never" it always bits you in the end. There is a time a place for most rules. These seem like the worst of the...

I would try creating a stored procedure on the linked server to do the delete and then just call the one stored procedure from the other server. I have...

I have not taken the course, but have wanted to take the IEPTO1: Immersion Event on Performance Tuning and Optimization – Part 1 and Part 2 classes by SqlSkill forever...

Thanks for the feedback. Upper management is looking for it to replace SQL Server. Hopefully between myself and the development team we will have enough information to talk...

Disk space is pretty cheap now a days, why make it smaller? Is archiving a possibility? You can play with compression, but I wouldn't just try it in production...

SQLRNNR (7/31/2014)

---

Sarah Wagner (7/31/2014)

---

I hired in to a software company and sad to say we were one of those vendors. Gladly we are not anymore as I rewrote all of...

I hired in to a software company and sad to say we were one of those vendors. Gladly we are not anymore as I rewrote all of our recommendations to...

Offer them an alternative like Skype or Facetime? It gives a face to face feel without all the travel. I have worked with several agencies that have been willing...

update <<tablename>>

set path = replace('/AWDBI/', '/Development/AWDBI/', path)

If you have multiple things that need to be replaced you can have more than one.

update <<tablename>>

set path = replace('/AWB/', '/Development/AWB/', replace('/AWDBI/', '/Development/AWDBI/', path))

Eirikur Eiriksson (7/21/2014)

---

Quick suggestion, don't use OPENXML, it is a depreciated feature and shoul not be used in new development. It is also much slower than XQuery/nodes methods, there are...

XML is case sensitive, but that doesn't appear to be the problem. Try:

DECLARE @XML AS XML, @hDoc AS INT, @sql NVARCHAR (MAX)

SELECT @XML = XMLData

FROM #XMLwithOpenXML

EXEC sp_xml_preparedocument...

I can't even imagine what it would be like to have 6 weeks off. Wonderful. We all work so incredibly hard. I take a week vacation where...