I disable it for Internet facing databases and grant specific permissions. It's also interesting that the article has not been reviewed in two years and SQL 2012 is not...

I have both a high-powered laptop with lots of RAM, an SSD and docking station with multiple large monitors and standard keyboard and mouse, and a 10" tablet with a...

Here is the whitepaper for all the different SharePoint BI components...

http://www.microsoft.com/en-us/download/details.aspx?id=23176

There is always a back door. Consider this...

PsExec.exe -s -i

If you really want to shrink a log file and it is in use with transactions at the end of the log preventing shrinking, you can do so without affecting...

How timely. I just added a note to this MSDN article yesterday to explain how to deal with multiple instances in a cluster when SSIS is not a cluster...

In addition to system level roles, the running packages folder uses the SSIS roles in the MSDB database. By default, logins with the db_dtsadmin or sysadmin role will see...

I think I understand what you're asking for now. That's not exposed via TSQL, but you could use some .NET code and expose it through an assembly that can...

An easy way around this is to replace the offending character when receiving the input from the user. I used to like to replace any special characters with a...

Since you didn't specify a version, I'm going to reply based on SQL 2005. You best bet is tables in the MSDB database that are named dbo.sysdtsxxxx - these...

This is a great method to get started, but make sure you are answering a relevant question. It may not always be "What do you use to measure how...

It's not just Microsoft, it's pretty much every software vendor that follows that bug fixing process. It's basically an industry standard.

http://discuss.fogcreek.com/joelonsoftware/default.asp?cmd=show&ixPost=20746

You sometimes don't know about bugs until a user...

Whether they realize it or not, most large companies are already following government guidance for security compliance - anyone ever hear of ITIL? That is the guidance that has...

I've used ADO.NET this way, and it even says it's possible in the provided documentation:

The source converts any data type that does not map to a specific Integration Services data...

I used it to replace xp_getfiledetails. This allowed several developers relying on the stored procedure to just do a find and replace on the stored procedure name in their...