Developer Network
MSDN subscriptions
Get tools
Sign in
  • Home
  • Technologies
    • Cloud
    • Mobile
    • Web
    • Business
    • Data
    • Gaming
  • Dev centers
  • Connect
    • Tech Advisors
    • Events
    • Forums
  • Downloads
    • Developer tools
    • SDKs
    • MSDN subscriptions
  • Library
  • Samples
Follow us
  • http://www.facebook.com/microsoftdeveloper
  • https://twitter.com/msdev
  • http://plus.google.com/111221966647232053570/
  • Tech Advisors
  • Events
  • Forums
Ask a question
Quick access
  • Forums home
  • Browse forums users
  • FAQ
Announcement: 33

SQL Server Master Data Services announcements

  • Link
    Please Indicate "Mark as Answer" if a Post has Answered the Question
    edhickey Wednesday, June 23, 2010 8:39 PM

    While reading a reply to your question, you will notice a button with an icon that says "Mark as Answer."   Please select this button when a reply answers your question.

     

    There are several reasons to do this:

     

    • Our search engine weights Answered questions more highly. By marking Answers you increase the chances that others searching this forum will find the answer directly rather than re-posting the question.
    • You give credit to the hard working folks who answer your questions. This is peer to peer support, so recognition is our only reward. (Check out the Top Answerers in 30 Days chart at the bottom of the thread list to see who is currently answering questions.)
    • You help Microsoft to track the health of this forum. Our forum gets 'measured' based on how many unanswered questions are in it at any time and we work hard to keep those numbers to as low a level as possible. By marking answers, others get a more accurate understanding of how well (or badly) things are going on the forum.

     

    You can also vote "Yes" or "No" if the reply was helpful.

     

    Thank you!

     

    Ed Hickey

SQL Server Setup & Upgrade announcements

  • Link
    AVAILABLE: SQL Server 2012 Upgrade Technical Guide
    Ahmed Ibrahim - MSFT Wednesday, May 16, 2012 5:01 AM
    • Customer-ready SQL Server 2012 Upgrade Technical Guide(How to upgrade).
    • What's new.(Why upgrade)

SQL Server Migration announcements

  • Link
    Welcome to the SQL Server Migration forum
    Keshav Ramarao Wednesday, April 28, 2010 2:14 AM

    Need help with migration to SQL Server? Have any questions related to SQL Server Migration Assistant (SSMA) products for Oracle/Sybase/MySQL/Access? Feel free to discuss any SQL Server migration related topics or post any questions related to SSMA.

.NET Framework inside SQL Server announcements

  • Link
    Scope and purpose of this forum
    Bob Beauchemin Tuesday, August 14, 2012 8:28 PM

    This forum covers questions regarding .NET assemblies and database objects running as part of SQL Server including user-defined types, user-defined aggregates, UDFs, triggers, and stored procedures implemented in .NET code. supported by SQL Server 2005 and later versions. Other questions regarding SQL Server database access and other related technologies should be directed to the most appropriate forum to obtain the best response.

    Questions on SQL Server .NET Client (SqlClient) data access should be posted to the ADO.NET data provider forum: http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/threads

    Questions on using SQL Server with ASP.NET should be posted to the ASP.NET forums: http://forums.asp.net/

    Questions on writing Transact-SQL code, including T-SQL stored procedures, UDFs, and triggers: http://social.technet.microsoft.com/Forums/en-US/transactsql/threads

    Questions on installation problems pertaining to .NET installations should be posted to the SQL Server Setup and Upgrade forum: http://social.technet.microsoft.com/Forums/en-US/sqlsetupandupgrade/threads

    Questions on problems using SQL Server Data Tools: http://social.technet.microsoft.com/Forums/en-US/sqltools/threads

    Questions on using other Data Access APIs (e.g. ODBC, OLE DB): http://social.technet.microsoft.com/Forums/en-US/sqldataaccess/threads

    Questions on writing code for SQL Server Compact Edition: http://social.technet.microsoft.com/Forums/en-US/sqlce/threads

    Questions on SQL Server Express-specific issues: http://social.technet.microsoft.com/Forums/en-US/sqlexpress/threads

    Questions that are off-topic in this forum may be moved to one of the other, more relevent, forums to ensure the best, most prompt response and facilitate forum-specific searchng for similar questions that have already been resolved.

SQL Server Express announcements

  • Link
    Some useful links to download SQL Server 2008 and 2008 R2 Express (RTM)
    Papy Normand Monday, May 09, 2011 3:29 PM

    Hello,

    Many thanks to Rick Byham who provided me these links :

    - SQL Server 2008 Express RTM http://www.microsoft.com/downloads/en/details.aspx?FamilyID=58ce885d-508b-45c8-9fd3-118edd8e6fff

    - SQL Server 2008 Express with Advanced services RTM http://www.microsoft.com/downloads/en/details.aspx?FamilyID=b5d1b8c3-fda5-4508-b0d0-1311d670e336

    - SQL Server 2008 R2 Express RTM http://www.microsoft.com/downloads/en/details.aspx?FamilyID=8b3695d9-415e-41f0-a079-25ab0412424b

    - SQL Server 2008 R2 Express with Advanced services RTM http://www.microsoft.com/downloads/en/details.aspx?FamilyID=e08766ce-fc9d-448f-9e98-fe84ad61f135

    I will try to update these links when a new Service Pack or SQL Server "Denali" ( 2011 ? ) will be released

     

SQL Server Samples and Community Projects announcements

  • Link
    Welcome aboard! Community & Samples Forum Intro
    David Reed - MSFT Thursday, January 29, 2009 9:58 PM

    This forum is the place to discuss all things "samplish" in the SQL Server community and samples space, whether it's an "official Microsoft sample" or a community project in CodePlex or Code Gallery. This is *not* the place to discussion specific nuances of T-SQL syntax or wage data modeling methodology wars: there are lots of other forums for those purposes. This one is for questions about samples, community projects and conversations between the collaborators that build them.

     

    Some examples of projects that are open for discussion can be found here: http://www.codeplex.com/SqlServerSamples/ It doesn't have to be listed there to be fair game, but it's a good bet that it is fair game if it's already listed there.

     

    Also, please post your project announcements here when you create a new release or a whole new project. If you're looking for people to work on your project or looking for a project to work on, this would be a good place to do both.

     

    Let us know what's missing, let know what could be better and let us know what we're doing right!

  • Link
    Samples bugs and suggestions.
    David Reed - MSFT Monday, February 02, 2009 4:26 PM
    All of the work items for our community projects and product samples are in TFS on CodePlex. If you want to report a bug, suggest a change for an existing sample or suggest a new sample, create a work item in the appropriate project so that our community team (not just Microsoft employees) can vote on them, help us triage and prioritize them.

    For example, here's the URL for the work items for AdventureWorks: http://www.codeplex.com/MSFTDBProdSamples/WorkItem/AdvancedList.aspx
  • Link
    How to Use this Forum - Please Read Before Posting
    Mr. Wharty Tuesday, October 02, 2012 4:49 AM

    Welcome to the SQL Server Samples and Community Projects Forum.

    This forum is the place to discuss all things "samplish" in the SQL Server community and samples space, whether it's an "official Microsoft sample" or a community project in CodePlex or Code Gallery. This is*not* the place to discussion specific nuances of T-SQL syntax or wage data modeling methodology wars: there are lots of other forums for those purposes. This one is for questions about samples, community projects and conversations between the collaborators that build them.

    Some examples of projects that are open for discussion can be found here: http://www.codeplex.com/SqlServerSamples. It doesn't have to be listed there to be fair game, but it's a good bet that it is fair game if it's already listed there.

    Below are a few guidelines to help you find your answer quickly and also to help the people who answer the questions, answer yours correctly.

    • Is your question about SQL Server Samples and Community Projects . If it's not please locate the correct forum otherwise your question may be moved, closed/locked or deleted.
    • Try searching the forum . Search the forum to see if your question has been asked before and answered.  If you cannot find what you are looking for, please start a new thread rather than adding to an old one as some people do not see answered questions in their forum views so you may not get the assistance you're looking for.
    • Don't be brief . The more information you can give in your question, the better the response will be.
    • Check your alerts . You can subscribe to a question so that you can see any update on it (ReferSetting up your alerts below).
    • No Spam. Spamming will have your thread deleted and may also result in your account being banned.
    • Be polite.  You will get better assistance if you're polite to other members so no flaming or trolling.  If you persist with flaming or trolling, your accountmay get banned.
    • Mark your question answered. If someone answers your question please mark their reply as the answer to your question. You can also mark multiple replies as answers if you think they answered your question.  Marking replies not only assists others with similar questions, it also let's people know that you're grateful for their assistance.

    Dead thread/Answer policy.

    Where possible the moderators will allow sufficient time for the original poster to come back and mark the replies to their questions as answers. The amount of time is at the discretion of the individual moderator but is suggested that it will be declared dead after a week if the original poster does not respond . We will always try to be fair and mark suitable replies as answers.

    Setting up your alerts

    If you are having trouble receiving alerts on the threads you have created or replied to please see thisthread for troubleshooting advice.

Data Mining announcements

  • Link
    Live at BI Labs: SQL Server Data Mining for the Cloud
    Raman Iyer Friday, April 29, 2011 7:37 PM

    Microsoft BI Labs went live today featuring a look into the future of SQL Server Data Mining in the Cloud. The SQL Server Data Mining team presents a set of prototype web services  in the cloud that mirror some of the great predictive analytics functionality available in the Table Analysis Tools for Excel add-in from the SQL Server 2008 Data Mining Add-ins for Office package. No installation required.

     

    This blog post provides more details.

     

    Explore these predictive services from your browser - on your own data - and give us your feedback!

SQL Server Replication announcements

  • Link
    SQL Server 2005 SP3 is now available
    Greg Y Thursday, December 18, 2008 5:10 AM
    SQL Server 2005 SP3 is released, access it here.

    Read about what's new for Replication here.

    Many replication bugs were fixed in SP3, you can find your way through them here.

