Viewing 15 posts - 16 through 30 (of 128 total)
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...
July 15, 2013 at 9:46 am
Here is the whitepaper for all the different SharePoint BI components...
May 30, 2013 at 4:28 pm
There is always a back door. Consider this...
PsExec.exe -s -i
March 7, 2012 at 11:58 am
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...
February 1, 2012 at 1:44 pm
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...
September 28, 2011 at 1:47 pm
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...
April 20, 2011 at 11:07 am
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...
April 19, 2011 at 10:19 am
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...
April 18, 2011 at 10:20 am
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...
April 18, 2011 at 9:13 am
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...
April 7, 2011 at 9:56 am
It's not just Microsoft, it's pretty much every software vendor that follows that bug fixing process. It's basically an industry standard.
You sometimes don't know about bugs until a user...
March 3, 2011 at 10:49 am
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...
March 17, 2010 at 9:04 am
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...
March 10, 2010 at 9:13 am
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...
December 11, 2009 at 8:43 am
I don't know any of the names on that list of 15. How about someone that actually wrote some software that I still use on a daily basis like...
November 12, 2009 at 11:48 am