SSIS Community Tasks and Components
Do you know there are hundreds of additional tasks, tools, and components for SSIS, many which are free? Why re-invent...
2012-01-04 (first published: 2011-12-30)
3,092 reads
Do you know there are hundreds of additional tasks, tools, and components for SSIS, many which are free? Why re-invent...
2012-01-04 (first published: 2011-12-30)
3,092 reads
SQL Server Master Data Services (MDS) has a number of enhancements in SQL Server 2012:
Improved web user interface – If you...
2011-12-28
1,833 reads
SQL Server 2012 has many new security features, and three of the bigger new features are: Default Schema for Windows Groups,...
2011-12-23
1,956 reads
AlwaysOn is a new integrated high availability (HA) and disaster recovery (DR) solution that provides redundancy within a datacenter and across datacenters...
2011-12-21
1,573 reads
Junk dimensions are dimensions that contain miscellaneous data such as flags and indicators. When designing a data warehouse, you might...
2011-12-19
1,366 reads
A factless fact table is a fact table that does not have any measures. It is essentially an intersection of...
2011-12-16
2,635 reads
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,064 reads
A table that does not have a clustered index is referred to as a Heap. While a lot has been written about index fragmentation and how to defrag indexes, there is not much that talks about how to defrag a heap table.
2011-12-13
5,779 reads
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,700 reads
A table that does not have a clustered index is referred to as a Heap. While a lot has been...
2011-12-09
7,123 reads
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Comments posted to this topic are about the item Going Native with Fabric Spark...
Which of these are valid OPENQUERY() uses?
See possible answers