Scaling The Data Warehouse
Data warehouses aren't just exploding in size, they're also supporting more users and increasingly complex queries, all in shorter time frames. Here's how to make sure yours is ready to scale.
2008-10-16
2,707 reads
Additional Articles
SQL Server consolidation: Why it's an optimization
SQL Server consolidation benefits are high availability and lower licensing costs. Here's what to expect for hardware needs, system monitoring and SQL licensing.
2008-10-16
2,737 reads
Basic Set Functions: The BottomCount() Function, Part I
Isolate worst / lowest performers from the member population at large, and perform sophisticated analysis with BottomCount(). Join MSAS Architect Bill Pearson in the first of a pair of articles focusing upon the powerful BottomCount() function, where we experience “hands-on” some of the possible ways it can offer multi-perspective decision support.
2008-10-15
2,879 reads
Importance of Database Backups and Recovery Plan
As a DBA you need to ensure that the databases you manage are backed up regularly. This article details the importance of database backups and a recovery plan
2008-10-15
2,652 reads
Can you shrink your SQL Server database to death?
To increase SQL Server disk space, 'shrink the database' task is used. But the tests in this tip using autogrowth prove that 'shrink database' poorly impacts SQL performance.
2008-10-14
4,484 reads
Granting View Definition Permission to a User or Role
Instead of granting higher level permissions, is there a way to allow users that only have public access the ability to see object definitions?
2008-10-13
3,693 reads
Database Encryption in SQL Server 2008 Enterprise Edition
This white paper compares TDE with these other encryption methods for application developers and database administrators. While this is not a technical, in-depth review of TDE, technical implementations are explored and a familiarity with concepts such as virtual log files and the buffer pool are assumed.
2008-10-10
2,702 reads
Parent-child dimensions in SQL Server 2005
Retrieving a hierarchy with recursive relationships can be difficult in SQL. Easily implement these relationships with a parent-child dimension using Analysis Services MDX.
2008-10-10
3,842 reads
SQL Server 2008 Data Collections and the Management Data Warehouse
Data Collections are a great tool that allows DBAs to gather different statistics, and the Management Data Warehouse (MDW) is the repository for storing those statistics. This article offers an overview of Data Collections and how to configure the MDW.
2008-10-09
2,720 reads
Understanding and dealing with orphaned users in a SQL Server database
Attaching and restoring databases from one server instance to another are common tasks executed by a DBA. After attaching or restoring of a database, previously created and configured logins in that database do not provide access. This tip looks at how to deal with this.
2008-10-09
4,605 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Jelambar Baru Raya Telpon/WA:08137887595
BCA KCP Jelambar Baru Raya Telpon/WA:08137887595.Jl. Jelambar Baru Raya No.53 C, Jelambar, Kec. Grogol...
BCA KCU SUKABUMI Tlpn/wa:085373737551
Jl. A. Yani No.33-35, Gunungparang, Kec. Cikole, Kota Sukabumi, Jawa Barat 43111
BCA Finance Kelapa Gading Layanan Mobil Telpon/WA:0851•8812•0691
BCA Finance Kelapa Gading Layanan Mobil Telpon/WA:0851•8812•0691 Ruko Mall Of Indonesia Blok B 32-33,...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers