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 model
Database Normalization Still Relevant in a NoSQL World
Today, we have relational database management systems like SQL Server sharing the spotlight with variations of the NoSQL technology. Let's revisit the original reasons for normalizing data and see if they're still relevant.
Tempdb: Checksum or Torn Page Detection (or None)? 3
Recently, I read a posting about the Page Verify option of database properties, and tempdb not allowing any option other than CHECKSUM, which is not true for SQL Server 2008 R2 and 2012. Why would you want to use an option other than CHECKSUM?
Big Data roadsign
Big Data: Model or Not Model? 2
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? 5
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? 3
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.
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) ×