Viewing 15 posts - 661 through 675 (of 7,168 total)
For new server builds I like to go with the latest and greatest where possible. SP1 was released on 5/14, so only about a month ago, but unless you have...
June 22, 2015 at 11:55 pm
I love this article mainly because I can pass it on to one of senior .NET developers and do not have to write up anything myself to demo for him...
June 22, 2015 at 11:41 pm
SSRS Newbie (6/17/2015)
June 19, 2015 at 11:46 pm
HookSqlDba7 (6/18/2015)
June 19, 2015 at 11:39 pm
June 19, 2015 at 11:07 pm
June 19, 2015 at 11:05 pm
You will need to go to either VS 2012 or VS 2013. VS 2010 does not host SSDT for SQL 2014.
June 19, 2015 at 11:01 pm
After reading the article and the comments I was left wondering if the author and many of the commenters had a clear understanding of the difference between a statement, an...
June 5, 2015 at 8:31 pm
Jeff Moden (5/28/2015)
Solomon Rutzky (5/28/2015)
But SQLCLR is far better than the alternatives of xp_cmdshell, the OLE Automation Procedures, extended stored procedures, and sometimes even OPENROWSET / OPENQUERY
Extremely personal and grossly...
May 28, 2015 at 9:10 pm
Jeff Moden (5/27/2015)
Orlando Colamatteo (5/26/2015)
Jeff Moden (5/26/2015)
For those cases where you're not going to violate the 2GB limit, you don't even need FileStream to load binaries.
True, but with in-table storage...
May 27, 2015 at 8:27 am
A SQLCLR object that makes a connection to the Cloud database is an option as well. Given the "different domains" comment I suspect any connection between the two instances will...
May 27, 2015 at 12:12 am
SSIS is metadata-driven and as you have found an out of the box setup needs to be modified each time the set of source or destination columns that need to...
May 27, 2015 at 12:08 am
Jeff Moden (5/26/2015)
For those cases where you're not going to violate the 2GB limit, you don't even need FileStream to load binaries.
True, but with in-table storage the cost per GB...
May 26, 2015 at 11:44 pm
mwpowellhtx (5/26/2015)
Orlando Colamatteo (5/26/2015)
May 26, 2015 at 11:25 pm
fregatepllada (5/26/2015)
FileTable does not support transactions,
Sure it does...
while Filestream does, plus in Filestream you have a choice to hide files from Windows 🙂
You can hide the files in Windows...
May 26, 2015 at 11:19 pm
Viewing 15 posts - 661 through 675 (of 7,168 total)