SQL Server 2016 Management Studio Enhancements – Part 2
In this tip we will explore more enhancements in SQL Server 2016 Management Studio.
Hi! I am Rajendra Gupta, Database Specialist and Architect, helping organizations implement Microsoft SQL Server, Azure, Couchbase, AWS solutions fast and efficiently, fix related issues, and Performance Tuning with over 14 years of experience.
I am the author of the book "DP-300 Administering Relational Database on Microsoft Azure." I can be reached at: Rajendra.gupta16@gmail.com for any consulting help.
- MSSQLTips Awards:
- Author of the Year - 2022 | Author Contender - 2021/2023/2024 | Champion Award (100+ tips) - 2020
Profiler like templates for Extended Events Sessions in SQL Server
Read this tip to learn about the new Profiler like templates for SQL Server Extended Events that ship with Management Studio.
SQL Server DBCC CLONEDATABASE Example
Microsoft has recently released SQL server 2014 SP2 in which a new DBCC command - DBCC CLONEDATABASE is introduced. I found this command very useful and interesting too. In this tip we will explore the functionality of DBCC CLONEDATABASE.
SQL Server 2016 Sample Workload Tools
Along with the new sample databases for SQL Server 2016, Microsoft also introduced new tools to mimic sample workloads to further explore the functionality. In this tip we will explore these sample workload tools.
SQL Server 2016 Management Studio Enhancements
Learn about SQL Server 2016 Management Studio Enhancements including code highlighting, inline search, Quick Launch, tab customization, pinning tabs and more.
SQL Server 2016 Telemetry Extended Event Session
Read this tip to learn about the Telemetry Extended Events Session in SQL Server 2016.
Download and Install SQL Server Sample Databases WideWorldImporters
Learn how to download and install the SQL Server 2016 Sample Databases WideWorldImporters and WideWorldImportersDW.
SQL Server 2016 Trace Flags 1118 and 1117 for Page Allocations
Learn about SQL Server 2016 Trace Flags 1118 and 1117 for Page Allocations including the new default behaviors and how to validate the allocations.
Understanding database recovery with SQL Server 2016 Extended Events
Sometimes after a SQL Server restart you see that database recovery takes a long time and you want to know what is causing the delay. Up until SQL Server 2014 we could get some info from the error log, but in SQL Server 2016 we can get more insight.
SQL Server 2016 Auditing Improvements
Learn about the SQL Server 2016 Auditing improvements including user defined auditing, conditional auditing, auditing filtering, record of disabled and enabled auditing.
SQL Server 2016 Parameter Sniffing as a Database Scoped Configuration
Learn about how to setup and use SQL Server 2016 Parameter Sniffing as a Database Scoped Configuration.
Capture Detailed SQL Server Restore Steps with Extended Events
SQL Server 2016 provides Extended Events for database restores, which we will explore in this tip.
SQL Server Database Scoped Configuration Settings
In an earlier tip SQL Server 2016 Database Scoped Configuration, we provided an overview of the important parameters that can be set at the database level which were previously available at the instance level only. In this tip we are going to explore this
SQL Server 2016 Extended Events Detailed Backup Information
There are several ways to track SQL Server database backup and restore progress using wait stats, DMVs and trace flags, but SQL Server 2016 provides more insight using Extended Events which we will take a look at in this tip.
SQL Server 2016 Database Scoped Configuration Options
SQL Server 2016 Database Scoped Configuration options including Legacy Cardinality Estimation, MAX DOP, Parameter Sniffing, Query Optimizer Fixes and Clearing the Plan Cache.
SQL Server 2016 RC0 Installation and Configuration Changes
In a previous tip on SQL Server 2016 installation changes, we have seen some changes in the SQL server 2016 installation process. In this tip we are going to see some additional changes and improvements with the SQL Server 2016 RC0 installation process.
SQL Azure Geo Replication Configuration and Testing
Learn about the options for SQL Azure Geo Replication as well as the steps to complete the configuration and testing.
Configure and Customize SQL Azure Dynamic Data Masking
Learn how to configure and customize SQL Azure Dynamic Data Masking for common data such as credit cards, social security numbers, etc. and custom fields.
SQL Server Compress and Decompress Functions
In SQL Server 2016 we have new compression functions to compress and uncompress specific data. Read this tip to learn about these new functions.
SQL Server 2016 Row Level Security Block and Filter Predicates Example
Learn about the SQL Server 2016 Row Level Security Block and Filter Predicates with Select, Insert, Update and Delete example T-SQL code
Manage Extended Events for SQL Server 2016 Analysis Services in Management Studio
Learn how to configure and manage Extended Events for SQL Server Analysis Services 2016 with SQL Server 2016 Management Studio.
SQL Server Transactional Replication Static Row and Column Filters
Learn how to filter both column and row level data when replicating SQL Server data.
SQL Server 2016 Database Maintenance Plan Improvements
Learn about SQL Server 2016 for Database Maintenance Plans for reindexing, reorganizing indexes and DBCC CHECKDB.
Consistency Checks for SSAS
Learn about SQL Server Analysis Services (SSAS) database consistency checks (DBCC) for databases, cubes or partitions. Check out code samples and capturing output.