Simple Metadata
Tagging has become a new hot action for many people on the Internet, especially in the Web 2.0 social networking world. Steve Jones comes to a revelation about tagging and metadata.
2008-12-14
867 reads
Articles
Career Challenges - Database Weekly (Dec 15, 2008)
This week Steve Jones sees a lot of people talking about challenges in their career.
2008-12-13
578 reads
Career Challenges - Database Weekly (Dec 15, 2008)
This week Steve Jones sees a lot of people talking about challenges in their career.
2008-12-13
835 reads
Career Challenges - Database Weekly (Dec 15, 2008)
This week Steve Jones sees a lot of people talking about challenges in their career.
2008-12-13
622 reads
ETL Auditing
This Article shows a method to audit ETL-Processes to be able to retrace processes and affected data.
2008-12-12
11,524 reads
2008-12-12
51 reads
Discover Analysis Service's Properties using Windows PowerShell and AMO
Part 2 of this series illustrates how to use Windows PowerShell and AMO to get the various Server properties of SQL Server Analysis Service.
2008-12-12
2,235 reads
Using SQL Server meta data to list tables that make up views
One of the issues I often face is the need to find views that are already established for certain tables. This maybe for other developers, end users or even for myself. I could search the system tables to find this or explore each view, but are there other ways to easily find a list of all tables that are used for a view or even a list of all views that a table is tied to?
2008-12-12
3,940 reads
Writing a Basic MDX Query Pt.2 - SQL School Video
In the second part of this basic video on MDX queries, MVP Brian Knight continues with his discussion of MDX, examining some more advanced MDX features.
2008-12-11
6,739 reads
Analyze and Fix Index Fragmentation in SQL Server 2008
This article describes how an index gets fragmented and the steps which a DBA can take to fix index fragmentation
2008-12-11
2,876 reads
Blogs
Advice I Like: Ranch Rules
By Steve Jones
Leave a gate behind you the way you first found it. – from Excellent...
Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes
By SQLPals
Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes ...
Three Ways to Use Snowflake Data in Microsoft Fabric
By James Serra
Organizations increasingly want Snowflake and Microsoft Fabric to coexist without duplicating data or fragmenting...
Forums
You Have Homework
Comments posted to this topic are about the item You Have Homework
SSIS 2019 or 2022 - Microsoft Connector for Oracle
Hello all, I am having one heck of a time installing Microsoft Connector for...
bringing a .bak across the wire without rdp'ing or mapping into the sql server
hi, a peer of mine would like to be self sufficient in bringing small...
Question of the Day
The Query Optimizer and Page Density
If I have a fillfactor set to 70%, this reduces my page density to roughly 70%. Does this affect the query plans that the optimizer chooses?
See possible answers