Michelle A. Poolet

Michelle A.
Poolet
Cofounder,
Mount Vernon Data Systems
23 146 19

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

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

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
Aug 27, 2015
blog

A Replacement for Maintenance Plan Backups

This blog post is a bit of a ‘repeat’ – since I already covered much of the rationale behind this post in Part 23 of my multi-part series on AlwaysOn Availability Groups and SQL Server Agent Jobs. But, I also figured that this is enough of an important topic to merit its own blog post....More
Aug 19, 2015
blog

Looking forward to Containers

Virtualization has long been a staple when it comes to computing. In essence, virtualization is really just the use of abstraction to make things either easier to manage or more fault-tolerant. Disks, for example, have long been virtualized in the sense that a single, physical, can easily be divided up into multiple logical (or virtual) volumes (or drives) just as easily as a number of discreet physical disks can also be virtualized into a single drive (via RAID) – which can further be partitioned into volumes, LUNs, and so....More
Jul 28, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 29: Practical Implementation Tips

My initial goal in writing this series of posts was to outline some of the concerns surrounding Availability Groups (AGs) and SQL Server Agent Jobs – and call out how there is virtually no guidance from Microsoft on this front and then detail some of the pitfalls and options available for tackling this problem domain. I initially expected this series of posts to have between 25 and 30 posts – according to some of the early outlines I created ‘way back when’....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) ×