I had tough time working with Integration Services (SSIS) on one of the 64 bit machine that will be used for a 24/7 based application. So here goes my ranting and things you need to take care when having installation of SQL Server 2005 on 64 bit platform, specially within ETL processes completion. So...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
11-19-2007
Filed under: sql server, microsoft, ssis, download, dts, database mirroring, x64, etl, integration services, compatability, backward
Using SELECT @@VERSION statement you can get simply get information of SQL Server you are running , when connected to that SQL Server instance. What if to know same for the Analysis Services components, we don't have such an easy way to find out! I mean there isn't a straight way to find out...
Why not take advantage of testing your knowledge or make use of technology from Microsoft's Business Intelligence features. Microsoft has setup VirtualLabs for BI solutions in order to give in hand information on advantages & features. Excitingly in participating any of virtual labs will get...
As the evolution of Analysis Services has taken to new heights in SQL Server 2005 equally the users are looking to deploy on the large scale and having a need to go though the samples that are helpful. So how about referring to a project that contains Analysis Services (latest edition) samples contributed...
Over the times managing RDBMS platform has evolved into a phase that all of the essential functionality that a Database Administrator needs to administer a multivendor or single-vendor database environment wrapped in an intuitive graphical interface. May be it is a smaller system or mission-critical...
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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
05-18-2007
Filed under: sql server, management, microsoft, ssis, security, ssas, ssms, ssrs, search, anti-virus, kba
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...
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...