SQL metadata, Google Cloud, Backups, Monitoring, TSQL and more

Learn about new SQL Server topics from MSSQLTips.com [MSSQLTips.com logo]( [View email in your browser]( [Secure your data with layers of protection on Azure SQL Managed Instance]( TODAY'S NEWS FROM MSSQLTips Learn something new every day! [mssqltips image]( [Best Practices for Google Cloud Security]( When moving to the cloud, security is critical and this article reviews things to consider when using Google Cloud services.... [Read Now]( [mssqltips image]( [Query SQL Server system data about tables and columns]( This article discusses using T-SQL to access metadata for SQL Server tables and how to query sys.tables, sys.columns, sys.system_columns, and sys.all_columns.... [Read Now]( [mssqltips image]( [SQL Server Monitoring at Every Layer]( End to End Monitoring | Health | Availability - I need to monitor the SQL Server instances in my environment and our IT team has a need to monitor the health and availability of our overall environment. We need to understand the issues in the enviro... [Read Now]( RECOMMENDED READING ON MSSQLTips [mssqltips image]( [Simple script to backup all SQL Server databases]( In this article we look at how you can automatically backup all of your SQL Server databases with a couple of T-SQL commands.... [Read Now]( [mssqltips image]( [Learn about Protecting SQL Server in the Cloud - Tomorrow]( Join this webinar to learn what it means to secure data within a managed service like Azure SQL Managed Instance and the basics of securing your SQL data through our layered, defense-in-depth approach.... [Read Now]( [mssqltips image]( [SQL Server DROP TABLE IF EXISTS Examples]( In this article we cover various ways to check if a SQL Server table exists before trying to drop the table to avoid the error Msg 3701 Level 11 State 5 cannot drop the table because it does not exist or you do not have permission.... [Read Now]( ADDITIONAL RESOURCES ON MSSQLTips [mssqltips image]( [Email Validation Simplified with Web API and SSIS]( Email based validation is more than just a simple RFC check, this is where Melissa's Global Email Verification with a web-based API and SSIS delivers valuable data to SQL Server Professionals.... [Read Now]( [mssqltips image]( [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.... [Read Now]( [mssqltips image]( [Understanding Disaster Recovery Options for SQL Server]( This white paper provides some practical guidance to help system and database administrators tasked with creating business continuity and disaster rec... [Read Now]( [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL} [tag]