SQL Server Reporting Services, Power View announcements

  • Link
    Reporting Services 2008 - Resources & Latest Downloads (SP2)
    Robert Bruckner Thursday, February 05, 2009 9:44 PM
    Last update: Mar 27, 2011.


    Get an overview and the latest information on Reporting Services 2008 at the MSDN aggregation page for Reporting Services! 

    Important downloads for Reporting Services 2008:  

    SP2:

    • Report Builder 2.0 (SP2 Download)
      for Reporting Services 2008 (build 10.00.4000)
       
    • SQL Server 2008 SP2 Cumulative Update #3 (build 10.00.4279)
    • SQL Server 2008 SP2 Cumulative Update #2 (build 10.00.4272)
    • SQL Server 2008 SP2 Cumulative Update #1 (build 10.00.4266)
    • Download SQL Server 2008 SP2
    • Download SQL Server 2008 SP2 Express
    • Download SQL Server 2008 SP2 Feature Packs
       
    • RS 2008 SP2 Add-In for SharePoint Integrated Mode (build 10.00.4000) 
      Note: updates for the SharePoint add-in are available for each CU as well, just make sure to select the "..._RSSharepoin" download package.

    SP1:

    • RS 2008 SP1 Add-In for SharePoint Integrated Mode (build 10.00.2531) 
      Note: updates for the SharePoint add-in are available for each CU as well, just make sure to select the "..._RSSharepoin" download package.
       
    • SQL Server 2008 SP1 Cumulative Update #13 (build 10.00.2816)
    • SQL Server 2008 SP1 Cumulative Update #12 (build 10.00.2808)
    • SQL Server 2008 SP1 Cumulative Update #11 (build 10.00.2804)
    • SQL Server 2008 SP1 Cumulative Update #10 (build 10.00.2799)
    • SQL Server 2008 SP1 Cumulative Update #9 (build 10.00.2789)   
    • SQL Server 2008 SP1 Cumulative Update #8 (build 10.00.2775)   
    • SQL Server 2008 SP1 Cumulative Update #7 (build 10.00.2766)   
    • SQL Server 2008 SP1 Cumulative Update #6 (build 10.00.2757)   
    • SQL Server 2008 SP1 Cumulative Update #5 (build 10.00.2746)
    • SQL Server 2008 SP1 Cumulative Update #4 (build 10.00.2734)
    • SQL Server 2008 SP1 Cumulative Update #3 (build 10.00.2723) 
    • SQL Server 2008 SP1 Cumulative Update #2 (build 10.00.2714) 
    • SQL Server 2008 SP1 Cumulative Update #1 (build 10.00.2710)
    • SQL Server 2008 Service Pack 1 (build 10.00.2531)

    RTM:

    • SQL Server 2008 RTM Cumulative Update #10 (build 10.00.1835)    
    • SQL Server 2008 RTM Cumulative Update #9 (build 10.00.1828)   
    • SQL Server 2008 RTM Cumulative Update #8 (build 10.00.1823)
    • SQL Server 2008 RTM Cumulative Update #7 (build 10.00.1818)
    • SQL Server 2008 RTM Cumulative Update #6 (build 10.00.1812)
    • SQL Server 2008 RTM Cumulative Update #5 (build 10.00.1806)
    • SQL Server 2008 RTM Cumulative Update #4 (build 10.00.1798)
    • SQL Server 2008 RTM Cumulative Update #3 (build 10.00.1787) 
    • SQL Server 2008 RTM Cumulative Update #2 (build 10.00.1779)
    • SQL Server 2008 RTM Cumulative Update #1 (build 10.00.1763)
    • SQL Server 2008 RTM (build 10.00.1600.22)
       
    • Updated SQL Server 2008 Books Online (July 2009 Update)


    Also check related discussion threads in this forum about the Reporting Services 2008 release, and Report Builder 2.0 release.

  • Link
    Reporting Services 2005 - Resources & Latest Downloads (SP4)
    Robert Bruckner Thursday, February 05, 2009 9:44 PM

    Last update: Mar 27, 2011.

    MSDN information aggregator site for Reporting Services 2005. 

    Important downloads for Reporting Services 2005:

    SP4:

    • SQL Server 2005 SP4 Cumulative Update #3 (build 9.00.5266)
    • SQL Server 2005 SP4 Cumulative Update #2 (build 9.00.5259)
    • SQL Server 2005 SP4 Cumulative Update #1 (build 9.00.5254)
    • SQL Server 2005 SP4 RTM, Express Edition RTM (build 9.00.5000)

    SP3:

    • SQL Server 2005 SP3 Cumulative Update #15 (build 9.00.4325) 
    • SQL Server 2005 SP3 Cumulative Update #14 (build 9.00.4317) 
    • SQL Server 2005 SP3 Cumulative Update #13 (build 9.00.4315) 
    • SQL Server 2005 SP3 Cumulative Update #12 (build 9.00.4311)
    • SQL Server 2005 SP3 Cumulative Update #11 (build 9.00.4309) 
    • SQL Server 2005 SP3 Cumulative Update #10 (build 9.00.4305)  
    • SQL Server 2005 SP3 Cumulative Update #9 (build 9.00.4294)   
    • SQL Server 2005 SP3 Cumulative Update #8 (build 9.00.4285)    
    • SQL Server 2005 SP3 Cumulative Update #7 (build 9.00.4273)   
    • SQL Server 2005 SP3 Cumulative Update #6 (build 9.00.4266)  
    • SQL Server 2005 SP3 Cumulative Update #5 (build 9.00.4230) 
    • SQL Server 2005 SP3 Cumulative Update #4 (build 9.00.4226)   
    • SQL Server 2005 SP3 Cumulative Update #3 (build 9.00.4220)   
    • SQL Server 2005 SP3 Cumulative Update #2 (build 9.00.4211)   
    • SQL Server 2005 SP3 Cumulative Update #1 (build 9.00.4207) 
    • SQL Server 2005 SP3 RTM (build 9.00.4035)  

    SP2:

    • SQL Server 2005 SP2 Cumulative Update #17 (build 9.00.3356) - Final CU for SP2   
    • SQL Server 2005 SP2 Cumulative Update #16 (build 9.00.3355)   
    • SQL Server 2005 SP2 Cumulative Update #15 (build 9.00.3330)  
    • SQL Server 2005 SP2 Cumulative Update #14 (build 9.00.3328) 
    • SQL Server 2005 SP2 Cumulative Update #13 (build 9.00.3325) 
    • SQL Server 2005 SP2 Cumulative Update #12 (build 9.00.3315) 
    • SQL Server 2005 SP2 Cumulative Update #11 (build 9.00.3301) 
    • SQL Server 2005 SP2 RTM (build 9.00.3042) 
       
    • RS Add-in for SharePoint Integrated Mode (SP3 download, SP2 download) 
    • SQL Server 2005 Books Online (December 2008 Update)

     

  • Link
    Reporting Services 2012 - Power View
    Robert Bruckner Friday, November 18, 2011 5:08 AM

    SQL Server 2012 has been released in early 2012.

    This post summarizes much of the new functionality in Power View with RC0. A few more capabilities were added in the RTM Version.

    Multiple Views in a Single Report

    You asked for it, and we are delivering it! Power View reports now support multiple views per report. The report pictured below contains a total of five views that you can see previews of to the left of the canvas.

    MultipleViews

    Export to Microsoft PowerPoint

    Along with the ability to create reports with multiple views, you can also export your report to PowerPoint. These are not just static images. Power View reports inside PowerPoint are fully interactive.

    PowerPoint Export

    PowerPivot Gallery Preview Images

    Power View now produces preview images in the PowerPivot Gallery, just like Excel workbooks. They are supported in all views of the PowerPivot Gallery (gallery, theater and carousel).


    PowerPivot Gallery Preview
    In addition, now that Power View reports support multiple views in a single report, when you click on a specific view of the report, Power View will launch with that view as the active view.

    Storyboard

    When you are presenting reports with multiple views in them, there is way to navigate the views in a report called storyboard. Just hover to preview any of the views and select the one you want to display.

    Storyboard

    Sorting

    We are certain you saw this one coming, but Power View now supports sorting on all data regions. On tables and matrices, all you have to do is click on the column headers to sort. For charts, there is an area above the chart that we call the “floatie” that allows you to choose to sort the chart by a measure or its categories.ChartSorting

    For charts that are displayed as multiples, you can sort those too. For multiples, sorting sorts the charts themselves by a subtotal, and of course, it’s just a click away via the floatie as well.
    MultipleSorting

    More Chart Features

    Power View has added more functionality to charts. In particular, charts now support
    • more than 20 series,
    • multiple measures,
    • and color (series) in scatter and bubble charts.
    The chart below shows multiple measures in action, depicting the average win percentage of major league baseball both at home and on the road over a set of years.
    MultipleSeries
    In the next chart, you can see colors assigned on the scatterplot.
    ScatterPlot
    Of course, the feature works with legend highlighting as well. Select a market size from the legend and all of the points associated with that entry will be highlighted in the chart.
    ScatterPlotHighlighting

    Chart Highlighting Enhancements

    There is also significant change to the highlighting feature with charts. When your column and bar charts contain non additive data, Power View will now display the highlighted values with a thinner column that is overlaid on top of the previous values. This is done to make it possible to see the previous values, regardless of the highlighted values.
    It also makes it possible to see cases where the selected item from another visual has no representation in the chart. For example, in the chart below, not only can we see how Expressjet compares against the average of all carriers for flights delayed by carrier, but we also can see that Expressjet did not operate any routes greater than 1,500 miles.
    ChartHighlighting

    Number Formatting for Tables and Matrix

    Power View now supports number formatting on both tables and matrix.
    NumberFormatting

    Slicers Cross Filter Other Slicers

    When you have multiple slicers on a view now, if you select an entry in one slicer, the other slicers in the view are filtered by it.

    Per Data Region Filtering

    Filtering improvements are available in RC0. Power View now supports filters on each data region. The picture below shows the chart region filter selected in the filter pane. If you want to switch to filtering the entire view, just hover over the grey “view” text and select it and you’ll be on your way to filtering the entire view.
    Filtering

    Measure Filters and Filter Restatement

    There are two other new features in the filter pane depicted above as well. The filter pane now supports measure filters and will also restate your filters even when a specific filter is in its collapsed state.
    MeasureFiltering

    Search in Filters

    But we’re not done yet. Have a long list of categories that you don’t want to wade through, use the search feature.
    SearchFilter

    SearchFilterResult

    Drag Your Data to the Canvas

    You can now drag fields directly to the canvas from the model explorer. If you hover the field over the canvas, it will create a new table. If you hover the field over an existing visualization, it will add that field to the next logical location in the visualization.
    DragDrop

    Print it!

    You can now print your current view. Print is “what you see is what you get”.
    Print

     

    Support for DirectQuery mode

    DirectQuery mode for Analysis Services tabular models allows you to keep your data in a SQL Server relational database and still get the benefits of interactive reporting with Power View. You can read all about direct query mode here.

    Database Image Support

    Power View now supports database images stored directly in the model.
    DatabaseImages

    Show Items with No Data

    Often referred to as “outer join”, Power View now supports the ability to display items with no data. The table below shows this feature in action.
    OuterJoin
    And just like everything else in Power View, this feature is just a click away in the field well.
    FieldWellOuterJoin

    Measures as Non-Measures

    PowerView also supports the ability to treat measures as non-measures (i.e. as categories). To do this, you just go to the field well and choose the option on the field to “Do Not Summarize” as shown below.
    MeasuresAsNonMeasures
    Below is an example of a report showing the count of airline flights by minutes late. Minutes late is a measure in the table on the left. The table on the right is the same table with the “Do Not Summarize” feature turned on.
    DoNotSummarize

    All New Canvas Look

    We’ve changed the overall look of the canvas and many of the items that you can place on the canvas. Here are a couple of examples of the new look in action.

    PowerView1

    PowerView2



  • Link
    Reporting Services 2008 R2 - Resources & Latest Downloads
    Robert Bruckner Monday, May 24, 2010 3:45 PM

    Last Update: Mar 4, 2011.

    SQL Server 2008 R2 was released to manufacturing on April 21, 2010.  You can read more about it here.

    Downloads available: 

    • Report Builder 3.0 RTM 
    • SQL Server 2008 R2 RTM - Developer Trial Edition
    • SQL Server 2008 R2 RTM - Express Edition with Advanced Services
    • SQL Server 2008 R2 RTM - Documentation
    • SQL Server 2008 R2 RTM - Feature Pack (with Report Builder and PowerPivot for Excel 2010)
    • Reporting Services 2008 R2 Add-in for SharePoint 2010
    • Visual Studio 2010 Report Viewer Redistributable

    Cumulative Updates:

    • SQL Server 2008 R2 RTM Cumulative Update #6 (build 10.50.1765)
    • SQL Server 2008 R2 RTM Cumulative Update #5 (build 10.50.1753)
    • SQL Server 2008 R2 RTM Cumulative Update #4 (build 10.50.1746)
    • SQL Server 2008 R2 RTM Cumulative Update #3 (build 10.50.1734)
    • SQL Server 2008 R2 RTM Cumulative Update #2 (build 10.50.1720)
    • SQL Server 2008 R2 RTM Cumulative Update #1 (build 10.50.1702)

    You can read about specific new Reporting Services features added in November CTP on top of what was available in August CTP.  You can research and ask questions on the dedicated MSDN forum. 

  • Link
    Reporting Services Migration Tool v1
    Tristan Fernando Sunday, April 22, 2012 10:54 PM

    We have released a beta version of the Reporting Services Migration Tool.  The tool is available for download at:

    http://www.microsoft.com/download/en/details.aspx?id=29560

    This tool essentially allows you to create a backup store of a native mode Report Server and then migrate that content to a SharePoint-integrated mode Report Server.  Migrated content includes all report items (reports, shared data sources, models, shared datasets, report parts), along with associated metadata (shared schedules, subscriptions, history snapshots, etc.).  Some additional details are in this blog post, along with the download link:

    http://blogs.msdn.com/b/jameswu/archive/2012/04/21/reporting-services-migration-tool.aspx

    We are working on enabling more features in this tool, so feel free to share any feedback or report any issues.  Thanks!

  • Link
    ** Please Include SSRS Version When Posting Questions
    Sean Boon Wednesday, April 22, 2009 4:45 AM
    When posting questions in this forum, please include the version of SQL Server Reporting Services you are using.  This will help us be more efficient in answering questions.  If you are using the Report Viewer Control, it will helpful if you include the version of the control as well. 

    Thanks,
    Sean

