Michelle A. Poolet
|
|
Michelle A. Poolet is a contributing editor for SQL Server Magazine and cofounder of Mount Vernon Data Systems. She teaches database design and programming, has a master's degree in computer information systems, and is an MCP.
Email address: MAPoolet@MountVernonDataSystems.com
|
128 results found for Michelle A. Poolet, displaying items 1 - 20
|
 |
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
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
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
Where in the World Are Pubs and Northwind?
SQL Server Magazine
Indexing the Data Warehouse
Windows IT Pro
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
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
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
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: Junk Dimensions
Find out how you can keep your data warehouse design simple by placing miscellaneous attributes into junk dimensions.
SQL Server Magazine
|
April 23, 2008 |
 |
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
|
February 25, 2008 |
|
Why Can’t My Database Restore Be an Online Operation?
Learn why you can’t access a database while it’s being restored.
SQL Server Magazine
|
February 25, 2008 |
|
How Do I Recover To A Point in Time?
Restore a database to a point in time.
SQL Server Magazine
|
February 25, 2008 |
|
What Is a Tail-Log Backup?
In SQL Server 2005, a tail-log backup captures records on the transaction log that were written since the last transaction log backup.
SQL Server Magazine
|
|
Register
