Resources  
  • How To Install And Configure Microsoft SQL Server Management Studio (SSMS) Oct 18, 2023. 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.
  • Registered Servers in SQL Server Management Studio (SSMS)Sep 27, 2023. 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 database-related resources from within a single interface. Here's a detailed description of this feature.
  • How To Install SQL Server Management Studio 2022May 22, 2023.
  • How to enable line numbers in SQL Server Management Studio (SSMS)Jan 11, 2023. 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 query window and explaining the benefits of using line numbers in your SQL script development. Additionally, the article will also show an alternative way to achieve the same result in case if someone wants to use that.
  • What is SQL Server Management Studio (SSMS)Jan 04, 2023. 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 objects, importing and exporting data, and running queries.
  • How To Query Dataverse In Microsoft SQL Server Management Studio (SSMS)?Dec 08, 2021. In this article, you will learn how to query dataverse in Microsoft SQL Server Management Studio (SSMS).
  • How To Install Microsoft SQL Server Management Studio (SSMS)?Nov 24, 2021. In this article, you will learn how to install microsoft SQL server management studio (SSMS)?
  • What Is SQL Server Management Studio (SSMS)?Apr 05, 2019. 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 download and install SSMS.
  • Use SQL Server Management Studio 🌐 To Connect Azure🛢️SQL DatabaseDec 31, 2018. In this article, we will learn how to use SQL Server Management Studio to connect and query the Azure SQL database.
  • How To Install SQL Server Management Studio 2017Aug 06, 2018. SQL Server Management Studio (SSMS). This article explains how to download and install SQL Server Management Studio 2017.
  • Trick To Use Dark Theme In SQL Server Management Studio 2017Jul 03, 2018. Learn how to set the Dark theme of SQL Server Management Studio (SSMS).
  • How To Create a Stored Procedure In SQL Server Management Studio (SSMS)Nov 25, 2017. In this article, you will learn about how to create a stored procedure in SQL Server using SSMS.
  • Backup And Restore Your Database Using SQL Server Management Studio (Step by Step)Nov 07, 2015. In this article you will learn how to upload your App to Windows Store (Step by Step), backup and restore your database using SQL Server Management Studio (Step by Step).
  • Make Connection between SQL Server Management Studio and Visual Studio 2010Aug 31, 2015. In this tutorial I’ll show you how to make a connection between SQL Server Management Studio and Visual Studio 2010.
  • Import CSV File Into SQL Server Using SQL Server Management StudioMay 04, 2022. In this article, you will learn how to import CSV file into SQL server using SQL server management Studio.
  • How To Import Or Restore BACPAC File Using SQL Server Management StudioMar 30, 2021. This article describes how to import BACPAC file using SQL Server Manage Studio
  • How To Install SQL Server Management StudioMar 03, 2021. In this article, you will learn how to Install SQL Server Management Studio 2019.
  • How To Create SQL Database In Azure And Connect With SQL Server Management StudioMar 13, 2019. In this article, we will learn how to create a SQL Azure Database in Microsoft Azure and how to connect the SQL Azure to SQL Server Management Studio.
  • Creating An Azure SQL Database And Connecting Through SQL Server Management StudioJul 23, 2017. This article demonstrates how to create an azure SQL Database, setting the Firewall rule and connecting through the SQL Server Management Studio.
  • Create SQL Azure And Access Through Microsoft SQL Server Management StudioJun 23, 2016. In this article, we are going to learn how to create the SQL Database and access it through Microsoft SQL Server Management Studio.
  • Keyboard Query Shortcuts In SQL Server Management StudioMay 06, 2016. In this article we are going to see some shortcuts that may be useful to you when you work with SQL Server Management Studio.
  • Using The Template Explorer Of SQL Server Management StudioMar 01, 2016. In this article you will learn how to use the Template explorer of SQL Server Management Studio.
  • Tools in SQL Server Management StudioMar 04, 2014. This article shows how to use Tools in SQL Server Management Studio.
  • SQL Azure - Connect to SQL Azure Using SQL Server Management StudioJun 20, 2011. In this article we are going to see how to connect to the SQL Azure database using SQL Server Management Studio.
  • Establishing Communication Between Executable Files Using TCP/IPMar 19, 2024. WPF apps use various IPC methods like Named Pipes, WCF, TCP/IP Sockets. TCP/IP sockets offer cross-platform communication with advantages like reliability but face complexity and firewall issues. Steps include server/client development, execution instructions. Use CommonHelper for collaboration.
  • How To Install Appium Inspector And Appium Server GUIMar 18, 2024. This article walks you through every step of installing and configuring Appium for mobile test automation. From downloading the necessary software to configuring dependencies , this guide covers it all
  • Deploying a Windows Server Virtual Machine in Microsoft Azure Mar 17, 2024. To deploy a Windows Server Virtual Machine (VM) in Microsoft Azure, you'll configure various settings to create your virtual environment.
  • TINYINT Data Type in SQL and Its C# EquivalentMar 16, 2024. Understanding data types is crucial for effective data manipulation and storage. In this article, we will learn about TINYINT in SQL efficient storage for small integers. In C#, use byte or sbyte for representation. Optimization is crucial.
  • Dynamic Redirect URL/ Wildcard URL in Azure App RegistrationMar 15, 2024. Learn how to configure dynamic redirect URLs or wildcard URLs in Azure App Registration for enhanced flexibility and scalability. By leveraging this feature, you can dynamically handle various callback URLs, accommodating different environments or scenarios without manual intervention.
  • Validate Multiple Tokens with Different Providers in ASP.NET 8 APIMar 15, 2024. Learn to validate multiple tokens from different authentication providers in an ASP.NET 8 API. Configure authentication schemes for each provider, accommodating diverse token formats and validation requirements seamlessly.
  • Exploring Blackbox AI Code Generation, Code Chat, and Code Search for VS CodeMar 15, 2024. Discover the latest enhancements in Visual Studio Code (VS Code) with Blackbox AI Code Generation, Code Chat, and Code Search features. Boost productivity, streamline collaboration, and navigate code effortlessly within the familiar VS Code environment.
  • What is Use of ‘Using’ Statement in .NET?Mar 15, 2024. In this article, we will cover What is the use of the ‘Using’ statement in .NET. The 'using' statement in .NET ensures efficient resource management, prevents memory leaks, and promotes cleaner, more reliable code.
  • Creating Contact Record in D365 with PowerShell Script & Image AttributeMar 15, 2024. Learn to automate Dynamics 365 contact record creation via PowerShell. This script includes adding image attributes, streamlining CRM data management. Utilize Microsoft's Xrm.Data.PowerShell module for efficient and seamless integration, enhancing your CRM automation capabilities.
  • Provide Security Role Access for D365 OutlookMar 14, 2024. In this article, we will customize permissions, manage user access, and enforce Role-Based Access Control (RBAC). Optimize Microsoft 365 settings to tailor access rights, enhancing data protection and organizational compliance.
  • How to Install Configure VPN on Windows ServerMar 14, 2024. This detailed guide offers step-by-step instructions on how to set up a VPN on Windows Server. Learn to set up a VPN on Windows Server 2019 efficiently. Understand the server's dual roles: client and host. Follow clear steps for installation and configuration. Simplify remote access and enhance security.
  • Is Blockchain the Future of Digital Identity Management?Mar 13, 2024. Is Blockchain the Future of Digital Identity Management?
  • Central Package Management (CPM) in .NET CoreMar 13, 2024. Learn the power of NuGet's central package management (CPM) for efficient dependency handling across projects. Utilize Directory.Packages.props to centrally manage package versions for simplified maintenance and enhanced control.
  • Managing Storage Spaces with File Server Resource Manager (FSRM)Mar 13, 2024. FSRM has key features to provide control over your storage space. I cover topics such as Quota Management and File Screening Management in this article.
  • Increasing Item Limit in Power Apps: A Step-by-Step Guide up to 2000Mar 12, 2024. In this article, we will learn to Unlock the full potential of Power Apps by increasing the item limit to 2000 with our comprehensive step-by-step guide. Learn how to efficiently manage data sources, optimize performance, and adhere to best practices for app development.
  • Creating Users and Groups Within an Organizational Unit on Windows ServerMar 12, 2024. Active Directory Users and Computers is a common tool used by administrators to manage objects in an Active Directory domain.  
  • How to Install and Configure RODC in ServerMar 12, 2024. In this article, we will explore A read-only domain controller (RODC) is a domain controller that hosts an Active Directory database's read-only partitions.
  • How to Fetch Daily, Weekly, Monthly, and Yearly based Data in SQLMar 12, 2024. In SQL, fetching data based on specific time intervals like day, week, month, and year is essential for meaningful analysis.
  • Introduction To Term Store Management in SharePoint OnlineMar 12, 2024. In this article we will discuss – Introduction To Term Store Management in SharePoint Online And How to create Term Store using PowerShell.
  • Installing File Server Resource Manager on Windows ServerMar 11, 2024. In this article, we will learn File Server Resource Manager (FSRM) is a role service in Windows Server that allows you to manage and control the data stored on your file servers. FSRM helps you to classify files, set quotas on folders, and create reports monitoring storage usage.
  • A Seamless Debugging Experience with Source Link in .NET 8Mar 11, 2024. Discover how to enhance your debugging experience in .NET 8 with Source Link, authored by Ziggy Rafiq. This article guides about the efficient use of Source Link for debugging, providing invaluable insights for software developers. With this authoritative resource, you can master the intricacies of debugging in .NET 8.
  • Mastering Form Creation in Power Apps: Integration with SharePoint Mar 11, 2024. Discover how to create powerful forms in Power Apps and seamlessly integrate them with SharePoint. Master the art of designing intuitive interfaces, implementing advanced functionalities, and automating workflows.
  • Basics of Azure Databricks: Data Analytics in the CloudMar 11, 2024. Azure Databricks stands at the forefront of cloud-based data analytics platforms, revolutionizing the way organizations manage, process, and derive insights from massive datasets. Azure Databricks, exploring its components, features, and capabilities to empower data-driven decision-making in the digital age.
  • Data Transformations: ETL, ELT, and the Reverse ETL RevolutionMar 10, 2024. Delve into the complexities of data management through an in-depth examination of ETL, ELT, and the pioneering emergence of Reverse ETL in this extensive guide. Explore the applications, benefits, and evolving dynamics of these transformative methods shaping the data terrain.
  • Benefits of Temporary Tables over Table Variables in SQL ServerMar 10, 2024. The article explores the advantages of utilizing temporary tables over table variables in SQL Server. It discusses how temporary tables offer better performance, scalability, and flexibility for handling large datasets and complex data manipulation tasks.
  • How to Pass Credentials as Parameters in PowerShellMar 09, 2024. In this article we will learn how to pass credentials as parameters in PowerShell. Learn how to pass credentials as parameters in PowerShell using PS objects. Follow step-by-step instructions to update a SharePoint Online site title using SPO PowerShell module with credential parameters.
  • Autonumber Attribute Generation: Programmatically or Non-ProgrammaticallyMar 08, 2024. In this article, we will discover techniques for auto-incrementing identifiers, managing data, and implementing automation, potentially utilizing frameworks like Entity Framework.
  • Implement Global Exception Handling Middleware in .NET ProjectMar 07, 2024. Implementing custom global exception handling in your project involves setting up a system to manage errors across your application. By defining exception classes and configuring error logging, you can ensure smoother error handling and improve the reliability of your software.
  • Understanding FORMATMESSAGE() Function in SQL ServerMar 06, 2024. In this article, we will discuss how to use FORMATMESSAGE() function in SQL Server, its advantages and usages with example.
  • Renaming the Column in SQL ServerMar 06, 2024. Renaming columns in SQL Server is a fundamental task in database management. This comprehensive guide provides step-by-step instructions, syntax examples, and best practices to effectively rename columns, ensuring data integrity and maintaining database structures.
  • Best Practices for Handling Exceptions in C# Mar 05, 2024. Learn effective exception handling techniques in C# with Ziggy Rafiq's comprehensive guide. Discover best practices for managing exceptions, including specifying exception types, logging errors, and employing cleanup strategies. Enhance your C# application's robustness and reliability while minimizing downtime.
  • Out-of-the-Box Site Navigation and Audience Targeting in SharePointMar 05, 2024. In this article, we will explore SharePoint's built-in tools for intuitive site navigation and precise audience targeting. Enhance user experience with customizable menus and targeted content delivery, optimizing engagement and productivity across diverse user groups.
  • Securing Remote Access to SQL ServerMar 05, 2024. Securing remote access to SQL Server is paramount for data protection and compliance. Explore methods like VPNs, firewalls, encryption, and multi-factor authentication for enhanced security and protection against cyber threats.
  • How to Do Distributed File System (DFS) In ServerMar 04, 2024. In this article, we will learn a distributed File System (DFS) as the name suggests, is a file system that is distributed on multiple file servers or multiple locations.
  • Understanding Grouping by Columns in SharePoint ListsMar 04, 2024. In this article, we will discover how to efficiently organize and manage data in SharePoint Lists by understanding the powerful grouping capabilities.
  • SQL Tuning - Effective Strategies with Practical ExamplesMar 03, 2024. SQL Tuning — Effective Strategies with Practical Examples
  • Product Management Application using .NET Core and React JS with CRUD OperationsMar 02, 2024. In this article, learn to create a product management web API with CRUD operations using .NET Core 6 and React JS. Utilize SQL Server for the backend and Axios for API consumption.
  • Difference Between Collect and ClearCollect in PowerAppsMar 01, 2024. In PowerApps, the Collect and ClearCollect functions play pivotal roles in managing data within your applications. Collect appends data to an existing dataset, while ClearCollect replaces the entire contents, refreshing the dataset. Master their nuances for effective data management.
  • Implement and Configure Windows Defender Application Control (WDAC)Mar 01, 2024. Windows Defender Application Control is a security software application designed to protect devices, from malware and other harmful software. Its main purpose is to allow trusted applications to run on PCs.
  • How to Do Zone Transfer in Windows ServerMar 01, 2024. Zone transfer is a crucial process for synchronizing DNS zone data across multiple servers, ensuring all DNS servers responsible for a domain remain updated with the latest information. By following the step-by-step instructions outlined in the article, users can configure zone transfer between primary and secondary DNS servers effectively.
  • How to Open, Read or View MS SQL Error Log FileFeb 29, 2024. Explore methods to open, read, or view SQL Server Error Log File. Get the best solution to open or view the SQL Server Log File of MS SQL Server in easy steps.
  • Bulk Add Terms, Term Sets, and Groups with PowerShell in SharePointFeb 29, 2024. This blog post provides step-by-step instructions on process of executing PowerShell scripts to import term store metadata elements into SharePoint, automating the creation and management of taxonomy structures.
  • Quick SQL Refresher Feb 28, 2024. The Quick SQL Refresher provides a concise cheat sheet for SQL, covering essential concepts, keys, commands (DDL, DML, DQL, DCL, TCL), constraints, clauses, T-SQL fundamentals, joins, functions, exception handling, indexes, views, stored procedures, transaction control, triggers, and cursors.
  • SQL Server Data Types for Performance, Memory EfficiencyFeb 28, 2024. "Embark on a journey to unlock SQL Server's full potential through savvy data type selection. Enhance performance and streamline operations with optimal choices.
  • How to Add Additional Domain Controller in ServerFeb 28, 2024. Deploying additional domain controllers increases the redundancy, which results in even greater resilience and higher availability.
  • Exporting and Importing Site Collection Term Stores In SharePointFeb 27, 2024. Looking to streamline your SharePoint management? Learn how to efficiently export and import Site Collection Term Store Groups! ?? From exporting your Term Store Groups for backup or migration purposes to importing them into new site collections, we'll walk you through the step-by-step process.
  • How to Install WDS in Server?Feb 26, 2024. This article provides a comprehensive guide on installing Windows Deployment Services (WDS) on Server 2019, detailing each step in the process.
  • Creating a Personalized Waiting Window in .NET 6, 7, 8 WPFFeb 26, 2024. A custom loader in a WPF (Windows Presentation Foundation) .Net 6,7,8 application serves the purpose of indicating to the user that the application is performing a task or operation that may take some time to complete.
  • Understanding SharePoint Content Types: Organizing Your Content EffectivelyFeb 23, 2024. Explore the significance of SharePoint content types for efficient content organization. Learn how to leverage metadata and structured data to customize and manage documents effectively within your SharePoint environment.
  • Azure Key Vault Creation, RBAC Setup, User Addition, Secret ManagementFeb 21, 2024. Azure Key Vault empowers secure storage of secrets, keys, and certificates. Implement RBAC for fine-grained access control, manage users, and grant permissions. Easily create backup, delete, and restore secrets, ensuring robust security and compliance with Azure's comprehensive toolset.
  • Tips to Launch Your SQL MissionFeb 20, 2024. This article consists of roadmap to embark on an exhilarating journey to master SQL which is the universal language of data management and analysis. In this comprehensive guide, we'll delve deep into actionable strategies and invaluable tips to help you kickstart your SQL learning journey and unleash the transformative power of data manipulation and insight extraction.
  • How to Do Work Folder in Windows Server?Feb 19, 2024. Work Folders in Windows Server 2019 enable seamless synchronization of user files between devices, ensuring access to up-to-date data. Administrators can set up and manage Work Folders via Group Policy and Active Directory.
  • Rate Limits for Efficient Resource ManagementFeb 19, 2024. Rate limits are crucial for efficient resource management. Rate limits restrict the frequency of requests or actions within a defined timeframe, preventing system overload and ensuring fair resource distribution. It is essential for maintaining optimal performance and reliability in various computing environments.
  • Azure Update Manager - Patch ManagementFeb 19, 2024. Azure Update Manager is a Software as a Service (SaaS) solution by Microsoft designed to simplify and automate software update management for Windows and Linux machines.
  • Securing Your .NET Projects: Simple Strategies and Real ExamplesFeb 18, 2024. In today's digital world, keeping our software safe from cyber threats is super important. For developers working with .NET projects, it's not just a good idea but really necessary to make sure our apps are strong against potential attacks. Luckily, there are lots of tools and tricks within the .NET world to help us do this.
  • Error Management in .NET CoreFeb 18, 2024. In software development, dealing with mistakes is really important. Whether it's a small problem or a big one, how a program handles mistakes can really affect how well it works for users. In the .NET Core world, there's a cool way to handle errors called global exception handling using custom middleware.
  • Fortifying your .NET ProjectFeb 16, 2024. This article explores essential strategies to enhance the security of .NET projects, addressing common threats like SQL injection and XSS. It covers input validation, parameterized queries, authentication, secure communication, XSS prevention, and dependency management for robust application security.
  • Enable Audit History for an Entity in CRMFeb 15, 2024. Enable audit history in CRM to track entity changes. Enhance data security, compliance, and integrity by monitoring modifications. Configure settings to log and report on user actions for improved governance.
  • Creating Collections from SharePoint Lists in PowerAppsFeb 15, 2024. Learn how to utilize collections in PowerApps to manage data within your application, especially useful for scenarios where users may be offline or have limited connectivity. Discover the advantages of collections over SharePoint lists, including the ability to perform complex queries.
  • External Streaming Data - Bitstream FormatFeb 14, 2024. The main aim of this article is to extend knowledge related to object-oriented programming focusing on interoperability between the computing process and data visualization, archiving, and networking resources.
  • How to Create and Manage Subsites in SharePoint?Feb 14, 2024. Learn the ins and outs of creating and managing subsites in SharePoint. Master site hierarchy, permissions, and navigation for effective collaboration and content management within your organization.
  • Analyzing Image Moderation using Azure Content SafetyFeb 13, 2024. At the end of the article readers will able to understand and implement the usage of Content safety studio with moderating image contents in real time scenarios.
  • Use .http files in Visual StudioFeb 13, 2024. In Visual Studio, .http files enable direct API testing within the IDE from Visual Studio 2019 onwards. Before this, developers relied on tools like Postman or Swagger, or unit testing. These files streamline API testing by allowing requests.
  • How to Create a SharePoint List Directly from ExcelFeb 13, 2024. Learn to seamlessly migrate Excel data to SharePoint lists. Enhance collaboration and data management with this step-by-step guide.
  • Getting started with Azure OpenAI GPT Modules and Azure OpenAIFeb 13, 2024. In this module, we will be learning about modules in Azure Openai prompt engineering techniques and getting started with Azure Openai Studio.
  • Analysis of T-SQL and PL/SQLFeb 12, 2024. This article delves into the distinctions between Transact-SQL (T-SQL) and PL/SQL, examining their origins, syntax, functionality, and optimization strategies. Explore their unique features for efficient database application development.
  • Sending Reminder Emails Using Power AutomateFeb 12, 2024. This article explains how to use Power Automate to send reminder emails effectively. Learn how to create reminder emails in Power Automate for pending tasks using SharePoint. The article outlines the design, conditions, and steps, ensuring efficient task management and escalation to managers.
  • Difference Between UNION and UNION All (SQL Server)?Feb 12, 2024. UNION merges and filters out duplicates from various SELECT queries, whereas UNION ALL combines them without eliminating duplicates, providing quicker results but retaining all rows, including duplicates.
  • New Modifications and Improvements to the Azure Stream Analytics No-Code Editor Feb 11, 2024. Explore real-time analytics with Azure Stream Analytics, a Microsoft Azure service for processing and analyzing streaming data. Learn about input sources, SQL-like query language, output destinations, and recent user experience enhancements for streamlined stream processing logic.
  • The Amazing Adventure of MongoDB QueriesFeb 09, 2024. This content provides an engaging analogy of MongoDB queries as an adventurous quest through a treasure-filled city. It introduces concepts like planning the query as preparing a treasure map, execution as detective work, utilizing the Aggregation Framework for complex queries.
  • How to Find Blocked Deadlocks in SQL?Feb 09, 2024. The SQL query utilizes dynamic management views (DMVs) like sys.dm_exec_requests, sys.dm_exec_sessions, sys.dm_exec_connections, and sys.dm_exec_sql_text to monitor and manage active sessions, connections, and SQL statements on a SQL Server instance.
  • What is a Wrapper Component in React?Feb 09, 2024. Wrapper components in React.js refer to components that encapsulate other components or elements within them. They are commonly used for various purposes such as styling, behavior modification, context management, implementing Higher-Order Components (HOCs).
  • Difference Between Raw SQL and Dapper Feb 08, 2024. Explore the trade-offs between using raw SQL queries and leveraging Dapper, a micro-ORM for database access in C# development. Delve into performance, code maintainability, and efficiency to make informed decisions in your data retrieval strategies.
  • AWS Transfer Family ( SFTP , FTP , FTPS Server ) OverviewFeb 08, 2024. AWS Transfer Family , What is AWS Transfer Family , Supported Transfer Protocols and Benefits. AWS Transfer Family is a managed service facilitating secure file transfers to and from AWS using protocols like FTP, FTPS, and SFTP. It integrates with S3, CloudWatch, and Lambda for seamless workflows.
  • How to Deploy Angular Application on Nginx?Feb 07, 2024. Deploying an Angular application on Nginx involves setting up Angular, installing Node.js, creating folders, installing Angular CLI, downloading Nginx, configuring ports, building the app, copying files to Nginx's HTML folder, and starting and stopping the Nginx server.
  • Multithreading in C#: Processes, Threads, and Performance OptimizationFeb 07, 2024. In this article, we will learn to Explore how threads are managed, synchronized, and executed at the kernel level, shedding light on the core mechanisms of concurrency and parallelism.

About SQL Server Management Studio

NA

OUR TRAINING