ETL Auditing
This Article shows a method to audit ETL-Processes to be able to retrace processes and affected data.
2008-12-12
11,526 reads
Articles
2008-12-12
54 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,741 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
Determine Object Dependencies Before Changing Your SQL Server Schema Design
Maintaining a database often means schema changes. Before you change or delete anything, be sure to check for dependent objects.
2008-12-11
2,638 reads
SQL Server 2008 Mirroring Testing
Comparison of performance of SQL 2008 mirroring to SQL 2005 mirroring.
2008-12-10
7,466 reads
Configuring storage in DB with more writes than reads
Learn how to configure SQL Server database storage with higher disk writes than disk reads. Set up a RAID 10 array, cache configuration and file disk layout.
2008-12-10
3,222 reads
Data Types in SQL Server 2008
Don Schlichting compares and contrasts the various SQL Server 2008 Data Types. In addition, he explores which Data Types are the best solutions for specific situations.
2008-12-10
4,663 reads
Blogs
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers