Thank you for this article.  I am struggling with a much, much smaller problem. I am pulling the log data from one SQL Server to a central database.  The monitored...

I worked for a managed service provider providing DBA services.  We had an on call rotation, where we were primary on call  one week and secondary on call one week. ...

Thank you Steve for your insightful reminder.  I get involved heavily in things that are not truly important, whether it is a silly computer game or rarely my work and...

One hiccup I've encountered using dm_db_index_usage_stats happens when I recently checked the table by doing a select.  Suddenly I had a user_scan not related to production usage.

I try to remember...

I was working contract at a place where one person was the lynchpin to several projects.  He was a lead or manager and all of the facts needed to make...

The contents of Text_Value does not look like xml
Can you put this into text?

My recollection is that cross database ownership chaining was on by default in earlier versions of SQL Server and was off by default in later versions of SQL Server.  I...

I don't know if there is a better way yet.  But I found that I could query the catalog.executions view in an Execute SQL task:

SELECT Folder_Name...

I can't say for sure, but I suspect that something is happening when SSIS queries the server for metadata.  Using a SQL Command you have provided the column names that...

I was unable to reproduce the behavior in SQL Server 2016.  Before I dig into SSIS, can you answer a couple questions.  What version of SQL Server are you...

What specifically are you trying to do?  What happens when you try to change the file path that doesn't happen when you change the file name?

I am a developer and have many times been frustrated at hard headed DBAs.

But in the places where they have been the most intransigent, they are also the busiest. ...

You are looking at your problem backwards. You don't want to have a union of two rows of XML. You want xml of a union of two select...

You would just need something like this:

With XMLNamespaces ('namespace' as ns0)

select col as [ns0:col]

from tbl

for xml path

Sorry, since you hadn't responded to my questions about putting it into the SQL, I assumed...