server management Resources

Share

Related resources for server management

Tools in SQL Server Management Studio4/3/2024 10:42:11 AM. Learn to utilize essential tools like Object Explorer, Query Editor, and TSQL in SQL Server Management Studio. Navigate objects, execute commands, and manage databases efficiently. Explore more tech a
Comparing Execution Plans In SQL Server 4/3/2024 9:52:56 AM. SQL Server Management Studio (SSMS) allows easy comparison of execution plans, aiding in identifying performance discrepancies. Users can compare .sqlplan files, highlighting differences in query oper
Trick To Use Dark Theme In SQL Server Management Studio 20174/3/2024 9:42:18 AM. Unlock the stylish Dark Theme in SQL Server Management Studio 2017 with this ingenious trick. Enhance your visual experience and reduce eye strain while working with SQL databases. Customize your work
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 Configure ASP.Net Website in IIS3/19/2024 11:56:23 AM. In this article, you will learn essential aspects like setting up application pools, creating virtual directories, and deploying websites, crucial for efficient web development and server management o
How to Install and Configure IIS 8 on Windows Server3/15/2024 6:51:03 AM. In this article, you will learn about how to install and configure IIS8 (Internet Information Services 8) on Windows Server 2012.
How to Do Work Folder in Windows Server?2/19/2024 10:10:36 AM. 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 Polic
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.
How To Install SQL Server Management Studio 20225/22/2023 7:30:10 AM.
How To Install SQL Server Management Studio1/12/2023 6:38:45 AM. In this article, you will learn how to Install SQL Server Management Studio 2019.
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
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).
Import CSV File Into SQL Server Using SQL Server Management Studio5/4/2022 5:52:34 AM. In this article, you will learn how to import CSV file into SQL server using SQL server management Studio.
Automating Database And Folder Backups On Windows Server3/3/2021 3:01:51 PM. Using this open-source utility, you can automate server backups including MSSQL Database, MySQL Database, and Folder contents. You can upload backups to an Amazon S3 bucket and set email alerts for fa
Cursor In SQL Server With Syntax And Example1/14/2021 3:05:20 PM. This article provides an explanation about how you can use and set up a basic cursor in SQL Server. many developers/programmers/people those who work with Microsoft SQL Server will have at least heard
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.
Linked Servers in SQL Server6/4/2019 2:04:36 AM. This article helps you to understand the concept of Linked Servers in SQL Server 2008, 2012. I will show with an example, how to connect the two different databases using Linked Servers in SQL Server
How To Create SQL Database In Azure And Connect With SQL Server Management Studio3/13/2019 9:42:46 AM. 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.
Use SQL Server Management Studio 🌐 To Connect Azure🛢️SQL Database12/31/2018 8:54:04 AM. In this article, we will learn how to use SQL Server Management Studio to connect and query the Azure SQL database.
Creating An Azure SQL Database And Connecting Through SQL Server Management Studio7/23/2017 11:59:20 AM. This article demonstrates how to create an azure SQL Database, setting the Firewall rule and connecting through the SQL Server Management Studio.
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.
Resolving Local User Account Issue While Creating SharePoint Server 2016 Configuration Database6/29/2016 3:05:56 PM. In this article, you will learn how to resolve local user account issues while creating a SharePoint Server 2016 configuration database.
Using The Template Explorer Of SQL Server Management Studio3/1/2016 1:15:26 PM. In this article you will learn how to use the Template explorer of SQL Server Management Studio.
Important Keyboard Shortcuts In SQL Server 201412/22/2015 12:32:35 AM. This article will help you to know about the shortcuts that are mostly useful while using SQL Server.
Import Data From Excel File To SQL Server12/15/2015 8:13:56 AM. This article is about importing excel file data into your SQL server database.
Restore Generated SQL Scripts Of Table With Records Into Another Database11/16/2015 12:46:49 PM. In this article, I have explained how to generate SQL Scripts of the table with records and restore it into another database.
Backup And Restore Your Database Using SQL Server Management Studio (Step by Step)11/7/2015 2:11:16 PM. 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 20109/16/2015 12:42:48 AM. In this tutorial I’ll show you how to make a connection between SQL Server Management Studio and Visual Studio 2010.
Copy Database From One Server to Another Server in SQL6/18/2015 4:51:35 PM. This article shows how to copy a database from one server to another server using SQL Server Management Studio.
Getting Started With SQL Server 2012 Management Studio1/28/2015 7:09:53 PM. This article provides an introduction to SQL Server Management Studio and its installation process.
Import Data to Another Server11/20/2014 7:07:04 PM. In this article you will learn how to import data or a database from another server with SQL Server Management Studio.
Introduction To SQL Server Management Object2/3/2014 1:34:55 PM. SQL Server Management Objects (SMOs) were introduced by Microsoft to manage SQL Server objects in C#. This is the managed code replacement of DMOs.
Intrinsic DataBase in LightSwitch 20128/13/2013 7:14:38 PM. Here we will see how to attach an intrinsic database in a LightSwitch Application (Visual C#) in Visual Studio 2012.
Customize Menu and Toolbar in SQL Server 20129/2/2012 12:07:37 AM. Here, we will take a look at how to customize the SQL Server Management Studio for our own convenience.
SQL Azure - Connect to SQL Azure Using SQL Server Management Studio5/20/2012 7:40:34 AM. In this article we are going to see how to connect to the SQL Azure database using SQL Server Management Studio.
How to Restore a Database in SQL Server 20085/20/2012 1:13:00 AM. You will learn how to restore a database in SQL Server 2008
SQL Server Integration Services (SSIS)- Export Data using Wizard5/20/2012 1:06:24 AM. In this article we will see how to export data from SQL Server using the wizard which is provided with SSMS (SQL server Management Studio).
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).
SQL Azure - Creating New Database Stored Procedure in Azure Portal6/16/2011 12:06:52 AM. In this article we are going to see how to create a new database stored procedure using the new Azure portal instead of using the SQL Server Management Studio.
What is SMO?5/3/2010 3:32:00 AM. SQL Server Management Objects (SMO) are objects designed for programmatic management of Microsoft SQL Server.

Topics