Join Business Intelligence Architect Bill Pearson as he continues his subseries surrounding components of the Analysis Services dimensional model. In this article we continue our introduction to dimension attributes, focusing upon the Misc group of attribute properties.
2008-05-29
1,215 reads
Seeking to recognize DBAs for the work they do, the Exceptional DBA Awards are open for nominations. Steve Jones talks a bit about the event.
2008-05-29
51 reads
Seeking to recognize DBAs for the work they do, the Exceptional DBA Awards are open for nominations. Steve Jones talks a bit about the event.
2008-05-29
35 reads
Seeking to recognize DBAs for the work they do, the Exceptional DBA Awards are open for nominations. Steve Jones talks a bit about the event.
2008-05-29
43 reads
The Trash Destination and this article came from early experiences of using SSIS and community feedback at the time. When developing a package it is very useful to have a destination adapter that does nothing but consume rows with no setup requirement. You often want run a package part way through development, or just add a path so you can set a Data Viewer.
2008-05-29
1,183 reads
When searching meta-data to find an occurance of a particular string or pattern it is difficult to look everywhere. This procedure helps you find what you are looking for.
2008-05-28
8,754 reads
This component needs little explanation. It generates random integer (DT_I4) and string (DT_WSTR) data and places them in the pipeline. You specify how many columns of each you would like and for any string columns you pass a fixed length value. You then need to specify how many rows in total you require to be generated.
2008-05-28
2,077 reads
Last time, we discussed Table inheritance, which allowed us to easily reduce redundancies in our table design by creating "base" or "super" tables that contain columns and relations that "sub-tables" automatically inherit.
2008-05-28
3,163 reads
As the number of different software/technologies increases exponentially, does specializing limit an IT professional's ability to move around?
2008-05-28
49 reads
As the number of different software/technologies increases exponentially, does specializing limit an IT professional's ability to move around?
2008-05-28
40 reads
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
By DataOnWheels
I have been active in the data community throughout my career. I have met...
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
hi, in an ssis for each loop over an object variable called MyListVariable, i...
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers