(Parikshit Savjani) One of the design goals of SQL Server 2016 was to improve performance and scalability of the engine out of the box to make it run faster without the need of any knobs or trace flags for customers.

(Manvendra Singh) If you have to remove an AlwaysOn Availability Group from your SQL Server instance then follow this tip. I’ll explain step by step how to remove an AlwaysOn Availability Group using both SQL Server Management Studio and T-SQL commands.

(Jack Vamvas) This is not a trick question, but what is the Windows Exit Code 1077?

(Kenneth Fisher) Hey, who changed the max memory setting for the xyz instance? The good news is that this information is captured in the default trace.

(Greg Larsen) Most shops use database mail for sending email alerts. Additionally, you might have some applications that are sending database mail. Database mail items are stored in the msdb database.

(Pinal Dave) Applying a patch in SQL Server is a planned process which is followed across various companies. Most of the companies take time to apply the patch to make sure the stability of the patch can be validated. Let us see an error related to patch installer.

(Melissa Coates) Tags in Azure are useful pieces of metadata for documenting (annotating) things such as:

(mksunitha) App Service domains (preview) simplifies to create and manage domains for various Azure services. App Service domains leverages Azure DNS for hosting the domain and GoDaddy as the domain registrar.In addition to the domain registration fee, usage charges for Azure DNS apply.

(Kenneth Fisher) As DBAs our stock in trade is information and there is certainly an impressive amount available. The diagnostic views are the most common place to get the information we need but every now and again it’s nice to get an organized/pretty view.

(Manoj Pandey) This happened when we started working on a new SQL Server instance for our DEV environment. The history of SQL jobs was not getting retained after a day or few runs.