(Manoj) Here are some of the best practices post installing SQL Server on Linux that can help you maximize database performance:
Tag: sql server
Measuring Query Execution Time: What Is Most Accurate
(Grant Fritchey) Probably the single most important factor when deciding which query to tune, or actively tuning a query, is how you go about measuring query execution time.
SQL Server high availability best practices in the cloud
(Lindsay Moore) The cloud isn’t immune to system failures. You can increase database uptime and prevent data losses with these high availability best practices for SQL Server in the cloud.
Bug in SSMS when using Extended Events
(Tibor Karaszi) I’d like to share one bug that has been irritating me over a long time. It is very easy to handle, once you know what the problem is. I’ve seen it when I want to open a file XE target:
Sending emails in Azure SQL Managed Instance
(Jovan Popovic) Azure SQL Database Managed Instance enables you to use most of the SQL Server features in fully managed cloud environment. One of the features is database mail system that enables you to send emails directly from Managed Instance.
The Good The Bad and The SLA
(blobeater) Lets just get straight to the point, Azure SQL Database across all service tiers gives you the customer a SLA of 99.99% up-time.
Backup a SQL database to a remote drive
(Jack Vamvas) Question: I’d like to backup a remote database and add a notification when it’s completed.
SQL SERVER – Script – Turn off Firewall Remotely (PowerShell, NetSh, PsExec)
(Pinal Dave) I was working with a client to deploy an automated solution to install SQL Server. Since this involved scripting and running PowerShell remotely, we wanted to disable the firewall.
Complicated linked servers and a bunch of head-desks: T-SQL Tuesday #104
(Kenneth Fisher) Wayne Sheffield (b/t) is our host this month for the long running blog party (104 months now and running!) started by Adam Machanic (b/t).
Configuring node.js application on Azure App Service with Azure Blob Storage
(Kruthi Villivalam) In this article, we will learn about configuring the node js applications deployed on Azure App Services with the Azure blob storage.
