New Bug founds on CU 3 SqlServer 2012 SP1 CU3. SSIS projects and maintenance plans do not work after applying CU3 for SQL Server 2012 SP1.Connect URL:https://connect.microsoft.com/SQLServer/feedback/details/781921/ssis-projects-and-maintenance-plans-do-not-work-after-applying-cu3-for-sql-server-2012-sp1 The KB 2832017 is the hotfix or CU 4 .Will be released on 3/4 +-
The build number of the cumulative update package is 11.0.3349.0.http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=2812412&kbln=en-us The 2 interesting bugs it fixes are: (http://support.microsoft.com/kb/2755192/ ) FIX: SSMS freezes when you perform management operations that relate to roles to an SSRS 2008 R2 or SSRS 2012 database (http://support.microsoft.com/kb/2761400/ ) FIX: An incomplete data import is reported as successful after a time-out in SSAS 2008 R2 or in SSAS 2012
This post is important only if you need to open the same SQL Server unit test projects in both Visual Studio 2010 and Visual Studio 2012.The SQL Server unit testing runtime components installed with SQL Server Data Tools (SSDT) are specific to Visual Studio 2010 and Visual Studio 2012. When working with only one version of Visual Studio the appropriate version of the runtime components is installed and there is no issue, but some care is needed when Visual Studio 2010 and Visual Studio 2012 are used side-by-side on the same project. Side-by-side use includes the following scenarios: Using...
Hi,Lesson learned from upgrade more than 2000 packages located on a file system.1.open SSDT2. convert to package deployment model3. add existing packages- No more than 100, it will stuck otherwise.4. copy all necessary configuration files.5. right click on the package folder click upgrade.6. save report for QA needs.Done
This windows application allows you to manage Microsoft Reporting Service instance. Currently supporting SQL Server 2000, 2005, 2008, 2008R2 (only Native Mode).Features Manage (Add / Edit / Delete) Servers.
Dashboard on landing form
Top 10 heavy reports in Size
Subscription Vs Snapshot run details (Last 7 days)
Pie chart (Report size and Snapshot size on server) (Last 7 days)
Subscription execution details (Last 7 days)
Snapshot details (Last 7 days)Server Objects
List server objects
Download multiple reports in one click
List subscriptions of any report
List snapshots for any report
Delete Snapshots from serverCopy Objects
Copy reports from one server to another server
Set data source...
Business Intelligence System Monitor from http://bisystemmonitor.codeplex.com/Designed for SQL ServerThere is a wealth of typically untapped information that collectively describes the health of a Business Intelligence environment and the trustworthiness of the data it stores. Often, problems aren't detected until after a business user notices them: a report won't run, two reports present conflicting results, an ETL process failed, or a log drive filled up. BI System Monitor is a solution designed to provide a one-stop, quick-glance dashboard to allow you to assess the quality of your data and the health of the hardware and software supporting your BI platforms....
Project Description on http://ssisreportingpack.codeplex.com/ * SSRS reports that operate over the SSIS catalog* A stored proc, sp_ssiscatalog, that provides detailed analysis of the SSIS CatalogGo to SSIS Reporting Pack for the documentation regarding the reports.Go to sp_ssiscatalog for documentation on that.Installation OverviewPre-RequisitesThese reports expose data from hence you will need an instance of that database. See Catalog Overview in SQL Server “Denali” CTP1 - SSIS for instructions on how to create
You will need a SQL Server Reporting Services Report Server onto which to deploy the reports. (Although, the installer provides a Visual Studio project for the reports...
In order to choose the best partition column for a table, it's critical to understand how the partition function works, because the partition function includes a data type that must be the same data type as the table's partition column. In this section, we'll look at how the partition function works for a simple integer value. In the next section, "Choosing a Partition Column," we'll take a closer look at other data types.Partition functions are stored within the database you create them in, but they are not equivalent to user-defined functions. Instead, they are special objects used only with...
Many Microsoft customers have been using in-memory technologies as part of SQL Server since 2010 including xVelocity Analytics, xVelocity Column Store and Power Pivot, . Looking forward, Ted Kummert recently announced project codenamed “Hekaton,” available in the next major release of SQL Server. “Hekaton” will provide a full in-memory transactional engine, and is currently in private technology preview with a small set of customers. This technology will provide breakthrough performance gains of up to 50 times.For those who are keen to get a first view of customers using the technology, below is the video of online gaming company bwin...