• Facebook
  • Twitter
  • Linkedin
  • 0Shopping Cart
Mount Vernon Data Systems
  • Home
  • About
    • Opt-out preferences 2023-03-18
  • Services
  • Education
  • Blog
  • Search
  • Menu
  • PUBLISHED WORKS

  • TECHNICAL WRITING

  • REMOTE DATABASE ADMINISTRATION

  • E-COURSES

  • COACHING AND TEACHING

  • TECHNICAL WRITING

  • REMOTE DATABASE ADMINISTRATION

  • PUBLISHED WORKS

MICROSOFT SQL SERVER

C-LEVEL STRATEGY AND EXPERTISE

PROJECT-BASED, BY THE HOUR

PROACTIVE, CUSTOM SOLUTIONS

REMOTE DATABASE ADMINISTRATION

TEMPORARY HELP OR ONGOING SERVICE

READY TO TALK MORE ABOUT YOUR PROJECT?

We specialize in helping companies with Microsoft® SQL Server® who need more DBA help but who can’t add staff positions to keep their SQL systems running better, faster, cheaper with great tools, training and mentoring programs.

If you’d like to discuss how Mount Vernon Data Systems could transform the way you see and manage your data, schedule a consult call or send us an email today.

SCHEDULE A FREE CONSULT CALL

The best way to determine if MVDS is the right fit for you is to have a free consult call. We can find out more about your project and suggest ways to move forward.
Schedule your free consult call on Doodle today.

SEND AN EMAIL

MOST RECENT BLOG POSTS

Blog image

SQL Server Management Studio Keyboard Shortcuts

March 18, 2016
Are you an impatient DBA?  Does it make you crazy to have to mouse around the SQL Server Management Studio dashboard?  Wouldn't it be nice to know the keyboard shortcuts that can make you go faster? Back in "the day" we knew that REAL computer people use a keyboard, not a mouse. Mice were for those Apple folk...
Read more
https://i0.wp.com/mountvernondatasystems.com/wp-content/uploads/2018/10/blog-img.jpg?fit=367%2C317&ssl=1 317 367 Michelle Poolet https://mountvernondatasystems.com/wp-content/uploads/2018/10/Mount-vernon-data-systems-logo-300x92.png Michelle Poolet2016-03-18 15:03:382018-11-12 22:53:15SQL Server Management Studio Keyboard Shortcuts

WHAT’S A VLF AND WHY DO I CARE?

March 1, 2016
Some Background SQL Server ensures that all changes to the database,…
Read more
https://i0.wp.com/mountvernondatasystems.com/wp-content/uploads/2018/10/ai-close-up-code-160107.jpg?fit=5472%2C3648&ssl=1 3648 5472 Michelle Poolet https://mountvernondatasystems.com/wp-content/uploads/2018/10/Mount-vernon-data-systems-logo-300x92.png Michelle Poolet2016-03-01 15:26:542018-10-30 18:06:18WHAT’S A VLF AND WHY DO I CARE?

Teaching is Learning, or How to Survive the SQL Server Learning Curve

May 4, 2015
Dan Crisan, @dandancrisan, a full-time student and tech blogger,…
Read more
https://i0.wp.com/mountvernondatasystems.com/wp-content/uploads/2018/10/adult-agreement-beard-429247.jpg?fit=6000%2C4026&ssl=1 4026 6000 Michelle Poolet https://mountvernondatasystems.com/wp-content/uploads/2018/10/Mount-vernon-data-systems-logo-300x92.png Michelle Poolet2015-05-04 14:27:162018-10-30 18:06:55Teaching is Learning, or How to Survive the SQL Server Learning Curve
SEE MORE

FREE DOWNLOAD

THE 7D METHOD™ SQL LIFECYCLE –

Improve Performance & Maximize Uptime with this Free Blueprint

Get a taste of Mount Vernon Data Systems with our FREE download of the 7D Method™ SQL Lifecycle. Our guide is an overview of database administration best practices in every step of the process–a perfect companion for beginners and overworked DBAs alike!

We review the key tasks, deliverables, outcomes (and key skills you’ll need) for each stage from discovery and design of a new database, to day-to-day upkeep and security so you know you’ll never miss a step.

Sign up below and we’ll email you your free copy.

MICROSOFT SQL SERVER DATABASE ADMINISTRATION

SQL SERVER ADMINISTRATION

What is Remote SQL Server Administration?

With our Remote Database Administration Service, MVDS outfits your small to medium business with a highly skilled SQL Server Database Administrator (DBA). Our DBA will help you monitor, manage, and operate your system, as well as assist with any necessary upgrades and patches. We tailor our services to meet your specific needs, offering short-term support, ongoing service, and everything in between.

