SSIS projectsdo not work after applying CU3 for SQL Server 2012 SP1

31/03/2013

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 +-
אין תגובות

Cumulative update package 3 for SQL Server 2012 Service Pack 1

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
אין תגובות

SQL Server Unit Testing using Visual Studio 2010 and Visual Studio 2012 Side by Side

24/03/2013

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...
תגובה אחת

SSRS Plus+

21/03/2013

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 Object details List subscriptions of any report Rerun subscription List snapshots for any report Download snapshots Delete Snapshots from serverCopy Objects Copy reports from one server to another server Set data source...
אין תגובות

Business Intelligence System Monitor

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....
תגובה אחת

SSIS Reporting Pack

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...
אין תגובות

The Partition Function

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...
אין תגובות

how fast is “Hekaton”

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...
אין תגובות