Tuesday, November 1, 2022

Team Explorer in Visual Studio - GitHub - Shrinking

GitHub via Visual Studio (circa 2017)

Whu happend?

Sunday, July 3, 2022

Azure Rookie Mistakes: Creating an Image from a VM will Generalize the source VM, bricking it

You won't be warned. It will both stop the source VM and worse, it will GENERALIZE it, meaning it removes all personal account info. This is irreversible.

Tuesday, June 14, 2022

Visual Studio roslyn csc.exe error : Try running VS as Admin

Try to build a newly added project and get:

bin\roslyn\csc.exe

Try running Visual Studio as Administrator.

Sunday, June 12, 2022

Request

AcceptTypes: {string[8]}

AnonymousID: null

AppRelativeCurrentExecutionFilePath: "~/Apply/FCC_Standard_1"

ApplicationPath: "/"

Browser: {System.Web.Mobile.MobileCapabilities}

ClientCertificate: {System.Web.HttpClientCertificate}

ContentEncoding: {System.Text.UTF8Encoding}

ContentLength: 11897

ContentType: "multipart/form-data; boundary=----WebKitFormBoundaryDmtGCaOzox2vBh7G"

Cookies: {System.Web.HttpCookieCollection}

CurrentExecutionFilePath: "/Apply/FCC_Standard_1"

CurrentExecutionFilePathExtension: ""

FilePath: "/Apply/FCC_Standard_1"

Files: {System.Web.HttpFileCollection}

Filter: {System.Web.HttpInputStreamFilterSource}

Form: {__EVENTTARGET=&__EVENTARGUMENT=&__VIEWSTATE=9Zsr6u4%2flTUh2TKRaHFcaOb%2fglJP89ebqo%2bbxVjsAUGRiLGOzPNWHRdNETDuEql7pdWnVQaAgNRQKUCKCSwNRwMlIEwoCGnNgLD0y785cVeikYYLlfzNb%2flDJWpvyCZuc9YUn9siFtJe8GYf94bFWOwN90dyVf5GPgNsGpPBbNoykil5%2bEM7qxf99W%2fWlsB2HkylX1uqYjRVhqpK4KpKemuAKaMKlewd%2b5W2u......................................

vToCZT0xdJS9Oe9zT6atygIO9V8CZQOuLx36mMww%3d%3d&ctl00%24MainContent%24Submit=Submit}

Headers: {Cache-Control=max-age%3d0&Connection=keep-alive&Content-Length=11897&Content-Type=multipart%2fform-data%3b+boundary%3d----WebKitFormBoundaryDmtGCaOzox2vBh7G&Accept=text%2fhtml%2capplication%2fxhtml%2bxml%2capplication%......................................e%2fapng%2c*%2f*%3bq%3d0.8%2capplication%2fsigned-exchange%3bv%3db3%3bq%3d0.9&Accept-Encoding=gzip%2c+deflate%2c+br&Accept-Language=en-US%2cen%3bq%3d0.9&Cookie=__AntiXsrfToken%3df59b........................c+%22Chromium%22%3bv%3d%22102%22%2c+%22Google+Chrome%22%3bv%3d%22102%22&sec-ch-ua-mobile=%3f0&sec-ch-ua-platform=%22Windows%22&Upgrade-Insecure-Requests=1&Origin=http%3a%2f%2flocalhost%3a62848&Sec-Fetch-Site=same-origin&Sec-Fetch-Mode=navigate&Sec-Fetch-User=

%3f1&Sec-Fetch-Dest=document}

HttpChannelBinding: {System.Web.HttpChannelBindingToken}

HttpMethod: "POST"

InputStream: {System.Web.HttpInputStream}

IsAuthenticated: false

IsLocal: true

IsSecureConnection: false

LogonUserIdentity: {System.Security.Principal.WindowsIdentity}

