Browsed by
Category: GÓC IT

IT quăng hết vào đây

Giới thiệu User Logins, Server Roles, Database Schemas trong SQL Server

Giới thiệu User Logins, Server Roles, Database Schemas trong SQL Server

I. User Logins SQL Server cho phép người dùng có thể tạo tài khoản và đăng nhập vào. Mỗi người dùng đều truy cập vào trong SQL Server qua 1 tài khoản riêng. Khi tạo 1 tài khoản người dùng mới, quản trị viên sẽ cấp cho tài khoản này các quyền(Server Roles) và phạm vi có thể truy cập(Database Schemas). Tạo tài khoản Đăng nhập thử tài khoản mới II. Server Roles Để giới hạn mức độ truy cập…

Read More Read More

Delete your Office Document Cache and PendingDeletes folder

Delete your Office Document Cache and PendingDeletes folder

The Office Document Cache is used by the Microsoft Office Upload Center to give you a way to see the state of files you’re uploading to a server—keeping track of how uploads are progressing and whether any files need your attention. You can manage the Office Document Cache settings by customizing the settings in the Microsoft Office Upload Center. The safe way to clean up WinSxS is with Windows’ Deployment Image Servicing and Management (DISM). Running the following in an elevated CMD…

Read More Read More

Create a Dummy Printer on Windows 10

Create a Dummy Printer on Windows 10

1. Open Settings > Devices > Printers 2. Click + to add a new printer > wait for Discovery to finish and click ‘ The Printer was not listed ‘  3. Select ‘Add Local Printer’ > Next > Use an existing Port – Drop down and set COM1 > Next  4. Select a Generic Driver > Generic / Text only > Set a memorable placeholder name

How to stop Google Chrome from automatically redirecting to HTTPS

How to stop Google Chrome from automatically redirecting to HTTPS

1. In a new browser tab, enter URL: chrome://net-internals/#hsts 2. Scroll down to “Delete domain security policies” and enter the domain that you don’t want automatic redirection. Then click the Delete button. 3. If the problem still exists, try to clean the browsing data/cache by going to Settings => Privacy and security.

How to Delete a SharePoint Site

How to Delete a SharePoint Site

New SharePoint sites are easily created in Microsoft 365, but sometimes a bit too easy. I often see a lot of unused SharePoint sites in SharePoint online. Users accidentally created two sites for the same project, or just wanted to test something out. So sometimes we will need to delete SharePoint sites to keep our environment cleaned up. It’s important to check if SharePoint sites are not used anymore before we can delete them. And this can sometimes be a…

Read More Read More

How to Enable Remote Connections in SQL Server 2014/2012/2008

How to Enable Remote Connections in SQL Server 2014/2012/2008

When you try to connect to a SQL Server instance from a remote computer, you might receive the following error message: Cannot connect to SQL Server.An error has occurred while establishing a connection to the server. When connecting to SQL Server 2008, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified) (Microsoft SQL Server) After installing SQL Server,…

Read More Read More

Difference Between SQL Server Logins and Database Users

Difference Between SQL Server Logins and Database Users

Although the words logins and users are often used interchangeably, they are very different things in Microsoft SQL Server. There has always been confusion over logins and users, especially for most new SQL Server users. Here I’ll explain the difference between SQL Server logins and database users. Part 1: Logins vs. Users Logins are created at the server level, while users are created at the database level. In other words, a login allows you to connect to the SQL Server…

Read More Read More

Disable Hardware Graphic Acceleration for Office 2019 / 2016 / 2013

Disable Hardware Graphic Acceleration for Office 2019 / 2016 / 2013

Starting with Microsoft Office 2013, hardware graphics acceleration is enabled by default, which moves all graphics and text rendering from CPU to GPU (a chip on your graphics card) for getting better performance, but it may also increase the burden on the graphic card. If you experienced crash, slowness, blurred text and cursor hanging when running Office, turning off hardware graphics acceleration should solve the problem. Here are 2 ways to disable hardware graphics acceleration in Office 2019 / 2016…

Read More Read More

Tutorial: How to Check RDP Windows Server Connection Logs

Tutorial: How to Check RDP Windows Server Connection Logs

Part 1. How to check incoming RDP Windows Server connection logs There are three ways to help you check incoming RDP Windows Server connection logs. Way 1. Check incoming RDP connection logs via Event Viewer The first way to check incoming RDP connection logs on Windows Server is using the Event Viewer. Step 1.Press Win + R to invoke the Run dialog box, then type in “eventvwr.msc” and press OK to open Event Viewer. Step 2. Navigate here: Applications and Services Logs > Microsoft > Windows > TerminalServices-RemoteConnectionManager > Operational. Right-click Operational and choose Filter Current Log. Step 3….

Read More Read More

Hướng dẫn kiểm tra Log Remote Desktop trên Windows

Hướng dẫn kiểm tra Log Remote Desktop trên Windows

Các Sự kiện trên Linux được ghi lại vào File log, còn đối với windows sẽ được ghi vào Event Viewer theo các Name cụ thể ứng với từng loại log. Trong bài viết này chúng ta sẽ cùng tìm hiểu chi tiết về Event Viewer và cách sử dụng trong từng trường hợp Các Sự kiện trên Linux được ghi lại vào File log, còn đối với windows sẽ được ghi vào Event View theo các Name cụ thể…

Read More Read More