SQL Server Data Tools announcements

  • Link
    Updated Sql Server Data Tools for September 2013
    Jill McClenahan Wednesday, September 18, 2013 4:03 AM

    The September 2013 release has a targeted fix for the Schema Compare error when working with large display text or high DPI.  This release will replace the August 2013 release and contains the same bug fixes with this one additional fix.  We appreciate your patience while we worked to publish this update.

    Get it here:

    SSDT for Visual Studio 2012: http://msdn.microsoft.com/en-us/jj650015

    SSDT for Visual Studio 2010: http://msdn.microsoft.com/en-us/jj650014

    Contact Us

    If you have any questions or feedback, please visit our forum or Microsoft Connect page.  We look forward to hearing from you.

  • Link
    Issue Upgrading Data-Tier Application Framework through SSDT Check For Updates
    Adam Mahood [MSFT] Monday, November 19, 2012 7:05 PM

    Several customers have reported an issue when attempting to upgrade their installation of the Data-Tier Application Framework (DACFx) after being prompted by the SSDT Check For Updates feature.

    Symptom - On an x64 machine, SSDT continues to prompt to update to the latest release of DACFx (November 2012) even after installing the latest version from the DACFx download page.

    Issue - There is an issue in the DACFx detection logic of the SSDT Check for Updates feature such that you will continue to be prompted to update if you have only installed the x64 versions of the MSIs of the latest DACFx (November 2012) release.

    Workaround - If you are on an x64 machine, install both the x86 version and x64 version of DACFx and its dependencies from the DACFx download page here - http://go.microsoft.com/fwlink/?LinkID=266427

    We apologize for the inconvenience and thank you for reporting this issue.

    Thanks,

    Adam


  • Link
    SSDT - December 2012 Available for Download
    Janet Yeilding Friday, December 14, 2012 11:20 PM

    The SSDT team is pleased to announce that SQL Server Data Tools - December 2012 is now available for download!

     

    Get it here:

    SSDT for Visual Studio 2012: http://msdn.microsoft.com/en-us/jj650015

    SSDT for Visual Studio 2010: http://msdn.microsoft.com/en-us/jj650014

    What’s New?

    Database Unit Testing

    We have received an overwhelming amount of feedback that database unit testing is a critical feature for customers, so SSDT- December 2012 adds support for this feature. Database Unit Testing in SSDT will look familiar to many of you as it is based on the equivalent capability in the Visual Studio 2010 DB Pro tools.  Some highlights:

    • Installs in Visual Studio 2010 or Visual Studio 2012:
      • Requires Visual Studio Professional or higher edition to support database unit testing functionality.
      • Installs side-by-side with existing Visual Studio 2010 DB Pro tools in Visual Studio Premium and Ultimate editions.
    • Supports client-side testing based on MSTest with the same built-in test conditions as DB Pro.
    • Allows desktop development and execution of tests as well as execution from the command line or as part of a build on a build server.
    • Upgrades existing VS 2010 test projects without change to the database unit test scripts or code.
    • Integrates with SSDT SQL Server database projects:
      • Automates deployment of the database project on test initialization.
      • Generates skeleton test scripts for stored procedures, functions and triggers via SQL Server Object Explorer.
      • Applies changes to test scripts when refactoring objects in database projects.    
    • Supports custom test conditions (existing custom test conditions need to be modified before they can be used).

    Stay tuned for a follow-up post on getting started with SQL Server database unit testing. 

    Integration of SSDT Power Tools

    The SSDT team started releasing SSDT Power Tools last April as a mechanism to deliver new and experimental features with each release. Since then, the Power Tools have been downloaded over 24,500 times.

    We received a great deal of positive feedback on the Power Tools and as a response, this release integrates the functionality previously delivered via Power Tools into the core SSDT product. The advantage of product inclusion is that a separate install will no longer be needed and that features are now fully supported and available to users in all languages. The following features are now included in SSDT's SQL Server Object Explorer:

    Projects node adds the equivalent of Schema View to SSDT. You can use this node to browse the logical schema of your project and to edit, refactor, and add new objects. 

    Script As support in SSOX enables you to generate Create, Alter, Drop, and Drop and Create-To scripts for objects in your connected database.

    DAC actions allow you to perform similar DAC-based tasks in SSDT to those available in SSMS.  You can extract a dacpac from a live database, publish a dacpac to a database, register a database as a DAC, or remove the registration metadata for a database registered as a DAC. These actions are supported for both on-premises SQL Server databases as well as Windows Azure SQL Databases.

    clip_image003

    We recommend that you uninstall the SSDT Power Tools extension if you had it previously installed.

    Updated Data-Tier Application Framework

    This release includes the November 2012 release of SQL Server Data-Tier Application Framework (DACFx), which contains several feature enhancements and bug fixes.  You can learn more about the latest release of DACFx here.

    Bug fixes

    SSDT - December 2012 contains over 50 bug fixes, including fixes for customer-reported issues from SSDT - November 2012 and SSDT Power Tools releases.

    Contact Us

    If you have any questions or feedback about SSDT, please visit our forum or Microsoft Connect page.  We look forward to hearing from you.


Microsoft StreamInsight announcements

  • Link
    StreamInsight V2.1 Released
    Roman Schindlauer Wednesday, June 27, 2012 11:42 PM

    Dear StreamInsight users,

    We just officially announced our new StreamInsight V2.1 release - you can find all the relevant information including download links in the StreamInsight blog!

    Regards,
    Roman

  • Link
    StreamInsight V1.2 Released
    Roman Schindlauer Monday, July 18, 2011 7:38 PM

    We just officially announced our new StreamInsight V1.2 release - you can find all the relevant information including download links in our latest blog posting!

    Regards,
    Roman

  • Link
    StreamInsight on Twitter
    Roman Schindlauer Tuesday, June 01, 2010 5:41 PM

    As appeared on the blog:

    Finally: The StreamInsight Development Team is now tweeting! Follow streaminsight to receive latest announcements and news. We are excited about the opportunity to use this push-channel to deliver messages to our developer and user community, that's the true spirit of an event-driven world!

    Regards,

    The StreamInsight Team

SQL Server Analysis Services announcements

  • Link
    FAQ - Analysis Services Information, Webcasts, Tools, Samples
    Edward Melomed Tuesday, December 16, 2008 11:27 PM
     References:

    Books On-Line Homepage

    Analysis Services Information Hub

    Tutorials

    Guded Tours

    SQL Server Customer Advisory Team

    TechNet Webcasts

    Videos on LernMicrosoftBI.com

    Product Code Samples

    Community Samples

    MDX Studio Project

Power Pivot announcements

  • Link
    Fix for PowerPivot November CTP Expiration Released
    Kathy MacDonald [MSFT] Wednesday, April 07, 2010 10:07 PM

    The PowerPivot team is pleased to report that the fix for the November CTP expiration issue has been released. We know many of you have been eagerly awaiting this fix since last week when the PowerPivot for Excel add-in expired. We do sincerely apologize for the inconvenience this may have caused you.

    We have released a new version of the November CTP for the PowerPivot for Excel add-in. This new version is functionally identical to the old one except that it extends the expiration date to end of the year. You can download it from the same locations as in the past:

    • http://powerpivot.com/download.aspx
    • http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=48a5b47b-8c9c-450f-ab6e-178600a733ca

    Please note that the new version will take some time to replicate across all servers in the Microsoft download center. If you download it from the above links and still get the expiration error message, then try again periodically. It might also help to clear any browser/download caches on your computer.

  • Link
    PowerPivot Beta will not work with released versions of Excel, Sharepoint 2010 and others. Pls read!!
    Vikram Jayaram Friday, February 05, 2010 9:16 PM


    Summary

    =============================

    If PowerPivot for Excel 2010, Excel 2010, SharePoint 2010, or the Reporting Services Addin for SharePoint 2010 are beta versions, PowerPivot and its related functionality will not work with the Released versions of these components.

     

    More Information

    =============================

    The beta versions of the components listed above are not compatible with the released versions of these components. If the beta versions of the components are installed, they will not function with the released versions. For example, if you have a beta version of the PowerPivot download installed and upgrade to the released version of Excel 2010, the PowerPivot addin will not be available in Excel.

     

    The solution is to upgrade the beta components to their released versions when they become available.

  • Link
    PowerPivot for Excel 2010 November CTP Expired
    Kathy MacDonald [MSFT] Friday, April 02, 2010 9:18 PM

    If you are running the November 2009 CTP version of the PowerPivot for Excel 2010 add-in, your add-in expired on April 1st. We apologize for any inconvenience this may have caused you.

    The SQL Server team will re-release the November 2009 CTP version of the PowerPivot for Excel 2010 add-in with an extended expiration date very soon. We will post an availability announcement with the download location and installation instructions on the PowerPivot blogs and forums as soon as possible.

    Kathy MacDonald
    SQL Server Analysis Services

SQL Server Database Engine announcements

  • Link
    SQL Server 2008 SP1 released
    Ed Lehman Wednesday, April 08, 2009 6:18 PM

    Service Pack 1 for SQL Server 2008 is now available for customers. The Service pack is available via download at http://www.microsoft.com/downloads/en/default.aspx and is primarily a roll-up of previous cumulative updates, quick fix engineering updates and minor fixes made in response to requests reported through the SQL Server community. While there are no new features in this service pack, customers running SQL Server 2008 should download and install SP1 to take advantage of the fixes which increase supportability and stability of SQL Server 2008.

     

    Customers have no reason to wait to upgrade to SQL Server 2008 and many are already taking advantage of SQL Server 2008 as a smart IT investment. In fact, there have been over 3 million downloads of SQL Server 2008 since the RTM in August. With this Service pack, Microsoft is introducing 80% fewer changes to customer configurations compared to previous SQL Server Service Pack releases. This remarkable decrease is a testament to a revised product development process and updated servicing strategy that is focused on ease of deployment while keeping customer environments stable.

     

    With this service pack, Microsoft has made investments to ease deployment and make management of service packs more efficient. Key improvements in SP1 include Slipstream, Service Pack Uninstall and Report Builder 2.0 click-once deployment.

    ·         Slipstream allows administrators to install SQL Server 2008 and Service Pack 1 in a single instance. This decreases the total time for an installation, including a fewer number of reboots thereby increasing productivity and deployment availability.

    ·         Service Pack Uninstall allows administrators to uninstall the service pack separately from the database release.  This feature also improves DBA productivity, reduces the cost of deployment and improves overall supportability

    ·         Report Builder 2.0 Click Once improves the existing SQL Server end-user report authoring application by easing deployment to business users

     

    To download the SQL Server 2008 Service Pack 1, please click here.

    For more information on SQL Server 2008, please click here.

SQL Server PowerPivot for SharePoint announcements

  • Link
    PowerPivot Beta will not work with released versions of Excel, Sharepoint 2010 and others. Pls read!!
    Vikram Jayaram Friday, February 05, 2010 9:17 PM

    Summary

    =============================

    If PowerPivot for Excel 2010, Excel 2010, SharePoint 2010, or the Reporting Services Addin for SharePoint 2010 are beta versions, PowerPivot and its related functionality will not work with the Released versions of these components.

     More Information
    =============================

    The beta versions of the components listed above are not compatible with the released versions of these components. If the beta versions of the components are installed, they will not function with the released versions. For example, if you have a beta version of the PowerPivot download installed and upgrade to the released version of Excel 2010, the PowerPivot addin will not be available in Excel.

  • Link
    Windows 2008 R2 and Windows 7 Patch Now Available
    Kathy MacDonald [MSFT] Friday, November 20, 2009 10:50 PM
    Some of you may have been waiting for the Windows 7 and Windows 2008 R2 QFE to be released before installing SharePoint 2010 and PowerPivot for SharePoint. The QFE has just been released!

    To read more about how to install the QFE with SharePoint 2010, please see: http://blogs.msdn.com/opal/archive/2009/11/16/installation-notice-for-sharepoint-2010-public-beta.aspx.

    Thanks ~

    Kathy MacDonald 

Database Design announcements

  • Link
    Database Design Resources
    Arnie Rowland Wednesday, December 23, 2009 8:40 PM

    The following list of database design resources is not intended to be exhaustive or ‘the correct list’. Items are included simply because one of the Moderators knew the material and offered it as a suggestion. If you wish to offer suggestions for inclusion, please do so.

     

    Books

     

    A Developer's Guide to Data Modeling for SQL Server: Covering SQL Server 2005 and 2008

    Eric Johnson and Joshua Jones

    An Introduction to Database Systems

    Chris Date

    Applied Mathematics for Database Professionals

    Lex de Haan, Toon Koppelaars

    Architecting Regulatory-Compliant Architectures
    Mike Walker, Microsoft

    Data Modeling Essential

    Graeme Simsion and Graham Witt

    Database Modeling and Design: Logical Design

    Toby Teorey

    Information Modeling and Relational Databases

    Terry Halpin

    Practical Issues in Database Management: A Reference for the Thinking Practitioner

    Fabian Pascal

    Pro SQL Server 2008 Relational Database Design and Implementation

    Louis Davidson, Kevin Kline, et al

     

    Online Resources

     

    A Simple Guide to Five Normal forms and Relational Database Theory
    http://www.bkent.net/Doc/simple5.htm

    Data Modeling vs. Database Design
    http://www.aisintl.com/case/library/R-Theory_vs_ER/r-theory_vs_er.html

    Data Models
    http://www.databaseanswers.org/data_models/index.htm

    Database Design - Ten Common Database Design Mistakes, Louis Davidson
    http://www.simple-talk.com/sql/database-administration/ten-common-database-design-mistakes/

    Database Design Issues -EAV Model Discussion (Querying an EAV Table)
    http://tinyurl.com/yks8hu

    Database Design Issues –EAV and OTLT
    http://tonyandrews.blogspot.com/2004/10/otlt-and-eav-two-big-design-mistakes.html

    Database Design ROI by Paul Nielsen
    http://www.sqlserverbible.com/files/databasedesignroi.pdf

    Introduction to the Unified Dimensional Model (UDM)
    http://technet.microsoft.com/en-us/library/ms345143(SQL.90).aspx

    Library of database models
    http://www.databaseanswers.org/data_models/

    On Normalization and Repeating Groups by Fabian Pascal
    http://www.dbdebunk.com/page/page/622318.htm

    ORM white paper
    http://www.orm.net/pdf/ORMwhitePaper.pdf

    Overview of the Relational Model
    http://www.utexas.edu/its/archive/windows/database/datamodeling/rm/overview.html   

    Understanding Data Model Quality, Graeme Simsion
    http://www.tdan.com/view-articles/5100

     

  • Link
    Please READ before Posting or Replying to Posts
    Arnie Rowland Monday, December 07, 2009 6:27 PM

     


    Out of Scope
     

    Some topics are out of scope for this forum.

    1. Bugs, Product Decisions, and Feedback: The purpose of this forum is not to ask the product team why decisions were made and to ask them to make other changes. That feedback belongs in Connect. The purpose of this forum is to help you out with specific issues, if possible. Please post your feedback via Connect:

    https://connect.microsoft.com/SQLServer

      

    Rules of Conduct

    ·         Relevance to Topics: We encourage you to keep your postings as close to the subject as possible.

    ·         Respect: Please be respectful of other participants, and their contributions; avoiding insults, demeaning remarks and slurs.

    ·         Tolerance: Please don’t assume someone’s curtness was meant to insult, slur, or demean you.

    ·         Confidentiality: Confidential information should not be posted. This is a publicly available forum.

    ·         Appropriate Language: Please keep the conversation on a professional level, avoiding any hint of profanity in your interactions.

    ·         Advertising/Solicitation: Advertisements should not be posted, and will be removed.

    Forum Moderators may, at their discretion, edit posts for clarity, readability and inappropriate language; split post into separate threads when appropriate; and delete post that do not positively contribute to the thread. Failure to comply with these 'Rules of Conduct' may result in your posts being edited to remove the offending comments, censure, or expulsion from participating in the Forums. The bottom line is: this Forum should feel like a ‘safe’ place to ask hard questions that invoke passionate responses.

    Marking Answers

    By their very nature, many database design questions will not have a easily decernible 'answer'. You are encouraged to give folks 'credit' for helping you when appropriate. If someone's response was 'Helpful', use the 'Vote as Helpful' button. If a response answered some part of your question, or provided you one or more clues that led you to a solution, then use the 'Mark as Answer' option. Just as a thread may evolve into multiple questions, it may also have more than one 'Answer'.

    Welcome to the Database Design Forum

    This is a Forum for questions and discussions about database designs for Microsoft technologies, including: SQL Server, Access, SQL Azure, SQL Express, SQL Compact, etc. Often Database Designs will be generic and can be ported to any vendor's technology. Design problems that are best solved with other technologies will be welcomed and addressed to the best of our knowledge and ability.

    We ask that you recognize that database design is a mixture of art and science. You may receive conflicting suggestions, for there can be multiple paths to a workable solution. You will have to use your own judgment and knowledge of your business requirements to determine the best solution for your particular problem. The 'right' design is compounded by many factors, including business, regulatory, hardware/software requirements, as well as staff expertise. We also encourage you to share your experiences with a particular design issue if it will serve to help others encountering similar problems.

    In order to receive useful responses, please spend some time and properly present your scenario. Attempts to 'save time and effort' by cutting out parts of the scenario will often lead to wasted time and effort as the suggestions have to be discarded because they don't work with other parts of the unseen puzzle.


    But there are limits to what you can expect from volunteers through a disconnected medium. The questions most likely to receive a good and targeted answer, are those that present a small problem, that give a very clear description of that problem within its context, and that are placed by people with a fair understanding of the subject who need help getting over a few nasty bumps. The questions that are almost impossible to answer satisfactorily are those that present a huge problem, with no clear description, and asked by someone totally new to the subject matter.

    We hope that you will understand when we say that most of us that volunteer our time on this Forum do so in order to help folks learn. We will be pleased if you find the Forum to be useful. However, it is difficult or impossible for us to engage with folks privately. We don't have time to do both, and our commitment is help folks using the Forums.

    Do not hesitate to read all of the threads, join in the discussions, offer your own experiences and information, and ask questions to increase your knowlege. Seek out blogs from those who write in a manner that you appreciate, and consider reviewing the Database Design Resources for additional guidance and help.

     

SQL Server Compact announcements

  • Link
    SQL Server Compact 4.0 downloads and feature information
    ErikEJ Sunday, April 03, 2011 1:11 PM
    This post on my blog should have links to all required information.

SQL Server Notification Services announcements

  • Link
    Please Direct SQLDependency/Query Notification and DBMail Questions to the Appropriate Forums
    Lukasz Pawlowski -- MS Friday, May 21, 2010 7:36 PM

    The following forums can be used to post questions and discussion about the topics: SQLDependency/Query Notification and DBMail.

    Please use
    http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/threads for SQLDependency and Query Notification.

    Please use http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/threads for DBMail.

    (Attribution: Jang-uk In)

    Hope that helps,

    -Lukasz

  • Remove From My Forums

Forums [ view all ]

Selected forums

Clear
SQL Server Master Data Services
x
Microsoft Drivers for PHP for SQL Server
x
SQL Server Setup & Upgrade
x
SQL Service Broker
x
SQL Server Migration
x
SQL Server Spatial
x
SQL Server Tools
x
SQL Server Security
x
SQL Server Search
x
Getting started with SQL Server
x
SQL Server Documentation
x
SQL Server High Availability and Disaster Recovery
x
.NET Framework inside SQL Server
x
SQL Server Express
x
SQL Server Integration Services
x
SQL Server Samples and Community Projects
x
Data Mining
x
SQL Server Replication
x
SQL Server SMO/DMO
x
SQL Server Reporting Services, Power View
x
SQL Server Data Tools
x
Microsoft StreamInsight
x
SQL Server Analysis Services
x
Database Mirroring
x
SQL Server Data Warehousing
x
SQL Server Manageability
x
SQL Server Distributed Replay
x
Power Pivot
x
SQL Server Database Engine
x
Transact-SQL
x
SQL Server Data Access
x
SQL Server PowerPivot for SharePoint
x
SQL Server Data Quality Services
x
SQL Server Application and Multi-Server Management
x
SQL Server XML
x
Database Design
x
SQL Server Compact
x
SQL Server Notification Services
x
+ 28 more
Filter : All threads
All threads
Answered
Unanswered
Proposed answers
General discussion

No replies
Helpful
Has code

