By Michelle A. Poolet, 03/01/2011
If you’re designing a database from scratch, there are 10 things you absolutely need to do to ensure a successful database project.
By Michelle A. Poolet, 12/21/2010
Long story short, the enterprise architect's responsibility is over-arching across the entire enterprise, whereas the Data Architect has a subset of the enterprise architect's ...
By Michelle A. Poolet, 12/17/2010
Find out how six popular data modeling software packages stack up to each other.
By Michelle A. Poolet, 11/22/2010
In this conclusion of our two-part series, we show you how to develop, deploy, and perform day-to-day maintenance of your SQL Server disaster-recovery plan.
By Michelle A. Poolet, 10/25/2010
We apply the first 5 Ds of our 7D Method to the SQL Server disaster-recovery scenario. In Part 1, we focus on Discovery and Design, and in Part 2, we'll show you how to Develop, ...
By Michelle A. Poolet, 01/20/2010
At some point in your career you might get a request, possibly in the form of a court order, to hand over electronically stored information that’s under your care. What can you do ...
By Michelle A. Poolet, 01/20/2010
Electronically stored information (ESI) is data and information that is created, manipulated, stored, transmitted, and utilized in digital form.
By Michelle A. Poolet, 01/20/2010
Slack space is a form of internal fragmentation, i.e., wasted space, on a hard disk.
By Michelle A. Poolet, 01/20/2010
A forensic image is an image or exact, sector by sector, copy of a hard disk.A forensic copy is a file-level copy of data from a hard disk.
By Michelle A. Poolet, 11/16/2009
Data warehouse performance is tied to the performance of the underlying storage subsystem. Discover what you need to know to design a storage subsystem for maximum performance.
By Michelle A. Poolet, 07/24/2009
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 ...
By Michelle A. Poolet, 07/19/2009
There are certain things you should NOT do when developing your data warehouse project. Here's a short list of nine musts to avoid.
By Michelle A. Poolet, 07/19/2009
When you're gathering requirements in the Discover phase of creating a data warehouse project here is a handy checklist.
By Michelle A. Poolet, 03/23/2009
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 ...
By Michelle A. Poolet, 01/22/2009
Learn what to look for if you’re pulling data from a legacy nonrelational database.
By Michelle A. Poolet, 09/09/2008
Michelle discusses the pros and cons of analyzing raw transactional data instead of extracted, transformed, and loaded data warehouse data.
By Michelle A. Poolet, 09/09/2008
Michelle discusses the benefits of building a data warehouse rather than analyzing raw transactional data.
By Michelle A. Poolet, 08/28/2008
Determine the type of data warehouse you have and the workloads it uses so that you can then optimize its performance.
By Michelle A. Poolet, 08/28/2008
By Michelle A. Poolet, 08/28/2008
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 ...