Difference between revisions of "Pluralsight SQL Server Standard Edition Survival Guide (Course)"

From Minor Miracle Software
Jump to: navigation, search
(Miscellaneous)
 
(No difference)

Latest revision as of 18:58, 27 June 2018


Russ Thomas

Standard vs. Enterprise editions

Licensing, licensing, licensing.

Licensing Cost Determination

SQL Server (SKU) - Stock Keeping Unit


Microsoft Licensing Channels

  • Microsoft Open Licensing - For companies with 2-250 PCs
    • Open License
    • Open Value
    • Open Value Subscription
    • Open License Government
    • Open License Charity
    • Open License Education
  • Microsoft MPSA (formerly select) - For companies with 250+ PCs
    • Simpler Agreements
  • Microsoft Enterprise (volume) - For companies with 500+ PCs
    • Deeper Savings
    • More Support Options
    • Less Up Front Cost
  • Software Assurance, some other benefits.

Which Cores Count?
If the OS underneath the SQL Instance recognizes the core, it must be licensed. This applies to hard and virtual cores and cores shared among different OSes.

Standard Edition

  • Has a per-server license + one license per Client Access license (CAL)

Features

Enterprise - Better security right off. CAN do that in Standard, but with difficulty.

Disaster Recovery

Log Shipping -

Database Mirroring is deprecated, replaced with availability groups.


Failover Clustering

Always Encrypted

  • in transit
  • Column based
  • Automatic encryption and decryption client side.
  • .NET 4.6 SQL Provider
    • Deterministic - same encryption each time. Vulnerable to pattern matching. But, can be searched on by trusted software.
    • Randomized - different each time. Impervious to pattern matching. But can't be searched by trusted software.
  • Backups are encrypted as well.
  • Extensible Key Management - External SQL key management.
    • Separate Duties for IT and ISO
    • Can be required
    • Easier key rotation
    • Centralized management for multiple instances.

Aside

  • With SQL 2016 SP1, MS provided more features on Standard that were previously only available on Enterprise and wanted to provide a consistent programmability surface area across SQL Server editions.

High Performance

  • Non Uniform Memory Access (NUMA)
  • Partitions - Breaking down the range into partitions for easier computation.
  • Resource Governor - Resources grouped into pools and allocated by login user, or user group.
  • In-Memory OLTP Now in Standard
  • Standard has a 32GB Limit. Enterprise limit 2TB
  • Rebuilding Indexes online or offline.

SQL Server 2017

  • Automatic query plan regression testing. The new query plan might be better.
  • Interleaved multi statement table value functions -
  • Support for graph database concepts
  • Resumable online index

Miscellaneous

  • Compression
  • Multiple Filestream Containers - Blob storage on the disk and delegating that to the file system.
  • Change Data Capture - Tracks changes in a data warehouse.
  • Polybase - Connector to Hadoop and other big data storage.
  • Integrated R Services - R language
  • Mirroring is Deprecated.
  • Online operations -

Internal Links

Parent Article: Microsoft Certified Solutions Associate (MCSA) (SQL 2016)