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 by Michelle A. Poolet
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 2
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.
IT/Dev Connections

Register now to get the best rate available!

From the Blogs
computer keyboard with blue save money key
Apr 15, 2014
blog

Save Thousands in Licensing Costs for SQL Server AlwaysOn Availability Groups

Windows Server 2012 or Windows Server 2012 R2 Standard Edition is a great way to save thousands on licensing—and save yourself some serious headaches when deploying SQL Server AlwaysOn Availabiliity Groups....More
Apr 8, 2014
blog

NoSQL: Eventual Consistency Yields Major Flaws

While I believe that NoSQL can have some places where it legitimately makes sense, I also believe that NoSQL is also the patently wrong choice for a number of different types of applications or use cases....More
Apr 1, 2014
News

SQL Server 2014 Now Available—No Joke

Initial word on the street is that SQL Server 2014 has been very stable so far—which is probably why it went to release so quickly and bypassed what would typically have been another pre-release....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) ×