SQL Cheat Sheet, Most Popular SQL Server Jobs, Date Conversions and Week in Review (MSSQLTips 10/17/2022)

[tag] [View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [300+ industry leading sessions from 300+ expert speakers - Register now]( [SQL Cheat Sheet for Basic T-SQL Commands]( [SQL Cheat Sheet for Basic T-SQL Commands]( In this article, we cover some basic T-SQL commands that show you how to interact with a SQL Server database table.... [What are the most popular SQL Server jobs?]( [What are the most popular SQL Server jobs?]( Learn about the current demand for SQL Server-related jobs and the trends for various positions as well as salary-related information.... [Sign up today with the special codes to attend in person or online this November]( [Sign up today with the special codes to attend in person or online this November]( The largest data conference is just around the corner! Learn, network, and boost your data career. Use code SQLTIPSVIP for $150 OFF on a 3-Day In-Person conference pass and SQLTIPSONLINEVIP for 10% OFF on the 3-Day Online Pass. Register now... [SQL Server Cursor Example]( [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... [Optimize SQL Server Monitoring for Operational and Performance Needs]( [Optimize SQL Server Monitoring for Operational and Performance Needs]( Learn about how SQL Monitor saves significant time for operational tasks and performance monitoring for large SQL Server environments with instances on premises, in the cloud, running in virtualized environments, clusters, and Availability Groups.... [SQL Convert Date to YYYYMMDD]( [SQL Convert Date to YYYYMMDD]( In this article we look at different ways to use the date format YYYYMMDD in SQL Server.... [Migrate to AWS Cloud to Gain Business Agility and Cost Benefits]( [Migrate to AWS Cloud to Gain Business Agility and Cost Benefits]( The migration to AWS was a major undertaking for SkyTouch. Not only did SkyTouch need to minimize the impact of downtime for their customers, they also had to plan for numerous integrations between systems, customers, and third parties. The AWS Migra... [Execute Dynamic SQL commands in SQL Server]( [Execute Dynamic SQL commands in SQL Server]( In some applications having hard coded SQL statements is not appealing, because of the dynamic nature of the queries being issued against the database server. This is where dynamically building SQL statements can be useful.... [How is the data quality in your SQL Server databases?]( [How is the data quality in your SQL Server databases?]( Data is being generated at breakneck speed, and more companies are moving towards a data-driven culture. But many data professionals and companies still struggle with the challenge to improve data quality and accuracy in their systems.... MSSQLTips Week In Review [Bringing SQL Server Data Quality Tools to Your Company]( [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.... [How to connect to a Power BI Datamart in Power BI Desktop]( [How to connect to a Power BI Datamart in Power BI Desktop]( In this article, we look at four different approaches to connecting Power BI Desktop to a Power BI Datamart along with the steps to make a proper connection.... [Indexing in SQL with Clustered and Non-Clustered Indexes]( [Indexing in SQL with Clustered and Non-Clustered Indexes]( In this article, we look at how to create clustered and nonclustered indexes for SQL Server tables.... [Leveraging the Script Activity within Azure Data Factory]( [Leveraging the Script Activity within Azure Data Factory]( Learn how to use the Script activity in an Azure Data Factory pipeline to deploy and populate databases using DDL, DCL, and DML statements. ... [Python Keywords - Boolean, Conditionals, Logical Operators, Membership Checks, Exceptions and Loops]( [Python Keywords - Boolean, Conditionals, Logical Operators, Membership Checks, Exceptions and Loops]( This article provides an overview of all Python keywords according to their function: Boolean, conditionals, logical operators, membership checks, exceptions, and loops, along with explanations and examples. ... [Raising Exceptions and Error Handling with SQL Server THROW]( [Raising Exceptions and Error Handling with SQL Server THROW]( Learn how and why to use THROW in your SQL Server code to be able to better handle errors that may occur during code execution.... [Scroll Cursors in SQL Server]( [Scroll Cursors in SQL Server]( Learn about Scroll Cursors in SQL Server, how to build them and how they can be used to selectively pick a row from the cursor instead of looping through row by row.... [Using the Microsoft Assessment and Planning (MAP) Toolkit to Inventory SQL Server Instances Across the Network]( [Using the Microsoft Assessment and Planning (MAP) Toolkit to Inventory SQL Server Instances Across the Network]( Learn how to use the Microsoft Assessment and Planning (MAP) Toolkit to take inventory of SQL Server instances and databases across the network. ... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}