Michelle A. Poolet

Michelle A.
Poolet
Cofounder,
Mount Vernon Data Systems
15 145 15

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
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 3
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.
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.
Comments
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...

Why Aren't We All Great SQL Server DBAs?
September 3, 2014

I think I'm hearing you say that the "SQL rock stars" are driven, have extraordinary focus, and/or passion for the product...that they don't leave the work at work but rather...

The SQL Server 833, What Is It?
August 25, 2014

These are terrific suggestions of where to look and what to do when you get there. I wish that the vendor storage engineers and I had been able to observe first-hand what was...

The Trouble with Type Tables
January 29, 2013
Good job explaining reasons to use what you call "type tables", what I call "lookup tables". Couple this articles with InstantDoc ID #48811, which I wrote...
A Case for Shorter SQL Server Conference Sessions
March 24, 2012
I'm with you, Brian -- 60 minutes is just too long for any presentation other than a class or workshop. Thirty minutes I can do, like you said, once or maybe even twice a...
Upcoming Conferences

Register now to get the best rate available!

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
Two women looking a man's computer monitor
Sep 17, 2014
Article

AlwaysOn Availability Groups and SQL Server Jobs, Part 6: High-Level Options and Rationale for Handling Batch Jobs

There are a couple of options for how we could handle batch jobs when Availability Groups are thrown into the mix....More
Sep 12, 2014
Sponsored

Managing a Healthy SQL Server Database: Three Principles We Overlook

In managing a database or sometimes numerous databases, we often get caught up in the day-to-day maintenance and lose sight of the other principles we know are critical to ensuring optimal performance. Here’s a quick refresher....More
Exclamation marke on yellow road sign
Sep 9, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 5: Setting Up Failover Alerts

Alerts represent a great way to take a proactive stance on being notified or alerted when something ugly, potentially ugly, or important happens on a SQL Server. On most servers that I manage, I typically deploy a whole bevy of different alerts....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) ×