Michelle A. Poolet

Michelle A.
Poolet
Cofounder,
Mount Vernon Data Systems
60 146 20

Michelle Poolet, MCIS and Zachman Certified Enterprise Architect tm, has been part of the Information Technology community since long before she started Mount Vernon Data Systems LLC in 1990. She’s been working with Microsoft SQL Server since version 6.0, focusing on transactional database design, administration, and performance tuning. She’s also earned her chops in classroom teaching, OJT training, and IT systems project management.
 
For detailed information, check out Michelle’s profile on LinkedIn.

Articles
Data Warehouse planning grid.
The Data Warehouse Project Discovery Phase
Gathering requirements is absolutely necessary in the discovery phase of successful data warehouse project. In this article, we'll walk through the highlights of gathering requirements for the three project tracks—Technology, Data, and Application Layer.
Checklist
Data Warehouse Requirements Checklist
When you're gathering requirements in the Discover phase of creating a data warehouse project here is a handy checklist.
data warehouse illustration
Some Musts To Avoid When Developing Your Data Warehouse Project
There are certain things you should NOT do when developing your data warehouse project. Here's a short list of nine musts to avoid.
yellow uh-oh road sign
Lessons Learned from Poor Data Warehouse Design 1
Here are the business and design factors that you need to consider and address when designing your data warehouse.
project management puzzle
Seven Steps for Successful Data Warehouse Projects 4
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.
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.
Comments
Increasing your Storage Efficiency with SQL Server Stretch Databases
May 19, 2016

Mike, is this feature available across all versions of SQL 2016, or Enterprise only?

The Essential Guide to SQL Server 2014 Series: Buffer Pool Extensions
May 26, 2015

Good writeup, Mike...I'm just a little confused about the one line "If it’s not limited SQL Server will dynamically grow the Buffer Pool until the maximum available memory in...

What's the Difference Between a Data Architect and an Enterprise Architect?
January 29, 2015

In the Zachman Enterprise Framework(tm) there are six levels, or layers of worker-types. This doesn't mean that one person will inhabit just one layer -- in many cases, in...

SQL Server Distributed Replay
September 29, 2014

Jody, I don't think I understand...if the Microsoft SQL Server Distributed Replay feature is meant to help you assess the impact of future SQL Server upgrades, how can it do...

Tempdb: Checksum or Torn Page Detection (or None)?
September 17, 2014

Is there ever a situation where you'd want to use TORN PAGE DETECTION, say, for instance, for backward compatibility? Personally, I don't think I'd want to be backwardly...

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.

 

From the Blogs
Jul 17, 2017
Sponsored

How Inferred Linking in Matched Records Digs Deeper into Your Data

Duplicate records clutter databases and render the data within them unclear. This kind of problem is very common, and it’s the main reason that deduping software exists. But there’s another benefit to deduplication software: the ability to infer connections between individual records from various data sets....More
May 22, 2017
Sponsored

Chief Data Officer Playbook: How to Be Successful in This Ground-Breaking Role

Companies looking to grow and extract value from their data are increasingly turning to Chief Data Officers (CDOs) to execute their data strategy. The role is new, and a playbook is necessary to address the many challenges CDOs face....More
May 12, 2017
blog

5 Common Challenges to Building BI in the Cloud

After spending 20 years building analytics, BI and database solutions, I've focused on Cloud data solutions over the past 2 years. I've chosen 5 common challenges that I face every day with Cloud migrations and that you'll face in your Cloud BI projects....More

Sponsored Introduction Continue on to (or wait seconds) ×