One of our SQL servers has decided to stop working. It works fine after we reboot for a few hours, then stops again. Logs and eventvwr show nothing. I am wondering if there is a way to turn on verbose logging in SQL Server 2005.
SQL Server Integration Services can read XML files, that’s known by every BI developer. (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.)
But how far can you go? When does the XML Source component become …