Params: {__EVENTTARGET=&__EVENTARGUMENT=&__VIEWSTATE=9Zsr6u4%2flTUh2TKRaHFcaOb%2fglJP89ebqo%2bbxVjsAUGRiLGOzPNWHRdNETDuEql7pdWnVQaAgNRQKUCKCSwNRwMlIEwoCGnNgL...........................................

FSLCC%2bpFKujl%2bYWb2Ni2lqqT8Xr5ByYmDybPo52OXrFFzbqbZlLqLhTAXe8vxMGZjxPkWs4NgH82hu2jjT8doKB3vpFgkiU19T5cXuK8OLT1j0yIR1ogk%2b5vSVcl2USMs8qyqeVn8dfldBZffw3sRz..............................

covToC......................Mww%3d%3d&ctl00%24MainContent%24Submit=Submit&__AntiXsrfToken=f59b1ef7e.........................52afe68dc82&ALL_HTTP=HTTP_CACHE_CONTROL%3amax-age%3d0%0d%0aHTTP_CONNECTION%3akeep-alive%0d%0aHTTP_CONTENT_LENGTH%3a11897%0d%0aHTTP_CONTENT_TYPE%3amultipart%2fform-data%3b+boundary%3d----WebKitFormBoundaryDmtGCaOzox2vBh7G%0d%0aHTTP_ACCEPT%3atext%2fhtml%2capplication%2fxhtml%2bxml%2capplication%2fxml%3bq%3d0.9%2cimage%2favif%2cimage%2fwebp%2cimage%2fapng%2c*%2f*%3bq%3d0.8%2capplication%2fsigned-exchange%3bv%3db3%3bq%3d0.9%0d%0aHTTP_ACCEPT_ENCODING%3agzip%2c+deflate%2c+br%0d%0aHTTP_ACCEPT_LANGUAGE%3aen-US%2cen%3bq%3d0.9%0d%0aHTTP_COOKIE%3a__AntiXsrfToken%3df59b1ef7e2f04abeb39b552afe68dc82%0d%0aHTTP_HOST%3alocalhost%3a62848%0d%0aHTTP_REFERER%3ahttp%3a%2f%2flocalhost%3a62848%2fApply%2fFCC_Standard_1%0d%0aHTTP_USER_AGENT%3aMozilla%2f5.0+(Windows+NT+10.0%3b+Win64%3b+x64)+AppleWebKit%2f537.36+(KHTML%2c+like+Gecko)+Chrome%2f102.0.0.0+Safari%2f537.36%0d%0aHTTP_SEC_CH_UA%3a%22+Not+A%3bBrand%22%3bv%3d%

2299%22%2c+%22Chromium%22%3bv%3d%22102%22%2c+%22Google+Chrome%22%3bv%3d%22102%22%0d%0aHTTP_SEC_CH_UA_MOBILE%3a%3f0%0d%0aHTTP_SEC_CH_UA_PLATFORM%3a%22Windows%22%0d%0aHTTP_UPGRADE_INSECURE_REQUESTS%3a1%0d%0aHTTP_ORIGIN%3ahttp%3a%2f%2flocalhost%3a62848%0d%0aHTTP_SEC_FETCH_SITE%3asame-origin%0d%0aHTTP_SEC_FETCH_MODE%3anavigate%0d%0aHTTP_SEC_FETCH_USER%3a%3f1%0d%0aHTTP_SEC_FETCH_DEST%3adocument%0d%0a&ALL_RAW=Cache-Control%3a+max-age%3d0%0d%0aConnection%3a+keep-alive%0d%0aContent-Length%3a+11897%0d%0aContent-Type%3a+multipart%2fform-data%3b+boundary%3d----WebKitFormBoundaryDmtGCaOzox2vBh7G%0d%0aAccept%3a+text%2fhtml%2capplication%2fxhtml%2bxml%2capplication%2fxml%3bq%3d0.9%2cimage%2favif%2cimage%2fwebp%2cimage%2fapng%2c*%2f*%3bq%3d0.8%2capplication%2fsigned-exchange%3bv%3db3%3bq%3d0.9%0d%0aAccept-Encoding%3a+gzip%2c+deflate%2c+br%0d%0aAccept-Language%3a+en-US%2cen%3bq%3d0.9%0d%0aCookie%3a+__AntiXsrfToken%3df59b1ef7e2f04abeb39b552afe68dc82%0d%0aHost%3a+localhost%3a62848%0d%0aReferer%3a+http%3a%2f%2flocalhost%3a62848%

2fApply%2fFCC_Standard_1%0d%0aUser-Agent%3a+Mozilla%2f5.0+(Windows+NT+10.0%3b+Win64%3b+x64)+AppleWebKit%2f537.36+(KHTML%2c+like+Gecko)+Chrome%2f102.0.0.0+Safari%2f537.36%0d%0asec-ch-ua%3a+%22+Not+A%3bBrand%22%3bv%3d%2299%22%2c+%22Chromium%22%3bv%3d%22102%22%2c+%22Google+Chrome%22%3bv%3d%22102%22%0d%0asec-ch-ua-mobile%3a+%3f0%0d%0asec-ch-ua-platform%3a+%22Windows%22%0d%0aUpgrade-Insecure-Requests%3a+1%0d%0aOrigin%3a+http%3a%2f%2flocalhost%3a62848%0d%0aSec-Fetch-Site%3a+same-origin%0d%0aSec-Fetch-Mode%3a+navigate%0d%0aSec-Fetch-User%3a+%3f1%0d%0aSec-Fetch-Dest%3a+document%0d%0a&APPL_MD_PATH=%2fLM%2fW3SVC%2f2%2fROOT&APPL_PHYSICAL_PATH=C%3a%5cUsers%5cSQ7tywgw287a%5csource%5crepos%5cRisingStars1%5cRisingStars1%5c&AUTH_TYPE=&AUTH_USER=&AUTH_PASSWORD=&LOGON_USER=&REMOTE_USER=&CERT_COOKIE=&CERT_FLAGS=&CERT_ISSUER=&CERT_KEYSIZE=&CERT_SECRETKEYSIZE=&CERT_SERIALNUMBER=&CERT_SERVER_ISSUER=&CERT_SERVER_SUBJECT=&CERT_SUBJECT=&CONTENT_LENGTH=11897&CONTENT_TYPE=multipart%2fform-data%3b+boundary%3d----WebKitFormBoundaryDmtGCaO

zox2vBh7G&GATEWAY_INTERFACE=CGI%2f1.1&HTTPS=off&HTTPS_KEYSIZE=&HTTPS_SECRETKEYSIZE=&HTTPS_SERVER_ISSUER=&HTTPS_SERVER_SUBJECT=&INSTANCE_ID=2&INSTANCE_META_PATH=%2fLM%2fW3SVC%2f2&LOCAL_ADDR=%3a%3a1&PATH_INFO=%2fApply%2fFCC_Standard_1&PATH_TRANSLATED=C%3a%5cUsers%5cSQ7tywgw287a%5csource%5crepos%5cRisingStars1%5cRisingStars1%5cApply%5cFCC_Standard_1&QUERY_STRING=&REMOTE_ADDR=%3a%3a1&REMOTE_HOST=%3a%3a1&REMOTE_PORT=52595&REQUEST_METHOD=POST&SCRIPT_NAME=%2fApply%2fFCC_Standard_1&SERVER_NAME=localhost&SERVER_PORT=62848&SERVER_PORT_SECURE=0&SERVER_PROTOCOL=HTTP%2f1.1&SERVER_SOFTWARE=Microsoft-IIS%2f10.0&URL=%2fApply%2fFCC_Standard_1&HTTP_CACHE_CONTROL=max-age%3d0&HTTP_CONNECTION=keep-alive&HTTP_CONTENT_LENGTH=11897&HTTP_CONTENT_TYPE=multipart%2fform-data%3b+boundary%3d----WebKitFormBoundaryDmtGCaOzox2vBh7G&HTTP_ACCEPT=text%2fhtml%2capplication%2fxhtml%2bxml%2capplication%2fxml%3bq%3d0.9%2cimage%2favif%2cimage%2fwebp%2cimage%2fapng%2c*%2f*%3bq%3d0.8%2capplication%2fsigned-exchange%3bv%3db3%3bq%3d0.9&HTTP_ACCEPT_ENCODI

NG=gzip%2c+deflate%2c+br&HTTP_ACCEPT_LANGUAGE=en-US%2cen%3bq%3d0.9&HTTP_COOKIE=__AntiXsrfToken%3df59b1ef7e2f04abeb39b552afe68dc82&HTTP_HOST=localhost%3a62848&HTTP_REFERER=http%3a%2f%2flocalhost%3a62848%2fApply%2fFCC_Standard_1&HTTP_USER_AGENT=Mozilla%2f5.0+(Windows+NT+10.0%3b+Win64%3b+x64)+AppleWebKit%2f537.36+(KHTML%2c+like+Gecko)+Chrome%2f102.0.0.0+Safari%2f537.36&HTTP_SEC_CH_UA=%22+Not+A%3bBrand%22%3bv%3d%2299%22%2c+%22Chromium%22%3bv%3d%22102%22%2c+%22Google+Chrome%22%3bv%3d%22102%22&HTTP_SEC_CH_UA_MOBILE=%3f0&HTTP_SEC_CH_UA_PLATFORM=%22Windows%22&HTTP_UPGRADE_INSECURE_REQUESTS=1&HTTP_ORIGIN=http%3a%2f%2flocalhost%3a62848&HTTP_SEC_FETCH_SITE=same-origin&HTTP_SEC_FETCH_MODE=navigate&HTTP_SEC_FETCH_USER=%3f1&HTTP_SEC_FETCH_DEST=document}

Path: "/Apply/FCC_Standard_1"

PathInfo: ""

PhysicalApplicationPath: "C:\\Users\\SQ7tywgw287a\\source\\repos\\RisingStars1\\RisingStars1\\"

PhysicalPath: "C:\\Users\\SQ7tywgw287a\\source\\repos\\RisingStars1\\RisingStars1\\Apply\\FCC_Standard_1"

QueryString: {}

RawUrl: "/Apply/FCC_Standard_1"

ReadEntityBodyMode: Classic

RequestContext: {System.Web.Routing.RequestContext}

RequestType: "POST"

ServerVariables: {ALL_HTTP=HTTP_CACHE_CONTROL%3amax-age%3d0%0d%0aHTTP_CONNECTION%3akeep-alive%0d%0aHTTP_CONTENT_LENGTH%3a11897%0d%0aHTTP_CONTENT_TYPE%3amultipart%..............................undaryDmtGCaOzox2vBh7G%0d%0aHTTP_ACCEPT%3atext%2fhtml%2capplication%2fxhtml%2bxml%2capplication%2fxml%3bq%3d0.9%2cimage%2favif%2cimage%2fwebp%2cimage%....................................n%2fsigned-exchange%3bv%3db3%3bq%3d0.9%0d%0aHTTP_ACCEPT_ENCODING%3agzip%2c+deflate%2c+br%0d%0aHTTP_ACCEPT_LANGUAGE%3aen-US%2cen%3bq%3d0.9%0d%0aHTTP_COOKIE%3a__AntiXsrfToken%3df59b1ef7e2f04abeb39b552afe68dc82%0d%0aHTTP_HOST%3alocalhost%..........................%0d%0aHTTP_REFERER%3ahttp%3a%2f%2flocalhost%3a62848%2fApply%2fFCC_Standard_1%0d%0aHTTP_USER_AGENT%3aMozilla%2f5.0+(Windows+NT+10.0%3b+Win64%3b+x64)+AppleWebKit%2f537.36+(KHTML%2c+like+Gecko)+Chrome%2f102.0.0.0+Safari%2f537.36%0d%0aHTTP_SEC_CH_UA%3a%22+Not+A%3bBrand%22%3bv%3d%2299%22%2c+%22Chromium%22%3bv%3d%22102%22%2c+%22Google+Chrome%22%3bv%3d%22102%22%0d%0aHTTP_SEC_CH_UA_MOBILE%3a%3

f0%0d%0aHTTP_SEC_CH_UA_PLATFORM%3a%22Windows%22%0d%0aHTTP_UPGRADE_INSECURE_REQUESTS%3a1%0d%0aHTTP_ORIGIN%3ahttp%3a%2f%2flocalhost%3a62848%0d%0aHTTP_SEC_FETCH_SITE%3asame-origin%0d%0aHTTP_SEC_FETCH_MODE%3anavigate%0d%0aHTTP_SEC_FETCH_USER%3a%3f1%0d%0aHTTP_SEC_FETCH_DEST%3adocument%0d%0a&ALL_RAW=Cache-Control%3a+max-age%3d0%0d%0aConnection%3a+keep-alive%0d%0aContent-Length%3a+11897%0d%0aContent-Type%3a+multipart%2fform-data%3b+boundary%3d----WebKitFormBoundaryDmtGCaOzox2vBh7G%0d%0aAccept%3a+text%2fhtml%2capplication%2fxhtml%2bxml%2capplication%2fxml%3bq%3d0.9%2cimage%2favif%2cimage%2fwebp%2cimage%2fapng%2c*............................................%2fsigned-exchange%3bv%3db3%3bq%3d0.9%0d%0aAccept-Encoding%3a+gzip%2c+deflate%2c+br%0d%0aAccept-Language%3a+en-US%2cen%3bq%3d0.9%0d%0aCookie%3a+__AntiXsrfToken%3df59...............................2afe68dc82%0d%0aHost%3a+localhost%3a62848%0d%0aReferer%3a+http%3a%2f%2flocalhost%3a62848%2fApply%2fFCC_Standard_1%0d%0aUser-Agent%3a+Mozilla%2f5.0+(Windows+NT+10.0%3b+Win64%3b+x64)+AppleWebKit%2f537.36

+(KHTML%2c+like+Gecko)+Chrome%2f102.0.0.0+Safari%2f537.36%0d%0asec-ch-ua%3a+%22+Not+A%3bBrand%22%3bv%3d%2299%22%2c+%22Chromium%22%3bv%3d%22102%22%2c+%22Google+Chrome%22%3bv%3d%22102%22%0d%0asec-ch-ua-mobile%3a+%3f0%0d%0asec-ch-ua-platform%3a+%22Windows%22%0d%0aUpgrade-Insecure-Requests%3a+1%0d%0aOrigin%3a+http%3a%2f%2flocalhost%3a62848%0d%0aSec-Fetch-Site%3a+same-origin%0d%0aSec-Fetch-Mode%3a+navigate%0d%0aSec-Fetch-User%3a+%3f1%0d%0aSec-Fetch-Dest%3a+document%0d%0a&APPL_MD_PATH=%2fLM%2fW3SVC%2f2%2fROOT&APPL_PHYSICAL_PATH=C%3a%5cUsers%5cSQ7tywgw287a%5csource%5crepos%5cRisingStars1%5cRisingStars1%5c&AUTH_TYPE=&AUTH_USER=&AUTH_PASSWORD=&LOGON_USER=&REMOTE_USER=&CERT_COOKIE=&CERT_FLAGS=&CERT_ISSUER=&CERT_KEYSIZE=&CERT_SECRETKEYSIZE=&CERT_SERIALNUMBER=&CERT_SERVER_ISSUER=&CERT_SERVER_SUBJECT=&CERT_SUBJECT=&CONTENT_LENGTH=11897&CONTENT_TYPE=multipart%2fform-data%3b+boundary%3d----WebKitFormBoundaryDmtGCaOzox2vBh7G&GATEWAY_INTERFACE=CGI%2f1.1&HTTPS=off&HTTPS_KEYSIZE=&HTTPS_SECRETKEYSIZE=&HTTPS_SERVER_ISSUER=&HTTPS_S

ERVER_SUBJECT=&INSTANCE_ID=2&INSTANCE_META_PATH=%2fLM%2fW3SVC%2f2&LOCAL_ADDR=%3a%3a1&PATH_INFO=%2fApply%2fFCC_Standard_1&PATH_TRANSLATED=C%3a%5cUsers%5cSQ7tywgw287a%5csource%5crepos%5cRisingStars1%5cRisingStars1%5cApply%5cFCC_Standard_1&QUERY_STRING=&REMOTE_ADDR=%3a%3a1&REMOTE_HOST=%3a%3a1&REMOTE_PORT=52595&REQUEST_METHOD=POST&SCRIPT_NAME=%2fApply%2fFCC_Standard_1&SERVER_NAME=localhost&SERVER_PORT=62848&SERVER_PORT_SECURE=0&SERVER_PROTOCOL=HTTP%2f1.1&SERVER_SOFTWARE=Microsoft-IIS%2f10.0&URL=%2fApply%2fFCC_Standard_1&HTTP_CACHE_CONTROL=max-age%3d0&HTTP_CONNECTION=keep-alive&HTTP_CONTENT_LENGTH=11897&HTTP_CONTENT_TYPE=multipart%2fform-data%3b+boundary%3d----WebKitFormBoundaryDmtGCaOzox2vBh7G&HTTP_ACCEPT=text%2fhtml%2capplication%2fxhtml%2bxml%2capplication%2fxml%3bq%3d0.9%2cimage%2favif%2cimage%2fwebp%2cimage%2fapng%2c*%2f*%3bq%3d0.8%2capplication%2fsigned-exchange%3bv%3db3%3bq%3d0.9&HTTP_ACCEPT_ENCODING=gzip%2c+deflate%2c+br&HTTP_ACCEPT_LANGUAGE=en-US%2cen%3bq%3d0.9&HTTP_COOKIE=__AntiXsrfToken%3df59b1ef7e2f04ab

eb39b552afe68dc82&HTTP_HOST=localhost%3a62848&HTTP_REFERER=http%3a%2f%2flocalhost%3a62848%2fApply%2fFCC_Standard_1&HTTP_USER_AGENT=Mozilla%2f5.0+(Windows+NT+10.0%3b+Win64%3b+x64)+AppleWebKit%2f537.36+(KHTML%2c+like+Gecko)+Chrome%2f102.0.0.0+Safari%2f537.36&HTTP_SEC_CH_UA=%22+Not+A%3bBrand%22%3bv%3d%2299%22%2c+%22Chromium%22%3bv%3d%22102%22%2c+%22Google+Chrome%22%3bv%3d%22102%22&HTTP_SEC_CH_UA_MOBILE=%3f0&HTTP_SEC_CH_UA_PLATFORM=%22Windows%22&HTTP_UPGRADE_INSECURE_REQUESTS=1&HTTP_ORIGIN=http%3a%2f%2flocalhost%3a62848&HTTP_SEC_FETCH_SITE=same-origin&HTTP_SEC_FETCH_MODE=navigate&HTTP_SEC_FETCH_USER=%3f1&HTTP_SEC_FETCH_DEST=document}

