Microsoft SQL Server
@MSSQLServerTraining
9.19K
subscribers
269
photos
77
videos
46
files
5.2K
links
Sql Server Training
Adimn :
@MSSQLServerTrainingAdmin
Download Telegram
Join
Microsoft SQL Server
9.19K subscribers
Microsoft SQL Server
https://www.mssqltips.com/sqlservertip/7008/red-hat-subscription-management-vmware-virtual-machine/?utm_source=dailynewsletter&utm_medium=email&utm_content=headline&utm_campaign=20211014
Mssqltips
Configure Red Hat Subscription Management on VMware Virtual Machine
In this article we configure Red Hat Subscription Management on a VMware virtual machine so we can install SQL Server 2019 for Linux.
Microsoft SQL Server
https://www.mssqltips.com/sqlservertip/7001/sql-string-functions-sql-server-oracle-postgresql/
Mssqltips
SQL String functions Examples for SQL Server, Oracle and PostgreSQL
In this article we look at how to use string functions to concatenate, replace, trim and get substrings in SQL Server, Oracle and PostgreSQL.
Microsoft SQL Server
https://www.mssqltips.com/sqlservertip/7007/azure-mlops-framework/
Microsoft SQL Server
https://www.mssqltips.com/sqlservertip/6091/how-to-use-rowcount-in-sql-server/
MSSQLTips.com
How to use @@ROWCOUNT in SQL Server
In this tip we look at how to use the SQL Server @@ROWCOUNT system variable and things you should know about its usage.
Microsoft SQL Server
https://www.mssqltips.com/sqlservertip/6997/bi-developer-technical-and-soft-skills/?utm_source=dailynewsletter&utm_medium=email&utm_content=headline&utm_campaign=20211018
Mssqltips
BI Developer Technical and Soft Skills for Success
In this article we cover technical skills and soft skills that are typically found in successful BI developers.
Microsoft SQL Server
https://www.mssqltips.com/sqlservertip/6828/sql-server-login-user-permissions-fn-my-permissions/
MSSQLTips.com
SQL Server Login and User Permissions with fn_my_permissions
In this article we look at how to list SQL Server permissions for a login or a user using the system function fn_my_permissions.
Microsoft SQL Server
https://www.mssqltips.com/sqlservertip/7006/copy-data-between-cosmos-db-containers-with-pyspark-scripts/?utm_source=dailynewsletter&utm_medium=email&utm_content=headline&utm_campaign=20211018
Mssqltips
Copy Data Between Cosmos DB Containers with PySpark Scripts
In this article learn how to use PySpark scripts in Azure Databricks service to copy data between Cosmos DB containers.
Microsoft SQL Server
https://www.mssqltips.com/sqlservertip/6611/email-validation-simplified-with-web-api-and-ssis/?utm_source=dailynewsletter&utm_medium=email&utm_content=headline&utm_campaign=20211018
MSSQLTips.com
Email Validation Simplified with Web API and SSIS from Melissa
Melissa Data's Global Email Verification solution delivers valuable and accurate data in real time with an API or in batch with SSIS.
Microsoft SQL Server
https://www.mssqltips.com/sqlservertip/6432/improve-the-data-quality-for-healthcare-clinical-and-life-sciences-projects-with-melissa-informatics/?utm_source=dailynewsletter&utm_medium=email&utm_content=headline&utm_campaign=20211018
MSSQLTips.com
Improve Data Quality for Healthcare Projects with Melissa Informatics
Learn how to improve the Data Quality for Healthcare, Clinical and Life Sciences Projects with Melissa Informatics.
Microsoft SQL Server
https://www.mssqltips.com/sqlservertip/7005/multiple-linear-regression-estimation-prediction-sql-server-r/
Mssqltips
Multiple Linear Regression for Estimation and Prediction in SQL Server
Deep dive into multiple linear regression for estimation and prediction using real estate data and SQL Server and R for data analysis.
Microsoft SQL Server
https://www.mssqltips.com/sqlservertip/7002/power-bi-dashboard-power-apps/?utm_source=dailynewsletter&utm_medium=email&utm_content=headline&utm_campaign=20211018
Mssqltips
Display Power BI Dashboards and Reports in Power Apps
In this article we will look at how to display Power BI reports and dashboards in Power Apps.
Microsoft SQL Server
https://www.mssqltips.com/sqlservertip/6995/data-warehouse-development-challenges/?utm_source=dailynewsletter&utm_medium=email&utm_content=headline&utm_campaign=20211020
Mssqltips
Data Warehouse Development Challenges Uncovered
This article is dedicated to building the new generation data warehouse called lakehouse and we discuss common data warehouse building challenges.
Microsoft SQL Server
https://www.mssqltips.com/sqlservertip/7011/pie-charts-in-python-sql-server-data/?utm_source=dailynewsletter&utm_medium=email&utm_content=headline&utm_campaign=20211020
Mssqltips
Pie Charts in Python from SQL Server Data
In this article we look at how to generate different types of pie charts using Python and SQL Server.
Microsoft SQL Server
https://www.mssqltips.com/sqlservertip/6988/sql-server-availability-group-maintenance-distributed-availability-groups/
MSSQLTips.com
Perform Maintenance on SQL Server Availability Groups
Learn how to perform maintenance on the replicas of the primary SQL Server Availability Group when using Distributed Availability Groups.
Microsoft SQL Server
https://www.mssqltips.com/sqlservertip/1419/how-to-find-keywords-in-sql-server-stored-procedures-and-functions/
Mssqltips
How to Find Keywords in SQL Server Stored Procedures and Functions
In this tip we look at different ways to search SQL Server system objects to find specific strings within stored procedures, triggers, functions and more.
Microsoft SQL Server
https://www.mssqltips.com/sqlservertip/1100/setting-up-database-mail-for-sql-server/?utm_source=dailynewsletter&utm_medium=email&utm_content=headline&utm_campaign=20211020
MSSQLTips.com
Setting up Database Mail for SQL Server
In this tip learn how to setup and configure database mail for SQL Server.
Microsoft SQL Server
https://www.mssqltips.com/sqlservertip/1520/recursive-queries-using-common-table-expressions-cte-in-sql-server/?utm_source=dailynewsletter&utm_medium=email&utm_content=headline&utm_campaign=20211020
MSSQLTips.com
Recursive Queries using Common Table Expressions (CTE) in SQL Server
Learn how to write recursive queries in SQL Server by using a Common Table Expression also know as a CTE.
Microsoft SQL Server
https://www.mssqltips.com/sqlservertip/5568/sql-server-reporting-services-rest-api/?utm_source=dailynewsletter&utm_medium=email&utm_content=headline&utm_campaign=20211020
MSSQLTips.com
SSRS Rest API
In this tip we look at how to use the new REST API for accessing certain meta data details concerning SQL Server Reporting Services (SSRS).
Microsoft SQL Server
https://www.mssqltips.com/sqlservertip/7003/text-strings-power-bi-dax/?utm_source=dailynewsletter&utm_medium=email&utm_content=headline&utm_campaign=20211021
Mssqltips
Combine Text Strings in Power BI Using DAX
Learn various ways to concatenate strings in Power BI such as using CONCATENATE, COMBINEVALUES and using an ampersand.
Microsoft SQL Server
https://www.mssqltips.com/sqlservertip/7010/repositories-install-sql-server-red-hat-linux-virtual-machine/?utm_source=dailynewsletter&utm_medium=email&utm_content=headline&utm_campaign=20211021
Mssqltips
Repositories to install SQL Server on Red Hat Linux Virtual Machine
In this article we look at how to get the correct repositories in place to install SQL Server 2019 on Red Hat Linux virtual machine.
