Michelle A. Poolet
|
|
Michelle A. Poolet is a contributing editor for SQL Server Magazine and cofounder of Mount Vernon Data Systems and Six Sigma Uptime. She teaches database design and programming, has a master's degree in CIS, and is a Zachman Certified™ Enterprise Architect.
Email address: MAPoolet@MountVernonDataSystems.com
|
131 results found for Michelle A. Poolet, displaying items 1 - 20
|
 |
Lessons Learned from Poor Data Warehouse Design
Here are the business and design factors that you need to consider and address when designing your data warehouse.
SQL Server Magazine
Seven Steps for Successful Data Warehouse Projects
Poolet shares the approach she uses when planning and managing a database project. This is project management for non-PMs: admins and developers without a PM, or IT pros who must build a data warehouse and act as their own PM.
SQL Server Magazine
NULL in the Data Warehouse
Learn what to look for if you’re pulling data from a legacy nonrelational database.
SQL Server Magazine
BI Without the Data Warehouse
Michelle discusses the pros and cons of analyzing raw transactional data instead of extracted, transformed, and loaded data warehouse data.
SQL Server Magazine
BI without the Data Warehouse, Part 2
Michelle discusses the benefits of building a data warehouse rather than analyzing raw transactional data.
SQL Server Magazine
Data Warehouse Workloads and Use Cases
Determine the type of data warehouse you have and the workloads it uses so that you can then optimize its performance.
SQL Server Magazine
Desperately Seeking Samples
Educate yourself on the design and operation concepts for databases and data warehouses by taking advantage of Microsoft’s sample databases. Although the business scenarios are fictitious, they translate to real-world uses.
SQL Server Magazine
Where in the World Are Pubs and Northwind?
SQL Server Magazine
Indexing the Data Warehouse
Learn the best way to index the dimensions, and fact tables, and staging databases in your data warehouse to reduce query response time.
SQL Server Magazine
Indexing the Data Warehouse
Windows IT Pro
Who Is Bill Inmon?
Find out why Bill Inmon is an icon in the data warehousing world.
Windows IT Pro
Many-to-Many Relationships in the Data Warehouse
Learn how to model your database to support both market basket and affinity analysis.
SQL Server Magazine
|
June 16, 2008 |
|
Indexing the Staging Database
Find out how to index the database that's used as a landing place for transactional and non-transactional datasources as they enter the data warehouse.
SQL Server Magazine
|
June 3, 2008 |
|
Retaining Relational Integrity in the Data Warehouse
Find out why Michelle thinks you shouldn't enforce referential integrity at the data warehouse level.
SQL Server Magazine
Who Can Do Backups?
SQL Server Magazine
Backup and Restore Fundamentals
Back up your SQL Server databases regularly to prevent lost data in the event of a disaster.
SQL Server Magazine
Data Warehousing: Degenerate Dimensions
Find out how to map control numbers to a fact table and associate them with each line item.
SQL Server Magazine
Data Warehousing: Junk Dimensions
Find out how you can keep your data warehouse design simple by placing miscellaneous attributes into junk dimensions.
SQL Server Magazine
Alternative Backup Strategies
Learn about advanced SQL Server backup options.
SQL Server Magazine
Data Warehousing: Horizontally Partitioning the Fact Table
Save yourself from having to deal with large, difficult-to-manage fact tables by partitioning the rows.
SQL Server Magazine
|
|
Register