TimedOutToken: IsCancellationRequested = false

TlsTokenBindingInfo: null

TotalBytes: 11897

Unvalidated: {System.Web.UnvalidatedRequestValues}

Url: {http://localhost:62848/Apply/FCC_Standard_1}

UrlReferrer: {http://localhost:62848/Apply/FCC_Standard_1}

UserAgent: "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36"

UserHostAddress: "::1"

UserHostName: "::1"

UserLanguages: {string[2]}

Sunday, April 24, 2022

VS2017 Templates: ASP.NET Web Forms (and MVC): Bootstrap 3 to 4

Invaluable page here:

https://www.mytecbits.com/microsoft/dot-net/how-to-add-bootstrap-in-asp-net#WebFormsNuGet

So couple things:

1. Popper, how to get that included properly

2. The nav bar from the template is for BS3. Won't work with BS4.

Here's how the nav bar from template looks with BS4:

For Popper:

Go to Site.Master file and add the reference to popper.js either directly or by using BundleConfig and ScriptReference. (NOTE: Popper.js is needed only if you are using tooltips, popovers or dropdowns in bootstrap).

(Using Bootstrap 4.6.0)

Solved by adding the following to ScriptManager reference in Site.Master:

 <asp:scriptReference Path="~/Scripts/umd/popper.min.js" />

For the nav bar, here's the old code you need to replace in Site.Master:

</button>

<a class="navbar-brand" runat="server" href="~/">Application name</a>

</div>

<li><a runat="server" href="~/About">About</a></li>

<li><a runat="server" href="~/Contact">Contact</a></li>

</ul>

<asp:LoginView runat="server" ViewStateMode="Disabled">

<li><a runat="server" href="~/Account/Register">Register</a></li>

</ul>

</AnonymousTemplate>

<li><a runat="server" href="~/Account/Manage" title="Manage your account">Hello, <%: Context.User.Identity.GetUserName() %> !</a></li>

<li>

<asp:LoginStatus runat="server" LogoutAction="Redirect" LogoutText="Log off" LogoutPageUrl="~/" OnLoggingOut="Unnamed_LoggingOut" />

</li>

</ul>

</LoggedInTemplate>

</asp:LoginView>

</div>

Replace with:

</button>

<li class="nav-item"><a class="nav-link" href="#about">About</a></li>

<li class="nav-item"><a class="nav-link" href="#contact">Contact</a></li>

<a class="nav-link dropdown-toggle" href="#" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false" id="dropdown04″>Dropdown <span class="caret"></span></a>

<a class="dropdown-item" href="#">Action</a>

<a class="dropdown-item" href="#">Another action</a>

<a class="dropdown-item" href="#">Something else here</a>

</div>

</li>

</ul>

</div>

</nav>

=============

Here is the one you'd use if you have Accounts in your template:

</button>

<li class="nav-item"><a class="nav-link" href="#about">About</a></li>

<li class="nav-item"><a class="nav-link" href="#contact">Contact</a></li>

<li class="nav-item">Login stuff to go here</li>

<asp:LoginView runat="server" ViewStateMode="Disabled">

<li class="nav-item"><a class="nav-link" runat="server" href="~/Account/Register">Register</a></li>

</AnonymousTemplate>

<li class="nav-item"><a class="nav-link" runat="server" href="~/Account/Manage" title="Manage your account">Hello, <%: Context.User.Identity.GetUserName() %> !</a></li>

<asp:LoginStatus class="nav-link" runat="server" LogoutAction="Redirect" LogoutText="Log off" LogoutPageUrl="~/" OnLoggingOut="Unnamed_LoggingOut" />

</li>

</LoggedInTemplate>

</asp:LoginView>

<a class="nav-link dropdown-toggle" href="#" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false" id="dropdown04″">Dropdown <span class="caret"></span></a>

<a class="dropdown-item" href="#">Action</a>

<a class="dropdown-item" href="#">Another action</a>

<a class="dropdown-item" href="#">Something else here</a>

</div>

</li>

</ul>

</div>

</nav>

Thursday, April 21, 2022

SQL Server: get count of tables, views, stored procs, etc

NOTE: the sys is not in master, but in msdb. So the full name would be:

SELECT count(name) as spcount FROM msdb.sys.sysobjects WHERE xtype = 'P'

select * from [servername\instance].msdb.sys.sysobjects

===========================

SELECT count(name) as tablecount FROM sys.sysobjects WHERE xtype = 'U'

Below query will return the total number of views in sql server

SELECT count(name) as viewscount FROM sys.sysobjects WHERE xtype = 'V'

Below query will return the total number of stored procedures in sql server

SELECT count(name) as spcount FROM sys.sysobjects WHERE xtype = 'P'

Below query will return the total number of functions in sql server

SELECT count(name) as fncount FROM sys.sysobjects WHERE xtype = 'FN'

SELECT name FROM sys.sysobjects WHERE xtype = 'U'

SELECT name FROM sys.sysobjects WHERE xtype = 'V'

SELECT name FROM sys.sysobjects WHERE xtype = 'P'

SELECT name FROM sys.sysobjects WHERE xtype = 'FN'

SQL Server : querying from another server

You needed to link the server.

To check if already linked:

select * from sys.servers

If not, use:

EXEC sp_addlinkedserver @server='servername\instance'

EXEC sp_addlinkedsrvlogin 'servername\instance', 'false', NULL, 'userLoginname', 'pa$$w0rd'

Now you can use queries like:

select * from [servername\instance].DatabaseName.dbo.Tablename

select * from [servername\instance].msdb.sys.sysobjects

SQL Server : get count of tables, views, etc.

Get total number of tables, views, stored procedures and functions count and names in sql server

Below query will return the total number of tables in sql server

SELECT count(name) as tablecount FROM sys.sysobjects WHERE xtype = 'U'

Below query will return the total number of views in sql server

SELECT count(name) as viewscount FROM sys.sysobjects WHERE xtype = 'V'

Below query will return the total number of stored procedures in sql server

SELECT count(name) as spcount FROM sys.sysobjects WHERE xtype = 'P'

Below query will return the total number of functions in sql server

SELECT count(name) as fncount FROM sys.sysobjects WHERE xtype = 'FN'

Tuesday, April 12, 2022

SQL Server and Windows Service Accounts

Good article:

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-windows-service-accounts-and-permissions?view=sql-server-ver15

Most services and their properties can be configured by using SQL Server Configuration Manager.

C:\Windows\SysWOW64\SQLServerManager15.msc

Startup accounts used to start and run SQL Server can be

domain user accounts,

If the service must interact with network services, access domain resources like file shares or if it uses linked server connections to other computers running SQL Server, you might use a minimally-privileged domain account. Many server-to-server activities can be performed only with a domain user account. This account should be pre-created by domain administration in your environment.

If you configure the SQL Server to use a domain account, you can isolate the privileges for the Service, but must manually manage passwords or create a custom solution for managing these passwords. Many server applications use this strategy to enhance security, but this strategy requires additional administration and complexity. In these deployments, service administrators spend a considerable amount of time on maintenance tasks such as managing service passwords and service principal names (SPNs), which are required for Kerberos authentication. In addition, these maintenance tasks can disrupt service.

local user accounts,

You'd only use this if the computer is not part of a domain

managed service accounts,

A Managed Service Account (MSA) is a type of domain account created and managed by the domain controller. It is assigned to a single member computer for use running a service.

The password is managed automatically by the domain controller. You can't use an MSA to sign into a computer, but a computer can use an MSA to start a Windows service.

An MSA has the ability to register a Service Principal Name (SPN) within Active Directory when given read and write servicePrincipalName permissions.

An MSA is named with a $ suffix, for example DOMAIN\ACCOUNTNAME$.

When specifying an MSA, leave the password blank.

Because an MSA is assigned to a single computer, it can't be used on different nodes of a Windows cluster.

GROUP-managed service account variant: an MSA for multiple servers.

Beginning with SQL Server 2014 (Windows Server 2012 R2), SQL Server supports group-managed service accounts for standalone instances, and SQL Server 2016 and later for failover cluster instances, and availability groups

virtual accounts

Virtual accounts (beginning with Windows Server 2008 R2 and Windows 7) are managed local accounts to simplify service administration.

The virtual account is auto-managed, and the virtual account can access the network in a domain environment.

If the default value is used for the service accounts during SQL Server setup, a virtual account using the instance name as the service name is used, in the format NT SERVICE\<SERVICENAME>.

Services that run as virtual accounts access network resources by using the credentials of the computer account in the format <domain_name>\<computer_name>$. When specifying a virtual account to start SQL Server, leave the password blank.

Service Accounts Step-by-Step Guide

Virtual accounts can't be used for SQL Server Failover Cluster Instance, because the virtual account would not have the same SID on each node of the cluster.

The following table lists examples of virtual account names.

Service	Virtual Account Name
Default instance of the Database Engine service	NT SERVICE\MSSQLSERVER
Named instance of a Database Engine service named Dev	NT SERVICE\MSSQL$Dev
SQL Server Agent service on the default instance of SQL Server	NT SERVICE\SQLSERVERAGENT
SQL Server Agent service on an instance of SQL Server named Dev	NT SERVICE\SQLAGENT$Dev

built-in system accounts:

local SERVICE account (NT AUTHORITY\LOCAL SERVICE): a single account that is built-in, has same access as Users.

The Local Service account IS NOT supported for the SQL Server or SQL Server Agent services. Local Service isn't supported as the account running those services because it is a shared service and any other services running under local service would have system administrator access to SQL Server.

Network Service Account ( NT AUTHORITY\NETWORK SERVICE): has access to more than just Users. Services that run as the Network Service account access network resources by using the credentials of the computer account in the format <domain_name>\<computer_name>$.

Local System Account (NT AUTHORITY\SYSTEM ): a very high-privileged built-in account.

Always use SQL Server tools such as SQL Server Configuration Manager to change the account used by the SQL Server Database Engine or SQL Server Agent services, or to change the password for the account. In addition to changing the account name, SQL Server Configuration Manager performs additional configuration such as updating the Windows local security store which protects the service master key for the Database Engine. Other tools such as the Windows Services Control Manager can change the account name but Don't change all the required settings.

Thursday, April 7, 2022

Database Backups - Recovery Models

There are many different strategies for doing database backups. The key thing to understand in appreciating the differences are between transactional versus structural.

If you are just backing up transactions, they won't take into account structural (DDL) changes, in particular, the fields/columns of tables and their data types.

Common situation is the following:

A FULL backup every week, DIFFERENTIAL every day, and a TRANSACTION LOG every 15 minutes.

===============

This also becomes the key difference in how you manage database refreshes, from one environment to another (Dev to QA/Test to Prod and back down the food chain).

Structural changes are also the problem in maintaining a match with associated source code changes. Microsoft's Entity Framework formalized a lot of the terminology for this in the .NET world, with the labeling of these changes as MIGRATIONS.

============

SQLShack: https://www.sqlshack.com/understanding-sql-server-backup-types/

Microsoft: https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/backup-overview-sql-server?view=sql-server-ver15

https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/full-database-backups-sql-server?view=sql-server-2016

MSSQLTips: https://www.mssqltips.com/sqlservertutorial/6/types-of-sql-server-backups/

====================

Full Backups:

A full backup must be done at least once before any of the other types of backups can be run—this is the foundation for every other kind of backup.

Differential: Changes since last full backup (? so there is no such thing as Differential from last Differential?)

Transaction Log: Doesn't save data per se, just the LOGS of the data changes. (? MUCH smaller than Differential?)

I wonder if the RECOVERY MODELS Microsoft has are an attempt to describe these three backup types. To me that is the first order of confusion. Because now you also have these three terms:

Simple, Full, Bulk Logged

https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/recovery-models-sql-server?view=sql-server-ver15

Then you have Log-Shipping and Mirroring, and Backup Sets.

Overarching the notions of backups confusion is the perennial conflation of HIGH AVAILABILITY with DISASTER RECOVERY.

HA != DR

Friday, March 11, 2022

2022 Buzzwords

As opposed to a MONOLITHIC application, we now have not only services, but MICROSERVICES.

MICROSERVICES are self-contained, and are like FUNCTIONS. In fact, Azure's product, in true Microsoft banal-naming convention, calls their microservice product: Azure Functions.

AWS Lambda are the serverless equivalent on Amazon.

MONOLITHIC as opposed to MODULAR.

MONOLITHS are TIGHTLY coupled, vs Microservices which are LOOSELY coupled.

Scaling a monolithic application is also inefficient because developers have to scale the whole application – instead of simply scaling an individual function or service.

You connect microservices to each other using RESTful APIs.

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

Swagger is like a wsdl for Rest API's.

Friday, February 11, 2022

Azure: Cloud Shell

https://docs.microsoft.com/en-us/azure/cloud-shell/persisting-shell-storage

https://azure.microsoft.com/en-us/pricing/details/storage/files/

>Get-CloudDrive

Azure and Powershell - Round 1

Install-Module -Name Az -Verbose

(did you try Install-Module -Name -Az -Verbose -Force ? Hello, Azure for Dummies readers. It is an irresponsible typo.)

PS C:\WINDOWS\system32> Install-Module -Name -Az -Verbose -Force

NuGet provider is required to continue

PowerShellGet requires NuGet provider version '2.8.5.201' or newer to interact with NuGet-based repositories. The NuGet

provider must be available in 'C:\Program Files\PackageManagement\ProviderAssemblies' or

'C:\Users\XXXXXX\AppData\Local\PackageManagement\ProviderAssemblies'. You can also install the NuGet provider by running

'Install-PackageProvider -Name NuGet -MinimumVersion 2.8.5.201 -Force'. Do you want PowerShellGet to install and

import the NuGet provider now?

[Y] Yes [N] No [S] Suspend [?] Help (default is "Y"):

VERBOSE: Valid authenticode signature found in the file 'Az.Accounts.psd1' for the module 'Az.Accounts'.

PackageManagement\Install-Package : The following commands are already available on this

system:'Login-AzAccount,Logout-AzAccount,Resolve-Error,Send-Feedback'. This module 'Az.Accounts' may override the

existing commands. If you still want to install this module 'Az.Accounts', use -AllowClobber parameter.

At C:\Program Files\WindowsPowerShell\Modules\PowerShellGet\1.0.0.1\PSModule.psm1:1809 char:21

+ ... $null = PackageManagement\Install-Package @PSBoundParameters

+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

+ CategoryInfo : InvalidOperation: (Microsoft.Power....InstallPackage:InstallPackage) [Install-Package],

Exception

+ FullyQualifiedErrorId : CommandAlreadyAvailable,Validate-ModuleCommandAlreadyAvailable,Microsoft.PowerShell.Pack

ageManagement.Cmdlets.InstallPackage

>Connect-AzAccount

https://docs.microsoft.com/en-us/powershell/scripting/install/installing-powershell-on-windows?view=powershell-7.2

Update-Help: Failed to update Help for the module(s) 'ConfigDefenderPerformance, PSReadline, WindowsUpdateProvider' with UI culture(s) {en-US} : One or more errors occurred. (Response status code does not indicate success: 404 (The specified blob does not exist.).).

English-US help content is available and can be installed using: Update-Help -UICulture en-US.

PS C:\Windows\System32> Update-Help -UICulture en-US

English-US help content is available and can be installed using: Update-Help -UICulture en-US.

PS C:\Windows\System32>

PS C:\Windows\System32> Connect-AzAccount

WARNING: Both Az and AzureRM modules were detected on this machine. Az and AzureRM modules cannot be imported in the same session or used in the same script or runbook. If you are running PowerShell in an environment you control you can use the 'Uninstall-AzureRm' cmdlet to remove all AzureRm modules from your machine. If you are running in Azure Automation, take care that none of your runbooks import both Az and AzureRM modules. More information can be found here: https://aka.ms/azps-migration-guide