How To Rename a database in SQL Azure

by ebarcza 4/9/2020 5:07:00 AM

Alter Database [nameofdb] modify name = [newdbname].

Tags:

How to solve “The specified service has been marked for deletion” error

by ebarcza 4/2/2020 2:00:00 PM

There may be several causes which lead to the service being stuck in “marked for deletion”. - #4 Usually solves it for me

  1. SysInternals' Process Explorer is opened. Closing it should lead to automatic removal of the service.

  2. Task Manager is opened.

  3. Microsoft Management Console (MMC) is opened. To ensure all instances are closed, run taskkill /F /IM mmc.exe.

  4. Services console is opened. This is the same as the previous point, since Services console is hosted by MMC.

  5. Event Viewer is opened. Again, this is the same as the third point.

  6. The key HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\{service name} exists.

  7. Someone else is logged into the server and has one of the previously mentioned applications opened.

  8. An instance of Visual Studio used to debug the service is open.

Tags:

Where is the Spotify Queue

by ebarcza 3/31/2020 3:17:00 PM

To view your Spotify queue, tap the queue icon in your "Now Playing" bar. You can edit and add songs to your queue at any time

Tags:

Installing a Windows Service with Powershell

by ebarcza 3/31/2020 11:27:00 AM

Install your service manually using PowerShell

  1. From the Start menu, select the Windows PowerShell directory, then select Windows PowerShell.

  2. Access the directory where your project's compiled executable file is located.

  3. Run the New-Service cmdlet with the with your project's output and a service name as parameters:

New-Service -Name "YourServiceName" -BinaryPathName <yourproject>.exe

 

Uninstall your service manually using PowerShell

  1. From the Start menu, select the Windows PowerShell directory, then select Windows PowerShell.

  2. Run the Remove-Service cmdlet with the name of your service as parameter:

Remove-Service -Name "YourServiceName"

sc.exe delete "YourServiceName" for PSVersion 5.1

Tags: ,

Powershell

Visual Studio 2017 setup project missing

by ebarcza 3/31/2020 9:58:00 AM

1) open vs2017 and select "Tools" -> "Extensions and Updates"

2) Under Extensions and Updates select "Online" on the left of the window and on the right type in search box "Visual Studio Installer Projects Extension" hit enter and it is the first download in result (attached image) select this result "Microsoft Visual Studio 2017 Installer Projects" and click on "Download"

3) You will have to restart your VS2017 for the installation to happen so click on "close" button then restart you VS2017 then you should have it!

4) To use it you right click on your "Solution abc" then "Add New Project" under "Other Project Types" select "Visual Studio Installer" as I did in this attachment below.

Tags:

Creating a new User in Azure SQL

by ebarcza 3/31/2020 8:38:00 AM

First Create the Login

-----------------------------------------

CREATE LOGIN Big_Bad_Man WITH PASSWORD = 'SecurePWD' GO

 

Next Create the USER in the target database

--------------------------------------------

CREATE USER [Big_Bad_Man] FOR LOGIN [Big_Bad_Man] WITH DEFAULT_SCHEMA=[dbo]

 

Add to ROLE

-----------------------------------------------

EXEC sp_addrolemember db_owner, 'Big_Bad_Man' GRANT CONNECT TO Big_Bad_Man

Tags:

What is a CNAME

by ebarcza 3/27/2020 9:48:00 AM

Here's a link to a great explanation - https://www.web24.com.au/tutorials/cname-records-used

A CNAME, or Canonical Name record, is a record that points to another domain address rather than an IP address.

For example, say you have several subdomains, like www.mydomain.com, ftp.mydomain.com, mail.mydomain.com etc and you want these sub domains to point to your main domain name mydomain.com. Instead of creating A records for each sub-domain and binding it to the IP address of your domain you can create CNAME records.

As you can see in the table below, in the case where the IP address of your server changes, you only need to update one A record and all the subdomains follow automatically because all the CNAMES point to the main domain with the A record:

(sub)Domain / Hostname Record Type Target / Destination
mydomain.com A 111.222.333.444
www.mydomain.com CNAME mydomain.com
ftp.mydomain.com CNAME mydomain.com
mail.mydomain.com CNAME mydomain.com

 

Tags:

How to Add another admin user to Azure Account

by ebarcza 3/27/2020 9:28:00 AM

  1. From the portal home page, click on the Subscriptions Icon(KEY), and then click on the subscription you want to add an admin account to.
  2. Click on Access Control(IAM)
  3. Click the Add BUtton
  4. Choose Co-Admin
  5. FInd the user
  6. CLick Add at the bottom

 

Home>Subscriptions>Azure subscription 1 | Access control (IAM)

Tags:

Viewing the SQL Server Error Log

by ebarcza 3/24/2020 8:25:00 AM

View Log Files

  1. In Object Explorer, expand Management.

  2. Do either of the following:

    • Right-click SQL Server Logs, point to View, and then click either SQL Server Log or SQL Server and Windows Log.

    • Expand SQL Server Logs, right-click any log file, and then click View SQL Server Log. You can also double-click any log file.

    The logs include Database MailSQL ServerSQL Server Agent, and Windows NT.

Tags:

How to create shortcut to website on chrome

by ebarcza 3/23/2020 9:22:00 AM

 

1.    Navigate to https://www.repairtraq.com/login.aspx and click the ••• icon in the right corner of the screen.

2.    Select More tools.

3.    Select Create Shortcut...

4.    Edit the shortcut name.

5.    Click Create.

 

Tags:

Powered by BlogEngine.NET 1.5.0.7
Theme by Mads Kristensen

About the author

Name of author Author name
Something about me and what I do.

E-mail me Send mail

Calendar

<<  May 2020  >>
MoTuWeThFrSaSu
27282930123
45678910
11121314151617
18192021222324
25262728293031
1234567

View posts in large calendar

Recent comments

Tags

Disclaimer

The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

© Copyright 2020

Sign in