SqlServer-QA.net

If you work in Financial based Enterprise then Sarbanes-Oxley is not a new concept for you as per American law that regulates the accountability of publicly owned companies. Just to talk about the main purpose of the law it to make sure the financial statement that a company reports is legitimate and that there’s no room for someone to manipulate ...

So far the SQL Server 2008 Analysis Services new features were included until October CTP, top features that Microsoft would like to include within RTM version: New Aggregation designer - to browse and modify aggregation designs that are now shown grouped by measure group. Simplified and enhanced Aggregation Design and Usage-Based ...

As you are aware that SYSMON (PERFMON) provides very useful counters to analyze the system performance or to schedule a historical growth of your system usage.   From the changes (upgrade) to the Operating System and  SQL Server we now have new set of SQL Server Integration Services ...

This is a typical error you would get when a SSIS package is executed that involves remote server connectivity. Basically on the error note it will clearly identified as a network related issue. Similar issue happened at our end whereas the SSIS package uses an application is using the SqlClient provider that will write big datachunks to ...

Though it is more to do with SQL Storage  kind of question, I have just dragged into Performance tuning section for the sake of large installation you talk with clustering. For the sake of discussion it seems better to plan ahead for the failing instances since, for example, two of the four servers could go down. In the majority of cases, ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise X64 EditionNotification Contents: New and All Modifications The ''SQL Server:SSIS Pipeline'' performance object does not appear in the ''Performance object'' list after you install Integration Services from a 64-bit version of SQL ...

High-speed heterogeneous integration is a challenge for many corporate IT departments today. Most modern IT groups are having to deal with an incredible amount of disparate systems across the organization, coupled with an ever-growing data set. To address these challenges, many IT pros are looking at bringing in high-speed data interconnects to ...

What advantages we took when deployed the 64-bit computing within SQL Server As you aware 64 bit computing with 64-bit processors have become the standard for systems ranging from the most scalable servers to desktop PCs. The way to take full advantage of these systems is with 64-bit editions of Microsoft Windows products.  Same way SQL ...

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 EditionNotification Contents: New and All Modifications FIX: An SSIS package stops responding when you run the package and the package contains a data flow task that contains one or more MergeJoin ...

Windows IT Pro magazine has lined up a live event on High Performance Connectivity for SQL Server 2005 and SSIS.  ETI has partnered with Microsoft to bring best-of-breed high-speed data interconnects to the new SSIS environment, making plug-and-play with mainframe, legacy, Teradata, and other database systems a reality. These new ...