The MVDS DBA can be contracted to provide short term support, to cover temporary administration or personnel disruptions, or provide ongoing service in lieu of hiring an in-house DBA.

If you’d like to discuss how we at Mount Vernon Data Systems can work with you to ease your Microsoft® SQL Server® needs, schedule a consult call or send us an email today.

DATA MODELING

Data Modeling is Our Core Specialty

Data modeling allows us to transform raw data into meaningful information. Data modeling is the design of a functional information structure that makes the storehouse of data within your company usable and accessible.

Utilizing infographics and reports, we allow you to make informed decisions about how to successfully run your business. We also utilize data modeling to analyze the design of your database(s) so they reflect the specific needs of your company.

Data modeling allows us to reflect the business requirements of a company in the design of the database from the start. MVDS understands businesses and their needs as much as it understands the technical process of creating a database. It is this broad–based competence that sets us apart.

If you’d like to discuss how we at Mount Vernon Data Systems can work with you to better understand your Microsoft® SQL Server® environment, schedule a consult call or send us an email today.

DATA MIGRATION & LOSS PREVENTION

DATA MIGRATION & LOSS PREVENTION

Transferring your company’s most valuable asset — your data — from one platform to another is typically a task you’ll only perform once in your career. For that reason, even experienced DBAs can make mistakes that leave their organization vulnerable or missing data. Staffers who are already overwhelmed with their daily duties have little time to devote to such a task. This is when you need to call in the data migration pros at Mount Vernon Data Systems.

The experts at MVDS have been migrating data between dissimilar platforms since 1990 and can guide you through a seamless transition. We’ve migrated data across the following platforms:

Microsoft Excel® to Microsoft Access®

Microsoft Access® to Microsoft® SQL Server®

Microsoft FoxPro® to Microsoft® SQL Server®

Google Sheets to Microsoft® SQL Server®

iMIS to SQL Server®/ProTech CRM4M®

SQL Server®/Custom Solutions to SQL Server®/ProTech CRM4M®

Avectra NetForum® to SQL Server®/ProTech CRM4M®

If you’d like to discuss how we at Mount Vernon Data Systems can work with you to ease your data migration needs, schedule a consult call or send us an email today.

SQL SERVER STRATEGY

Our Business Keeps Your Business in Business

MVDS helps you maximize your operational effectiveness and lower your costs through SQL strategy consulting. We consider scale, reliability, security, price, and more to ensure the system you use is perfectly suited to meet your unique corporate needs. We’re prepared to create systems optimized for high-traffic environments as well as those capable of delivering interactive reports.

Because of the depth & breadth of its experience across many industries, with companies ranging from small to large, MVDS understands strategic corporate asset management.

We support your ability to make faster and better-informed business decisions, by designing reporting systems that deliver real-time life cycle information. If you’d like to discuss how we at Mount Vernon Data Systems can work with you to better strategize your SQL Server® environment, schedule a consult call or send us an email today.

PERFORMANCE TUNING

SQL Performance Monitoring & Tuning

There are dozens of reasons why SQL Server® performance can be less than what you expect. SQL Monitoring Support is offered with any of our Remote DBA services. We highly recommend taking advantage of our performance evaluation services, so we can assess what’s working and what’s not before fine-tuning your system. Our performance monitoring solution identifies and analyzes SQL Server performance problems on either physical or virtual servers, and provides you with a full report of findings, including recommendations for improvement. If you’d like to discuss how we at Mount Vernon Data Systems can work with you to optimize your SQL Server’s performance, schedule a consult call or send us an email today.

TRAINING

TRAINING

MVDS currently offers training in any of our competency areas for your staff. We also provide training for new databases if (and when) you’re ready to hand off your data management to a full-time team.

We also offer online mentoring, and our signature Coach-in-a-Can® program, which is perfect for beginners looking to better understand the foundations, theory, and applications of database management–as well as more experienced managers, looking to monitor and avoid emergencies like a pro. If you’d like to discuss how we at Mount Vernon Data Systems can work with you to better understand your SQL Server® environment, schedule a consult call or send us an email today.

TECHNICAL WRITING

AUTHOR WITH EXPERTISE

AUTHOR WITH EXPERTISE

Michelle Poolet, co-founder and current President of Mount Vernon Data Systems, has years of experience with technical authoring. She is the author of 13 books on database design and programming, 190 (+/-) database articles for the SQL Server Pro magazine, and innumerable white papers and blog posts. She’s a regular presenter at area SQL Saturday events in the Colorado Front Range, and has presented multiple topics at the local SQL Server User Group meetings. As a course developer, during her tenure as Adjunct Professor with the University of Denver, University College, she developed and delivered 6 online courses in database systems – the first to be offered for the Master of Computer Information Systems program of study.

