Michelle A. Poolet

Michelle A.
Poolet

Michelle A. Poolet is a contributing editor for SQL Server Pro 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.

Articles
Ruins of old Greek temple
NULL in the Data Warehouse 2
Learn what to look for if you’re pulling data from a legacy nonrelational database.
computer keyboard with data access spelled out on blue keys
BI Without the Data Warehouse 1
Michelle discusses the pros and cons of analyzing raw transactional data instead of extracted, transformed, and loaded data warehouse data.
Data information retrieval
BI Without the Data Warehouse, Part 2 1
Michelle discusses the benefits of building a data warehouse rather than analyzing raw transactional data.
Desperately Seeking Samples 2
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.
Illustration of a database data warehouse
Data Warehouse Workloads and Use Cases 1
Determine the type of data warehouse you have and the workloads it uses so that you can then optimize its performance.
Where in the World Are Pubs and Northwind?
If you’re a long-time user of SQL Server and you’ve migrated to SQL Server 2005, you’d probably like to know where you can find the pubs database.
Diagram of how to create clustered & non-clustered indexes in data warehouse
Indexing the Data Warehouse 3
Learn the best way to index the dimensions, and fact tables, and staging databases in your data warehouse to reduce query response time.
Many-to-Many Relationships in the Data Warehouse 2
Learn how to model your database to support both market basket and affinity analysis.
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.
Binary code
Retaining Relational Integrity in the Data Warehouse
Find out why Michelle thinks you shouldn't enforce referential integrity at the data warehouse level.
Password screenshot
Who Can Do Backups? - 29 May 2008
Not everyone can back up a database. This permission is limited by default to members of the sysadmin fixed server role, and to members of the db_owner and db_backupoperator fixed database roles.
SQL Server OLTP Database and Data Warehouse illustration
Data Warehousing: Degenerate Dimensions 2
Find out how to map control numbers to a fact table and associate them with each line item.
backup and restore word cloud
Backup and Restore Fundamentals
Back up your SQL Server databases regularly to prevent lost data in the event of a disaster.
car junk yard
Data Warehousing: Junk Dimensions
Find out how you can keep your data warehouse design simple by placing miscellaneous attributes into junk dimensions.
Computer backup button
Alternative Backup Strategies
Learn about advanced SQL Server backup options.
Upcoming Conferences

Register now to get the best rate available!

From the Blogs
Save money red computer keyboard key
Jul 30, 2014
blog

When More Expensive Processors Actually Cost Less

Smart organizations are always looking for ways to cut costs when it comes to licensing SQL Server. Here are two ideas, or options, to save money....More
Health check note on computer keyboard
Jul 28, 2014
Sponsored

Grasp the Business Value of a Complete SQL Server Health Check

A comprehensive SQL Server health check will provide you with a better understanding of your complex database environment, and delivers answers you need....More
Baby duck swimming alone
Jul 15, 2014
blog

The Marginalization of SQL Server Standard Edition 6

Microsoft seems to be bent on marginalizing SQL Server Standard Edition—both in the sense of the artificial constraints placed upon how much memory it can use, and in terms of what seems to be a shift in focus on the role of Standard Edition from Microsoft....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×