Michelle A. Poolet

Michelle A.
Poolet
Cofounder,
Mount Vernon Data Systems
13 144 13

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
Big Data roadsign
Big Data: Model or Not Model? 1
Are you faced with issues of how to wrangle database design and data modeling in the big data world?
woman working at her computer
Why Aren't We All Great SQL Server DBAs? 3
What's holding us back from becoming great SQL Server database administrators (DBAs)? We know we're good, but we also know we can be better.
SAN Storage Server
The SQL Server 833, What Is It? 4
Here's a story that I'd like to share, about the infamous SQL Server 833. As you may know, an event 833 (or error 833, as it’s sometimes called) is a signal from the SQL Server that it’s waiting for records that it’s requested.
sql server database design drawing
Database Design Essentials
If you’re designing a database from scratch, there are 10 things you absolutely need to do to ensure a successful database project.
data architecture
What's the Difference Between a Data Architect and an Enterprise Architect? 1
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.
Software written on a computer screen
Comparative Review: Sizing Up Data Modeling Software 6
Find out how six popular data modeling software packages stack up to each other.
Building damaged by an earthquake disaster
The Smart DBA's Guide to SQL Server Disaster Recovery, Part 2
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.
laptop with fire flames on keyboard
The Smart DBA's Guide to SQL Server Disaster Recovery, Part 1
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.
eyeball looking through data
E-Discovery Q & A for Data Warehouse Administrators
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?
Red Hard Disk Drive
What is Slack Space?
Slack space is a form of internal fragmentation, i.e., wasted space, on a hard disk.
Man typing on a computer keyboard with data in background
What is ESI?
Electronically stored information (ESI) is data and information that is created, manipulated, stored, transmitted, and utilized in digital form.
Computer data on disks under magnifying glass
What Are Forensic Images and Forensic Copies?
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.
Data storage cubes
Design your Data Warehouse for Performance
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.
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.
Comments
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...
Will SSDs Cause Performance Tuning Experts to Go the Way of the Milkman?
June 23, 2011
Brian, you have a point when you say "this is the first time Ive started to see a pattern of throwing hardware at the problem being a decent answer." Hardware, not...
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
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
synchronize key on computer keyboard
Sep 5, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 4: Synchronizing Server-Level Details

When setting up HA or HA+DR solutions with SQL Server AlwaysOn Availability Groups, it's critical to remember that the basic unit of failover in these scenarios is the availability group (or the group of user-defined databases)....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) ×