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
Storage is one of the most critical components for any relational database management system, and getting the right storage configuration affects reliability, availability, and performance. When it comes to SQL Server storage best practices, choosing between storage hardware options has changed significantly over the last decade, but that doesn’t necessarily make choosing the correct storage … Read more SQL Server Storage Best Practices: Choosing Storage Options
If your organization needs data security and a convenient way to share, store, and organize content, you may already be using SharePoint. If you aren’t already using SharePoint, it may be time to start. Customizable and scalable, SharePoint is a powerful and industry-leading web-based tool that facilitates workplace collaboration. When using SharePoint, ensuring SharePoint server … Read more SharePoint Farm Explained: What It Is and How To Use It
For nearly three decades, developers have been using File Transfer Protocol, or FTP, to transfer files. However, using FTP can leave your data and passwords vulnerable during the transfer, as FTP doesn’t encrypt passwords. Consequently, many developers have switched to using Secure File Transfer Protocol (SFTP) or File Transfer Protocol over SSL (FTP/S). Using an … Read more 6 FileZilla Alternatives for Safe File Transfers
Managing any database ecosystem is difficult enough: taking backups, maintaining statistics, and doing performance tuning all tax the time of the DBA or database developer. The job is complex even without considering the work you do to manage the various schema and data drifts that can occur. Unless you operate in a vacuum or within … Read more Spotting and Avoiding Database Drift
One of the easiest ways to increase query performance in SQL Server is to make sure it can quickly access the requested data as efficiently as possible. In SQL Server, using one or more indexes can be exactly the fix you need. In fact, indexes are so important, SQL Server can warn you when it … Read more Indexing Strategies for SQL Server Performance
Azure is a flexible and scalable cloud computing service announced in 2008, released in 2010 as Windows Azure, and renamed Microsoft Azure in 2014. While traditional IT infrastructure requires you to manage on-premises servers, Azure takes a cloud-based approach, so you can build, run, and manage your applications with a Microsoft-managed global cloud storage site. … Read more Azure Service Bus Explained: What It Is, How To Use It, and How To Monitor It
The performance of your applications is a complex, multi-layered puzzle. Performance can be negatively impacted at the application layer or even by remote calls to networked services. However, the most common bottleneck for applications is the data storage layer. The most common data storage tier for applications is a relational database, whose performance can vary … Read more Basic SQL Server Query Tuning Secrets Every SQL Admin Should Know
Today employees seek instant online help and prefer technical support through an online information base instead of waiting for a human support technician to respond via email or call. To meet high service expectations, enterprises strive to build a simple and comprehensive knowledge base that empowers employees to resolve issues in a few clicks. A … Read more 5 Tips to Build a Great Knowledge Base