|
|
-
|
|
All the videos for the sessions at 24 Hours of PASS (Fall 2012) are available for free. Check the session schedule for a complete list. Enjoy!
...
|
|
-
|
|
The SQL MERGE statement was introduced in SQL Server 2008 and allows you to modify data in a target table based on data in a source table in one easy statement, replacing lots of messy code. I use it frequently when building a data warehouse.
In short, th...
|
|
-
|
|
In the same vein as my post Watch out, Visual Studio 2010 does not support BI, Visual Studio 2012 does not support BI. Meaning, VS 2012 does not support SSAS, SSIS, or SSRS. If you try to open one of those projects, you will be greeted with:
At least th...
|
|
-
|
|
Microsoft has posted ALL the session videos for TechEd Europe 2012 and they are available for free! What a great way to learn all about SQL Server 2012. Check them out here.
...
|
|
-
|
|
If you are using partitions in SQL Server, be aware that “partition switching” is a great feature to quickly truncate partitions or to load data in parallel.
To truncate a partition:
Create a staging table with the schema structure matching th...
|
|
-
|
|
Microsoft has posted ALL the session videos for TechEd North America 2012 and they are available for free! What a great way to learn all about SQL Server 2012. Check them out here.
...
|
|
-
|
|
If you’ve been working with databases for any length of time, you have heard the term normalization.
Normalization is the process of efficiently organizing data in a database. There are two goals of the normalization process: eliminating redundant data (for example, storing the same data in ......
|
|
-
|
|
SQL Server 2012 has many new security features, and three of the bigger new features are: Default Schema for Windows Groups, Audit enhancements, and User-Defined Server Roles.
Default Schema for Windows Groups
A database schema can now be tied to a Windows Group rather than an individual user in o......
|
|
-
|
|
AlwaysOn is a new integrated high availability (HA) and disaster recovery (DR) solution that provides redundancy within a datacenter and across datacenters to help enable fast application failover during planned and unplanned downtime. Specifically, AlwaysOn delivers failover cluster instances, mul......
|
|
-
|
|
Junk dimensions are dimensions that contain miscellaneous data such as flags and indicators. When designing a data warehouse, you might come across a source system that has a bunch of yes/no indicator fields. If those fields needs to be tracked in a fact table, the result could be many small dimen......
|
|