All languages
Sort : Most recent post
  • Most recent post
  • Most recent thread
  • Total votes
  • Total replies
  • large check mark
    Unanswered
    0
    Votes

    SQL Server 2012 - Issue with Full-Text Search on FileTable

    SQL Server
     > 
    SQL Server Search
    Please bare with me as I am new to Full-Text Searches and FileTables.   I am working on a resume search system.  I created a FileTable and the Share which contains about ...
    10 Replies | 234 Views | Created by Wade A. Chestnut - Friday, April 11, 2014 4:28 PM | Last reply by Wade A. Chestnut - a few seconds ago
  • large check mark
    Unanswered
    0
    Votes

    SSIS OLE DB connection using SSL, how to verify it is using SSL

    SQL Server
     > 
    SQL Server Integration Services
    I created an 2008 SSIS package which uses a Connection Manger connection to an iSeries host. It uses an IBM i Access for Windows OLE DB driver - IBMDA400. (OLD DB Provider: IBM DB2 for i IBMDA400 ...
    0 Replies | 6 Views | Created by TheBrenda - 4 minutes ago
  • large check mark
    Unanswered
    0
    Votes

    SSMS 2014 Crashes After Installation

    SQL Server
     > 
    SQL Server Setup & Upgrade
    Just finished re-installing SQL Server 2014 (Dev Edition x64) and when opening SSMS for the first time, I get the following error: Problem signature:   ...
    0 Replies | 9 Views | Created by davelm42 - 6 minutes ago
  • large check mark
    Unanswered
    0
    Votes

    SQL SERVER 2012 EXPRESS Server Roles

    SQL Server
     > 
    SQL Server Security
    Hi , I am trying to check the Server Roles properties in SQL SERVER 2012 EXPRESS. I log on as the user "sa" who has the sysadmin ...
    2 Replies | 34 Views | Created by qdb.t - 1 hour 3 minutes ago | Last reply by qdb.t - 6 minutes ago
  • large check mark
    Unanswered
    0
    Votes

    design question - alternative to CASE statement in JOIN

    SQL Server
     > 
    Transact-SQL
    Hi Experts, I'm hoping someone knows the alternative to a CASE statement in a join. I have a sproc that builds a table that's a cross join of a set of dimension tables. Its purpose is to create a row ...
    6 Replies | 149 Views | Created by SSIS struggler - Friday, May 02, 2014 8:43 PM | Last reply by Naomi N - 8 minutes ago
  • large check mark
    Unanswered
    0
    Votes

    JOIN - unrecognized values

    SQL Server
     > 
    Transact-SQL
    Hello, I have a simple join operation as follows: TableA (department, transaction_year, company ... ) TableB(department, ...
    4 Replies | 45 Views | Created by sedso - 1 hour 19 minutes ago | Last reply by Naomi N - 11 minutes ago
  • large check mark
    Unanswered
    0
    Votes

    Using Punctuations in Full Text Searches

    SQL Server
     > 
    SQL Server Search
    Hi, I'm having a bit of trouble implementing full text search effectively in regards to punctuations. In my thesaurus file I have something along the lines ...
    2 Replies | 127 Views | Created by ChaoticLoki - Tuesday, April 22, 2014 9:28 AM | Last reply by SQLWork - 12 minutes ago
  • large check mark
    Unanswered
    0
    Votes

    Calling conection to script task to validate sql statement

    SQL Server
     > 
    SQL Server Integration Services
    Can we pass a a variable in Execute SQL task as sql statement?
    1 Replies | 22 Views | Created by rama rose - 22 minutes ago | Last reply by ArthurZ - 16 minutes ago
  • large check mark
    Unanswered
    0
    Votes

    SSIS OLE DB Source editor does not load all the access database tables

    SQL Server
     > 
    SQL Server Integration Services
    Hi, I have access database where I have couple of hundred tables and I am trying to import all the tables to SQL server using SSIS but in OLEDB source editor ...
    3 Replies | 63 Views | Created by srinivasable - 3 hours 17 minutes ago | Last reply by ArthurZ - 17 minutes ago
  • large check mark
    Proposed
    0
    Votes

    Better way than multiple JOINs to same table?

    SQL Server
     > 
    Transact-SQL
    I am looking for a better way to write this query.  The query uses the results from a CTE created previously which has these columns: ( ...
    7 Replies | 263 Views | Created by ken2k12 - Friday, May 02, 2014 11:11 PM | Last reply by ken2k12 - 20 minutes ago
  • large check mark
    Unanswered
    0
    Votes

    sql mirroring or sql dag?

    SQL Server
     > 
    SQL Server Manageability
    im running sql 2012 in both primary and secondary site. I have an app that uses primary site. Should i use db mirroring so that the app in the econdary site can access the same replica instance or can ...
    1 Replies | 32 Views | Created by JonDoe321 - Sunday, May 04, 2014 4:49 PM | Last reply by Prashanth Jayaram - 24 minutes ago
  • large check mark
    Unanswered
    3
    Votes

    Print dialog in SSRS reports not localized

    SQL Server
     > 
    SQL Server Reporting Services, Power View
    <p>Hi, I am facing issue in SSRS reports toolbar Print dialog localization. It does appear for french but not for polish.Can someone tell me if this is Microsoft ...
    2 Replies | 146 Views | Created by ArchanaSivakumar - Friday, May 02, 2014 11:59 PM | Last reply by ArchanaSivakumar - 24 minutes ago
  • large check mark
    Unanswered
    0
    Votes

    Tabular DAX Query for MINX, MAXX and AVGX

    SQL Server
     > 
    SQL Server Analysis Services
    Hi, I need to create three measure to get value of min, max and avg. For example, I have 3 columns in my table. I need to take minimum value of Column3 ...
    6 Replies | 148 Views | Created by KANNANPSY - Sunday, May 04, 2014 6:47 AM | Last reply by KANNANPSY - 27 minutes ago
  • large check mark
    Unanswered
    0
    Votes

    restore backup problem

    SQL Server
     > 
    SQL Server Manageability
    >restore>>database and then change source to device then click on browse icon and then try to choose a backup file, it takes two long to verify backup media, some times it ...
    6 Replies | 50 Views | Created by hamed23100 - 3 hours 3 minutes ago | Last reply by hamed23100 - 36 minutes ago
  • large check mark
    Unanswered
    0
    Votes

    SQL Server Management Studio 2012 freezes when adjusting options

    SQL Server
     > 
    Getting started with SQL Server
    I am using the following components with Windows 7: Microsoft SQL Server Management Studio 11.0.3128.0 Microsoft Analysis Services Client Tools ...
    0 Replies | 27 Views | Created by MsTiggy - 38 minutes ago
  • large check mark
    Unanswered
    0
    Votes

    SSRS Prior and Next Functions

    SQL Server
     > 
    SQL Server Reporting Services, Power View
    I have several reports in Hyperion that I use the next and prior functions to look at the row right before and/or the row after. To do this, I sort the data in a certain way to make ...
    2 Replies | 45 Views | Created by grahamtribe - 1 hour 46 minutes ago | Last reply by grahamtribe - 38 minutes ago
  • large check mark
    Answered
    0
    Votes

    Display the names in the next line

    SQL Server
     > 
    Transact-SQL
    Hello, I am working on a query that should display the contact names in the next line. This is the query I am working on declare @contactlist ...
    5 Replies | 92 Views | Created by srisql - 4 hours 49 minutes ago | Last reply by srisql - 42 minutes ago
  • large check mark
    Unanswered
    0
    Votes

    What is the best way to send auto mail with excel(generated by query) attachment?

    SQL Server
     > 
    SQL Server Integration Services
    Hello, Need to generate first data from stored procedure and the save it to an excel file and then send mail with the same excel file. So am searching for the ...
    2 Replies | 66 Views | Created by ajay_kumar22m - 14 hours 17 minutes ago | Last reply by Prashanth Jayaram - 45 minutes ago
  • large check mark
    Answered
    0
    Votes

    Question on Product Key

    SQL Server
     > 
    SQL Server Setup & Upgrade
    I don't know why my manager is asking...  But he would like to know if in the install package, there must be a file that holds the Product Key so that when setup is run the key automatically ...
    3 Replies | 50 Views | Created by lcerni - 1 hour 45 minutes ago | Last reply by lcerni - 49 minutes ago
  • large check mark
    Unanswered
    0
    Votes

    Write specific cell in excel through script task in SSIS

    SQL Server
     > 
    SQL Server Integration Services
    Hey guys.. I've task to update specific cells in excel. I need to create a table of data,bold it and color them as well in excel. This should happen in multiple ...
    1 Replies | 44 Views | Created by VJ DB trendz - 2 hours 19 minutes ago | Last reply by ArthurZ - 50 minutes ago
  • Items 1 to 20 of 380880 Next ›
Announcement: 33

SQL Server Master Data Services announcements

  • Link
    Please Indicate "Mark as Answer" if a Post has Answered the Question
    edhickey Wednesday, June 23, 2010 8:39 PM

    While reading a reply to your question, you will notice a button with an icon that says "Mark as Answer."   Please select this button when a reply answers your question.

     

    There are several reasons to do this:

     

    • Our search engine weights Answered questions more highly. By marking Answers you increase the chances that others searching this forum will find the answer directly rather than re-posting the question.
    • You give credit to the hard working folks who answer your questions. This is peer to peer support, so recognition is our only reward. (Check out the Top Answerers in 30 Days chart at the bottom of the thread list to see who is currently answering questions.)
    • You help Microsoft to track the health of this forum. Our forum gets 'measured' based on how many unanswered questions are in it at any time and we work hard to keep those numbers to as low a level as possible. By marking answers, others get a more accurate understanding of how well (or badly) things are going on the forum.

     

    You can also vote "Yes" or "No" if the reply was helpful.

     

    Thank you!

     

    Ed Hickey

SQL Server Setup & Upgrade announcements

  • Link
    AVAILABLE: SQL Server 2012 Upgrade Technical Guide
    Ahmed Ibrahim - MSFT Wednesday, May 16, 2012 5:01 AM
    • Customer-ready SQL Server 2012 Upgrade Technical Guide(How to upgrade).
    • What's new.(Why upgrade)

SQL Server Migration announcements

  • Link
    Welcome to the SQL Server Migration forum
    Keshav Ramarao Wednesday, April 28, 2010 2:14 AM

    Need help with migration to SQL Server? Have any questions related to SQL Server Migration Assistant (SSMA) products for Oracle/Sybase/MySQL/Access? Feel free to discuss any SQL Server migration related topics or post any questions related to SSMA.

.NET Framework inside SQL Server announcements

  • Link
    Scope and purpose of this forum
    Bob Beauchemin Tuesday, August 14, 2012 8:28 PM

    This forum covers questions regarding .NET assemblies and database objects running as part of SQL Server including user-defined types, user-defined aggregates, UDFs, triggers, and stored procedures implemented in .NET code. supported by SQL Server 2005 and later versions. Other questions regarding SQL Server database access and other related technologies should be directed to the most appropriate forum to obtain the best response.

    Questions on SQL Server .NET Client (SqlClient) data access should be posted to the ADO.NET data provider forum: http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/threads

    Questions on using SQL Server with ASP.NET should be posted to the ASP.NET forums: http://forums.asp.net/

    Questions on writing Transact-SQL code, including T-SQL stored procedures, UDFs, and triggers: http://social.technet.microsoft.com/Forums/en-US/transactsql/threads

    Questions on installation problems pertaining to .NET installations should be posted to the SQL Server Setup and Upgrade forum: http://social.technet.microsoft.com/Forums/en-US/sqlsetupandupgrade/threads

    Questions on problems using SQL Server Data Tools: http://social.technet.microsoft.com/Forums/en-US/sqltools/threads

    Questions on using other Data Access APIs (e.g. ODBC, OLE DB): http://social.technet.microsoft.com/Forums/en-US/sqldataaccess/threads

    Questions on writing code for SQL Server Compact Edition: http://social.technet.microsoft.com/Forums/en-US/sqlce/threads

    Questions on SQL Server Express-specific issues: http://social.technet.microsoft.com/Forums/en-US/sqlexpress/threads

    Questions that are off-topic in this forum may be moved to one of the other, more relevent, forums to ensure the best, most prompt response and facilitate forum-specific searchng for similar questions that have already been resolved.

SQL Server Express announcements

  • Link
    Some useful links to download SQL Server 2008 and 2008 R2 Express (RTM)
    Papy Normand Monday, May 09, 2011 3:29 PM

    Hello,

    Many thanks to Rick Byham who provided me these links :

    - SQL Server 2008 Express RTM http://www.microsoft.com/downloads/en/details.aspx?FamilyID=58ce885d-508b-45c8-9fd3-118edd8e6fff

    - SQL Server 2008 Express with Advanced services RTM http://www.microsoft.com/downloads/en/details.aspx?FamilyID=b5d1b8c3-fda5-4508-b0d0-1311d670e336

    - SQL Server 2008 R2 Express RTM http://www.microsoft.com/downloads/en/details.aspx?FamilyID=8b3695d9-415e-41f0-a079-25ab0412424b

    - SQL Server 2008 R2 Express with Advanced services RTM http://www.microsoft.com/downloads/en/details.aspx?FamilyID=e08766ce-fc9d-448f-9e98-fe84ad61f135

    I will try to update these links when a new Service Pack or SQL Server "Denali" ( 2011 ? ) will be released

     

SQL Server Samples and Community Projects announcements

  • Link
    Welcome aboard! Community & Samples Forum Intro
    David Reed - MSFT Thursday, January 29, 2009 9:58 PM

    This forum is the place to discuss all things "samplish" in the SQL Server community and samples space, whether it's an "official Microsoft sample" or a community project in CodePlex or Code Gallery. This is *not* the place to discussion specific nuances of T-SQL syntax or wage data modeling methodology wars: there are lots of other forums for those purposes. This one is for questions about samples, community projects and conversations between the collaborators that build them.

     

    Some examples of projects that are open for discussion can be found here: http://www.codeplex.com/SqlServerSamples/ It doesn't have to be listed there to be fair game, but it's a good bet that it is fair game if it's already listed there.

     

    Also, please post your project announcements here when you create a new release or a whole new project. If you're looking for people to work on your project or looking for a project to work on, this would be a good place to do both.

     

    Let us know what's missing, let know what could be better and let us know what we're doing right!

  • Link
    Samples bugs and suggestions.
    David Reed - MSFT Monday, February 02, 2009 4:26 PM
    All of the work items for our community projects and product samples are in TFS on CodePlex. If you want to report a bug, suggest a change for an existing sample or suggest a new sample, create a work item in the appropriate project so that our community team (not just Microsoft employees) can vote on them, help us triage and prioritize them.

    For example, here's the URL for the work items for AdventureWorks: http://www.codeplex.com/MSFTDBProdSamples/WorkItem/AdvancedList.aspx
  • Link
    How to Use this Forum - Please Read Before Posting
    Mr. Wharty Tuesday, October 02, 2012 4:49 AM

    Welcome to the SQL Server Samples and Community Projects Forum.

    This forum is the place to discuss all things "samplish" in the SQL Server community and samples space, whether it's an "official Microsoft sample" or a community project in CodePlex or Code Gallery. This is*not* the place to discussion specific nuances of T-SQL syntax or wage data modeling methodology wars: there are lots of other forums for those purposes. This one is for questions about samples, community projects and conversations between the collaborators that build them.

    Some examples of projects that are open for discussion can be found here: http://www.codeplex.com/SqlServerSamples. It doesn't have to be listed there to be fair game, but it's a good bet that it is fair game if it's already listed there.

    Below are a few guidelines to help you find your answer quickly and also to help the people who answer the questions, answer yours correctly.

    • Is your question about SQL Server Samples and Community Projects . If it's not please locate the correct forum otherwise your question may be moved, closed/locked or deleted.
    • Try searching the forum . Search the forum to see if your question has been asked before and answered.  If you cannot find what you are looking for, please start a new thread rather than adding to an old one as some people do not see answered questions in their forum views so you may not get the assistance you're looking for.
    • Don't be brief . The more information you can give in your question, the better the response will be.
    • Check your alerts . You can subscribe to a question so that you can see any update on it (ReferSetting up your alerts below).
    • No Spam. Spamming will have your thread deleted and may also result in your account being banned.
    • Be polite.  You will get better assistance if you're polite to other members so no flaming or trolling.  If you persist with flaming or trolling, your accountmay get banned.
    • Mark your question answered. If someone answers your question please mark their reply as the answer to your question. You can also mark multiple replies as answers if you think they answered your question.  Marking replies not only assists others with similar questions, it also let's people know that you're grateful for their assistance.

    Dead thread/Answer policy.

    Where possible the moderators will allow sufficient time for the original poster to come back and mark the replies to their questions as answers. The amount of time is at the discretion of the individual moderator but is suggested that it will be declared dead after a week if the original poster does not respond . We will always try to be fair and mark suitable replies as answers.

    Setting up your alerts

    If you are having trouble receiving alerts on the threads you have created or replied to please see thisthread for troubleshooting advice.

Data Mining announcements

  • Link
    Live at BI Labs: SQL Server Data Mining for the Cloud
    Raman Iyer Friday, April 29, 2011 7:37 PM

    Microsoft BI Labs went live today featuring a look into the future of SQL Server Data Mining in the Cloud. The SQL Server Data Mining team presents a set of prototype web services  in the cloud that mirror some of the great predictive analytics functionality available in the Table Analysis Tools for Excel add-in from the SQL Server 2008 Data Mining Add-ins for Office package. No installation required.

     

    This blog post provides more details.

     

    Explore these predictive services from your browser - on your own data - and give us your feedback!

SQL Server Replication announcements

  • Link
    SQL Server 2005 SP3 is now available
    Greg Y Thursday, December 18, 2008 5:10 AM
    SQL Server 2005 SP3 is released, access it here.

    Read about what's new for Replication here.

    Many replication bugs were fixed in SP3, you can find your way through them here.

SQL Server Reporting Services, Power View announcements

  • Link
    Reporting Services 2008 - Resources & Latest Downloads (SP2)
    Robert Bruckner Thursday, February 05, 2009 9:44 PM
    Last update: Mar 27, 2011.


    Get an overview and the latest information on Reporting Services 2008 at the MSDN aggregation page for Reporting Services! 

    Important downloads for Reporting Services 2008:  

    SP2:

    • Report Builder 2.0 (SP2 Download)
      for Reporting Services 2008 (build 10.00.4000)
       
    • SQL Server 2008 SP2 Cumulative Update #3 (build 10.00.4279)
    • SQL Server 2008 SP2 Cumulative Update #2 (build 10.00.4272)
    • SQL Server 2008 SP2 Cumulative Update #1 (build 10.00.4266)
    • Download SQL Server 2008 SP2
    • Download SQL Server 2008 SP2 Express
    • Download SQL Server 2008 SP2 Feature Packs
       
    • RS 2008 SP2 Add-In for SharePoint Integrated Mode (build 10.00.4000) 
      Note: updates for the SharePoint add-in are available for each CU as well, just make sure to select the "..._RSSharepoin" download package.

    SP1:

    • RS 2008 SP1 Add-In for SharePoint Integrated Mode (build 10.00.2531) 
      Note: updates for the SharePoint add-in are available for each CU as well, just make sure to select the "..._RSSharepoin" download package.
       
    • SQL Server 2008 SP1 Cumulative Update #13 (build 10.00.2816)
    • SQL Server 2008 SP1 Cumulative Update #12 (build 10.00.2808)
    • SQL Server 2008 SP1 Cumulative Update #11 (build 10.00.2804)
    • SQL Server 2008 SP1 Cumulative Update #10 (build 10.00.2799)
    • SQL Server 2008 SP1 Cumulative Update #9 (build 10.00.2789)   
    • SQL Server 2008 SP1 Cumulative Update #8 (build 10.00.2775)   
    • SQL Server 2008 SP1 Cumulative Update #7 (build 10.00.2766)   
    • SQL Server 2008 SP1 Cumulative Update #6 (build 10.00.2757)   
    • SQL Server 2008 SP1 Cumulative Update #5 (build 10.00.2746)
    • SQL Server 2008 SP1 Cumulative Update #4 (build 10.00.2734)
    • SQL Server 2008 SP1 Cumulative Update #3 (build 10.00.2723) 
    • SQL Server 2008 SP1 Cumulative Update #2 (build 10.00.2714) 
    • SQL Server 2008 SP1 Cumulative Update #1 (build 10.00.2710)
    • SQL Server 2008 Service Pack 1 (build 10.00.2531)

    RTM:

    • SQL Server 2008 RTM Cumulative Update #10 (build 10.00.1835)    
    • SQL Server 2008 RTM Cumulative Update #9 (build 10.00.1828)   
    • SQL Server 2008 RTM Cumulative Update #8 (build 10.00.1823)
    • SQL Server 2008 RTM Cumulative Update #7 (build 10.00.1818)
    • SQL Server 2008 RTM Cumulative Update #6 (build 10.00.1812)
    • SQL Server 2008 RTM Cumulative Update #5 (build 10.00.1806)
    • SQL Server 2008 RTM Cumulative Update #4 (build 10.00.1798)
    • SQL Server 2008 RTM Cumulative Update #3 (build 10.00.1787) 
    • SQL Server 2008 RTM Cumulative Update #2 (build 10.00.1779)
    • SQL Server 2008 RTM Cumulative Update #1 (build 10.00.1763)
    • SQL Server 2008 RTM (build 10.00.1600.22)
       
    • Updated SQL Server 2008 Books Online (July 2009 Update)


    Also check related discussion threads in this forum about the Reporting Services 2008 release, and Report Builder 2.0 release.

  • Link
    Reporting Services 2005 - Resources & Latest Downloads (SP4)
    Robert Bruckner Thursday, February 05, 2009 9:44 PM

    Last update: Mar 27, 2011.

    MSDN information aggregator site for Reporting Services 2005. 

    Important downloads for Reporting Services 2005:

    SP4:

    • SQL Server 2005 SP4 Cumulative Update #3 (build 9.00.5266)
    • SQL Server 2005 SP4 Cumulative Update #2 (build 9.00.5259)
    • SQL Server 2005 SP4 Cumulative Update #1 (build 9.00.5254)
    • SQL Server 2005 SP4 RTM, Express Edition RTM (build 9.00.5000)

    SP3:

    • SQL Server 2005 SP3 Cumulative Update #15 (build 9.00.4325) 
    • SQL Server 2005 SP3 Cumulative Update #14 (build 9.00.4317) 
    • SQL Server 2005 SP3 Cumulative Update #13 (build 9.00.4315) 
    • SQL Server 2005 SP3 Cumulative Update #12 (build 9.00.4311)
    • SQL Server 2005 SP3 Cumulative Update #11 (build 9.00.4309) 
    • SQL Server 2005 SP3 Cumulative Update #10 (build 9.00.4305)  
    • SQL Server 2005 SP3 Cumulative Update #9 (build 9.00.4294)   
    • SQL Server 2005 SP3 Cumulative Update #8 (build 9.00.4285)    
    • SQL Server 2005 SP3 Cumulative Update #7 (build 9.00.4273)   
    • SQL Server 2005 SP3 Cumulative Update #6 (build 9.00.4266)  
    • SQL Server 2005 SP3 Cumulative Update #5 (build 9.00.4230) 
    • SQL Server 2005 SP3 Cumulative Update #4 (build 9.00.4226)   
    • SQL Server 2005 SP3 Cumulative Update #3 (build 9.00.4220)   
    • SQL Server 2005 SP3 Cumulative Update #2 (build 9.00.4211)   
    • SQL Server 2005 SP3 Cumulative Update #1 (build 9.00.4207) 
    • SQL Server 2005 SP3 RTM (build 9.00.4035)  

    SP2:

    • SQL Server 2005 SP2 Cumulative Update #17 (build 9.00.3356) - Final CU for SP2   
    • SQL Server 2005 SP2 Cumulative Update #16 (build 9.00.3355)   
    • SQL Server 2005 SP2 Cumulative Update #15 (build 9.00.3330)  
    • SQL Server 2005 SP2 Cumulative Update #14 (build 9.00.3328) 
    • SQL Server 2005 SP2 Cumulative Update #13 (build 9.00.3325) 
    • SQL Server 2005 SP2 Cumulative Update #12 (build 9.00.3315) 
    • SQL Server 2005 SP2 Cumulative Update #11 (build 9.00.3301) 
    • SQL Server 2005 SP2 RTM (build 9.00.3042) 
       
    • RS Add-in for SharePoint Integrated Mode (SP3 download, SP2 download) 
    • SQL Server 2005 Books Online (December 2008 Update)

     

  • Link
    Reporting Services 2012 - Power View
    Robert Bruckner Friday, November 18, 2011 5:08 AM

    SQL Server 2012 has been released in early 2012.

    This post summarizes much of the new functionality in Power View with RC0. A few more capabilities were added in the RTM Version.

    Multiple Views in a Single Report

    You asked for it, and we are delivering it! Power View reports now support multiple views per report. The report pictured below contains a total of five views that you can see previews of to the left of the canvas.

    MultipleViews

    Export to Microsoft PowerPoint

    Along with the ability to create reports with multiple views, you can also export your report to PowerPoint. These are not just static images. Power View reports inside PowerPoint are fully interactive.

    PowerPoint Export

    PowerPivot Gallery Preview Images

    Power View now produces preview images in the PowerPivot Gallery, just like Excel workbooks. They are supported in all views of the PowerPivot Gallery (gallery, theater and carousel).


    PowerPivot Gallery Preview
    In addition, now that Power View reports support multiple views in a single report, when you click on a specific view of the report, Power View will launch with that view as the active view.

    Storyboard

    When you are presenting reports with multiple views in them, there is way to navigate the views in a report called storyboard. Just hover to preview any of the views and select the one you want to display.

    Storyboard

    Sorting

    We are certain you saw this one coming, but Power View now supports sorting on all data regions. On tables and matrices, all you have to do is click on the column headers to sort. For charts, there is an area above the chart that we call the “floatie” that allows you to choose to sort the chart by a measure or its categories.ChartSorting

    For charts that are displayed as multiples, you can sort those too. For multiples, sorting sorts the charts themselves by a subtotal, and of course, it’s just a click away via the floatie as well.
    MultipleSorting

    More Chart Features

    Power View has added more functionality to charts. In particular, charts now support
    • more than 20 series,
    • multiple measures,
    • and color (series) in scatter and bubble charts.
    The chart below shows multiple measures in action, depicting the average win percentage of major league baseball both at home and on the road over a set of years.
    MultipleSeries
    In the next chart, you can see colors assigned on the scatterplot.
    ScatterPlot
    Of course, the feature works with legend highlighting as well. Select a market size from the legend and all of the points associated with that entry will be highlighted in the chart.
    ScatterPlotHighlighting

    Chart Highlighting Enhancements

    There is also significant change to the highlighting feature with charts. When your column and bar charts contain non additive data, Power View will now display the highlighted values with a thinner column that is overlaid on top of the previous values. This is done to make it possible to see the previous values, regardless of the highlighted values.
    It also makes it possible to see cases where the selected item from another visual has no representation in the chart. For example, in the chart below, not only can we see how Expressjet compares against the average of all carriers for flights delayed by carrier, but we also can see that Expressjet did not operate any routes greater than 1,500 miles.
    ChartHighlighting

    Number Formatting for Tables and Matrix

    Power View now supports number formatting on both tables and matrix.
    NumberFormatting

    Slicers Cross Filter Other Slicers

    When you have multiple slicers on a view now, if you select an entry in one slicer, the other slicers in the view are filtered by it.

    Per Data Region Filtering

    Filtering improvements are available in RC0. Power View now supports filters on each data region. The picture below shows the chart region filter selected in the filter pane. If you want to switch to filtering the entire view, just hover over the grey “view” text and select it and you’ll be on your way to filtering the entire view.
    Filtering

    Measure Filters and Filter Restatement

    There are two other new features in the filter pane depicted above as well. The filter pane now supports measure filters and will also restate your filters even when a specific filter is in its collapsed state.
    MeasureFiltering

    Search in Filters

    But we’re not done yet. Have a long list of categories that you don’t want to wade through, use the search feature.
    SearchFilter

    SearchFilterResult

    Drag Your Data to the Canvas

    You can now drag fields directly to the canvas from the model explorer. If you hover the field over the canvas, it will create a new table. If you hover the field over an existing visualization, it will add that field to the next logical location in the visualization.
    DragDrop

    Print it!

    You can now print your current view. Print is “what you see is what you get”.
    Print

     

    Support for DirectQuery mode

    DirectQuery mode for Analysis Services tabular models allows you to keep your data in a SQL Server relational database and still get the benefits of interactive reporting with Power View. You can read all about direct query mode here.

    Database Image Support

    Power View now supports database images stored directly in the model.
    DatabaseImages

    Show Items with No Data

    Often referred to as “outer join”, Power View now supports the ability to display items with no data. The table below shows this feature in action.
    OuterJoin
    And just like everything else in Power View, this feature is just a click away in the field well.
    FieldWellOuterJoin

    Measures as Non-Measures

    PowerView also supports the ability to treat measures as non-measures (i.e. as categories). To do this, you just go to the field well and choose the option on the field to “Do Not Summarize” as shown below.
    MeasuresAsNonMeasures
    Below is an example of a report showing the count of airline flights by minutes late. Minutes late is a measure in the table on the left. The table on the right is the same table with the “Do Not Summarize” feature turned on.
    DoNotSummarize

    All New Canvas Look

    We’ve changed the overall look of the canvas and many of the items that you can place on the canvas. Here are a couple of examples of the new look in action.

    PowerView1

    PowerView2



  • Link
    Reporting Services 2008 R2 - Resources & Latest Downloads
    Robert Bruckner Monday, May 24, 2010 3:45 PM

    Last Update: Mar 4, 2011.

    SQL Server 2008 R2 was released to manufacturing on April 21, 2010.  You can read more about it here.

    Downloads available: 

    • Report Builder 3.0 RTM 
    • SQL Server 2008 R2 RTM - Developer Trial Edition
    • SQL Server 2008 R2 RTM - Express Edition with Advanced Services
    • SQL Server 2008 R2 RTM - Documentation
    • SQL Server 2008 R2 RTM - Feature Pack (with Report Builder and PowerPivot for Excel 2010)
    • Reporting Services 2008 R2 Add-in for SharePoint 2010
    • Visual Studio 2010 Report Viewer Redistributable

    Cumulative Updates:

    • SQL Server 2008 R2 RTM Cumulative Update #6 (build 10.50.1765)
    • SQL Server 2008 R2 RTM Cumulative Update #5 (build 10.50.1753)
    • SQL Server 2008 R2 RTM Cumulative Update #4 (build 10.50.1746)
    • SQL Server 2008 R2 RTM Cumulative Update #3 (build 10.50.1734)
    • SQL Server 2008 R2 RTM Cumulative Update #2 (build 10.50.1720)
    • SQL Server 2008 R2 RTM Cumulative Update #1 (build 10.50.1702)

    You can read about specific new Reporting Services features added in November CTP on top of what was available in August CTP.  You can research and ask questions on the dedicated MSDN forum. 

  • Link
    Reporting Services Migration Tool v1
    Tristan Fernando Sunday, April 22, 2012 10:54 PM

    We have released a beta version of the Reporting Services Migration Tool.  The tool is available for download at:

    http://www.microsoft.com/download/en/details.aspx?id=29560

    This tool essentially allows you to create a backup store of a native mode Report Server and then migrate that content to a SharePoint-integrated mode Report Server.  Migrated content includes all report items (reports, shared data sources, models, shared datasets, report parts), along with associated metadata (shared schedules, subscriptions, history snapshots, etc.).  Some additional details are in this blog post, along with the download link:

    http://blogs.msdn.com/b/jameswu/archive/2012/04/21/reporting-services-migration-tool.aspx

    We are working on enabling more features in this tool, so feel free to share any feedback or report any issues.  Thanks!

  • Link
    ** Please Include SSRS Version When Posting Questions
    Sean Boon Wednesday, April 22, 2009 4:45 AM
    When posting questions in this forum, please include the version of SQL Server Reporting Services you are using.  This will help us be more efficient in answering questions.  If you are using the Report Viewer Control, it will helpful if you include the version of the control as well. 

    Thanks,
    Sean

SQL Server Data Tools announcements

  • Link
    Updated Sql Server Data Tools for September 2013
    Jill McClenahan Wednesday, September 18, 2013 4:03 AM

    The September 2013 release has a targeted fix for the Schema Compare error when working with large display text or high DPI.  This release will replace the August 2013 release and contains the same bug fixes with this one additional fix.  We appreciate your patience while we worked to publish this update.

    Get it here:

    SSDT for Visual Studio 2012: http://msdn.microsoft.com/en-us/jj650015

    SSDT for Visual Studio 2010: http://msdn.microsoft.com/en-us/jj650014

    Contact Us

    If you have any questions or feedback, please visit our forum or Microsoft Connect page.  We look forward to hearing from you.

  • Link
    Issue Upgrading Data-Tier Application Framework through SSDT Check For Updates
    Adam Mahood [MSFT] Monday, November 19, 2012 7:05 PM

    Several customers have reported an issue when attempting to upgrade their installation of the Data-Tier Application Framework (DACFx) after being prompted by the SSDT Check For Updates feature.

    Symptom - On an x64 machine, SSDT continues to prompt to update to the latest release of DACFx (November 2012) even after installing the latest version from the DACFx download page.

    Issue - There is an issue in the DACFx detection logic of the SSDT Check for Updates feature such that you will continue to be prompted to update if you have only installed the x64 versions of the MSIs of the latest DACFx (November 2012) release.

    Workaround - If you are on an x64 machine, install both the x86 version and x64 version of DACFx and its dependencies from the DACFx download page here - http://go.microsoft.com/fwlink/?LinkID=266427

    We apologize for the inconvenience and thank you for reporting this issue.

    Thanks,

    Adam


  • Link
    SSDT - December 2012 Available for Download
    Janet Yeilding Friday, December 14, 2012 11:20 PM

    The SSDT team is pleased to announce that SQL Server Data Tools - December 2012 is now available for download!

     

    Get it here:

    SSDT for Visual Studio 2012: http://msdn.microsoft.com/en-us/jj650015

    SSDT for Visual Studio 2010: http://msdn.microsoft.com/en-us/jj650014

    What’s New?

    Database Unit Testing

    We have received an overwhelming amount of feedback that database unit testing is a critical feature for customers, so SSDT- December 2012 adds support for this feature. Database Unit Testing in SSDT will look familiar to many of you as it is based on the equivalent capability in the Visual Studio 2010 DB Pro tools.  Some highlights:

    • Installs in Visual Studio 2010 or Visual Studio 2012:
      • Requires Visual Studio Professional or higher edition to support database unit testing functionality.
      • Installs side-by-side with existing Visual Studio 2010 DB Pro tools in Visual Studio Premium and Ultimate editions.
    • Supports client-side testing based on MSTest with the same built-in test conditions as DB Pro.
    • Allows desktop development and execution of tests as well as execution from the command line or as part of a build on a build server.
    • Upgrades existing VS 2010 test projects without change to the database unit test scripts or code.
    • Integrates with SSDT SQL Server database projects:
      • Automates deployment of the database project on test initialization.
      • Generates skeleton test scripts for stored procedures, functions and triggers via SQL Server Object Explorer.
      • Applies changes to test scripts when refactoring objects in database projects.    
    • Supports custom test conditions (existing custom test conditions need to be modified before they can be used).

    Stay tuned for a follow-up post on getting started with SQL Server database unit testing. 

    Integration of SSDT Power Tools

    The SSDT team started releasing SSDT Power Tools last April as a mechanism to deliver new and experimental features with each release. Since then, the Power Tools have been downloaded over 24,500 times.

    We received a great deal of positive feedback on the Power Tools and as a response, this release integrates the functionality previously delivered via Power Tools into the core SSDT product. The advantage of product inclusion is that a separate install will no longer be needed and that features are now fully supported and available to users in all languages. The following features are now included in SSDT's SQL Server Object Explorer:

    Projects node adds the equivalent of Schema View to SSDT. You can use this node to browse the logical schema of your project and to edit, refactor, and add new objects. 

    Script As support in SSOX enables you to generate Create, Alter, Drop, and Drop and Create-To scripts for objects in your connected database.

    DAC actions allow you to perform similar DAC-based tasks in SSDT to those available in SSMS.  You can extract a dacpac from a live database, publish a dacpac to a database, register a database as a DAC, or remove the registration metadata for a database registered as a DAC. These actions are supported for both on-premises SQL Server databases as well as Windows Azure SQL Databases.

    clip_image003

    We recommend that you uninstall the SSDT Power Tools extension if you had it previously installed.

    Updated Data-Tier Application Framework

    This release includes the November 2012 release of SQL Server Data-Tier Application Framework (DACFx), which contains several feature enhancements and bug fixes.  You can learn more about the latest release of DACFx here.

    Bug fixes

    SSDT - December 2012 contains over 50 bug fixes, including fixes for customer-reported issues from SSDT - November 2012 and SSDT Power Tools releases.

    Contact Us

    If you have any questions or feedback about SSDT, please visit our forum or Microsoft Connect page.  We look forward to hearing from you.


Microsoft StreamInsight announcements

  • Link
    StreamInsight V2.1 Released
    Roman Schindlauer Wednesday, June 27, 2012 11:42 PM

    Dear StreamInsight users,

    We just officially announced our new StreamInsight V2.1 release - you can find all the relevant information including download links in the StreamInsight blog!

    Regards,
    Roman

  • Link
    StreamInsight V1.2 Released
    Roman Schindlauer Monday, July 18, 2011 7:38 PM

    We just officially announced our new StreamInsight V1.2 release - you can find all the relevant information including download links in our latest blog posting!

    Regards,
    Roman

  • Link
    StreamInsight on Twitter
    Roman Schindlauer Tuesday, June 01, 2010 5:41 PM

    As appeared on the blog:

    Finally: The StreamInsight Development Team is now tweeting! Follow streaminsight to receive latest announcements and news. We are excited about the opportunity to use this push-channel to deliver messages to our developer and user community, that's the true spirit of an event-driven world!

    Regards,

    The StreamInsight Team

SQL Server Analysis Services announcements

  • Link
    FAQ - Analysis Services Information, Webcasts, Tools, Samples
    Edward Melomed Tuesday, December 16, 2008 11:27 PM
     References:

    Books On-Line Homepage

    Analysis Services Information Hub

    Tutorials

    Guded Tours

    SQL Server Customer Advisory Team

    TechNet Webcasts

    Videos on LernMicrosoftBI.com

    Product Code Samples

    Community Samples

    MDX Studio Project

Power Pivot announcements

  • Link
    Fix for PowerPivot November CTP Expiration Released
    Kathy MacDonald [MSFT] Wednesday, April 07, 2010 10:07 PM

    The PowerPivot team is pleased to report that the fix for the November CTP expiration issue has been released. We know many of you have been eagerly awaiting this fix since last week when the PowerPivot for Excel add-in expired. We do sincerely apologize for the inconvenience this may have caused you.

    We have released a new version of the November CTP for the PowerPivot for Excel add-in. This new version is functionally identical to the old one except that it extends the expiration date to end of the year. You can download it from the same locations as in the past:

    • http://powerpivot.com/download.aspx
    • http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=48a5b47b-8c9c-450f-ab6e-178600a733ca

    Please note that the new version will take some time to replicate across all servers in the Microsoft download center. If you download it from the above links and still get the expiration error message, then try again periodically. It might also help to clear any browser/download caches on your computer.

  • Link
    PowerPivot Beta will not work with released versions of Excel, Sharepoint 2010 and others. Pls read!!
    Vikram Jayaram Friday, February 05, 2010 9:16 PM


    Summary

    =============================

    If PowerPivot for Excel 2010, Excel 2010, SharePoint 2010, or the Reporting Services Addin for SharePoint 2010 are beta versions, PowerPivot and its related functionality will not work with the Released versions of these components.

     

    More Information

    =============================

    The beta versions of the components listed above are not compatible with the released versions of these components. If the beta versions of the components are installed, they will not function with the released versions. For example, if you have a beta version of the PowerPivot download installed and upgrade to the released version of Excel 2010, the PowerPivot addin will not be available in Excel.

     

    The solution is to upgrade the beta components to their released versions when they become available.

  • Link
    PowerPivot for Excel 2010 November CTP Expired
    Kathy MacDonald [MSFT] Friday, April 02, 2010 9:18 PM

    If you are running the November 2009 CTP version of the PowerPivot for Excel 2010 add-in, your add-in expired on April 1st. We apologize for any inconvenience this may have caused you.

    The SQL Server team will re-release the November 2009 CTP version of the PowerPivot for Excel 2010 add-in with an extended expiration date very soon. We will post an availability announcement with the download location and installation instructions on the PowerPivot blogs and forums as soon as possible.

    Kathy MacDonald
    SQL Server Analysis Services

SQL Server Database Engine announcements

  • Link
    SQL Server 2008 SP1 released
    Ed Lehman Wednesday, April 08, 2009 6:18 PM

    Service Pack 1 for SQL Server 2008 is now available for customers. The Service pack is available via download at http://www.microsoft.com/downloads/en/default.aspx and is primarily a roll-up of previous cumulative updates, quick fix engineering updates and minor fixes made in response to requests reported through the SQL Server community. While there are no new features in this service pack, customers running SQL Server 2008 should download and install SP1 to take advantage of the fixes which increase supportability and stability of SQL Server 2008.

     

    Customers have no reason to wait to upgrade to SQL Server 2008 and many are already taking advantage of SQL Server 2008 as a smart IT investment. In fact, there have been over 3 million downloads of SQL Server 2008 since the RTM in August. With this Service pack, Microsoft is introducing 80% fewer changes to customer configurations compared to previous SQL Server Service Pack releases. This remarkable decrease is a testament to a revised product development process and updated servicing strategy that is focused on ease of deployment while keeping customer environments stable.

     

    With this service pack, Microsoft has made investments to ease deployment and make management of service packs more efficient. Key improvements in SP1 include Slipstream, Service Pack Uninstall and Report Builder 2.0 click-once deployment.

    ·         Slipstream allows administrators to install SQL Server 2008 and Service Pack 1 in a single instance. This decreases the total time for an installation, including a fewer number of reboots thereby increasing productivity and deployment availability.

    ·         Service Pack Uninstall allows administrators to uninstall the service pack separately from the database release.  This feature also improves DBA productivity, reduces the cost of deployment and improves overall supportability

    ·         Report Builder 2.0 Click Once improves the existing SQL Server end-user report authoring application by easing deployment to business users

     

    To download the SQL Server 2008 Service Pack 1, please click here.

    For more information on SQL Server 2008, please click here.

SQL Server PowerPivot for SharePoint announcements

  • Link
    PowerPivot Beta will not work with released versions of Excel, Sharepoint 2010 and others. Pls read!!
    Vikram Jayaram Friday, February 05, 2010 9:17 PM

    Summary

    =============================

    If PowerPivot for Excel 2010, Excel 2010, SharePoint 2010, or the Reporting Services Addin for SharePoint 2010 are beta versions, PowerPivot and its related functionality will not work with the Released versions of these components.

     More Information
    =============================

    The beta versions of the components listed above are not compatible with the released versions of these components. If the beta versions of the components are installed, they will not function with the released versions. For example, if you have a beta version of the PowerPivot download installed and upgrade to the released version of Excel 2010, the PowerPivot addin will not be available in Excel.

  • Link
    Windows 2008 R2 and Windows 7 Patch Now Available
    Kathy MacDonald [MSFT] Friday, November 20, 2009 10:50 PM
    Some of you may have been waiting for the Windows 7 and Windows 2008 R2 QFE to be released before installing SharePoint 2010 and PowerPivot for SharePoint. The QFE has just been released!

    To read more about how to install the QFE with SharePoint 2010, please see: http://blogs.msdn.com/opal/archive/2009/11/16/installation-notice-for-sharepoint-2010-public-beta.aspx.

    Thanks ~

    Kathy MacDonald 

Database Design announcements

  • Link
    Database Design Resources
    Arnie Rowland Wednesday, December 23, 2009 8:40 PM

    The following list of database design resources is not intended to be exhaustive or ‘the correct list’. Items are included simply because one of the Moderators knew the material and offered it as a suggestion. If you wish to offer suggestions for inclusion, please do so.

     

    Books

     

    A Developer's Guide to Data Modeling for SQL Server: Covering SQL Server 2005 and 2008

    Eric Johnson and Joshua Jones

    An Introduction to Database Systems

    Chris Date

    Applied Mathematics for Database Professionals

    Lex de Haan, Toon Koppelaars

    Architecting Regulatory-Compliant Architectures
    Mike Walker, Microsoft

    Data Modeling Essential

    Graeme Simsion and Graham Witt

    Database Modeling and Design: Logical Design

    Toby Teorey

    Information Modeling and Relational Databases

    Terry Halpin

    Practical Issues in Database Management: A Reference for the Thinking Practitioner

    Fabian Pascal

    Pro SQL Server 2008 Relational Database Design and Implementation

    Louis Davidson, Kevin Kline, et al

     

    Online Resources

     

    A Simple Guide to Five Normal forms and Relational Database Theory
    http://www.bkent.net/Doc/simple5.htm

    Data Modeling vs. Database Design
    http://www.aisintl.com/case/library/R-Theory_vs_ER/r-theory_vs_er.html

    Data Models
    http://www.databaseanswers.org/data_models/index.htm

    Database Design - Ten Common Database Design Mistakes, Louis Davidson
    http://www.simple-talk.com/sql/database-administration/ten-common-database-design-mistakes/

    Database Design Issues -EAV Model Discussion (Querying an EAV Table)
    http://tinyurl.com/yks8hu

    Database Design Issues –EAV and OTLT
    http://tonyandrews.blogspot.com/2004/10/otlt-and-eav-two-big-design-mistakes.html

    Database Design ROI by Paul Nielsen
    http://www.sqlserverbible.com/files/databasedesignroi.pdf

    Introduction to the Unified Dimensional Model (UDM)
    http://technet.microsoft.com/en-us/library/ms345143(SQL.90).aspx

    Library of database models
    http://www.databaseanswers.org/data_models/

    On Normalization and Repeating Groups by Fabian Pascal
    http://www.dbdebunk.com/page/page/622318.htm

    ORM white paper
    http://www.orm.net/pdf/ORMwhitePaper.pdf

    Overview of the Relational Model
    http://www.utexas.edu/its/archive/windows/database/datamodeling/rm/overview.html   

    Understanding Data Model Quality, Graeme Simsion
    http://www.tdan.com/view-articles/5100

     

  • Link
    Please READ before Posting or Replying to Posts
    Arnie Rowland Monday, December 07, 2009 6:27 PM

     


    Out of Scope
     

    Some topics are out of scope for this forum.

    1. Bugs, Product Decisions, and Feedback: The purpose of this forum is not to ask the product team why decisions were made and to ask them to make other changes. That feedback belongs in Connect. The purpose of this forum is to help you out with specific issues, if possible. Please post your feedback via Connect:

    https://connect.microsoft.com/SQLServer

      

    Rules of Conduct

    ·         Relevance to Topics: We encourage you to keep your postings as close to the subject as possible.

    ·         Respect: Please be respectful of other participants, and their contributions; avoiding insults, demeaning remarks and slurs.

    ·         Tolerance: Please don’t assume someone’s curtness was meant to insult, slur, or demean you.

    ·         Confidentiality: Confidential information should not be posted. This is a publicly available forum.

    ·         Appropriate Language: Please keep the conversation on a professional level, avoiding any hint of profanity in your interactions.

    ·         Advertising/Solicitation: Advertisements should not be posted, and will be removed.

    Forum Moderators may, at their discretion, edit posts for clarity, readability and inappropriate language; split post into separate threads when appropriate; and delete post that do not positively contribute to the thread. Failure to comply with these 'Rules of Conduct' may result in your posts being edited to remove the offending comments, censure, or expulsion from participating in the Forums. The bottom line is: this Forum should feel like a ‘safe’ place to ask hard questions that invoke passionate responses.

    Marking Answers

    By their very nature, many database design questions will not have a easily decernible 'answer'. You are encouraged to give folks 'credit' for helping you when appropriate. If someone's response was 'Helpful', use the 'Vote as Helpful' button. If a response answered some part of your question, or provided you one or more clues that led you to a solution, then use the 'Mark as Answer' option. Just as a thread may evolve into multiple questions, it may also have more than one 'Answer'.

    Welcome to the Database Design Forum

    This is a Forum for questions and discussions about database designs for Microsoft technologies, including: SQL Server, Access, SQL Azure, SQL Express, SQL Compact, etc. Often Database Designs will be generic and can be ported to any vendor's technology. Design problems that are best solved with other technologies will be welcomed and addressed to the best of our knowledge and ability.

    We ask that you recognize that database design is a mixture of art and science. You may receive conflicting suggestions, for there can be multiple paths to a workable solution. You will have to use your own judgment and knowledge of your business requirements to determine the best solution for your particular problem. The 'right' design is compounded by many factors, including business, regulatory, hardware/software requirements, as well as staff expertise. We also encourage you to share your experiences with a particular design issue if it will serve to help others encountering similar problems.

    In order to receive useful responses, please spend some time and properly present your scenario. Attempts to 'save time and effort' by cutting out parts of the scenario will often lead to wasted time and effort as the suggestions have to be discarded because they don't work with other parts of the unseen puzzle.


    But there are limits to what you can expect from volunteers through a disconnected medium. The questions most likely to receive a good and targeted answer, are those that present a small problem, that give a very clear description of that problem within its context, and that are placed by people with a fair understanding of the subject who need help getting over a few nasty bumps. The questions that are almost impossible to answer satisfactorily are those that present a huge problem, with no clear description, and asked by someone totally new to the subject matter.

    We hope that you will understand when we say that most of us that volunteer our time on this Forum do so in order to help folks learn. We will be pleased if you find the Forum to be useful. However, it is difficult or impossible for us to engage with folks privately. We don't have time to do both, and our commitment is help folks using the Forums.

    Do not hesitate to read all of the threads, join in the discussions, offer your own experiences and information, and ask questions to increase your knowlege. Seek out blogs from those who write in a manner that you appreciate, and consider reviewing the Database Design Resources for additional guidance and help.

     

SQL Server Compact announcements

  • Link
    SQL Server Compact 4.0 downloads and feature information
    ErikEJ Sunday, April 03, 2011 1:11 PM
    This post on my blog should have links to all required information.

SQL Server Notification Services announcements

  • Link
    Please Direct SQLDependency/Query Notification and DBMail Questions to the Appropriate Forums
    Lukasz Pawlowski -- MS Friday, May 21, 2010 7:36 PM

    The following forums can be used to post questions and discussion about the topics: SQLDependency/Query Notification and DBMail.

    Please use
    http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/threads for SQLDependency and Query Notification.

    Please use http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/threads for DBMail.

    (Attribution: Jang-uk In)

    Hope that helps,

    -Lukasz

Dev centers
  • Windows
  • Windows Phone
  • Office
  • Visual Studio
  • Nokia
  • Microsoft Azure
  • More...
Learning resources
  • Microsoft Virtual Academy
  • Channel 9
  • Interoperability Bridges
  • MSDN Magazine
Community
  • Forums
  • Blogs
  • Codeplex
Support
  • Self support
  • Other support options
Programs
  • BizSpark (for startups)
  • DreamSpark
  • Faculty Connection
  • Microsoft Student
United States (English)
  • Newsletter
  • Privacy & cookies
  • Terms of use
  • Trademarks
© 2014 Microsoft