DevOps Projects, Snowflake Schemas, Load Testing and Apache Spark (MSSQLTips 4/4/2023)

Learn about new SQL Server topics from MSSQLTips.com [MSSQLTips.com logo]( [View email in your browser]( [SQLGrease does the heavy lifting on performance problems]( [SQLGrease does the heavy lifting on performance problems]( TODAY'S NEWS FROM MSSQLTips Learn something new every day! [mssqltips image]( [Jenkins Installation, Configuration and Automation for DevOps Projects]( Learn about a scheduling tool called Jenkins that can be used to automate the execution of PowerShell scripts and other DevOps tasks in your environment.... [Read Now]( [mssqltips image]( [Spend Your Weekend Finding Easter Eggs Not Performance Problems]( Nobody likes spending time fixing performance problems on a holiday weekend. SQLGrease helps you proactively spot problems making it less likely that you'll spend your personal time working.... [Read Now]( [mssqltips image]( [What is a Snowflake Schema and how to use in Power BI]( In this article, we look at what a snowflake schema is and also how to use a snowflake schema in Power BI.... [Read Now]( RECOMMENDED READING ON MSSQLTips [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.... [Read Now]( [mssqltips image]( [Metadata Functions in SQL Server and Their Use Cases]( Learn about various SQL Server system functions to return meta data from SQL Server such as SERVERPROPERTY, DATABASEPROPERTYEX, DB_NAME, DB_ID, FILE_NAME, FILE_ID, FILE_IDEX, SCHEMA_NAME, SCHEMA_ID, OBJECT_NAME, OBJECT_ID and STATS_DATE.... [Read Now]( [mssqltips image]( [Deep SQL Query Optimization with SQL Grease]( Learn how to conduct deep SQL Query optimization with SQL Grease with the Enterprise dashboard, historical data, troubleshooting SQL Server Wait Stats, capturing anomalies and intelligent notifications.... [Read Now]( ADDITIONAL RESOURCES ON MSSQLTips [mssqltips image]( [Getting Started with SqlQueryStress for SQL Server Load Testing]( Learn how to install and use SqlQueryStress to help with tune your SQL Server databases, stored procedures, indexes, and more.... [Read Now]( [mssqltips image]( [Make SSIS Your Data Cleansing Tool]( Learn about the Melissa Data Quality Solutions for SSIS.... [Read Now]( [mssqltips image]( [Data Processing using Apache Spark and SQL Server using pymssql]( Microsoft and Databricks have created a high-speed Apache Spark connector to read or write dataframes to SQL Server. This article covers this and a library called pymssql that can control database interactions to SQL Server.... [Read Now]( [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL} [tag]