Rolling Up Data, Cursors, Databricks Data Governance and Python Machine Learning

Learn about new SQL Server topics from MSSQLTips.com [MSSQLTips.com logo]( [View email in your browser]( TODAY'S NEWS FROM MSSQLTips Learn something new every day! [mssqltips image]( [Understanding Databricks Unity Catalog for Unified Data Governance]( Organizations are beginning to switch to storage that provides unified data governance to company resources. Databricks Unity Catalog gives users a specific location to manage rights while offering granular access control and several other useful fea... [Read Now]( [mssqltips image]( [Unlock the Power of SolarWinds SQL Sentry: Join the Conversation!]( Check out SolarWinds SQL Sentry product forum for getting started, asking questions, and resources to help you get the most out of SQL Sentry.... [Read Now]( [mssqltips image]( [Validate the contents of large dynamic SQL strings in SQL Server]( Often when you are generating dynamic SQL you will want to validate the content of the query as opposed to just blindly executing it. Unfortunately, Management Studio can make it difficult to check that your command is complete, never mind to trouble... [Read Now]( RECOMMENDED READING ON MSSQLTips [mssqltips image]( [Reduce SSIS Development Time]( Learn how to enhance native SSIS Packages with new connectivity options, components for productivity and exceptional performance with SolarWinds Task Factory.... [Read Now]( [mssqltips image]( [Machine Learning to make Predictions using Python and TensorFlow]( This article looks at how to use machine learning to make predictions using Python code with the machine learning library TensorFlow.... [Read Now]( [mssqltips image]( [How Costly is Data Accuracy in SQL Server Databases]( Learn about the Challenges, Interesting Findings and Opportunities in the 2023 Data Quality Report. ... [Read Now]( ADDITIONAL RESOURCES ON MSSQLTips [mssqltips image]( [Rolling up multiple rows in a SQL Server table]( Learn how to roll-up multiple rows into one row and one column with concatenation in SQL Server with FOR XML, STUFF and STRING_AGG. ... [Read Now]( [mssqltips image]( [Get Database Insights Across Your Environment]( Learn how to improve your database efficiency with SolarWinds Database Insights, which combines two enterprise-ready products: Database Performance Analyzer (DPA) and SQL Sentry. ... [Read Now]( [mssqltips image]( [SQL Server Cursor Example]( A SQL Server cursor is a set of T-SQL logic to loop over a predetermined number of rows one at a time. The purpose for the cursor may be to update one row at a time or perform an administrative process such as SQL Server database backups in a sequent... [Read Now]( [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL} [tag]