http://www.sqlmag.com/authors/author/author/5777463/rss/5777463en-USFri, 25 May 2012 08:39:08 GMTFri, 25 May 2012 08:39:08 GMThttp://www.sqlmag.com/article/database-administration/database-design-essentials-129493
By Michelle A. Poolet
If you’re designing a database from scratch, there are 10 things you absolutely need to do to ensure a successful database project.]]>Michelle A. PooletTue, 01 Mar 2011 15:15:00 GMThttp://www.sqlmag.com/article/database-administration/database-design-essentials-129493http://www.sqlmag.com/article/sql-server/what-s-the-difference-between-a-data-architect-and-an-enterprise-architect-
By Michelle A. Poolet
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 responsibilities, which are focused mainly on the data itself.]]>Michelle A. PooletTue, 21 Dec 2010 10:39:00 GMThttp://www.sqlmag.com/article/sql-server/what-s-the-difference-between-a-data-architect-and-an-enterprise-architect-http://www.sqlmag.com/article/sql-server/data-modeling-software-comparison-review
By Michelle A. Poolet
Find out how six popular data modeling software packages stack up to each other.]]>Michelle A. PooletFri, 17 Dec 2010 13:13:00 GMThttp://www.sqlmag.com/article/sql-server/data-modeling-software-comparison-reviewhttp://www.sqlmag.com/article/database-administration/the-smart-dba-s-guide-to-sql-server-disaster-recovery-part-2
By Michelle A. Poolet
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.]]>Michelle A. PooletMon, 22 Nov 2010 12:08:00 GMThttp://www.sqlmag.com/article/database-administration/the-smart-dba-s-guide-to-sql-server-disaster-recovery-part-2http://www.sqlmag.com/article/database-administration/The-Smart-DBA-s-Guide-to-SQL-Server-Disaster-Recovery-Part-1-126089
By Michelle A. Poolet
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, Deploy, and maintain your SQL Server disaster-recovery plan Day-to-Day.]]>Michelle A. PooletMon, 25 Oct 2010 14:00:00 GMThttp://www.sqlmag.com/article/database-administration/The-Smart-DBA-s-Guide-to-SQL-Server-Disaster-Recovery-Part-1-126089http://www.sqlmag.com/article/data-management/e-discovery-q-a-for-data-warehouse-administrators
By Michelle A. Poolet
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 to prepare for this eventuality? ]]>Michelle A. PooletWed, 20 Jan 2010 00:00:00 GMThttp://www.sqlmag.com/article/data-management/e-discovery-q-a-for-data-warehouse-administratorshttp://www.sqlmag.com/article/data-management/what-is-esi-
By Michelle A. Poolet
Electronically stored information (ESI) is data and information that is created, manipulated, stored, transmitted, and utilized in digital form. ]]>Michelle A. PooletWed, 20 Jan 2010 00:00:00 GMThttp://www.sqlmag.com/article/data-management/what-is-esi-http://www.sqlmag.com/article/data-management/what-is-slack-space-
By Michelle A. Poolet
Slack space is a form of internal fragmentation, i.e., wasted space, on a hard disk. ]]>Michelle A. PooletWed, 20 Jan 2010 00:00:00 GMThttp://www.sqlmag.com/article/data-management/what-is-slack-space-http://www.sqlmag.com/article/data-management/what-are-forensic-images-and-forensic-copies-
By Michelle A. Poolet
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. ]]>Michelle A. PooletWed, 20 Jan 2010 00:00:00 GMThttp://www.sqlmag.com/article/data-management/what-are-forensic-images-and-forensic-copies-http://www.sqlmag.com/article/san/design-your-data-warehouse-for-performance
By Michelle A. Poolet
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.]]>Michelle A. PooletMon, 16 Nov 2009 00:00:00 GMThttp://www.sqlmag.com/article/san/design-your-data-warehouse-for-performancehttp://www.sqlmag.com/article/data-management/the-data-warehouse-project-discovery-phase
By Michelle A. Poolet
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.]]>Michelle A. PooletFri, 24 Jul 2009 00:00:00 GMThttp://www.sqlmag.com/article/data-management/the-data-warehouse-project-discovery-phasehttp://www.sqlmag.com/article/data-management/some-musts-to-avoid-when-developing-your-data-warehouse-project
By Michelle A. Poolet
There are certain things you should NOT do when developing your data warehouse project. Here’s a short list of nine musts to avoid.]]>Michelle A. PooletSun, 19 Jul 2009 00:00:00 GMThttp://www.sqlmag.com/article/data-management/some-musts-to-avoid-when-developing-your-data-warehouse-projecthttp://www.sqlmag.com/article/data-management/data-warehouse-requirements-checklist
By Michelle A. Poolet
When you’re gathering requirements in the Discover phase of creating a data warehouse project here is a handy checklist.]]>Michelle A. PooletSun, 19 Jul 2009 00:00:00 GMThttp://www.sqlmag.com/article/data-management/data-warehouse-requirements-checklisthttp://www.sqlmag.com/article/data-management/seven-steps-for-successful-data-warehouse-projects
By Michelle A. Poolet
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. ]]>Michelle A. PooletMon, 23 Mar 2009 00:00:00 GMThttp://www.sqlmag.com/article/data-management/seven-steps-for-successful-data-warehouse-projectshttp://www.sqlmag.com/article/data-management/null-in-the-data-warehouse
By Michelle A. Poolet
Learn what to look for if you’re pulling data from a legacy nonrelational database.]]>Michelle A. PooletThu, 22 Jan 2009 00:00:00 GMThttp://www.sqlmag.com/article/data-management/null-in-the-data-warehousehttp://www.sqlmag.com/article/data-management/bi-without-the-data-warehouse
By Michelle A. Poolet
Michelle discusses the pros and cons of analyzing raw transactional data instead of extracted, transformed, and loaded data warehouse data.]]>Michelle A. PooletTue, 09 Sep 2008 00:00:00 GMThttp://www.sqlmag.com/article/data-management/bi-without-the-data-warehousehttp://www.sqlmag.com/article/data-management/bi-without-the-data-warehouse-part-2
By Michelle A. Poolet
Michelle discusses the benefits of building a data warehouse rather than analyzing raw transactional data. ]]>Michelle A. PooletTue, 09 Sep 2008 00:00:00 GMThttp://www.sqlmag.com/article/data-management/bi-without-the-data-warehouse-part-2http://www.sqlmag.com/article/data-management/data-warehouse-workloads-and-use-cases
By Michelle A. Poolet
Determine the type of data warehouse you have and the workloads it uses so that you can then optimize its performance.]]>Michelle A. PooletThu, 28 Aug 2008 00:00:00 GMThttp://www.sqlmag.com/article/data-management/data-warehouse-workloads-and-use-caseshttp://www.sqlmag.com/article/sql-server/where-in-the-world-are-pubs-and-northwind-
By Michelle A. Poolet
Where in the World Are Pubs and Northwind?]]>Michelle A. PooletThu, 28 Aug 2008 00:00:00 GMThttp://www.sqlmag.com/article/sql-server/where-in-the-world-are-pubs-and-northwind-http://www.sqlmag.com/article/odbc/desperately-seeking-samples
By Michelle A. Poolet
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.]]>Michelle A. PooletThu, 28 Aug 2008 00:00:00 GMThttp://www.sqlmag.com/article/odbc/desperately-seeking-samples