Products
Overview
Monitoring Features
Database Monitoring
SQL Sentry
DataOps
Task Factory
Database Mapper
DBA xPress
Free Tools
Plan Explorer
Solutions
By Role
DBAs
IT Managers
BI Pros
Leaders
Monitoring
SQL Server
Azure SQL Database
SSAS
VMware
Windows Hyper-V
Azure Synapse SQL Pools
DataOps
Overview
Data Integration
Documentation
Data Lineage Analysis
Cloud Migration
AWS
Azure
How To Buy
Download Free Trials
Schedule Demo
Request Quote
Product Pricing
SentryOne Resellers
Resources
Blog
Webinars
Events
Resource Library
Popular Topics
SQLPerformance.com
Support
Documentation
Support Overview
Submit a Support Case
Support Community
Pro Services
Product Renewal
Partners
Find a Partner
Partner Portal Login
About
Overview
Our Team
Our News
Locations
Careers
My Account
Download Free Trial
Quote
Blog Home
SentryOne Newsletter
Authors
Categories
Category: SQL Server 2016 (3)
What Might the SSMS Changes Mean to You?
After the first Visual Studio 2015-based SSMS build is released, Aaron Bertrand talks about the changes you'll notice, and the changes you won't (yet).
April 5, 2016
|
Aaron Bertrand
|
Management Studio
,
SSMS
,
SQL Server 2016
0
On Telemetry and Other Data Collected by SQL Server
Aaron Bertrand talks about some of the upcoming changes to telemetry and other privacy settings in SQL Server 2016.
April 4, 2016
|
Aaron Bertrand
|
SQL Server 2016
,
SQL Server
0
More ways to discover changes in new versions of SQL Server
Following up on an earlier post about metadata, Aaron Bertrand reveals a few more of his sources for discovering changes in SQL Server.
March 30, 2016
|
Aaron Bertrand
|
Execution Plans
,
SQL Server 2016
,
Extended Events
0
Performance Surprises and Assumptions : STRING_SPLIT
SQL Server 2016 RC0 introduces a new native string splitting function,
STRING_SPLIT
.
March 18, 2016
|
SQLPerformance.com
|
SQL Server 2016
,
T-SQL
,
STRING_SPLIT
0
Management Studio February Preview: An Illustrated Guide
Aaron Bertrand explains some of the nuances of the latest Management Studio preview, with a visual tour through installation.
March 7, 2016
|
Aaron Bertrand
|
Management Studio
,
SSMS
,
SQL Server 2016
1
The Difference a Day Makes: SSMS 2016, Azure, and Extended Events
Aaron Bertrand shows why and how you should upgrade your SSMS 2016 client from 13.0.11000.48 to 13.0.11000.78.
February 4, 2016
|
Aaron Bertrand
|
SQL Server 2016
,
Cloud
,
Azure SQL Database
,
Extended Events
0
How I spot not-yet-documented features in SQL Server CTPs
Aaron Bertrand shares a few of the queries he uses to quickly hone in on changes that have been implemented between SQL Server CTPs.
December 2, 2015
|
Aaron Bertrand
|
SQL Server 2016
,
SQL Server
,
CTPs
,
SQL Server Builds
1
Plan Explorer Support for SQL Server 2016
Aaron Bertrand explains how to get Plan Explorer to work with plans from the latest builds of Azure SQL DB and CTPs of SQL Server 2016.
November 23, 2015
|
Aaron Bertrand
|
SQL Server 2016
,
SQL Sentry
,
Plan Explorer
0
Service Broker Enhancements in SQL Server 2016
Aaron Bertrand shows some interesting maintenance opportunities...
October 26, 2015
|
SQLPerformance.com
|
SQL Server 2016
0
New SERVERPROPERTY Options to Help Phase Out @@VERSION
Aaron Bertrand talks about new arguments to SERVERPROPERTY() that make @@VERSION even more obsolete (and changes that make @@VERSION problematic).
October 22, 2015
|
Aaron Bertrand
|
SQL Server 2016
,
SQL Server 2014
,
SQL Server Builds
2
SQL Relay Slides and Demo Code
John Martin talks about his sessions at the recent SQL Relay events throughout the UK, and shares his slide decks from the sessions.
October 19, 2015
|
John Martin
|
SQL Server 2016
,
Cloud
,
SQL Server
,
Azure
,
Availability Groups
0
Stronger Security Via Always Encrypted in SQL Server 2016
Stronger Security Via Always Encrypted in SQL Server 2016.
October 7, 2015
|
Kevin Kline
|
SQL Server 2016
,
Best Practices
,
Security
,
SQL Server
0
SQL Server 2016 : Getting tempdb a little more right
Aaron Bertrand explains how SQL Server 2016 improves tempdb configuration and performance.
September 30, 2015
|
Aaron Bertrand
|
SQL Server 2016
,
System Configuration
,
tempdb
,
SQL Server
7
Glenn Berry : Practical Processor Selection for OLTP Workloads
Glenn Berry (
@GlennAlanBerry
) provides some blueprints for how to decide whether newer processors are worth the investment to improve your O
September 15, 2015
|
SQLPerformance.com
|
SQL Server 2016
,
System Configuration
,
SQL Server 2014
0
Tim Radney: SQL Server 2016 - Introduction to Stretch Database
Tim Radney walks through the configuration of a new SQL Server 2016 feature, Stretch Database, and discusses some of its limitations.
August 18, 2015
|
SQLPerformance.com
|
SQL Server 2016
,
System Configuration
,
Cloud
0
Top Categories
SQL Server
(229)
SQL Sentry
(156)
Community
(147)
T-SQL
(133)
SentryOne
(105)
Execution Plans
(67)
Azure
(63)
SQLFamily
(63)
Monitoring
(62)
Plan Explorer
(54)
SQL Server 2016
(51)
Performance Analysis
(50)
Performance
(49)
Cloud
(47)
T-SQL Tuesday
(47)
Career
(41)
Advisory Conditions
(40)
Alerting
(39)
Query Plan Analysis
(34)
System Configuration
(34)
Best Practices
(33)
Azure SQL Database
(31)
SQLVacation
(31)
PASS Summit
(30)
SQLSaturday
(28)
PASS
(26)
Security
(24)
Professional Development
(22)
Virtualization
(22)
#BackToBasics
(21)
Event Calendar
(20)
SentryOne Builds
(18)
Statistics
(18)
SQL Server Builds
(17)
Slide Decks
(17)
Wait Stats
(17)
DevOps
(16)
Documentation
(16)
Events
(16)
Global Partner Network
(16)
Indexes
(16)
Data Lineage
(15)
I/O
(15)
Engineering
(14)
PowerShell
(14)
Custom Conditions
(12)
Database Documentation
(11)
Extended Events
(11)
SSAS
(11)
Support
(11)
Windows
(11)
AWS
(10)
CPU Performance
(10)
Data Mining
(10)
Database Mapper
(10)
Database Performance
(10)
Fragmentation
(10)
Migration
(10)
PowerBI
(10)
Tips and Tricks
(10)
Bad Habits
(9)
SQLBits
(9)
Analysis Services
(8)
Baselines
(8)
Data Compression
(8)
DataOps
(8)
Disk Performance
(8)
Management Studio
(8)
Performance Monitoring
(8)
SQL Server 2014
(8)
SQL Server 2019
(8)
SSIS
(8)
Task Factory
(8)
Tech Outbound
(8)
tempdb
(8)
Disaster Recovery
(7)
Hardware
(7)
Memory Limits
(7)
Reporting
(7)
SQL Server Agent
(7)
SQL Server on Linux
(7)
SQLintersection
(7)
SSMS
(7)
#entrylevel
(6)
Backups
(6)
ColumnStore
(6)
Microsoft
(6)
Optimizer
(6)
SQL Server 2017
(6)
SQL Server Training
(6)
SentryOne Test
(6)
Speaking
(6)
Trace
(6)
AlwaysOn
(5)
Automation
(5)
Availability Groups
(5)
Customer Success
(5)
EHO
(5)
ETL
(5)
In-Memory OLTP
(5)
Licensing
(5)
Machine Learning
(5)
Partner Spotlight
(5)
PostgreSQL
(5)
SQLCruise
(5)
SQLPASS
(5)
Securing Azure SQL Database
(5)
Service Packs
(5)
Ship Shape Challenge
(5)
Standard Edition
(5)
Table Variables
(5)
Testing
(5)
Training
(5)
Agile
(4)
Azure Data Factory
(4)
Compliance
(4)
Connect
(4)
Deadlocks
(4)
GDPR
(4)
Hyper-V
(4)
Installation
(4)
Managed Instances
(4)
News
(4)
Query Store
(4)
Query Tuning
(4)
SQL Sentry Essentials
(4)
SQL Server 2012
(4)
SSRS
(4)
SentryOne Portal
(4)
Storage
(4)
Storage Forecasting
(4)
Transaction Log
(4)
Troubleshooting
(4)
Women in Technology
(4)
Agile at Home
(3)
Amazon RDS
(3)
Azure DevOps
(3)
CTPs
(3)
Cumulative Updates
(3)
DTU Calculator
(3)
Data Governance
(3)
Data Testing and Validation
(3)
Demos
(3)
Evaluating
(3)
Event Chains
(3)
MSP
(3)
Multi-Tenancy with SQL Server
(3)
SQL Monitoring
(3)
SQLskills
(3)
STRING_SPLIT
(3)
Server Health
(3)
Upgrade
(3)
User Guide
(3)
VMware
(3)
Visual Studio
(3)
Webinar
(3)
.NET
(2)
11.2
(2)
4K
(2)
Azure Data Studio
(2)
Cardinality
(2)
DOC xPress
(2)
Data Dictionary
(2)
Data Trends
(2)
Delayed Durability
(2)
Developer Edition
(2)
Docker
(2)
Environment Map
(2)
HTAP
(2)
Key Lookups
(2)
Open Source
(2)
Partitioning
(2)
Pragmatic Works Software
(2)
Python
(2)
Reflection
(2)
Sabin IO
(2)
SentryOne Cloud Sync
(2)
SentryOne Docs
(2)
SentryOne EMEA
(2)
UDFs
(2)
Volunteering
(2)
Wildcard
(2)
Azure Table Storage
(1)
Blocking
(1)
CodeStock
(1)
DB Sentry
(1)
DBA xPress
(1)
DEVELOPMENT
(1)
Dash
(1)
Data Platform
(1)
Data Pros of Tomorrow Scholarship
(1)
Data Stewardship
(1)
Data and Schema Comparison
(1)
MAXDOP
(1)
Personal Development
(1)
Problem Solving
(1)
Process Improvement
(1)
Product Samples
(1)
Republic Bank
(1)
SQL Sentry Premium
(1)
SQL Server 2022
(1)
SSDs
(1)
SentryOne Ambassadors
(1)
SentryOne Database
(1)
Tableau
(1)
Tabular
(1)
Triggers
(1)
how to implement multi tenancy
(1)
how to optimize database performance
(1)
perfmon
(1)
sql database optimization techniques
(1)
what is multi tenancy
(1)
See all
❮
1
2
3
4
❯
Get the best SQL query analysis and optimization tool –
free!
Index Analysis Sandbox
Statistics Analysis with Histogram
Management Studio Add-in
Plan Diagram
Deadlocks
History and Comments