How to use a multidimensional cube with Power View
The requirements for Power View state that it can only use tabular models as data sources. So if you want to...
2012-06-25
2,309 reads
James Serra's Blog
SQLBits X videos online
All the videos for this popular conference are online or will be soon (69 of them). Take a look at the...
2012-06-20
1,125 reads
Tabular query modes: DirectQuery vs In-Memory
When using the Tabular model in SSAS, the deployment options screen offers four choices for “Query Mode”: DirectQuery, DirectQuery with...
2012-06-18
13,910 reads
TechEd North America 2012 videos online
Microsoft has posted ALL the session videos for TechEd North America 2012 and they are available for free! What a...
2012-06-15
1,045 reads
Presenting Tips
Having done a number of presentations, I have accumulated a list of items to go over before each presentation to...
2012-06-06
1,158 reads
Microsoft Master Data Services in SQL Server 2012
Microsoft SQL Server Master Data Services (MDS) is a Master Data Management (MDM) product from Microsoft. Master Data Services is...
2012-06-08 (first published: 2012-06-04)
20,630 reads
Syncing your calendars
I have a desktop computer, a laptop, and a iPhone. I frequently add meetings to my Outlook calender on my...
2012-05-30
1,968 reads
Columnstore indexes and memory
Columnstore indexes are built and processed completely in memory. You will receive an out-of-memory error if you do not have enough memory...
2012-05-23
1,459 reads
What happens when a SSAS Tabular model exceeds memory?
If you are using the Tabular model in SSAS, it will use the xVelocity technology to load your entire database...
2012-05-24 (first published: 2012-05-21)
3,780 reads
Being careful in SSAS to not make a cube/dimension unprocessed
A big headache in SSAS, especially when dealing with a large cube, is making a change that when deployed, causes...
2012-05-21 (first published: 2012-05-16)
3,138 reads
Blogs
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers