1,183 articles
You may be prompted to run the Enable Organization Customization cmdlet before you create or modify objects in your Exchange Online organization. Here are some examples of when you might see this: Creating a new role group or creating a…
Microsoft introduced a Simplified Ribbon in early 2021 for various Office programs, including Microsoft Outlook on Windows, Word for web, and Excel for web. The new ribbon shows fewer icons and takes up less space. If this isn’t for you,…
Changing SQL Server Instance name is not a routine task. Although, sometimes we get requirements to change SQL Instance name. There are multiple scenarios in which we need to rename SQL Server Instance like: If you have changed database server…
As you may know, the internal SQL Server name is based on the physical server name, but changing the physical server name does not update the metadata within SQL Server. When connecting to SQL Server, we use the physical server…
SQL Server 2019 (15.x) supports upgrade from the following versions of SQL Server: SQL Server 2012 (11.x) SP4 or later SQL Server 2014 (12.x) SP2 or later SQL Server 2016 (13.x) SP2 or later SQL Server 2017 (14.x) Windows 10…
Gmail is probably the most reliable email service out there right and for a lot of good reasons. But it can get a little frustrating at times for users especially when the service tries to make things ‘simple’ by organizing email in tabs for easier access.
In this article I am explaining how to do backup and restore using a SQLCMD and T-SQL command prompt. It’s one of the most important responsibilities for DBAs. It works across all supported operating systems, whether they are 64-bit or…
Creating backups using SQL Server Management Studio is pretty simple as well. Based on how simple the T-SQL commands are, there is a lot of clicking that needs to occur in SSMS to create a backup. The following screen shots…
Have you ever needed to upgrade or downgrade the SQL Server edition you already installed? Maybe you currently have Enterprise Edition and have discovered that you can save money on licensing if you downgrade to Standard Edition. The ability to…
Microsoft’s SQL Server Management Studio will connect by default to port 1433 and there’s nowhere in the connect dialog to specify a different port from the default. To connect using a different port specify the servername, a comma, and then…