SqlServer-QA.net

Making best use of SQL Server Integration Services within your ETL processes is a flexible choice, which has a huge share within the Business Intelligence application platform. You may be aware that SSIS introduces several new and enhanced features and tools to help you manage packages for ETL processes more effectively. To be specific about IS ...

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 ...

Recently on our Development platform we have deployed the Vista operating system to test an application against this installation. Part of the project is to deploy reports for the users using reporting services components, I was able to fix the issues between SQL Server 2005 & Vista but bit struggling with errors ...

You might have observed errors when using Performance Dashboard reports that is available (recently) for SQL Server 2005, the error below is mostly ocurred: Difference of two datetime columns caused overflow at runtime. Based on the forums & other blogs on the web suggests that  The fix for that error is to update setup.sql file ...

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 ...

There is no doubt that from SQL Server 2005 version onwards Business Intelligence (BI) solutions has been better as compared to the previous versions. Still it is interested to know what is the Microsoft's strategy on the expansion of BI. Having the integration of Proclarity with BI is a major advantage to integrate & manage the reports that ...

Another common question in the forums asking about what are the best practices for using antivirus software on servers running SQL Server. In my experience if your SQL Server is not a internet-faced one then no need to have one installed on a SQL Server that is dedicated to databases, rather tighten the access on the file access and share on ...

You may be aware that SQL Server 2005 version provides many new features as compared to other Business Intelligence products with rich media presentations, not only on the presentation layer if you deep dive into the new features there many more to integrate all the Business solutions with 1 shot using Share Point too. Business Intelligence ...

Microsoft is investing a lot to help the Business Intelligence (BI) platform users with the content and get acquaintance to the platform. You are aware BI includes SQL Server Analysis Services, Integration Services and Reporting Services, you can get to know by referring to the media presentation and learn about the enhanced features since the ...

Having a shortcut feature for a tool is handy to work quicker than clicking with a mouse on a PC, I always use Keyboard more than mouse and only when I feel lazy or not keen on the subject then will use mouse. As per the SQL Server 2000 Books Online I was amused to see the keyboard shortcuts for Query Analzyer that helped me a lot to complete ...