Align SQL Login to User

How to re-align a SQL Login to a Database User

In SQL Server there are two distinct security level when it comes to individual users... one at the server level, the other at the database level.

If a database is restored from a different location, then despite the there being a server login and database user with the exact same name, they are different objects and do not therefore align with each other.

Instead of removing either and re-implementing, simply use the following...

ALTER USER OrphanUser WITH LOGIN = correctedLoginName;

SQL XML Ordering

Ordering XML nodes by position in SQL

Passing XML into SQL provides a quick and powerful way of passing complex data into a SQL Server stored procedure.

Unfortunately when inserting new data, you cannot guarantee that it will insert in the actual order of the elements in the XML.

A solution to this is to use ORDER BY ROW_NUMBER...

DECLARE @XML XML = '<data><id>3</id><id>1</id><id>2</id></data>'
INSERT INTO MyTable (ID)
SELECT X.value('text()[1]', 'int')
FROM @XML.nodes('/data/id') AS X(X)
ORDER BY ROW_NUMBER() OVER (ORDER BY X.X)

Chrome Self-Signed SSL HSTS

Ignoring unsecure-site blocking on Chrome with self-signed SSL and HSTS

When viewing a development site that is using a self-signed certificate, it's normally possible to ignore the security message by "continuing" onto the site.

However, sometimes (and I don't know why) sites will give the message but not the ability to continue.

It turns out that Chrome has an easter egg that allow you to quickly and easily ignore the message.

Simply type thisisunsafe into the page (it will not appear on screen while typing) and hey-presto.