Managing Analysis Services Deployment - Part 2
Continuing with this series, Shahfaisal Muhammed brings us another method of deploying your SSAS projects to a new server. The rest of the series will cover other methods.
2010-02-18
5,687 reads
Analysis Services (SSAS)
Managing Analysis Services Deployment - Part 1
In part 1 of this series, Shahfaisal Muhammed brings us one method of deploying your SSAS projects to a new server. The rest of the series will cover other methods.
2010-02-16
8,467 reads
Professional Microsoft SQL Server Analysis Services 2008 with MDX - Sample Chapter
A sample chapter from a new book on Analysis Services. Check it out and see if this is the book for you.
2010-02-16
2,063 reads
Introduction to Security in Analysis Services
Join BI Architect Bill Pearson in this introduction to Security in Analysis Services 2008. Here we explore security concepts and implementation, and look forward to hands-on practice with security in other articles of this subseries.
2010-02-03
2,675 reads
A Decision Tree inside out
Step by step to create a Decision Tree and how to understand the results showed by Analysis Services
2009-12-03
8,449 reads
Using the SQL Server Analysis Services (SSAS) Deployment Wizard
I have to deploy my SQL Server Analysis Services project to a test server then to a production server after testing is completed. For both of these deployments I need to provide an installation program. I am not allowed to access either of these servers. For my own testing I can deploy my project using Business Intelligence Development Studio (BIDS) and this works great. How can I create an installer that my IT team can use to perform the deployment?
2009-11-25
2,137 reads
Improving Cube Performance with Precalculated Aggregations
A step by step example of how to add pre-calculated closing balances through T-SQL and semi-additive measures from Johan Åhlén.
2009-11-04
7,000 reads
XY (Scatter) Chart for Analysis Services Data
Display data series' as a set of points with an XY (scatter) chart - typically to compare distinct values across categories. BI Architect Bill Pearson leads the hands-on creation of an XY chart based upon an Analysis Service data source.
2009-10-29
2,209 reads
Cube Storage: Introduction to Partitions
Join BI Architect Bill Pearson in this introduction to Partitions in Analysis Services 2008. Here we explore partitioning concepts and advantages, and look forward to hands-on practice with partitions in subsequent articles.
2009-10-23
3,760 reads
Introduction to Cube Storage
BI Architect Bill Pearson introduces Storage in Analysis Service 2008. This article begins an extended examination of storage topics, including partitions and aggregations, within a multiple-article subseries.
2009-09-28
3,549 reads
Blogs
Azure SQL offerings
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
T-SQL Tuesday #183 Roundup
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
A Little Brainstorming with an AI
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
Forums
MEMORYBROKER_FOR_RESERVE experience
Hi, Does anyone have experience with MEMORYBROKER_FOR_RESERVE ? when suddenly there is somehow constantly...
Moving Database Files
I just learned that my database was created on my C:\ drive in the...
Migrate MSSQL to MYSQL - Different Servers
I am needing to migrate a MSSQL db to MySQL, on a different server...
Question of the Day
Mixed Backups
I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).
BACKUP DATABASE [complex]
FILE = N'thirdone'
, FILE = N'thirdtwo'
, FILEGROUP = N'second'
TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak'
WITH NOFORMAT, NOINIT, NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
See possible answers