Performance tips for SSAS
Over the past few years I have developed a list of ways to improve performance in SSAS and in two...
2011-10-17
4,099 reads
James Serra's Blog
Formula engine and storage engine in SSAS
In SSAS, to improve query performance, it’s important to understand what happens inside analysis services when a query is run. ...
2011-10-14
1,200 reads
SQL Server 2012 and other PASS annoucements
Some announcements and notes from SQL PASS Summit 2011, going on this week:
It was announced that the official name of the...
2011-10-13
1,628 reads
SQL Server 2012 and other PASS announcements
Some announcements and notes from SQL PASS Summit 2011, going on this week:
It was announced that the official name of the...
2011-10-13
973 reads
Error configuration in SSAS
In SSAS, there is an Error Configuration object that is central to the management of data integrity errors.
The following picture...
2011-10-12
2,418 reads
Sometimes temp tables can be your best friend
Here is a quick example of when using temporary tables will give you a big performance gain. I recently was...
2011-10-10
876 reads
Denormalizing dimension tables
When building a SSAS cube, you typically have a star schema containing dimension tables and fact tables. For dimension tables,...
2011-10-07
2,219 reads
Microsoft’s Data Warehouse offerings
If you are the decision maker in your company and you are tasked with purchasing one or more servers to...
2011-10-05
1,292 reads
Want to browse the web faster?
In our day-to-day activities, browsing the web is one of the most important aspects of our job. Whether researching for...
2011-10-03
794 reads
Microsoft SQL Server Reference Architecture and Appliances
Microsoft has made available SQL Server appliances and reference architectures that allow customers to deploy data warehouse (DW), business intelligence (BI) and...
2011-09-30
3,752 reads
Blogs
A New Word: Amoransia
By Steve Jones
amoransia – n. the melodramatic thrill of unrequited love; the longing to pine for...
The Data API Builder Start and Add Extensions in VS Code
By Steve Jones
One of the things that I like about the Data API Builder (DAB) is...
Using OneLake for Excel Files in Microsoft Fabric
By DataOnWheels
Hey data friends! This blog is to discuss an edge case I’ve run into...
Forums
DbDefence - how does work this tool?
How it is implemented? I have installed, tried, it is free for dbs <=30...
Technical Pain Behaviors
Comments posted to this topic are about the item Technical Pain Behaviors
trying to call powershell from TSQL statement
Hello, trying to call a powershell file I created, locally on the server, but...
Question of the Day
Counting Bits
What does the BIT_COUNT function do in SQL Server?
See possible answers