One of the easier ways to improve the performance of your SQL Server and Azure SQL database queries is to ensure you choose the right data types for your data, and the data types in your application’s code match the ones in your stored procedures and queries. Choosing the right data type conserves space, because … Read more How Data Types and Query Tuning Can Improve Application Performance
When it comes to saving on your database infrastructure cost, you must have a way to efficiently visualize your cloud-hosted database activities. Using a cloud-based database cost monitoring tool can enable you to gain clear, accurate insights into where costs are going in your database. By remotely discovering and analyzing these key metrics, you could … Read more Database Infrastructure in Cloud Cost Monitoring
Many people today are seeking ways to simply, quickly, and safely get files from one place to another. The ability to share files easily through file sharing, file transfer, and other means of file communication helps mobilize business data for optimization. Using Citrix ShareFile is one way to achieve this, as it is an enterprise … Read more 5 Citrix ShareFile Alternatives for Safer File Transfers
Many organizations have migrated their environments from on-premises to the cloud, and one of the clouds of choice is Microsoft Azure. For SQL Server workloads, organizations can use platform as a service solutions with features like Azure SQL Database and Managed Instance or infrastructure as a service solutions with Azure SQL virtual machines. Azure SQL virtual … Read more How to Make SQL Server Faster on Azure VMs
When’s the last time you looked at a syslog message? How often do you review your syslog messages? If you’re not regularly reviewing syslog messages, you’re missing important information about how your IT infrastructure is performing. But if you’re spending a lot of your time watching syslog messages (admittedly tedious and boring work), you’re not … Read more Syslog Management – Don’t Overlook Your Syslog Messages
As we all know, an extensive outage on Monday, October 4, brought Facebook, WhatsApp, and Instagram down. According to the estimates, this outage caused a loss of at least US$6 billion for Mark Zuckerberg as an effect of the stock price drop. And the impact on thousands of small and medium businesses relying heavily on … Read more Could Facebook Have Prevented the Outage and Saved $6 Billion for $850?
In the modern era there’s often no way to avoid sending files containing sensitive information from one device to another. Unfortunately, there are several complications you can encounter during the process that can be detrimental to your business. These cover everything from file loss and corruption to slow file transfer speeds. To help avoid those … Read more 6 WinSCP Alternatives for Safer File Transfers
As one of the biggest public cloud vendors on the market, Microsoft Azure has significantly grown in popularity over the years. With the many advantages of Azure, it’s easy to forget your services can quickly become far more expensive than your initial Azure cost estimate. Major cost savings is one of the main reasons why … Read more Azure Cost Monitoring Solutions
There are a large number of best practices around SQL Server performance tuning – I could easily write a whole book on the topic, especially when you consider the number of different database settings, SQL Server settings, coding practices, SQL wait types, and so on that can affect performance. For this post I decided to … Read more 10 SQL Server Performance Tuning Best Practices
Even if you’re not familiar with the ins and outs of SharePoint, you’ve probably heard of the platform. Launched by Microsoft in 2001, this popular web-based collaborative tool offers document management and storage systems teams can use to create and support websites and online portals. The platform uses workflow applications, “list” databases, and other logistical, … Read more SharePoint Infrastructure Monitoring and Health Check Guide