THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SSAS » SSRS   (RSS)
  • Build-time dependency resolving coming to Entity Framework. Now, how about those BI tools too?

    Three months ago I wrote a blog post entitled Some thoughts on Visual Studio database references and how they should be used for SQL Server BI where I shared some thoughts on a feature available to database developers in Visual Studio 2010 that I would love to see added to SQL Server Integration Services (SSIS), Analysis ...
    Posted to Jamie Thomson (Weblog) by jamiet on December 7, 2010
  • SQL Server v.Next (Denali) : Launch point for BI resources

    Microsoft's new data platform vision for BI is called BISM - Business Intelligence Semantic Model.  While I focus primarily on manageability, availability and database engine features, I'd like to keep tabs on who can help you out with their input on the other aspects I rarely touch - Analysis Services (SSAS), Integration Services (SSIS), and ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on November 30, 2010
  • PASS Summit 2010: Epilogue

    Another PASS Summit has come and gone, and a good time was had by all. The song at the opening keynote sums up the experience quite nicely, ''Simply the Best.'' My favorite quote of the week comes from Andy Leonard (blog| twitter) who tweeted on November 9, ''#sqlpass is a family reunion. :{>'' Oddly enough, Andy is one of the few people that I ...
    Posted to Stacia Misner (Weblog) by smisner on November 15, 2010
  • Using Dynamic MDX in Reporting Services: Part 2

    In this post, I continue my exploration of approaches to working with dynamic MDX in a Reporting Services dataset when you are using Analysis Services as a data source. I began this series with a look at string conversion functions in Part 1. In Part 1, the dynamic MDX relied on parameters that work as a filter on the query results. But what if ...
    Posted to Stacia Misner (Weblog) by smisner on October 8, 2010
  • Using Dynamic MDX in Reporting Services: Part 1

    If you're using Analysis Services as a data source for Reporting Services reports, you can build a simple dataset using the graphical query designer, but you'll want to switch to the generic query designer to create the MDX query string manually when you have more advanced requirements. Using the generic query designer, you can:· Impose greater ...
    Posted to Stacia Misner (Weblog) by smisner on October 7, 2010
  • Some thoughts on Visual Studio database references and how they should be used for SQL Server BI

    Over the past few weeks I have been making heavy use of the Database tools in Visual Studio 2010 (formerly known as datadude, DBPro, VSTS for Database Professionals or one of a plethora of other names that it has gone by over the past few years) and one of the features that has most impressed me has been database references.   Database ...
    Posted to Jamie Thomson (Weblog) by jamiet on September 14, 2010
  • It's Official - SQLSaturday is Coming to NYC!

    New Jersey SQL Server User Group (NJSQL) is bringing SQLSaturday #39 to NYC on April 24, 2010!  The free all-day training event will be hosted by Microsoft at their Midtown Manhattan offices.  The speaker line-up is growing fast—if you'd like to present, visit the event's open call for speakers.  This is a free full-day ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on February 6, 2010
  • The SQL developer gap (Warning: rant coming up)

    I recently submitted a bug to Microsoft Connect concerning the behaviour of the expression language in SSRS, if you’re interested you can read about it here: DateAdd() doesn't throw an error when it has invalid parameters. I got a swift and detailed reply (for which I am grateful) from a fellow on the SSRS team however the content of it wasn’t ...
    Posted to Jamie Thomson (Weblog) by jamiet on January 12, 2010
  • Start / Stop SQL Server, SSIS, SSAS, SSRS and SQL Server Agent at once with a batch file

    A lot of developers have SQL Server and its different services running on their PC or notebook to develop or test BI solutions. Unfortunately this slows down your system quite a lot. To speed things up when not using SQL Server, I used to stop and start each service manual quite often. Recently I found out that it's possible to start and stop all ...
    Posted to Jorg Klein (Weblog) by jorg on January 6, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement