Michelle A. Poolet

Michelle A.
Poolet
Cofounder,
Mount Vernon Data Systems
36 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
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
Apr 21, 2016
blog

Turning Global Addresses into your Biggest Asset

Sponsored Blog Are you dealing with national and international records? The more expansive your records are in territory, the more problems you will face when it comes to verifying addresses. Not only are you dealing with language differences, but you are also dealing with different address formatting for different countries....More
Mar 14, 2016
blog

Building Your Business with Quality Data

Your contact data is valuable, but is it up to its full potential? Without the proper maintenance, the quality of your data quickly decreases--so quickly that 50% of databases deteriorate after only two years. It is an absolute necessity to maintain your data in order to decrease costs and increase profits....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) ×