SSM Resources

Share

Related resources for SSM

Using Network Planner to Determine and Organize Network Requirements for Teams8/17/2024 8:14:50 PM. This content explores how to use a Network Planner to assess and organize network requirements for teams. It covers identifying network needs, designing efficient network structures, and ensuring seam
What is TDS Endpoint and How to Enable TDS in Dynamics 365 Customer Engagement/CRM Online?7/8/2024 7:35:22 PM. TDS (Tabular Data Stream) is pivotal for accessing Dataverse data securely in Dynamics 365 CE and Power Platform. It integrates with SSMS and Power BI, ensuring native security while enabling robust r
How We Hire Developer Talents?6/20/2024 4:55:46 AM. Our comprehensive recruitment process evaluates developers on technical skills and cultural fit through Testdome assessments, structured interviews, and a day with the team. This approach ensures we s
Backing Up and Restoring a SQL Database6/19/2024 7:31:50 AM. In database management, ensuring data integrity and availability is paramount. Regularly backing up your database is crucial to mitigate risks such as hardware failures, software issues, or accidental
Understanding Different Types of SQL Triggers in SQL Server6/11/2024 9:14:12 AM. SQL Server triggers are powerful tools that allow the automatic execution of SQL code in response to specific events on a table or view. They play a crucial role in maintaining data integrity, enforci
Migrate to Azure Defender from Qualys Vulnerability Assessment 6/3/2024 4:31:23 AM. Microsoft Defender for Cloud now uses Defender Vulnerability Management for assessments. The previous Qualys-powered container vulnerability assessment is retired. Transition seamlessly by enabling sc
Connect to SQL Server with SSMS Methods and Authentication Types5/31/2024 5:51:14 AM. Connecting to SQL Server using SQL Server Management Studio (SSMS) involves selecting a connection method and authentication type. Methods include specifying the server name and instance.
Securing Your Web Applications with WAF and ASGs5/14/2024 11:26:15 AM. Learn to fortify web apps with comprehensive security strategies, leveraging WAF and ASGs. Safeguard against cyber threats, implement access control, and ensure network integrity through advanced fire
Ingest Data into Azure SQL Database using SSMS4/25/2024 6:43:37 AM. This video shows how to ingest data into Azure SQL Database using SQL Server Management Studio.
How To Query Dataverse In Microsoft SQL Server Management Studio (SSMS)?4/3/2024 10:45:55 AM. Querying Dataverse in Microsoft SQL Server Management Studio (SSMS) involves using Transact-SQL (T-SQL) to interact with tables, views, indexes, and stored procedures. Understanding entity relationshi
SQL Server Vulnerability Assessment3/28/2024 6:33:00 AM. SQL Server Vulnerability Assessment (VA) in SQL Server Management Studio 17.4 or later lets SQL Server scan your databases for potential security vulnerabilities and can be run against SQL Server 2012
SQL Data Discovery And Classification In SSMS3/28/2024 6:32:31 AM. SQL Data Discovery and Classification in SSMS allows users to identify and categorize sensitive data within databases, aiding in compliance with regulations like GDPR. Enhance data security and govern
Static Data Masking (SSMS 18.0 Preview)3/28/2024 6:31:38 AM. Static Data Masking in SSMS 18.0 Preview enhances data security by obscuring sensitive information in databases. It safeguards privacy during testing by replacing real data with masked values, ensurin
How To Get Started With Always Encrypted For Beginners - Part Two3/28/2024 6:26:09 AM. In this post we will pick up where we left off in Part 1, if you haven’t read that please go back and do so. Now that we have encrypted our columns, it’s time to take a look at how we decrypt them ins
How to Fetch Daily, Weekly, Monthly, and Yearly based Data in SQL3/12/2024 10:59:03 AM. In SQL, fetching data based on specific time intervals like day, week, month, and year is essential for meaningful analysis.
Azure Migrate Application and Code Assessment Tool for .NET1/5/2024 10:37:28 AM. Explore seamless Azure migration with AppCAT, a powerful tool for .NET. Visual Studio and CLI installations, detailed analyses, and insightful reports empower coding excellence.
Ingest Excel Data to Azure SQL Database using SSMS GUI12/6/2023 5:30:32 AM. This video shows how to easily ingest Excel data to the Azure SQL Database using the SQL Server Management Studio Graphical User Interface
How to Get All SQL Server Agent Jobs in SQL Server?12/5/2023 9:17:54 AM. Retrieving a list of SQL Server Agent jobs in SQL Server Management Studio is a straightforward process. You can use the GUI provided by SSMS or run a T-SQL query to gather the necessary information.
What is SQL Server Management Studio (SSMS)11/7/2023 4:14:32 AM. SQL Server Management Studio (SSMS) is a tool used to manage and develop Microsoft SQL Server databases. It provides a graphical interface for connecting to servers, creating and modifying database ob
Connect to Data Warehouse in Microsoft Fabric from SQL Server Management Studio10/20/2023 9:16:19 AM. This video shows how implement connection to Data Warehouse in Microsoft Fabric from SQL Server Management Studio
How To Install And Configure Microsoft SQL Server Management Studio (SSMS) 10/18/2023 10:04:05 AM. Learn how to install and configure Microsoft SQL Server Management Studio (SSMS), a vital tool for managing SQL Server instances, with step-by-step guidance and helpful screenshots.
Know The History Of Your SQL Server Database10/16/2023 9:00:14 AM. Understand your SQL Server database history for effective management. Learn to identify the internal version number using SQL Server Management Studio and various T-SQL statements, ensuring accurate d
How To Restore Northwind Database In SQL Server In One Minute10/11/2023 8:49:39 AM. To use Northwind database in your SQL Server, you need to restore it. In this tutorial, I will explain all the restore database steps through the images.
Azure Landing Zone Review Assessment10/3/2023 8:38:11 AM. Azure Landing Zone is a set of guidelines, best practices, and resources provided by Microsoft Azure to help organizations set up an environment for successful adoption of Azure services. It's ess
Registered Servers in SQL Server Management Studio (SSMS)9/27/2023 8:17:36 AM. Registered Servers in SQL Server Management Studio (SSMS) is a feature that allows database administrators and developers to conveniently manage and access multiple SQL Server instances and other data
Append Only Ledger Table In SQL Server8/9/2023 4:59:20 AM. An append-only ledger table is a type of database table that only allows new data to be appended to the end of the table. Once data is added to an append-only ledger table, it cannot be changed or del
What is SQL Server Ledger?7/28/2023 4:56:50 AM. SQL Server Ledger is a feature of SQL Server that provides tamper-evident capabilities for your database. It does this by using a blockchain and Merkle tree data structures to track the history of cha
How To Install SQL Server Management Studio 20225/22/2023 7:30:10 AM.
Azure Cloud Migration4/15/2023 3:26:25 PM. Cloud migration in azure
Copy Azure Database To Local Server In SSMS 194/11/2023 9:18:22 AM. In this article, I will explain how you can copy your azure cloud database into your local server using SQL Server Management Studio 19. SSMS provides us export data tier option to copy the database.
AWS Systems Manager (SSM) Parameter Store In .NET 3.1 Web API3/16/2023 10:35:45 AM. Grab all the AWS Systems Manager (SSM) Parameter store in .NET 3.1 Web API and use them in entire project through Configuration
How To Connect SSMS With Microsoft Azure SQL Cloud Service3/15/2023 10:39:07 AM. In this article, you will learn how to Connect SSMS with Microsoft Azure SQL Cloud Service.
Basics of SQL Server Integration Services2/21/2023 9:18:58 AM. In this article we will see what a SQL Server Integration Services (SSIS) is; basic on why SSIS is used for, how to create a SSIS Package and how to debug the same.
SQL CLR For Beginners: Part 3: Create Function in SQL-CLR1/31/2023 6:53:49 AM. In this article we will see how to create a simple function in a SQL-CLR Project.
SQL CLR For Beginners: Part 2: Create Trigger in SQL-CLR Project1/25/2023 5:37:34 AM. In this article we will see how to create a simple trigger in a SQL-CLR project. I hope you are already quite familiar with the concept of triggers in SQL Server (or some other database).
How to enable line numbers in SQL Server Management Studio (SSMS)1/11/2023 9:23:13 AM. We will be discussing how to enable line numbers in SSMS, as well as other related tips and best practices. We will be going over the step-by-step instructions on how to enable line numbers in the que
What Is SQL Server Management Studio (SSMS)?1/9/2023 8:43:47 AM. SQL Server Management Studio (SSMS) is a Windows client app that allows database developers and database administrators to configure and manage SQL Server and Azure SQL databases. Learn how to downlo
SQL CLR For Beginners: Part 1: Create Store Procedure in SQL-CLR Project1/5/2023 10:35:35 AM. In this article series, we will understand a few important concepts to develop projects in SQL Server CLR. Please don't be confused by the name SQL-CLR, It's nothing but a SQL Server CLR proje
How To Create a Stored Procedure In SQL Server Management Studio (SSMS)12/28/2022 5:20:38 AM. In this article, you will learn about how to create a stored procedure in SQL Server using SSMS.
How To Install SQL Server Management Studio 201712/27/2022 12:19:32 PM. SQL Server Management Studio (SSMS). This article explains how to download and install SQL Server Management Studio 2017.
Migrating a SQL IaaS Database To Azure SQL Using DMA (Data Migration Assistant)5/11/2022 1:31:25 PM. In this article, you will learn how to migrate a SQL IaaS Database to Azure SQL using DMA (Data Migration Assistant).
How To Restore A SQL Server Database From A Backup4/28/2022 6:49:45 AM. In this article, you will learn how to restore a sql server database from a backup.
Connecting To Azure SQL Database With Active Directory - Universal With MFA3/2/2022 2:05:07 PM. In this article, you will learn how to connect to Azure SQL Database with Active Directory - Universal With MFA.
@classmethod And @staticmethod In Python2/23/2022 8:59:45 AM. The article explains @classmethod and @staticmethod in Python.
AWS Secrets Manager Vs Parameter Store (Systems Manager)2/2/2022 11:11:01 AM. In this article, you will learn about AWS Secrets Manager Vs Parameter Store.
How To Access Parameters From AWS Systems Manager Parameter Store In .NET 6 Web API1/5/2022 4:18:13 AM. In this article, you will learn how to access parameters from AWS Systems Manager Parameter store in .NET 6 Web API.
Variables, Methods And Inner Class In Python12/1/2021 10:44:11 AM. In this article, we will touch base with further concepts Types of Variables, Types of Methods and Inner Class in Python
How To Install Microsoft SQL Server Management Studio (SSMS)?11/24/2021 10:31:34 AM. In this article, you will learn how to install microsoft SQL server management studio (SSMS)?
Full And Differential Backup Using SSMS5/19/2021 12:34:27 PM. In this article, we will see how to create a SQL Server Database backup. Database backup using SQL Server Management Studio, SQL Server provides a large number of options to create backups. We will di
What Are The Options For Database Backup And Restore? How To Export BACPAC Using SSMS?3/26/2021 1:00:20 PM. This article describes what are the options for Database restore and create and how to export BACPAC file in SQL Server
Performing Vulnerability Assessment In Azure DevOps2/9/2021 1:46:26 PM. DevOps is a collaboration between the development and the operations teams. This collaboration has led to some fantastic benefits for organizations. DevOps has allowed people and organizations to ship
Deciding Which Processes To Automate1/15/2021 6:03:11 PM. In this article, you will learn how to decide which processes to Automate.
How to Generate Alter Script of Table Design Mode - Sql Server Management Studio11/13/2019 7:11:26 AM. How to generate the alter table SQL script in using SSMS.
SSML In Alexa Skill Kit - Part Two11/12/2019 9:06:45 AM. In this article, we will learn about SSML in Alexa Skill Kit.
Access Modifiers In Java9/27/2019 5:59:28 AM. Java Access Modifiers. In this article, you will learn about Access Modifiers keywords in Java.
Quick SSMS Tip9/12/2019 8:29:28 AM. In this article, you will learn a Quick SSMS Tip.
SQL Assessment API (Public Preview)8/6/2019 10:55:07 AM. Is your SQL Server configuration in line with Microsoft recommended best practices? If you want to know, check this latest video on SQL Assessment API.
Azure SQL Database IP Firewall Rules7/31/2019 2:00:31 AM. In this video, you will learn about the security features of Azure SQL Database. We will dive deep into Azure SQL Database IP Firewall rules.
Entity Framework Core In Docker Container - Part I - SQL Server5/3/2019 9:25:35 AM. In this article, we will learn using Docker with Entity Framework Core and with different databases.
Generating SELECT (JOIN) Query Through Criteria Pane, SQL Pane, and Diagram Pane8/2/2018 11:43:29 PM. In this training video, we will learn how to generate SELECT (INNER JOIN) Query through Criteria pane, SQL Pane, and Diagram Pane. We will not write query ourselves; instead, we will use SSMS GUI to g
Learn About SSMS Output Window3/17/2018 11:03:38 AM. In my experience, there have been occasions where SQL Server Management Studio (SSMS) becomes unresponsive for a length of time. In one particular case, this occurred while I was expanding the list of
SSMS 2016 - Enhanced Scrollbar11/15/2017 5:56:25 AM. Detailed description with screenshots of the enhanced scroll bar introduced in SSMS (SQL Server Management Studio) 2016.
Introduction Of New Useful Features In SSMS 201611/10/2017 12:25:37 PM. This article is an effort to list out a few exciting improvements that have been made to SQL Server Management Studio 2016. I believe, most of these new features can help improve the speed of our work
Cloud Migration - Microsoft Assessment And Planning Toolkit Guide7/12/2017 12:18:16 PM. The Microsoft Assessment and Planning Toolkit , also known as MAP, helps you to assess and understand the IT infrastructure and assets.
Differentiate Connections With Colored Status Bars3/15/2017 4:18:07 PM. This is about an old but under utilized feature of SSMS to differentiate connections using colored status bars.
SharePoint Infrastructure Assessment Questionnaire1/12/2017 11:01:02 AM. In this article, you will learn about a SharePoint Infrastructure Assessment Questionnaire.
How To Connect Azure SQL DataBase (Cloud ) Using SSMS9/27/2016 12:28:22 AM. This Video tutorial explain step by step how to connect Azure SQL DataBase (Cloud ) Using SQL Server Studio Management. This video covers the following topicsWhat is SQL Server Management studio? Conf
How To Carry Out A Quick Design Assessment8/15/2016 10:26:39 AM. In this article, you will learn how to carry out a Quick Design Assessment.
Step by Step Guide To Install SQL Server 2016, SSMS And SSDT Tool6/20/2016 10:16:48 AM. In this article, I will guide you on how to perform a new SQL Server 2016 installation.
Create SQL Database In Azure And Connect It With SSMS4/27/2016 4:05:16 PM. In this article, you will learn how to use Azure Portal to create a database and host it on SQL Server Management Studio.
Patient Weight Assessment, Desktop Application Powered by Raven DB2/29/2016 10:54:20 PM. In this article, I am going to demonstrate to you the “Patient Weight Assessment” desktop application developed using C# .NET and Raven DB for managing all the data.
Activity Monitor In SQL Server12/3/2015 2:46:49 PM. In this article you will learn about SQL Server 2014 Activity Monitor and steps to use it.
Debug ASP.Net Applications Using ELMAH: Part 22/8/2015 5:43:39 PM. In this article I will be explaining the integration of ELMAH with SQL Server(SSMS).
Generate Script Having Data as Well Using SSMS in SQL Server12/26/2014 7:17:00 PM. In this article we learn how to generate a script in SQL Server.
Determine Object Dependencies in SQL Server3/11/2014 4:41:55 PM. This article describes some of methods for determining object dependency information.
SQL Server Integration Services (SSIS) -Import Data using Wizard5/20/2012 1:05:33 AM. In this article we will see how to import data from SQL Server using the wizard which is provided with SSMS (SQL server Management Studio).
Using SOAP Header and SOAP Extensions in a Web Service5/19/2012 7:06:46 AM. In this article, we will develop a web service that would authenticate users for web sites. The web site needs to pass the user ID as well as the password for the user. Apart from this the web site also needs to pass the site’s ID and password.
SSMS Performance Dashboard Reports in SQL Server to find Bottlenecks5/19/2012 5:32:03 AM. In this article you will see how to use SSMS Performance Dashboard Reports in SQL Server to find Bottlenecks.

Topics