SqlServer-QA.net

If you remember about editions of SQL Server from 2000 onwards you will see Enterprise, Standard, Personal & Desktop Edition (MSDE) and when it comes to 2005 version Enterprise, Standard, Workgroup, Express & Express Advanced Services. So what's new with SQL Server 2008 version, in addition to 5 editions the newest one is Web ...

Data, data and  data everywhere: a typical scenario for an Enterprise DBA to handle the mission critical applications and comprehensive information across the organization using SQL Server technologies. Since the inception of SQL Server 2005 version Business INtelligence has taken new heights for Data Warehousing and Data Mining perspective ...

As blogged here before Virtual Labs are very handy for the new users and existing professionals to test out new features without disturbing their own platform. In this scenario Microsoft events are helping the users by providing access to their virtual platform for BI & Relational Databases that are built in latest operating system with new ...

Business Intelligence (BI) - is the new term from Microsoft for all Data Warehousing & Data Mining requirement since the SQL Server 2005 version is released. Say many organization face challenges with the Data Explode, this BI offers management and development tools for IT department and Business segment within your organization with ...

I was going through Books Online in learning the concepts of slicing of data within Analysis Services for the new project that is upcoming, all these years I have basic knowledge of SSAS and with latest available features in SQL Server 2005 Analysis Services there is more to learn from there. Slicing is the one that is most useful when you ...

The ascmd.exe command-line utility is a handy tool for testing performance characteristics to determine the appropriate values for parallel processing. This utility is similar to the sqlcmd.exe utility that you use to execute SQL statements in SQL Server. The ascmd.exe utility executes XMLA commands against an Analysis Services server. The ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Standard EditionNotification Contents: New and All Modifications FIX: Error message when you use the Association Rules algorithm to process a data mining model in SQL Server 2005 Analysis Services: ''This number of attributes exceeds the ...

We have got best practices articles on BPA, Security, IndexOptimization for SQL 2005 (non BI) and BP(suggested) for SSIS and I was searching for similar in OLAP - Business Intelligence on Analysis Services in SQL Server 2005. Here it is, a collection of best practices on the design of OLAP objects in Analysis Services 2005 is ...

The process is easy when you have all ingredients in place (handy) without any issues on the current environment. The Database Publishing Services are a set of ASP.NET web services you can easily deploy to make it simple for your customers to deploy SQL Server databases. Further to the subject I have taken help of ScottGu's blog post, that helped ...

Using SSMS tool you can get information on tables, indexes and filegroup information for a database, how about using a TSQL statement: select 'table_name'=object_name(i.id) ,i.indid ,'index_name'=i.name ,i.groupid ,'filegroup'=f.name ,'file_name'=d.physical_name ,'dataspace'=s.name from sys.sysindexes i ,sys.filegroups ...