If you’d like to discuss how we at Mount Vernon Data Systems can work with you to assist with your SQL Server® authoring needs, schedule a consult call or send us an email today.

BLOG POSTS & ARTICLES

BLOG POSTS & ARTICLES

Michelle Poolet, co-founder and current President of Mount Vernon Data Systems, blogs about Microsoft® SQL Server® on this website and at LinkedIn. Her articles covered tips, tricks, and how-to’s for database administrators, database design essentials, best practices for database management, and emergency database recovery tips. She’s also explained advanced DBA concepts in language that is both thorough and easily understood.

If you’d like to learn more about Microsoft® SQL Server®, follow Michelle’s blog.

TRAINING DOCUMENTS

TRAINING DOCUMENTS

Michelle Poolet, co-founder and current President of Mount Vernon Data Systems, has years of experience with technical writing and course development. She has created and delivered courseware on all facets of database systems for academic environments and corporate training facilities. She has been part of information technology and database management systems on computers ranging from mainframes to PCs and beyond. She has been teaching and training since 1989, as a staffer at University College, University of Denver, and as a technical trainer with ProTech and UCI/AmeriTeach in Denver, Colorado. Michelle combines all those years of experience and all those various environments into meaningful, useful short courses for those who are ready and willing to learn.

If you’d like to learn more about Microsoft® SQL Server®, sign up for one of the MVDS training courses (coming soon).

Need some help managing your data?

MVDS has been helping businesses manage and protect their data since 1990. We customize Microsoft SQL Server databases that support products like SharePoint, Kronos, Personify, or custom solutions so your operations run as efficiently as possible–saving you time and money. Book a consult call today to get started.

BOOK A
CONSULT CALL

PUBLISHED WORKS

Michelle has years of experience in technical writing, as demonstrated in her blog and in the SQL Server Pro Magazine (now known as IT Pro Today), along with multiple books, white papers, and articles written for other publications. Her articles have covered tips, tricks, and how-to’s for DBAs working on SQL Server, database design essentials, best practices for database management, and emergency data recovery tips. She’s also explained advanced DBA concepts in language that is both thorough and easily understood.

Database Normalization Still Relevant in a NoSQL World

Tempdb: Checksum or Torn Page Detection (or None)?

Big Data: Model or Not Model?

Why Aren’t We All Great SQL Server DBAs?

The SQL Server 833, What Is It?

Database Design Essentials

What’s the Difference Between a Data Architect and an Enterprise Architect?

Comparative Review: Sizing Up Data Modeling Software

The Smart DBA’s Guide to SQL Server Disaster Recovery, Part 2

The Smart DBA’s Guide to SQL Server Disaster Recovery, Part 1

E-Discovery Q & A for Data Warehouse Administrators

What Are Forensic Images and Forensic Copies?

What is ESI?

What is Slack Space?

Design your Data Warehouse for Performance

The Data Warehouse Project Discovery Phase

Some Musts To Avoid When Developing Your Data Warehouse Project

Data Warehouse Requirements Checklist

Lessons Learned from Poor Data Warehouse Design

Seven Steps for Successful Data Warehouse Projects

NULL in the Data Warehouse

BI Without the Data Warehouse, Part 2

BI Without the Data Warehouse

NULL and the CLR

NULL Overhead

Designing for Performance: NULL or NOT NULL?

Brush Up on Design Essentials with the SQL Diagrammer

Describe and Design

Why Model?

What is Coach-In-A-Can®?

Mount Vernon Data System’s Coach-In-A-Can® program is designed for the accidental and do-it-yourself DBAs. Get access to short videos and resources designed for quick training of everything you need to know and nothing you don’t. We offer to-do lists for key daily, weekly, monthly, and annual tasks so you ensure nothing slips through the cracks again.

Subscribe to our mailing list to get notified when the course is ready.

TESTIMONIALS

Michelle is one of the most knowledgeable people I have worked with. She has taught me much about webinars, sustainability and consulting. Her intelligent, yet kind approach to life models a balanced and approachable wisdom. I would recommend Michelle’s work at anytime for anyone.

— Cherie Peterson
Sharing Wisdom through Life Expressions

We hired Mount Vernon Data Systems because we wanted an experienced company that would challenge our assumptions and help us create a database not just for today but for years to come. We found MVDS be professional, practical and extraordinarily helpful. They delivered what they promised, on time and on budget. If someone were to ask us, ‘Would you hire them again?’ the answer would be a resounding ‘Yes!’

-John Anton
Anton Sport

Book a Consult Call 

See Our Privacy Policy

Michelle@MountVernonDataSystems.com
Golden, Colorado – Copyright 2018

Designed by Emerson St. Creative

Scroll to top
Manage Cookie Consent
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Manage options Manage services Manage {vendor_count} vendors Read more about these purposes
View preferences
{title} {title} {title}