AWS Cloud Costs Report, Free Space Report for Database Shrinking and SQL Server Indexing (MSSQLTips 1/9/2020)

Free SQL Server Resources [AWS Cloud Costs Report]( Cost Monitoring | Email Reporting - In this article we look at how to build a report that can be sent via email to notify you about our AWS resource usage. [Script to determine free space to support shrinking SQL Server database files]( In this tip we look at a script that can be used to see how much free space there is per SQL Server database file in order to assist you with determining which files you should shrink. [SQL Server Performance Tuning Hints and Tricks]( [Webcast] The goal of this presentation is to give you a set of steps you can follow that will detect and fix a lot of the most common SQL Server performance issues you'll encounter. [Using Parameters for SQL Server Queries and Stored Procedures]( One of the benefits of SQL is the ability to write a query and use parameters to dynamically act upon the resultset. Depending on the situation, there can be benefits to parameterizing queries, but it is not always clear when or how to do this. In this tip we look at different ways to pass in values as parameters to queries and the advantages and disadvantages. [Concatenate SQL Server Columns into a String with CONCAT()]( In this tip we look at different ways to concatenate SQL Server string data and how to deal with NULL values when concatenating strings. [SQL Server Reporting Services Mobile Reporting Tutorial]( SQL Server Reporting Services (SSRS) 2016 introduced Mobile Report Publisher which is intended to develop reports for mobile devices, tablets as well as desktops. It ships with 30 different visualizations that can be used to develop rich mobile dashboards. Built-in simulators can be used to test reports for different layouts, which eliminates the need for external third-party device specific simulators. [Types of SQL Server Indexes]( Query Performance | Indexes | Design - In this tip we will go through each type of index that is available in SQL Server and give an overview as well as advice on which index types fit each particular use case. More on MSSQLTips: [Tips]( [Tutorials]( [Webcasts]( [tag] You are receiving this email as a subscriber of MSSQLTips.com. [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC | PO Box 682 | Wilton, NH 03086 | [Privacy Statement]( Sent to this e-mail address: {EMAIL}