SQL Server “Denali”: Installing SSAS Multidimensional vs Tabular Mode
As I play with the recently released CTP3 of SQL Server Denali, I wanted to point something out about installing SSAS, since...
2011-07-15
1,901 reads
James Serra's Blog
SQL Server 2008 R2 Service Pack 1 Released
Microsoft has released the final build of SQL Server 2008 R2 SP1. It includes fixes from SQL Server 2008 R2 RTM Cumulative Updates 1 through...
2011-07-14
1,344 reads
SSIS package taking forever to load when you open it?
When you open a SQL Server Integration Services (SSIS) package in SSIS Designer or add components to a package, SSIS...
2011-07-13
2,573 reads
SQL Server “Denali”: CTP3 now available!
CTP3 of SQL Server Code Name “Denali” was made available for download this morning. You can download the 32-bit and...
2011-07-12
2,233 reads
Environment variable in SSIS not being recognized
If you are using environment variables in SSIS when using package configuration, chances are you will run into a situation...
2011-07-11
1,802 reads
Free SQL Server 2008 R2 Business Intelligence Training Course
If you are new to Business Intelligence (BI) and learn best by watching videos and “playing”, then this course is...
2011-07-08
5,201 reads
SQL Server Analysis Services Operations Guide published
Another whitepaper to add to your “to read” list: SQL Server 2008 R2 Analysis Services Operations Guide
This white paper describes...
2011-07-06
1,030 reads
SQL Server “Denali”: Project Crescent
Project “Crescent” is a new interactive data exploration and visual presentation experience coming in the next version of SQL Server, code-named “Denali”. It will...
2011-07-05
1,359 reads
SQL Server “Denali”: SQL Server Developer Tools, codename ‘Juneau”
Juneau is the code name for the new SQL Server Development Tool (SSDT), to be released along with the next...
2011-07-01
1,268 reads
Can you query a SSAS cube while it is processing?
I have always wondered if queries against a SSAS cube while it is processing would be forced to wait the...
2011-06-29
2,512 reads
Blogs
Create and Verify Microsoft Fabric Capacity
From June 1, 2023, Microsoft Fabric (preview) capacities are available via the Azure portal....
What is Always Encrypted and how does it work?
Always Encrypted was a new encryption feature added to SQL Server with the 2016...
Power BI – Empowering Users to Disable Tooltips
By DataOnWheels
Let’s set the scene. You’ve built a wonderful, useful, and descriptive report for your...
Forums
Efficient Airport Transfer in Mauritius - Reach Your Destination with Ease!
Make your arrival in Mauritius hassle-free with our efficient airport transfer service. Our experienced...
how to determine if we can delete the index can be removed
In SQL Server database, there is a table InventDim with two indexes: Idx1 with...
how to determine if we can delete the index can be removed
In SQL Server database, there is a table InventDim with two indexes: Idx1 with...
Ask SSC