Roger Doherty's Windows Azure Blog - All Commentshttp://blogs.msdn.com/b/rdoherty/Work blog for Roger Doherty, Sr. Program Manger, SQL Server Customer Experience Teamen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)re: Handling NULL instances of varbinary(max) FILESTREAM columnshttp://blogs.msdn.com/b/rdoherty/archive/2007/10/18/handling-null-instances-of-varbinary-max-filestream-columns.aspx#10564606Tue, 14 Oct 2014 16:48:35 GMT91d46819-8472-40ad-a661-2c78acb4018c:10564606Michael Johnson<p>I realize this is SUPER old, but I need a quick method to find out which of my rows have an empty FILESTREAM column. Judging by how long my query ( [File] IS NULL ) is running, I think SQL SERVER is checking the actual file in NTFS, rather than some other form of &quot;knowing&quot; it&#39;s empty. Any thoughts? My table has less than 17K rows, which is small for SQL access for large for NTFS access.</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10564606" width="1" height="1">re: Configuring a Service Principle Name (SPN) for an SSRS application poolhttp://blogs.msdn.com/b/rdoherty/archive/2006/07/26/678841.aspx#10541187Thu, 10 Jul 2014 08:30:31 GMT91d46819-8472-40ad-a661-2c78acb4018c:10541187Siva<p>So after a quick call to the help desk I was able to have a support technician with the appropriate privileges register the SPN for me!!!</p>
<p>How do we do this ?</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10541187" width="1" height="1">re: What You Need To Know About Data-tier Applications (DAC Fx)http://blogs.msdn.com/b/rdoherty/archive/2011/04/07/what-you-need-to-know-about-data-tier-applications-dac-fx.aspx#10470329Thu, 21 Nov 2013 19:11:01 GMT91d46819-8472-40ad-a661-2c78acb4018c:10470329Paul<p>So is this now possible in the latest DAC Fx? &nbsp;Can you suggest any good articles, tutorials, samples on how to do this? &nbsp;Since I am using Visual Studio which no longer comes with an installation tool, I am using WiX to create my MSI. &nbsp;Would love to see how to incorporate dacpac deployments into an MSI using WiX. &nbsp;Is that asking too much? &nbsp;:)</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10470329" width="1" height="1">re: Learn SQL Server 2012 Development Now!http://blogs.msdn.com/b/rdoherty/archive/2011/10/12/learn-sql-server-2012-development-now.aspx#10442550Sun, 18 Aug 2013 13:47:28 GMT91d46819-8472-40ad-a661-2c78acb4018c:10442550Devender<p>Use Microsoft Virtual labs to practice SQL Server from below link</p>
<p><a rel="nofollow" target="_new" href="http://www.zilckh.com/learn-practice-or-explore-windows-softwares-on-microsoft-virtual-labs/">www.zilckh.com/learn-practice-or-explore-windows-softwares-on-microsoft-virtual-labs</a></p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10442550" width="1" height="1">re: Announcing Metro Early Adoption Program for SQL Server Code Name “Denali”http://blogs.msdn.com/b/rdoherty/archive/2011/04/04/announcing-metro-early-adoption-program-for-sql-server-code-name-denali.aspx#10417810Sat, 11 May 2013 03:15:41 GMT91d46819-8472-40ad-a661-2c78acb4018c:10417810XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX<p>XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10417810" width="1" height="1">re: Announcing Metro Early Adoption Program for SQL Server Code Name “Denali”http://blogs.msdn.com/b/rdoherty/archive/2011/04/04/announcing-metro-early-adoption-program-for-sql-server-code-name-denali.aspx#10417809Sat, 11 May 2013 03:15:17 GMT91d46819-8472-40ad-a661-2c78acb4018c:10417809AYHANOZTOY----------------------------------------------------------------<p>METRO OWNER CARGO BUS............................................................................................</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10417809" width="1" height="1">re: Dependency Checker Fix for Windows 7 and Windows Server 2008 R2 Service Pack 1http://blogs.msdn.com/b/rdoherty/archive/2011/04/05/dependency-checker-fix-for-windows-7-and-windows-server-2008-r2-service-pack-1.aspx#10405235Mon, 25 Mar 2013 21:58:01 GMT91d46819-8472-40ad-a661-2c78acb4018c:10405235Onur Omer Ozturk<p>if you are trying to run those samples in windows 8 add 9200 too. And also in future it may change, you can find your current operating system&#39;s current build number from Registry. </p>
<p>Following key: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\CurrentVersion\CurrentBuildNumber</p>
<p>cheers!</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10405235" width="1" height="1">re: They’re Here! SQL Server 2012 Early Adoption Cook Book Videos!http://blogs.msdn.com/b/rdoherty/archive/2012/03/08/they-re-here-sql-server-2012-early-adoption-cook-book-videos.aspx#10394971Mon, 18 Feb 2013 19:54:38 GMT91d46819-8472-40ad-a661-2c78acb4018c:10394971Khampa<p>Hi Roger,</p>
<p>Any iidea on the adoption rate for SQ Server 2012 vs. 2008?</p>
<p>Thanks!</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10394971" width="1" height="1">re: Looking for a killer SQL Server 2012 demo?http://blogs.msdn.com/b/rdoherty/archive/2011/10/27/looking-for-a-killer-sql-server-2012-demo.aspx#10382150Thu, 03 Jan 2013 18:08:53 GMT91d46819-8472-40ad-a661-2c78acb4018c:10382150Domink<p>Looks great!</p>
<p>How is the tag cloud realized / visualizied ? What is the technology behind the tag cloud ?</p>
<p>Best regards!</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10382150" width="1" height="1">re: Learn Data Mining Development Today!http://blogs.msdn.com/b/rdoherty/archive/2011/04/15/learn-data-mining-development-today.aspx#10374011Mon, 03 Dec 2012 10:29:56 GMT91d46819-8472-40ad-a661-2c78acb4018c:10374011christi parks<p>Hello, i would like to ask that what is the benefits of sql training, what all topics should be covered and it is kinda bothering me … and has anyone studies from this course <a rel="nofollow" target="_new" href="http://www.wiziq.com/course/125-comprehensive-introduction-to-sql">www.wiziq.com/.../125-comprehensive-introduction-to-sql</a> of SQL tutorial online?? or tell me any other guidance...</p>
<p>would really appreciate help… and Also i would like to thank for all the information you are providing on sql training.</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10374011" width="1" height="1">re: New SQL Server 2012 and SQL Azure Presentations Availablehttp://blogs.msdn.com/b/rdoherty/archive/2011/10/17/new-sql-server-2012-and-sql-azure-presentations-available.aspx#10373614Fri, 30 Nov 2012 19:37:44 GMT91d46819-8472-40ad-a661-2c78acb4018c:10373614MUHAMMADSUBHAN<p>Mr Doherty, my trial azure is expired. How to extend my azure portal? I need for share knowledge in community and sales. thanks :)</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10373614" width="1" height="1">re: Windows Azure Virtual Machine is Here!http://blogs.msdn.com/b/rdoherty/archive/2012/06/08/windows-azure-virtual-machine-is-here.aspx#10329239Thu, 12 Jul 2012 13:50:50 GMT91d46819-8472-40ad-a661-2c78acb4018c:10329239Jorge Segarra (SQLChicken)<p>@Peter, running SQL Server on a VM isn&#39;t an issue with it &quot;not working well BECAUSE it&#39;s virtualized&quot;, there are a LOT of factors to take into consideration. How was the VM configured (memory, disks, resources)? Did you configure SQL Server correctly? There&#39;s tons of companies that are running SQL Server in a virtualized environment with no issues (yes, this means production as well). One good place to start your knowledge journey is over at virtualization.sqlpass.org. PASS has tons of great community resources to help you get everything you need to know about SQL Server.</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10329239" width="1" height="1">re: Windows Azure Virtual Machine is Here!http://blogs.msdn.com/b/rdoherty/archive/2012/06/08/windows-azure-virtual-machine-is-here.aspx#10329238Thu, 12 Jul 2012 13:50:15 GMT91d46819-8472-40ad-a661-2c78acb4018c:10329238Jorge Segarra<p>@Peter, running SQL Server on a VM isn&#39;t an issue with it &quot;not working well BECAUSE it&#39;s virtualized&quot;, there are a LOT of factors to take into consideration. How was the VM configured (memory, disks, resources)? Did you configure SQL Server correctly? There&#39;s tons of companies that are running SQL Server in a virtualized environment with no issues (yes, this means production as well). One good place to start your knowledge journey is over at <a rel="nofollow" target="_new" href="http://virtualization.sqlpass.org/">virtualization.sqlpass.org</a>. PASS has tons of great community resources to help you get everything you need to know about SQL Server.</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10329238" width="1" height="1">re: Trust Services Lab Refresh Coming July 9thhttp://blogs.msdn.com/b/rdoherty/archive/2012/07/05/trust-services-lab-refresh-coming-july-9th.aspx#10328285Tue, 10 Jul 2012 08:51:25 GMT91d46819-8472-40ad-a661-2c78acb4018c:10328285Ravi S.Maniam<p>This is great. I was waiting for it. :-)</p>
<p>Any technical papers on the architecture, how to use it etc ?</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10328285" width="1" height="1">re: Windows Azure Virtual Machine is Here!http://blogs.msdn.com/b/rdoherty/archive/2012/06/08/windows-azure-virtual-machine-is-here.aspx#10327189Thu, 05 Jul 2012 15:31:57 GMT91d46819-8472-40ad-a661-2c78acb4018c:10327189Roger Doherty<p>@Peter, Baldwin and everybody, if you are testing your SQL workloads on Windows Azure Virtual Machine we want to hear from you. &nbsp;Check out <a rel="nofollow" target="_new" href="http://bit.ly/sqliaasnom">http://bit.ly/sqliaasnom</a> for instructions on how to enroll in our managed preview.</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10327189" width="1" height="1">re: Dependency Checker Fix for Windows 7 and Windows Server 2008 R2 Service Pack 1http://blogs.msdn.com/b/rdoherty/archive/2011/04/05/dependency-checker-fix-for-windows-7-and-windows-server-2008-r2-service-pack-1.aspx#10322706Thu, 21 Jun 2012 18:45:18 GMT91d46819-8472-40ad-a661-2c78acb4018c:10322706Gerardo<p>Any other check? I already do that, and still displays the same message</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10322706" width="1" height="1">re: Windows Azure Virtual Machine is Here!http://blogs.msdn.com/b/rdoherty/archive/2012/06/08/windows-azure-virtual-machine-is-here.aspx#10321531Mon, 18 Jun 2012 22:45:27 GMT91d46819-8472-40ad-a661-2c78acb4018c:10321531Baldwin<p>This is a awesome blog post. Windows Azure is a cloud platform service which has a combinations of web sites, virtual machines, websites, cloud services, SQL database, storage and networks. Bringing everything together, Microsoft will be able to compete with companies such as Rackspace, Amazon Cloud, and etc. </p>
<p>Virtual Machines are heavily used in the business today, it is no surprise that Microsoft has added this feature to their web service platform. In addition, the conjunction between SQL servers and Virtual Machines is a excellent move by MIcrosoft because it will allow database type tasks to run on the Virtual Machines created on the Windows Azure platform.</p>
<p>On top of that, Microsoft data centers host and run their applications on their in-house Windows Azure cloud operating system which allows the services to run more efficiently. Lastly, the speed of Windows Azure cloud has not been tested versus the scalability of the service.</p>
<p>Unfortunately, providing great cloud services still does not address some of the main issues of cloud computing. Since cloud computing is fairly new, there is a security uncertainty on the cloud. Secondly, there are limitations to the control users have with their service because everything is scatter through out the cloud and rare to be find anything physically. </p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10321531" width="1" height="1">re: Windows Azure Virtual Machine is Here!http://blogs.msdn.com/b/rdoherty/archive/2012/06/08/windows-azure-virtual-machine-is-here.aspx#10319739Thu, 14 Jun 2012 06:49:07 GMT91d46819-8472-40ad-a661-2c78acb4018c:10319739Peter<p>We tried running MSSQL on a VM and found that although it worked, performance was dismal. Has this been addressed, and if so is there a KB article on how to fix performance of MSSQL on a regular VM (as opposed to Azure)?</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10319739" width="1" height="1">re: Sourcing XML Data in SSIS 2005http://blogs.msdn.com/b/rdoherty/archive/2005/03/16/396956.aspx#10290787Wed, 04 Apr 2012 14:34:30 GMT91d46819-8472-40ad-a661-2c78acb4018c:10290787Jim<p>Thanks you so much for this article. I was haveing the truncation problem and your solution worked perfectly for me.</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10290787" width="1" height="1">re: Looking for a killer SQL Server 2012 demo?http://blogs.msdn.com/b/rdoherty/archive/2011/10/27/looking-for-a-killer-sql-server-2012-demo.aspx#10283723Thu, 15 Mar 2012 15:34:51 GMT91d46819-8472-40ad-a661-2c78acb4018c:10283723Gary Zhang<p>I tried RTM, I still can only see word from Semantic Search not phrase.</p>
<p>I think if a Semantic Search can&#39;t return phrase, it is useless.</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10283723" width="1" height="1">re: Looking for a killer SQL Server 2012 demo?http://blogs.msdn.com/b/rdoherty/archive/2011/10/27/looking-for-a-killer-sql-server-2012-demo.aspx#10266758Sat, 11 Feb 2012 00:08:18 GMT91d46819-8472-40ad-a661-2c78acb4018c:10266758Semantic Search seems to work only on Word Documents. <p>Is there anything I need to do to get it to work for Excel Speadsheets?</p>
<p>select * from Documents</p>
<p>returns one row for test1.xlsx and one for test1.csv</p>
<p>SELECT *</p>
<p> &nbsp; &nbsp;FROM semantickeyphrasetable(Documents, *)</p>
<p>returns null</p>
<p>SELECT name, document_key, keyphrase, score</p>
<p> &nbsp; &nbsp;FROM semantickeyphrasetable(Documents, *)</p>
<p> &nbsp; &nbsp;INNER JOIN Documents ON stream_id = document_key</p>
<p> &nbsp; &nbsp;ORDER BY name, score DESC</p>
<p>returns null</p>
<p>Following the SQL Server 2012 Training Kit. I replaced word documents with the Excel Spreadsheet, but it doesn&#39;t seem to work. How do I check for Excel Filters?</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10266758" width="1" height="1">re: Announcing the SQL Server 2012 Early Adoption Cook Bookhttp://blogs.msdn.com/b/rdoherty/archive/2012/01/31/announcing-the-sql-server-2012-early-adoption-cook-book.aspx#10262555Wed, 01 Feb 2012 02:46:50 GMT91d46819-8472-40ad-a661-2c78acb4018c:10262555Mr. Wharty<p>Thanks for sharing</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10262555" width="1" height="1">re: New SQL Server 2012 Labs and Presentations Availablehttp://blogs.msdn.com/b/rdoherty/archive/2011/11/07/new-sql-server-2012-labs-and-presentations-available.aspx#10261575Sun, 29 Jan 2012 18:04:51 GMT91d46819-8472-40ad-a661-2c78acb4018c:10261575Fernando Marçal<p>Hi, I&#39;m having problems running &quot;Hands On Lab: Exploring SQL Server Denali Data Quality Services&quot;. I&#39;m able to reach the end of the lab, but had to change the expressions in conditional splits (for instance, I was not getting Unknowns but News in statuses). But the major issue I&#39;m getting is that when I add a Data Viewer right after the DQS Cleansing the &quot;%_Output&quot; columns do not receive the expected value when they are Correct or New). EmailAddress_Output is receiving Gender and StateProvince_Output is receiving AddressLine1. Changing the order of the columns before the DQS mantains the odd behaviour, i.e. they receive the values from other columns.</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10261575" width="1" height="1">re: Looking for a killer SQL Server 2012 demo?http://blogs.msdn.com/b/rdoherty/archive/2011/10/27/looking-for-a-killer-sql-server-2012-demo.aspx#10259538Mon, 23 Jan 2012 09:05:10 GMT91d46819-8472-40ad-a661-2c78acb4018c:10259538Yousry Lashin<p>Awesome &nbsp;Application</p>
<p>Does it support HTML documents instead of WORD documents ?</p>
<p>What languages are supported for indexing text ?</p>
<p>Regards</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10259538" width="1" height="1">re: New SQL Server 2012 Labs and Presentations Availablehttp://blogs.msdn.com/b/rdoherty/archive/2011/11/07/new-sql-server-2012-labs-and-presentations-available.aspx#10242304Tue, 29 Nov 2011 07:06:38 GMT91d46819-8472-40ad-a661-2c78acb4018c:10242304CSRedRat<p>2 Gb of operative memory and all kernels of the processor (or at least 2-4, since it already the standard for desktop computers) apply to corporation Microsoft on decrease in restrictions in Express release on use at least. It is necessary for small server appendices on which the given edition is focused. Also I ask to reconsider the user interface of the dispatcher of reports since it morally obsolete and needs processing as MS it does with W7 and W8.</p>
<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10242304" width="1" height="1">