Event Streams, REST APIs, Encryption, Database Free Space, SQL Functions, and more

[MSSQLTips.com logo]( [View email in your browser]( TODAY'S NEWSÂ FROM MSSQLTips Learn something new every day! [mssqltips image]( [Event Streams for Microservice Communication]( This article examines how you can use event sourcing to maintain persistent and asynchronous communication between microservices.... [mssqltips image]( [Securely Transform Your SQL Server with DreamFactory's Instant REST API]( DreamFactory provides a low-code approach to putting a RESTful API endpoint in front of any SQL Server table, view, or stored procedure. Our comprehensive security features ensure your APIs are both safe and compliant.... [mssqltips image]( [Build a Secure SQL Server REST API in Minutes]( Learn how to build a secure SQL Server REST API in minutes with DreamFactory which is middleware that connects all of your applications across the enterprise in a secure manner.... RECOMMENDED READINGÂ ON MSSQLTips [mssqltips image]( [Secrets to Fast, Easy High Availability for SQL Server]( Learn how to quickly build a two-node HA cluster for SQL Server in the AWS cloud.... [mssqltips image]( [Easy and Cost Effective way to Encrypt Every SQL Server Database]( Learn why Becton Dickinson has selected DBDefence to protect their SQL Server data across numerous medical devices in a cost effective manner.... [mssqltips image]( [Bringing SQL Server Data Quality Tools to Your Company]( Learn how and why you should be using Melissa's data quality components that fully integrate into SSIS packages to fix data problems and save your company money.... ADDITIONAL RESOURCESÂ ON MSSQLTips [mssqltips image]( [Different ways to determine free space for SQL Server databases and database files]( One of the functions of a DBA is to keep an eye on free space within the database and database files. The auto grow feature is great as a last resort, but proactively managing the database files is a better approach. Also, this information can be u... [mssqltips image]( [Auto generated SQL Server keys]( I am designing a table and I have decided to create an auto-generated primary key value as opposed to creating my own scheme or using natural keys. I see that SQL Server offers globally unique identifiers (GUIDs) as well as identities to create these... [mssqltips image]( [SQL Server Function GENERATE_SERIES]( In this tip, we cover how to use the GENERATE_SERIES function to expand a range of dates into rows.... [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLCÂ PO Box 682 | Wilton, NH 03086Â [Privacy Statement]( Sent to: {EMAIL}Â [tag]