SQL Server DBA Tools & Utilities

Brent Ozar’s free kits

First Responder Kit is packed with scripts, worksheets, and checklists like:

https://www.brentozar.com/first-aid/

First Responder kit on github:

https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit/tree/master

SSMS Tools:

http://www.ssmstoolspack.com/

SQL Server Backup, Integrity Check, and Index and Statistics Maintenance:

https://ola.hallengren.com/

The ‘System.Web.Security.SqlMembershipProvider’ requires a database schema compatible with schema version ‘1’

The ‘System.Web.Security.SqlMembershipProvider’ requires a database schema compatible with schema version ‘1’

INSERT INTO dbo.aspnet_SchemaVersions
VALUES
(‘common’, 1, 1),
(‘membership’, 1, 1),
(‘role manager’, 1, 1),
(‘health monitoring’, 1, 1),
(‘personalization’, 1, 1),
(‘profile’, 1, 1);

iisnode encountered an error when processing the request

 

iisnode encountered an error when processing the request.

HRESULT: 0x2
HTTP status: 500
HTTP subStatus: 1002
HTTP reason: Internal Server Error

You are receiving this HTTP 200 response because system.webServer/iisnode/@devErrorsEnabled configuration setting is 'true'.

In addition to the log of stdout and stderr of the node.exe process, consider using debugging and ETW traces to further diagnose the problem.

The node.exe process has not written any information to stderr or iisnode was unable to capture this information. Frequent reason is that the iisnode module is unable to create a log file to capture stdout and stderr output from node.exe. Please check that the identity of the IIS application pool running the node.js application has read and write access permissions to the directory on the server where the node.js application is located. Alternatively you can disable logging by setting system.webServer/iisnode/@loggingEnabled element of web.config to 'false'.

 

Resolution

Add line app.listen(process.env.PORT); in app.js

 

fatal: no submodule mapping found in .gitmodules for path ”

if you accidently delete your submodule folder and there are enteries in your .git config files, you have to manually remove from

  • .git/modules/<submodule folder>

remove following entries

 

[submodule ".\\services\\projectWCFService"] 
url = https://github.com/jagsmcp/project1.git active = true

from

  • .git/config/
  • .gitmodules

if you still see the error, use

git reset

How to: Project, frameworks, common projects, libs – Part 1

If you have been asked to upgrade the project structure or taken over some tasks to revamp your git repository in more meaningful manner- definitely, there will challenges ahead and among them would be inter-dependency of projects on common library developed in-house or 3rd party, which has its own life-cycle – master, dev, hotfix, and release.

Setup your common library projects

  • Upload your projects to git repository as usual projects.
  • Upload your Main project to git repository as usual projects.

Linking / Sub-module

git submodule add https://github.com/jagsmcp/fileFactory

git commit -am 'added fileFactory module'

git push origin master

Cloning

git clone https://github.com/jagsmcp/MainProject
git submodule init
git submodule update

or use one simple command

git clone --recursive https://github.com/jagsmcp/MainProject

Resolve Git error: src refspec master does not match any

If you often come across this error it is likely you need to add additional step when you push existing source code to new repository.

Regular steps:

PS C:\work\projects\repos>git remote add origin <repo>

PS C:\work\projects\repos>git push -u origin master

if you see an error during git push, use following steps –

PS C:\work\projects\repos>git remote add origin <repo>

PS C:\work\projects\repos>git add -- all

PS C:\work\projects\repos>git commit -m "initial master"

PS C:\work\projects\repos>git push -u origin master

 

Create a free website or blog at WordPress.com.

Up ↑

%d bloggers like this: