http://www.sqlmag.com/authors/author/author/5035194/rsscomment/5035194en-USFri, 25 May 2012 10:27:06 GMTFri, 25 May 2012 10:27:06 GMThttp://www.sqlmag.com/article/database-development/creating-a-custom-data-processing-extension#commentsAnchorThu, 19 Apr 2012 12:34:01 GMT
Excellent article. How can I get the sample code?]]>Iosif PetrouThu, 19 Apr 2012 12:34:01 GMThttp://www.sqlmag.com/article/database-development/creating-a-custom-data-processing-extension#commentsAnchorhttp://www.sqlmag.com/article/project-plan-analysis-sql-server-2008-r2-87/backup-recovery/backup-basics-for-sql-server-analysis-services#commentsAnchorThu, 17 Mar 2011 14:36:28 GMT
Hi Tyler,

Nice article! Cannot believe it was posted on the same day as I am looking for the ways to backup / restore OLAP SQL Server 2008 DB.

Do you by chance know how to move the OLAP cube to another server and specifically how to do that for TFS (Team Foundation Server) ?

Thanks in advance,
Yelena Varshal]]>Yelena VarshalThu, 17 Mar 2011 14:36:28 GMThttp://www.sqlmag.com/article/project-plan-analysis-sql-server-2008-r2-87/backup-recovery/backup-basics-for-sql-server-analysis-services#commentsAnchorhttp://www.sqlmag.com/article/sql-server-analysis-services/the-concepts-behind-time-calculations-in-ssas#commentsAnchorWed, 21 Jul 2010 14:35:32 GMT
]]>ToddWed, 21 Jul 2010 14:35:32 GMThttp://www.sqlmag.com/article/sql-server-analysis-services/the-concepts-behind-time-calculations-in-ssas#commentsAnchorhttp://www.sqlmag.com/article/database-development/creating-a-custom-data-processing-extension#commentsAnchorFri, 16 Jul 2010 14:47:35 GMT
Where are the images, listing, and sample code?]]>knicholsonFri, 16 Jul 2010 14:47:35 GMThttp://www.sqlmag.com/article/database-development/creating-a-custom-data-processing-extension#commentsAnchorhttp://www.sqlmag.com/article/sql-server-analysis-services/optimizing-time-based-calculations-in-ssas-#commentsAnchorTue, 04 May 2010 15:18:02 GMT
very useful article. its a bit clearer than David Shroyer’s original white paper which I found glossed over a couple of key steps. I had to work back from his examples to get it working on my cube. My big issue is I couldn’t figure out how to get this working on the different time dimensions we use. We are a healthcare company so we have admit date, discharge date, bill date etc... and different audiences use different time dimensions. I ended up with several versions of my cube each with just one time dimension so I could implement YoY, YTD, RollingYear etc...

But this is still much neater than the built in time intelligence in SSAS2008

Many thanks

Steve]]>PowellTue, 04 May 2010 15:18:02 GMThttp://www.sqlmag.com/article/sql-server-analysis-services/optimizing-time-based-calculations-in-ssas-#commentsAnchorhttp://www.sqlmag.com/article/reporting2/sql-server-reporting-services-questions-answered#commentsAnchorWed, 07 Apr 2010 02:10:10 GMT
Good article :-) Still problem with the download link when I do a "save link as". I get the message IE cannot download 102645.zip
When clicking I only get a nice dog telling me about the 404 error when trying to download the zip file. ]]>HallelandWed, 07 Apr 2010 02:10:10 GMThttp://www.sqlmag.com/article/reporting2/sql-server-reporting-services-questions-answered#commentsAnchorhttp://www.sqlmag.com/article/reporting2/sql-server-reporting-services-questions-answered#commentsAnchorMon, 05 Apr 2010 19:06:59 GMT
Download link works fine - just do a "save link as" instead of just clicking on it :)]]>GilesMon, 05 Apr 2010 19:06:59 GMThttp://www.sqlmag.com/article/reporting2/sql-server-reporting-services-questions-answered#commentsAnchorhttp://www.sqlmag.com/article/reporting2/sql-server-reporting-services-questions-answered#commentsAnchorMon, 05 Apr 2010 15:59:00 GMT
Download button still not working.]]>smearachainMon, 05 Apr 2010 15:59:00 GMThttp://www.sqlmag.com/article/reporting2/sql-server-reporting-services-questions-answered#commentsAnchorhttp://www.sqlmag.com/article/reporting2/sql-server-reporting-services-questions-answered#commentsAnchorFri, 02 Apr 2010 06:00:46 GMT
Download click not working??]]>PawanFri, 02 Apr 2010 06:00:46 GMThttp://www.sqlmag.com/article/reporting2/sql-server-reporting-services-questions-answered#commentsAnchorhttp://www.sqlmag.com/article/reporting2/sql-server-reporting-services-questions-answered#commentsAnchorFri, 02 Apr 2010 04:11:28 GMT
I would like to download the subscriptions report can you check the download link. It doesn’t seem to be working.
]]>KooFri, 02 Apr 2010 04:11:28 GMThttp://www.sqlmag.com/article/reporting2/sql-server-reporting-services-questions-answered#commentsAnchorhttp://www.sqlmag.com/article/reporting2/sql-server-reporting-services-questions-answered#commentsAnchorMon, 29 Mar 2010 15:17:21 GMT
I would like to download the subscriptions report can you check the download link. It doesn’t seem to be working.]]>Mon, 29 Mar 2010 15:17:21 GMThttp://www.sqlmag.com/article/reporting2/sql-server-reporting-services-questions-answered#commentsAnchorhttp://www.sqlmag.com/article/reporting2/sql-server-reporting-services-questions-answered#commentsAnchorMon, 29 Mar 2010 12:58:48 GMT
I would like to download the subscriptions report can you check the download link. It doesn’t seem to be working.]]>KnightMon, 29 Mar 2010 12:58:48 GMThttp://www.sqlmag.com/article/reporting2/sql-server-reporting-services-questions-answered#commentsAnchorhttp://www.sqlmag.com/article/sql-server-analysis-services/optimizing-time-based-calculations-in-ssas-#commentsAnchorFri, 26 Mar 2010 22:11:45 GMT
Great article! In my testing, I’ve found that in the SSAS cube browser, the time calculations correctly show the format (currency, etc) of the associated measure; however, Excel 2003 and 2007 do not show the right format. Is there a trick to this, or is it just a limitation of Excel?]]>DaveFri, 26 Mar 2010 22:11:45 GMThttp://www.sqlmag.com/article/sql-server-analysis-services/optimizing-time-based-calculations-in-ssas-#commentsAnchorhttp://www.sqlmag.com/article/reporting2/sql-server-reporting-services-questions-answered#commentsAnchorSun, 22 Nov 2009 06:32:42 GMT
Better project for scrubbing Execution Log results and platform for deeper SSRS querying (also on CodePlex) and targeting features in RS 2008: http://scrubs.codeplex.com]]>summitcloud Sun, 22 Nov 2009 06:32:42 GMThttp://www.sqlmag.com/article/reporting2/sql-server-reporting-services-questions-answered#commentsAnchorhttp://www.sqlmag.com/article/reporting2/sql-server-reporting-services-questions-answered#commentsAnchorFri, 06 Nov 2009 07:44:20 GMT
Fantastic Article, This is what I am looking for! Take Care!]]>MarcosFri, 06 Nov 2009 07:44:20 GMThttp://www.sqlmag.com/article/reporting2/sql-server-reporting-services-questions-answered#commentsAnchorhttp://www.sqlmag.com/article/internet/using-reporting-services-in-an-internet-extranet-environment#commentsAnchorMon, 15 Sep 2008 16:34:30 GMT
Great article. Had a problem that others might come across, for which there are large volumes of info on the web-- when in fact my solution was rather simple. With the Forms Authentication Sample implemented, including Tyler’s fixed VB file, BIDS could not Deploy my work to the server. While SSMS seemed fine with the forms authenticated user, BIDS did not seem to work with the new extension at all. It would over and over again prompt for "User name" and "password" in a Reporting Services Login box, yet it would not accept any valid credentials. Many many hours down the tube. Solution for me was to develop, and run Deploy, of my Report Model from BIDS on a SQL Server 2008 CTP installation on a different server. Worked on the first try. Tested from another 2005 box, does indeed appear that 2008 client tools was the fix. Hope it works for others as well.]]>FREDMon, 15 Sep 2008 16:34:30 GMThttp://www.sqlmag.com/article/internet/using-reporting-services-in-an-internet-extranet-environment#commentsAnchorhttp://www.sqlmag.com/article/common-language-runtime-clr/using-large-clr-udts-in-sql-server-2008#commentsAnchorTue, 15 Jul 2008 14:53:59 GMT
This article was very interesting; however the the zip file doesn’t appear to contain the sln described in the article, only containing: Web Listing 1_Using the XML Data Type.txt Web Listing 2_VarBinaryComp Implementation.txt Web Listing 3_Using the VarBinaryComp UDT in T-SQL Code.txt]]>FREDTue, 15 Jul 2008 14:53:59 GMThttp://www.sqlmag.com/article/common-language-runtime-clr/using-large-clr-udts-in-sql-server-2008#commentsAnchorhttp://www.sqlmag.com/article/user-defined-function-udf/compression-basics#commentsAnchorThu, 29 May 2008 22:21:20 GMT
This article was too basic. I don’t want super-complex articles, but I do want code samples and explicit instructions for how to deploy CLR based UDF’s onto the server.]]>BillThu, 29 May 2008 22:21:20 GMThttp://www.sqlmag.com/article/user-defined-function-udf/compression-basics#commentsAnchorhttp://www.sqlmag.com/article/quering/working-with-estimated-query-execution-plans#commentsAnchorWed, 30 Jan 2008 16:00:34 GMT
Where is the Me.GetXMLSchemaNamespace() function?]]>BOBWed, 30 Jan 2008 16:00:34 GMThttp://www.sqlmag.com/article/quering/working-with-estimated-query-execution-plans#commentsAnchorhttp://www.sqlmag.com/article/internet/using-reporting-services-in-an-internet-extranet-environment#commentsAnchorTue, 29 Jan 2008 11:26:16 GMT
Thanks so much for your feedback jamie@jtu.com! I will bring up the possibility of updating this article at our next article acquisitions meeting. Megan Bearly Assistant Editor, SQL Server Magazine mbearly@sqlmag.com]]>meganbearly Tue, 29 Jan 2008 11:26:16 GMThttp://www.sqlmag.com/article/internet/using-reporting-services-in-an-internet-extranet-environment#commentsAnchorhttp://www.sqlmag.com/article/internet/using-reporting-services-in-an-internet-extranet-environment#commentsAnchorTue, 22 Jan 2008 13:56:43 GMT
Very interesting. It would be nice to have an update to this article since it is over a year old. Are there better practices available now? Third parties tools?]]>jamie@jtu.com Tue, 22 Jan 2008 13:56:43 GMThttp://www.sqlmag.com/article/internet/using-reporting-services-in-an-internet-extranet-environment#commentsAnchorhttp://www.sqlmag.com/article/internet/using-reporting-services-in-an-internet-extranet-environment#commentsAnchorWed, 30 May 2007 14:35:54 GMT
Comments from the author: Hello. In the article I walk through 2 “phases” – phase 1 involves Installing the Sample Security Extension that ships with SQL Server 2005. After (and only after – because there are quite a few steps/config settings/etc. that can trip you up) you have this sample extension installed and working properly, you are ready to move to phase 2 – the “Second Sample”. The actual security extension of the second sample is a complete standalone project (CustomSecurity.vbproj) and can be found in the RS_External_Code\Sample2 - IntegratedApp\FormsAuthentication directory. The web site example of the second sample is called RSFormsAuthSample – and as you pointed out, there are no associated project or solution files. This is because I have this configured as a web project to ensure the IIS (and not the VS 2005 built-in Web Server) is used. You will need to configure the RS_External_Code\Sample2 - IntegratedApp\RSFormsAuthSample folder as an virtual directory within IIS, and then open the “project” using the File-Open-Web Site menu item within VS 2005. In the Open Web Site dialog box, make sure you have selected “Local IIS” (and not File System), and then select the RS_External_Code\Sample2 - IntegratedApp\RSFormsAuthSample folder. Assuming you’ve configured this folder properly in IIS, it should open up in VS 2005 – and you’ll be ready to go. Tyler]]>DianaWed, 30 May 2007 14:35:54 GMThttp://www.sqlmag.com/article/internet/using-reporting-services-in-an-internet-extranet-environment#commentsAnchorhttp://www.sqlmag.com/article/internet/using-reporting-services-in-an-internet-extranet-environment#commentsAnchorFri, 25 May 2007 12:31:34 GMT
This is good article, however, it didn’t show the step by step of how to install the sample project, and besides, cannot there is no project attached to the RSFormsAuthSample download, it only has the aspx and aspx.bv files. So, a bit loss of how to implement this sample code for testing/viewing.]]>DilanFri, 25 May 2007 12:31:34 GMThttp://www.sqlmag.com/article/internet/using-reporting-services-in-an-internet-extranet-environment#commentsAnchorhttp://www.sqlmag.com/article/internet/using-reporting-services-in-an-internet-extranet-environment#commentsAnchorWed, 29 Nov 2006 17:27:15 GMT
Hi Thanks for finding this. We’re uploading new files with the complete set of code files. Also, I see the "Rate this Article" problem you pointed out. We’ll take care of that too! Diana May Technical Editor - SQL Server Magazine]]>DianaWed, 29 Nov 2006 17:27:15 GMThttp://www.sqlmag.com/article/internet/using-reporting-services-in-an-internet-extranet-environment#commentsAnchorhttp://www.sqlmag.com/article/internet/using-reporting-services-in-an-internet-extranet-environment#commentsAnchorSun, 26 Nov 2006 05:40:50 GMT
Great, practical article. I would have given this 4, if 4 was available (my screen shows 1,1,3,1,5 as ratings!) and also if the zip file was not empty I would have been even more impressed.]]>ANTHONYSun, 26 Nov 2006 05:40:50 GMThttp://www.sqlmag.com/article/internet/using-reporting-services-in-an-internet-extranet-environment#commentsAnchorhttp://www.sqlmag.com/article/sql-server-2005/sql-server-2005-express-and-workgroup-scaled-back-yet-feature-rich#commentsAnchorMon, 07 Nov 2005 14:22:37 GMT
We are currently using SQL Server 2000 to replicate to 500 users. These users have MSDE loaded on their PC’s and are using pull subscriptions. Since replication uses the SQL Server Agent, we will not be able to upgrade our users databases to SQL Server 2005 Express. We also would not want to upgrade to SQL Server 2005 Workgroup because of the additional expense. Since one of Microsofts replication examples is replicating to a large sales force that is not connected all the time, how will they address this? Also, how will you be able to setup maintence on MSDE or schedule tasks? Will your application need to do these tasks? This seems very inefficiant. This will probably delay our upgrade to SQL Server 2005.]]>STEPHENMon, 07 Nov 2005 14:22:37 GMThttp://www.sqlmag.com/article/sql-server-2005/sql-server-2005-express-and-workgroup-scaled-back-yet-feature-rich#commentsAnchor