|
|
-
|
|
If you are using the Tabular model in SSAS, it will use the xVelocity technology to load your entire database in memory (greatly compressing the database). So what happens if your database is too big to fit in memory? You will get this error when you pro...
|
|
-
|
|
A big headache in SSAS, especially when dealing with a large cube, is making a change that when deployed, causes a cube to become unprocessed, forcing you to do a full process so the cube is usable. Nothing is worse than making a change without realizing ...
|
|
-
|
|
I see a lot of confusion on what exactly is the difference between a data warehouse and a data mart. The best definition that I have heard of a data warehouse is:
“A relational database schema which stores historical data and metadata from an operational ...
|
|
-
|
|
I have previously blogged about Fast Track Data Warehouse, a reference configuration optimized for data warehousing (see Microsoft SQL Server Reference Architecture and Appliances). That was version 3.0 of the reference configuration that was for SQL Serv...
|
|
-
|
|
I received this error the other day when trying to process a particular SSAS cube:
Error 18 File system error: The following file is corrupted: Physical file: file:///\\%3f\E:\SQL\OLAP\Data\Options”>\\?\E:\SQL\OLAP\Data\Options BI QA.0...
|
|
-
|
|
Thanks to everyone who attended my presentation “Scaling SQL Server to HUNDREDS of Terabytes” at Houston SQLSaturday.
Here is the PowerPoint presentation: Scaling SQL Server to HUNDREDS of Terabytes
Scaling SQL Server to HUNDREDS of Terabytes
Learn how SQL...
|
|
-
|
|
As a follow-up to my SQL Server 2012: New Certification Info, Microsoft Learning has announced the certification tracks for the SQL Server 2012 exams. There are new names for the certifications:
Your first step is to achieve Microsoft Certified Solutions ...
|
|
-
|
|
I will be speaking at the Houston SQLSaturday this upcoming Saturday (April 21st). Below is info on my session, which is at 4pm. I hope you can be there!
Scaling SQL Server to HUNDREDS of Terabytes
Learn how SQL Server 2008 can scale to HUNDREDS of terab...
|
|
-
|
|
SQL Server Data Tools (SSDT) is a Business Intelligence Development Studio (BIDS) replacement, meaning it has a suite of Visual Studio 2010 add-in tools for building Integration Services (SSIS), Analysis Services (SSAS) & Reporting Services (SSRS) solu...
|
|
-
|
|
I blogged previously that when you are a consultant or contractor, you can sometimes be faced with the decision when taking a new contract of whether to go 1099 or W-2 (Consultants: 1099 or W-2?). However, some staffing firms or clients don’t do 109...
|
|