SQL Server Tutorials (MSSQLTips 1/27/2023)

[tag] [View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [Free SQL Server Tutorials]( [Privileges and Roles in SQL Server, Oracle and PostgreSQL - Part 1]( [Privileges and Roles in SQL Server, Oracle and PostgreSQL - Part 1]( This tip will review the different ways of granting privileges in SQL Server, Oracle, and PostgreSQL, the differences in the concepts of roles, schemas, and owners, and the way to grant permissions on the whole schema. ... [Less Than 1 Week Left - Vote Now]( [Less Than 1 Week Left - Vote Now]( We have 21 dedicated authors in the running for the 2022 MSSQLTips.com Author and Rookie of the Year. Vote now and vote often...... [Tutorial - Learn Stored Procedures]( [Tutorial - Learn Stored Procedures]( This tutorial look at how to create stored procedures in SQL Server to be able to reuse the code for various purposes....... [Azure Data Factory Tutorial]( [Azure Data Factory Tutorial]( In this tutorial we will go over the basics of Azure Data Factory and show you how you can create your first pipelines....... [Tutorial on SQL Triggers]( [Tutorial on SQL Triggers]( There is often the need to perform a database action in response to a specific event occurring. In this tutorial learn about SQL Server triggers and how these can be used to run additional code after an event occurs like inserting or changing data....... [Indexing Step by Step]( [Indexing Step by Step]( This tutorial will try to go through each type of index available in SQL Server and explain why/when each one could be used to improve your query performance....... [SQL Strings Tutorial]( [SQL Strings Tutorial]( This shows how to use the SQL ASCII function to return the ASCII value for a character value....... [Snowflake Tutorial]( [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....... [By Greg Robidoux - ]( [Determining space used for all tables in a SQL Server database]( In this tip we look at a simple way to get a sortable list of space used for all tables in a SQL Server database.... [By Sergey Gigoyan - ]( [Find MAX value from multiple columns in a SQL Server table]( In this article we look at different T-SQL approaches to get the maximum value from multiple columns in a table.... [By Jeremy Kadlec - ]( [Learning SQL Server]( Learn about the core SQL Server concepts to build your skill set including the architecture, database design, development, administration and more.... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}