VSTS new branch not visible

by ebarcza 8/5/2020 6:47:00 AM

To see the new created branches in web site, please pull or sync your local repository first. Then you will see the new branch.

Tags: ,

SSRS RDL phone number format

by ebarcza 7/29/2020 8:06:00 AM


Reference to database and/or server name in 'master.sys.databases' is not supported in this version of SQL Server.

by ebarcza 6/19/2020 8:08:00 AM

You use the system view sys.databases (without the master qualification, it is not needed)

The system table sysdatabases has been deprecated since SQL Server 2005 (Azure is a later version) and in any case is not supported on Azureer 2005 (Azure is a later version) and in any case is not supported on Azure


How To Rename a database in SQL Azure

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

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


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.


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


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: ,


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.


Creating a new User in Azure SQL

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

First Create the Login




Next Create the USER in the target database




Add to ROLE


EXEC sp_addrolemember db_owner, 'Big_Bad_Man' GRANT CONNECT TO Big_Bad_Man


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



Powered by BlogEngine.NET
Theme by Mads Kristensen

About the author

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

E-mail me Send mail


<<  September 2022  >>

View posts in large calendar

Recent comments



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

© Copyright 2022

Sign in