Cary, Steve,

Great tips! Thank you.

They use Unitrend to back up the database. Unitrend only restores back to a live database. Backup files restore and restore with no recovery options are not available. So we...

Fantastic! Thank you all! I appreciate all your quick responses.

Articles with single purpose, with diagrams of logic discussed, screen shots, short text explanations, and examples. SQLserverCentral stairways, MsTIPs, DatabaseJournals....

Thank you. I have tried Regate SQL Compare. It is cool.

Hi RTaylor2208, yes, I have tried both switches. The results was always identical. In addition, I am more interested in tablediff's ability to compare the content of rows and provide...

I was in a similar situation today, and resolved it by right clicking "Replication" folder, then select "Update Replication Passwords...". Here you can re-enter the password, Management Studio will apply...

I work for a regular company. They are just on a crusade to move things to the cloud and go with everything possible with open source (community editions only), and...

Thanks guys, I totally agree with you. It has be fun with passion. Learning the Open Source side of things open up opportunities in the Internet companies and start-ups. But...

I switched to the new job for more learning opportunities, so learning new / different things is very important to me. However, too much of a good thing is not...

Thanks Grant, you are right. It does appear to be parameter after all. We noticed a FETCH API query that doesn't show long running time, but since it loops multiple...

Thank you Grant.

I have been investigating, same issue is still occurring off and on, DBCC Freeproccache always resolved it.

I did some profiler tracing, wrote down a list of...