Here we are going to connect SQL Server Management Studios to a SQL Server instance that is on UnRaid. Download SQL Server Management Studios (SSMS): https:/...

SQL Server: Optimizing SQL Server Query Performance

In this video you learn how to install Microsoft SQL Server 2017 step by step, SQL Server 2017 New Features.Microsoft SQL Server is a relational database man...

How to take an SQL Server database offline? Simple methods to bring a MSSQL database to offline state using transact-SQL or management studio.

Simple method to detach and attach database in SQL Server. T-SQL method and SSMS method to detach an database and attach it back.

Finding the deadlocks and blocked processes using extended events In SQL Server. Collecting deadlocks using extended events

Know how to view the SQL Server Error Log File Location using Transact-SQL, SQL Server Configuration Manager and Windows Application Event Viewer

"SQL Server 2019 Standard مایکروسافت: بهترین انتخاب برای مدیریت، ذخیره‌سازی و تحلیل داده‌های پیشرفته. مناسب برای کسب‌وکارهای متوسط و بزرگ، با پشتیبانی از لینوکس و Docker، اجرای بی‌نظیر روی پلتفرم‌های مختلف، و امنیت بی‌نقص با Always Encrypted و secure enclaves. بهره‌مندی از فناوری Big Data Clusters و ادغام هوشمند با Azure و سایر سرویس‌های کلودی، به همراه قابلیت‌های پیشرفته پردازش In-Memory و Intelligent Query Processing. افزایش کارایی، امنیت و هوش تحلیلی برای رقابت در دنیای داده‌محور امروز. خرید SQL Server 2019 Standard برای بهینه‌سازی عملکرد و امنیت پایگاه داده‌های شما." Keywords: SQL Server 2019 Standard، مدیریت داده، امنیت پایگاه داده، پردازش سریع، تحلیل داده‌های بزرگ، مایکروسافت، لینوکس، Docker، Always Encrypted، Big Data Clusters، Azure، In-Memory، Intelligent Query Processing.

Đừng bỏ qua bài viết này, chúng ta sẽ cùng nhau khám phá SQL Server là gì và tìm hiểu cách tải về và cài đặt cho tất cả những ai mới bắt đầu.

Webinar: Delivering Microsoft SQL Server High Availability on AWS You can use AWS services like Amazon EC2 and Amazon RDS to quickly build, deploy, scale and manage your SQL Server databases, which helps you build more agile applications. This webinar covers best practices for running SQL Server business-critical applications on AWS. Zlatan Dzinic, of AWS, and Dave […]

No, this isn’t one of those “why my RDBMS is better than your RDBMS” comparisons. One of the initial stumbling blocks a DBA on one system e...

Schedule Backup in SQL Server 2008, schedule backup in sql server, schedule backup in sql server 2012

Using simple sql technique, here we will see how to get the list of temporal tables in a database.

«« Previous Next »» Index MS SQL Server provides the following two services which is mandatory for databases creation and maint...

This topic describes how to rename SQL Server database using SQL Server Management Studio(GUI), Transact-SQL(command line) and detach/attach method

This blog describes end of life for Microsoft SQL Server 2005 support with its associated security risks and know its no longer version solutions.

SQL Server on Linux has been out for a bit now and I've played around a little (see here) but haven't really used it in "anger" nor will I for the foreseeable future if I'm honest. Nevertheless it's an area that I find very interesting as I know very little when it comes to the…

Know what are the new features in SQL Server Management Studio for SQL Server 2016 to enhance its performance and servie

could not open a connection to SQL Server, error: 40, a network-related or instance-specific error, Named Pipes Provider

SQL SERVER – Fix : Error 701 There is insufficient system memory to run this query; To fix this #sql error, do; i. Check the settings for both min server memory (MB) and max server #memory (#MB). ii. If max #server memory (MB) is a value close to the value of min server memory (MB). iii. Then increase the max server memory (MB) value.