October 2022 Top Tips, Python Functions and SQL Server Data Archival (MSSQLTips 11/2/2022)

[tag] [MSSQLTips.com]( Cannot see this MSSQLTips.com newsletter? [] [View in browser]( [Stop Indexing the Query!]( [Python Keywords for Functions, Modules, Classes, Variables, Coroutines and More]( In this tip, we learn about various Python keywords and how to use them related to functions, modules, classes, variables, coroutines, and others.... By Hristo Hristov - [Learn More]( [SQL Server at Scale – Using an Archive Table, Part 1]( In this series of articles, we look at strategies for archiving data from your production systems and the impact on systems and management of your databases.... By Aaron Bertrand - [Learn More]( [Register now for best practices for indexing and writing queries]( Learn index basics and how to write queries to take advantage of more efficient, better-performing SQL query performance.... [Learn More]( [Date and Time Conversions Using SQL Server]( In this article we look at several different date and time formats you can use in SQL Server.... [Learn More]( [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.... [Learn More]( [Getting Started with Snowflake Tutorial]( In this tutorial we will go over the basics of Snowflake, introducing the product and features which makes it stand out against its competitors. We look at how to load and query data as well as how to use Power BI to create reports using the Snowflak... [Learn More]( [VMware Performance Monitoring for SQL Server DBAs]( We have a large SQL Server environment supported by physical servers, VMware and cloud infrastructure. Unfortunately, we are facing a number of performance challenges. We have frequent situations where the end user experience degrades.... [Learn More]( [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... [Learn More]( [Real-Time Data Validation API for SQL Server]( Ingesting client data without prior validations or quality checks can cause tremendous headaches when the data reaches subsequent business processes. In this webcast, we showcase how to take advantage of two data quality APIs to validate, enhance and... [Learn More]( MSSQLTips - Last Month's Top Ten Tips [Improve Performance and Management of Large Table by Converting to Partitioned View in SQL Server]( [Quickly Evaluate SQL Server Best Practices with Invoke-SqlAssessment]( [Power BI Certification FAQ for Exams PL-300 and PL-900]( [SQL Stored Procedure Input and Output Parameters, Types, Error Handling, Security and more]( [Raising Exceptions and Error Handling with SQL Server THROW]( [Indexing in SQL with Clustered and Non-Clustered Indexes]( [New and Enhanced Features in SQL Server 2022]( [SQL Server Indexes to Improve Query Performance]( [Load Data Asynchronously to SQL Server via an API and Python]( [SQL Cheat Sheet for Basic T-SQL Commands]( [Twitter]( [Facebook]( [LinkedIn]( [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLC | PO Box 682 | Wilton, NH 03086 | [Privacy Statement]( Sent to this e-mail address: {EMAIL}