Michelle A. Poolet

Michelle A.
Poolet
Cofounder,
Mount Vernon Data Systems
38 146 20

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
Increasing your Storage Efficiency with SQL Server Stretch Databases
May 19, 2016

Mike, is this feature available across all versions of SQL 2016, or Enterprise only?

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

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
Jul 6, 2016
Sponsored

Using BI Office Together with Microsoft Power BI Desktop to Unlock Business Insights

It is crucial to move away from data and analytics stored on individual desktop computers. Today’s solutions must promote holistic, collective intelligence. The strong, continued alliance between Microsoft and Pyramid Analytics helps make all this possible....More
Jul 6, 2016
Sponsored

Why It’s Important to Unlock Business Insights Trapped on Individual Desktops

To become a truly data-driven enterprise, many business leaders recognize that they must extend the capabilities of self-service business intelligence (BI) and analytics to more of their business users. Many BI tools tackle part of this need, but they don’t offer a complete enterprise solution....More
May 12, 2016
blog

The 7 C's of Data Quality

Data quality is really important. Why? Because it helps you save money while increasing profits because of accurate contact data. It’s important to understand what data quality is and why it is important....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) ×