TechNet Virtual Labs
There is an excellent site called TechNet Virtual Labs that enables you to quickly and easily evaluate Microsoft’s newest products and...
2011-12-14
1,060 reads
James Serra's Blog
Top SSAS white papers
These are my favorite SSAS white papers released by Microsoft, with many from SQLCAT. I’ll keep this post updated with new...
2011-12-12
5,687 reads
Reduce heap table fragmentation
A table that does not have a clustered index is referred to as a Heap. While a lot has been...
2011-12-09
7,095 reads
Create SQL Server scripts with Visio 2010
If you are using Visio 2010 and creating tables via the Database Model Diagram template, you may be surprised to...
2011-12-07
2,293 reads
SQL Server 2012 Developer Training Kit
The SQL Server 2012 Developer Training Kit has been updated with a bunch of new content (download it here). This...
2011-12-05
1,121 reads
SQL Server 2012 (“Denali”) Licensing
Microsoft has posted the licensing for SQL Server 2012. It has simplified licensing: SQL Server 2012 will offer two licensing...
2011-12-02
1,491 reads
Buffer Size in SSIS
Behind the scenes in SSIS, the data flow engine uses a buffer-oriented architecture to efficiently load and manipulate datasets in...
2011-11-30
16,579 reads
Role-playing Dimensions
Dimensions are often recycled for multiple purposes within the same database. For instance, a “Date” dimension can be used for...
2011-11-28
4,828 reads
Conformed dimensions
A conformed dimension is a dimension that has the same meaning to every fact with which it relates. Conformed dimensions allow...
2011-11-21
3,481 reads
Reference Dimensions
A reference dimension occurs when the key column for the dimension is joined indirectly to the fact table through a...
2011-11-18
1,461 reads
Blogs
How To Restore Change Data Capture – CDC Tables When Restoring a SQL Server Database
By Tim Radney
I have recently had the privilege of working with multiple clients who have been...
KDA: Echoes of Deception - Onboarding
By Zikato
I’ll walk through the KDA UI and tackle the first challenge before diving into...
Kusto Detective Agency - Intro
By Zikato
While I mostly write about SQL Server, I have a soft spot for Kusto....
Forums
Meta AI by Facebook: A New Contender in the AI Battle
Comments posted to this topic are about the item Meta AI by Facebook: A...
Is SQL Server Feature Complete?
Comments posted to this topic are about the item Is SQL Server Feature Complete?
The Monitor Server
Comments posted to this topic are about the item The Monitor Server
Question of the Day
The Monitor Server
What does the monitor server do in log shipping?
See possible answers