Programmatically find SQL Server TCP ports

There are many instances in SQL Server management where one person would like to find all the TCP ports that SQL Server is binding to. Finding all the TCP ports that SQL Server is listening on might be for security related auditing, connectivity troubleshooting, or for some form of automation. One such example is used…


Community driven Enhancements in SQL Server 2017

While SQL Server 2016 runs faster, SQL Server 2017 promises to run even faster and empower customers to run smarter with intelligent database features like the ability to run advanced analytics using Python in a parallelized and highly scalable way, the ability to store and analyze graph data, adaptive query processing and resumable online indexing…


SQL Server Mysteries: The Case of the Not 100% RESTORE…

I recently visited a customer onsite and presented to them topics on SQL Server 2016. After the talk, I opened up the floor for the audience to ask me questions. One question I got went like this “I’ve tried to restore a database on SQL Server using the WITH STATS option. When I run the…


HADR Virtual Chapter – Monitoring Always On Availability Groups

This past week SQL Server Tiger Team delivered a webinar session for the HADR PASS virtual chapter. During the session, I talked about some of the enhancements which were introduced in SQL Server 2016 and SQL Server 2016 Service Pack 1. The enhancements which I covered during the session fall in three broad categories Fundamental…

0

SQL Server Performance Baselining Reports Unleashed for Enterprise Monitoring !!!

In my previous blog post, I shared how you can leverage SQL Server Performance Dashboard SSRS Reports for monitoring and point in time troubleshooting for large deployments of SQL Server. In this post, we will talk about why dbas should establish SQL Server Performance baselines for their environment and how you can leverage the SQL…


FILESTREAM issues with SQL Server on Windows 10 creators update

If you have SQL Server installed on Windows 10 and if you have enabled the Filestream feature at the instance level and created databases that have filestream containers, after applying the Windows 10 creators update [RS2] you will notice that the filestream feature does not work and you encounter unexpected errors. In Windows 10 creators…


SQL Saturday 613: Tiger Team sessions

  Tomorrow there’s an exciting SQL Saturday event at the Microsoft Campus in Redmond, where the community gets together to share insights, and meet new and not so new friends. The Tiger Team is excited to be a part of the event, and will be presenting a few sessions. At 9:45AM PST, Sunil Agarwal will…


Troubleshooting High HADR_SYNC_COMMIT wait type with Always On Availability Groups

HADR_SYNC_COMMIT indicates the time between when a transaction ready to commit in the primary replica, and all secondary synchronous-commit replicas have acknowledged the hardening of the transaction commit LSN in an AG. It means a transaction in the primary replica cannot be committed, until the primary replica received greater hardened LSNs from all secondary synchronous-commit…

0

DEA 2.0 Technical preview: Release Overview – Database Experimentation Assistant

Overview Database Experimentation Assistant (DEA) is a new A/B testing solution for SQL Server upgrades. It will assist in evaluating a targeted version of SQL for a given workload. Customers who are upgrading from previous SQL Server versions (SQL Server 2005 and above) to any new version of the SQL Server will be able to…

0

CDC functionality may break after upgrading to the latest CU for SQL Server 2012, 2014 and 2016

Microsoft SQL Server Product team has identified a potential issue with the latest Servicing Releases for SQL 2012, 2014 and 2016, where in Change Data Capture functionality might break if The databases enabled for CDC are part of Always On availability group, OR SQL Server replication components are not installed on the server Details Microsoft…

16