Web development and technologies

Disable overwrite in Sublime Text

By Paul on June 20, 2016Leave a Reply

If you have ever experienced Sublime Text overwriting your text when typing, and not knowing how to disable it other than re-opening your document, you know how frustrating it can be. I’ll show you how to toggle overwrite on/off and how to disable it completely if you never use it.

How to toggle overwrite on/off in Sublime Text

These are the default overwrite key bindings in Sublime Text:

Windows

simply press the [insert] key on your keyboard

Mac

cmd+alt+o

How to disable overwrite in Sublime Text

Overwrite can be handy in some circumstances, but if you never use it as me, it might just be easier to disable the key binding completely.

Sublime Text stores its key bindings in json format in a file which can’t be modified from within Sublime. Instead we will copy the “toggle_overwrite” key binding and paste it into our user key bindings file, which will overwrite the key binding specified in the default key bindings file.

Open up Sublime and go to the menu:

Sublime Text > Preferences > Key Bindings – Default

Search for “overwrite” and copy the line below:

[javascript]
{ "keys": ["super+alt+o"], "command": "toggle_overwrite" },
[/javascript]

Go to the menu again:

Sublime Text > Preferences > Key Bindings – User

Paste in the “toggle_overwrite” line you just copied from default key bindings file and change the command to “unbound”. This will unbind the overwrite key binding.

Your “Key Bindings – User” file will now look like this:

[javascript]
[
//Disable overwrite
{ "keys": ["super+alt+o"], "command": "unbound" }
]
[/javascript]

Save the file, and you’ll never be bothered again by Sublime overwriting your text.

If you on the other hand prefer to keep “toggle_overwrite” but change its key binding, simply change the key combination in “keys” and keep the command as per default.

Umbraco Codegarden 2016

By Paul on June 15, 2016Leave a Reply

This years annual Umbraco festival – Umbraco Codegarden 2016 is running from the 15th to the 17th of June and is being held at the Umbraco HQ in Odense.

It’s 3 full days where the Umbraco community gather for cool sessions from the core team and community experts, workshops, dinner, beers and networking.

If you were not able to attend this year, you can watch the live streams, as this years event is being broadcast live.

Umbraco Codegarden 2016 live streams:

Entrance room
Main room
Back room

Read more about Codegarden 2016, or check out the schedule.

ASP.NET Core and .NET Core Overview

By Paul on June 9, 2016Leave a Reply

Microsoft’s big shift

A lot is happening in Microsoft land and the future looks very exciting as a .NET developer with the introduction of .NET Core and ASP.NET Core, making it possible to run .NET on any platform.

Times are changing, also within Microsoft. They created the .NET foundation and open sourced a lot of projects. For instance .NET is now open source and developed on Github, making it possible for everyone to contribute.

Red Hat has partnered up with Microsoft and joined the .NET foundation alongside with JetBrains and Unity. Microsoft partnered with Canonical – the company behind Ubuntu, making it possible to run Ubuntu on Windows.

Not long ago Microsoft acquired Xamarin, open sourced its SDK under the MIT license and made it a part of the .NET foundation. With Xamarin along came Mono. Microsoft changed the license of Mono from GPGL to MIT and put it in the .NET foundation as well.

SQL Server will be released for Linux and is scheduled for 2017.

ASP.NET 5 is killed and renamed to ASP.NET Core 1, because as the name indicates, it’s a totally new framework. With .NET Core and ASP.NET Core Microsoft takes a huge step in becomming platform independent, as both run on Windows, Linux and Mac. ASP.NET 4.6 will continue to be developed and supported, and new features are yet to be added. ASP.NET Core is still fresh from the oven, and lacks several of the features from ASP.NET 4.6, but we will most likely see it mature and be up to speed in version 1.3 or 1.4. Microsoft have been a bit vague about the future for ASP.NET 4.6 and onwards, but it looks like it’s slowly getting phased out. My idea is that the development of ASP.NET will stop when ASP.NET Core is fully matured.

The future of .NET

Let’s take a glance at the .NET family to get a better understanding of what the future holds and how the different frameworks will be structured. On the top layer in the diagram below we have the app models; .NET Framework, .NET Core and Xamarin, which all share the same base class library (BCL) called .NET Standard Library. Instead of adding new features to either of the 3 stacks, they will be added in the .NET Standard Library and shared across.

.NET Framework is meant for Windows Presentation Foundation (WPF) apps, Windows Forms and ASP.NET, where as .NET Core is meant for Universal Windows Platform (UWP) and ASP.NET Core applications.

On microsoft.com/net things are clarified further. Basically the .NET Framework is meant for Windows development. That being native, mobile and web applications running in the Windows ecosystem.

.NET Core on the other hand is meant for cross-platform applications, which can run on either Windows, Linux or Mac.

.NET Overview | Build 2016

In the following video from Build 2016 Scott Hunter and Scott Hanselman gives an overview of the future for .NET. In the end of the video Todd Mancini from Red Hat demonstrates how to deploy a ASP.NET/Core application to Red Hat Enterprise Linux, running in a Docker container.

Go checkout redhatloves.net (how cool is that!?) and signup for the Red Hat developer program and download Red Hat Enterprise Linux for free, and play around with it yourself.

ASP.NET Core

ASP.NET Core 1 can run on both .NET Framework 4.6 and .NET Core 1.0, whereas ASP.NET 4.6 is meant to only run on .NET Framework 4.6.

ASP.NET Core even though not yet fully matured, holds a lof of exciting features. First and foremost it allows us to run our applications on Linux and Mac. It’s modular, which means that it’s stripped for most frameworks and libraries we might not even need in our application. For instance you have to include error pages yourself, which also opens up for customization so we can have company specific error pages. You can choose if you want to include MVC or Nancy, should you prefer the latter.

ASP.Net Core is fast! According to Microsoft you’ll see a 10x speed increasement, moving your current MVC application to ASP.Net Core.

ASP.NET/Core Overview | Build 2016

The two Scotts are at it again in this next video from Build 2016, where they show some really cool features of ASP.NET Core. For instance the best demo in the entire world – must watch!

Now, go code…

We are moving towards a more platform independent future, and it has never been more exciting to be a .NET developer as it is today. The cool thing I’m stoked about and think a lot of fellow developers are as well, is that we can now develop .NET applications directly from OS X, without having to open up Parallels. We are not fully there yet though, with frameworks and libraries still missing, but it’s a start. Head over to microsoft.com/net to get going!

Mobile website speed test tools

By Paul on June 4, 2016Leave a Reply

In a world that is fastly evolving from mobile first to mobile only, you are out of the game if your website is not accessible on a smartphone. That meaning, build with “mobile first” in mind. Your site needs to scale to the devices your visitors are using. People browsing the web from mobile devices are typically connected to the internet through 3G, 4G/LTE and in many cases even slower connections, which makes the speed of your website crucial. The majority of people tend to leave a site if it takes more than 4-5 seconds to load the page. As you may know, Google takes speed into consideration when ranking website, which is another important reason to speed up your site.

Google recently launched a new tool to check your site’s mobile friendliness and speed, which will tell you which areas you need to work on.
Go check it out: Google Mobile Website Speed Testing Tool

They are promising to send you a report within 24 hours, which I still haven’t received, even though I’ve past the 24 hours. It’s work in progress I guess.

You can still use the good old Google PageSpeed too, which shows you your results instantly. Funny enough the scores from their two services don’t exactly match, but that’s a minor detail.

Use these mobile website speed test tools and be ready for mobile only.

Change domain name WordPress, the SEO friendly way

By Paul on June 4, 2016Leave a Reply

How to change domain name of your WordPress site the SEO friendly way, without losing PR and link juice

I recently changed domain for this blog from egeek.dk to egeek.io. There are two parts of changing your domain or moving your site to a new host and domain – the technical part, and the SEO part where you try to preserve your search engine rankings. Doing it the right way will save you a lot less trouble in the future, and make you keep most of your hard earned SEO work. On the other hand, doing it wrong can have fatal consequences on your rankings in the search engines.

I’ll narrow it down and describe how I did it, and how you should do it too.

In my case I wanted to change domain from egeek.dk to egeek.io on a running WordPress site. I was not switching host/server, but just wanted to “rebrand” my site with a new domain. Whether you are in the same situation and want to rebrand your site, or want to switch host and domain, you can use these steps as a guideline.

I’m currently running this blog on IIS in a Windows Server environment, but the fundamentals are the same, and the following steps can be incorporated, should you run your site/blog on Apache, Nginx or on a LiteSpeed server in a *nix environment.

Disclaimer

Before starting out, I want to stress that changing your domain from olddomain.com to newdomain.com will affect your search engine rankings in the beginning. After you do a switch Google will index both of your sites, where after olddomain.com will slowly dissapear from the search results. I’ve had pages indexed with meta titles and descriptions chosen by Google, instead of the meta-data I chose for the pages (yeah, Google can do that). After the switch these pages are currently indexed with my new domain, and yet again Google has chosen meta titles and descriptions, though different (and much worse) than before. I had top 1 placements in Google with feature images and snippets, which are now gone after I changed domain. It’s a part of the process, but I’m positive the rankings and feature snippets will come back up, when everything is rolled out completely. It’s inevitable for things like these not to happen, as Google needs to reindex your whole site again. Don’t put too much concern into this though, as things will smooth out, and if you play it right, you’ll be back up where you were before. That’s what this guide is about.

Table of content

1. Domain name

2. Site and bindings

3. Change WordPress address

4. 301 redirects

5. Rename SQL database

6. Add properties in Google Search Console

7. Change address in Google Search Console

8. Submit sitemaps in Google Search Console

9. Update Google Analytics account and tracking code

10. Fetch site and submit to index

11. The afterwork

No data is available for the 2 most recent days

By Paul on May 31, 2016Leave a Reply

If you ever stumbled upon the info message “No data is available for the 2 most recent days” in Google Analytics when browsing the “Search Engine Optimization” section and wondered why this message appears, there’s a good explanation for that.

You will get this message after connecting your Google Analytics account to your website in Google Search Console (former Google Webmaster Tools).
The Search Engine Optimisation graphs in Google Analytics pulls data from Google Search Console, and this data is often several days delayed. People report it can be delayed by more than 2 days as originally stated.

Right after linking your accounts you won’t be able to see data until Google fetches initial data from Google Search Console – give it some days. After that, the message stays, and just tells you that Google Analytics is 2 days behind fetching data from Google Search Console. Don’t worry, it’s perfectly normal, and Google Analytics will eventually catch up.

It might be a good idea to re-check you linked the correct accounts though.
Log in to Google Search Console > click on your website > on the wheel in the top right corner click and chose “Google Analytics Property”, and you’ll see the Google Analytics account linked to your website.

Install Node.js on Windows

By Paul on May 28, 2016Leave a Reply

Node.js is a lightweight yet extremely powerful open source, cross-platform runtime environment for hosting and running JavaScript applications. Its popularity continues rising alongside with the popularity of JavaScript. The way we are able to develop web applications today has changed drastically from only a “few years” back where JavaScript could only be run in the browser. Today we are able to build big and complex applications in JavaScript and host them in Node.js, where in the past these types of applications had to be written in languages like Java, PHP, ASP, etc.

It’s very easy and fast to get going with Node.js which I’ll demonstrate.

1. First off download the 64bit Node.js msi-installer

2. Follow the installation and install Node.js to the default location (C:\Program Files\nodejs)
Make sure npm package manager is installed as well, as you will need this later on.
Also let Node.js be added to PATH (default), so you can access it from anywhere.

That’s it!
Open up Command Prompt and try the following:

node -v

Node will tell you which version it’s running:

As you can see, I’m running v.4.4.5 of Node.js

Go ahead and try the following as well

npm -v

It displays I’m running npm package manager v.2.15.5

We are now confident that both Node.js and npm are working and we can build our first application.

1. Create the directory C:\Node
2. Create the file “hello.js” in C:\Node with the following content:

[javascript]console.log("Hello World!");[/javascript]

3. In Command Prompt go to C:\Node and run;

node hello.js

It’s pretty basic, but we build and ran our first JavaScript application in Node.js.
Now let’s try to expand and host a web application.

1. Create the file C:\Node\server.js and paste the following;

[javascript]
//Include the http module
var http = require(‘http’);

//Create a webserver
http.createServer(function (req, res) {

//Respond to any incoming http request
res.writeHead(200, {‘Content-Type’: ‘text/plain’});
res.end(‘Hello World!\n’);

}).listen(1337, ‘127.0.0.1’);

//Log that we started listening on localhost:1337
console.log(‘Server running at 127.0.0.1:1337’);
[/javascript]

2. Standing in C:\Node in Command Prompt start your web application;

node server.js

3. Go to http://localhost:1337/ in your browser (from the same machine running Node.js of course)

We’ve now created a JavaScript application and hosted it through http with Node.js.
It’s still pretty basic, but the possibilities are endless. For example Ghost – a blogging platform like WordPress, and actually created by one of the former WordPress developers, is a Node.js application.

Reset MySQL root password on Windows

By Paul on May 13, 20162 Replies

If you have forgotten the root password for MySQL on Windows, it’s fairly easy to reset it back to a preferred password.

There are several ways of doing so. I tried the different options stated in the documentation, but ended up with the following warning

[Warning] TIMESTAMP with implicit DEFAULT value is deprecated.
Please use –explicit_default_timestamp server option
(see documentation for more details)

The solution to reset the root password for MySQL on Windows I came up with is as follows

1. Create “mysql-init.sql” on C:\
Depending on your MySQL version, paste one of the following sql statements in “mysql-init.sql” and save the file.

MySQL 5.7.6 and later

[sql]ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘MyNewPass’;[/sql]

MySQL 5.7.5 and earlier

[sql]SET PASSWORD FOR ‘root’@’localhost’ = PASSWORD(‘MyNewPass’);[/sql]

2. Open up my.ini, typically located in C:\ProgramData\MySQL\MySQL Server x.x\

Locate the [mysqld] section and add the following line

[shell]init-file=C:\\mysql-init.sql[/shell]

3. Restart MySQL using the console

net stop mysql
net start mysql

4. Check that your password has changed by running

mysql -u root -p

If your password has changed successfully, delete the file C:\mysql-init.sql so you don’t expose your password. Furthermore, remove the “init-file” line in my.ini

Same method works on Unix/Linux systems, but if you are looking for a more OS specific guide, take a look at the documentation.

Visual Studio 2013 high CPU usage

By Paul on January 30, 20151 Reply

If you experience extreme typing latency and Visual Studio is using high amount of CPU, even when idling, check if you have “Browser Link” enabled. I started experiencing latency when typing, after working just 5 minutes in Razor Views. CPU usage was consistent at 37-40%. Browser Link is a new feature in Visual Studio 2013 and enables dynamic data exchange between Visual Studio and your web application.

If you are interested in knowing exactly how Browser Links works, you can read more here.

Or if you just want to disable it straight away, do as shown in the picture.

Sitecore: Reset Sitecore admin password

By Paul on November 5, 2014Leave a Reply

If you forgot the admin password for Sitecore, you can reset it to default (admin/b), by running this SQL script against the core database

[sql]
/*******************************************************************
* PURPOSE: Resets the Sitecore admin password to ‘b’
* DATE AUTHOR
*——————————————————————-
* 04-04-14 Nehemiah J
*******************************************************************/

/* Change the Sitecore DB Name */
USE [SITECORE_CORE_DB]
GO

DELETE FROM [aspnet_Membership] WHERE UserId = N’b09bbcde-9b3c-4dcd-b69e-67f615ce01e9′
GO
DELETE FROM [aspnet_Profile] WHERE UserId = N’b09bbcde-9b3c-4dcd-b69e-67f615ce01e9′
GO
DELETE FROM [aspnet_Users] WHERE UserId = N’b09bbcde-9b3c-4dcd-b69e-67f615ce01e9′
GO

INSERT [dbo].[aspnet_Membership] ([ApplicationId], [UserId], [Password], [PasswordFormat], [PasswordSalt], [MobilePIN], [Email], [LoweredEmail], [PasswordQuestion], [PasswordAnswer], [IsApproved], [IsLockedOut], [CreateDate], [LastLoginDate], [LastPasswordChangedDate], [LastLockoutDate], [FailedPasswordAttemptCount], [FailedPasswordAttemptWindowStart], [FailedPasswordAnswerAttemptCount], [FailedPasswordAnswerAttemptWindowStart], [Comment]) VALUES (N’e0656bf5-52dd-4d6b-a85a-733561eabf65′, N’b09bbcde-9b3c-4dcd-b69e-67f615ce01e9′, N’qOvF8m8F2IcWMvfOBjJYHmfLABc=’, 1, N’OM5gu45RQuJ76itRvkSPFw==’, NULL, N”, N”, NULL, NULL, 1, 0, CAST(0x00009C7E00B986EC AS DateTime), CAST(0x0000A30001519E04 AS DateTime), CAST(0x00009C7E00B986EC AS DateTime), CAST(0xFFFF2FB300000000 AS DateTime), 0, CAST(0xFFFF2FB300000000 AS DateTime), 0, CAST(0xFFFF2FB300000000 AS DateTime), N’Sitecore Administrator’)
GO
INSERT [dbo].[aspnet_Profile] ([UserId], [PropertyNames], [PropertyValuesString], [PropertyValuesBinary], [LastUpdatedDate]) VALUES (N’b09bbcde-9b3c-4dcd-b69e-67f615ce01e9′, N’IsAdministrator:S:0:4:Portrait:S:4:27:FullName:S:31:13:ProfileItemId:S:44:38:SerializedData:B:0:3875:’, N’TruePeople/16×16/Astrologer.pngAdministrator{AE4C4969-5B7E-4B4E-9042-B2D8701CE214}’, 0x0001000000FFFFFFFF01000000000000000401000000E20153797374656D2E436F6C6C656374696F6E732E47656E657269632E44696374696F6E61727960325B5B53797374656D2E537472696E672C206D73636F726C69622C2056657273696F6E3D342E302E302E302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D623737613563353631393334653038395D2C5B53797374656D2E537472696E672C206D73636F726C69622C2056657273696F6E3D342E302E302E302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D623737613563353631393334653038395D5D040000000756657273696F6E08436F6D7061726572084861736853697A650D4B657956616C756550616972730003000308920153797374656D2E436F6C6C656374696F6E732E47656E657269632E47656E65726963457175616C697479436F6D706172657260315B5B53797374656D2E537472696E672C206D73636F726C69622C2056657273696F6E3D342E302E302E302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D623737613563353631393334653038395D5D08E60153797374656D2E436F6C6C656374696F6E732E47656E657269632E4B657956616C75655061697260325B5B53797374656D2E537472696E672C206D73636F726C69622C2056657273696F6E3D342E302E302E302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D623737613563353631393334653038395D2C5B53797374656D2E537472696E672C206D73636F726C69622C2056657273696F6E3D342E302E302E302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D623737613563353631393334653038395D5D5B5DCE00000009020000002500000009030000000402000000920153797374656D2E436F6C6C656374696F6E732E47656E657269632E47656E65726963457175616C697479436F6D706172657260315B5B53797374656D2E537472696E672C206D73636F726C69622C2056657273696F6E3D342E302E302E302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D623737613563353631393334653038395D5D00000000070300000000010000001500000003E40153797374656D2E436F6C6C656374696F6E732E47656E657269632E4B657956616C75655061697260325B5B53797374656D2E537472696E672C206D73636F726C69622C2056657273696F6E3D342E302E302E302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D623737613563353631393334653038395D2C5B53797374656D2E537472696E672C206D73636F726C69622C2056657273696F6E3D342E302E302E302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D623737613563353631393334653038395D5D04FCFFFFFFE40153797374656D2E436F6C6C656374696F6E732E47656E657269632E4B657956616C75655061697260325B5B53797374656D2E537472696E672C206D73636F726C69622C2056657273696F6E3D342E302E302E302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D623737613563353631393334653038395D2C5B53797374656D2E537472696E672C206D73636F726C69622C2056657273696F6E3D342E302E302E302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D623737613563353631393334653038395D5D02000000036B65790576616C7565010106050000000957616C6C70617065720606000000312F73697465636F72652F7368656C6C2F7468656D65732F6261636B67726F756E64732F6C69676874686F7573652E6A706701F9FFFFFFFCFFFFFF06080000001357616C6C70617065724261636B67726F756E640609000000072330373333374301F6FFFFFFFCFFFFFF060B0000001157616C6C7061706572506F736974696F6E060C0000000643656E74657201F3FFFFFFFCFFFFFF060E0000001464696765737463726564656E7469616C68617368060F00000020373130373464333335653834393632396562616532383434656165333436306101F0FFFFFFFCFFFFFF06110000002164696765737463726564656E7469616C68617368776974686F7574646F6D61696E061200000020313961323764323333663534633962303930303764303533326634666464343301EDFFFFFFFCFFFFFF06140000001F2F73697465636F72655C61646D696E2F526962626F6E2F4D792053747269700615000000267B44333341303634312D394631432D343938342D383334322D3036353543334430463132337D01EAFFFFFFFCFFFFFF06170000000D5061636B616765722F46696C6506180000002F536D61727420546F6F6C7320204164642056657273696F6E20616E6420436F707920436F6E74656E7431302E7A697001E7FFFFFFFCFFFFFF061A000000372F73697465636F72655C61646D696E2F557365724F7074696F6E732E436F6E74656E74456469746F722E56697369626C65537472697073061B000000AC037B43334643454242392D463338462D344142342D383537462D4346433431354236413334327D7C7B44304643393944392D354336352D343341332D414342362D3434393544343446423045377D7C7B39324144453739322D363833462D343830442D413330412D3031433146314241414235337D7C7B46353142433531412D463541462D343144462D414431312D4630443142343846464339337D7C7B36353533363336462D453930342D344632442D423232322D3039304430413236323938437D7C7B34434636343731362D384238432D344142432D383643322D4639433546334646313132387D7C7B44363030433133392D393244372D343844452D424239462D3438313241334442394138427D7C7B34383936374331392D433338372D343534442D384544322D3536324446313430394430387D7C7B41454439354537452D383734412D344346302D393234422D3844443930464338443733307D7C7B33333645393943382D433435462D344342372D393133362D4339463846453830324538467D7C7B42423246424235352D454243382D343732342D394131462D3337424346454430333730447D01E4FFFFFFFCFFFFFF061D000000312F73697465636F72655C61646D696E2F436F6E74656E7420456469746F722F53656374696F6E732F436F6C6C6170736564061E0000000B517569636B496E666F3D3001E1FFFFFFFCFFFFFF0620000000232F73697465636F72655C61646D696E2F4D656469612F55706C6F616465644974656D730621000000E0043230313430323039543231303432342373697465636F72653A2F2F6D61737465722F7B44363441363142352D463836332D343634432D423534352D3045434639423637373141437D3F6C616E673D64652D4445267665723D317C73697465636F72653A2F2F6D61737465722F7B35413631433446392D363730322D343143352D424245422D3131393439453243453345467D3F6C616E673D64652D4445267665723D317C73697465636F72653A2F2F6D61737465722F7B31413033373138442D364338462D343732322D424332352D3635464539424245353839367D3F6C616E673D64652D4445267665723D317C73697465636F72653A2F2F6D61737465722F7B39464445464539452D343742332D343532392D394333332D3431394230333239314430467D3F6C616E673D64652D4445267665723D317C73697465636F72653A2F2F6D61737465722F7B38374530313239352D363545342D343943372D383939442D3544304441433744434534387D3F6C616E673D64652D4445267665723D317C73697465636F72653A2F2F6D61737465722F7B34393134424644442D303830392D344635302D413235332D3545423030353232454544337D3F6C616E673D64652D4445267665723D317C73697465636F72653A2F2F6D61737465722F7B42373138433944302D383636332D343746342D424635392D3245434443354633353038317D3F6C616E673D64652D4445267665723D317C73697465636F72653A2F2F6D61737465722F7B42443643364230462D304333382D344433432D393131322D3141444535443537434536347D3F6C616E673D64652D4445267665723D317C01DEFFFFFFFCFFFFFF0623000000212F73697465636F72655C61646D696E2F5075626C6973682F4C616E677561676573062400000002656E01DBFFFFFFFCFFFFFF06260000001F2F73697465636F72655C61646D696E2F5075626C6973682F546172676574730627000000267B38453038303632362D444443332D344546342D413144312D4630424534413230303235347D01D8FFFFFFFCFFFFFF06290000002A2F73697465636F72655C61646D696E2F5075626C6973682F496E6372656D656E74616C5075626C697368062A0000000566616C736501D5FFFFFFFCFFFFFF062C000000242F73697465636F72655C61646D696E2F5075626C6973682F536D6172745075626C697368092A00000001D2FFFFFFFCFFFFFF062F000000212F73697465636F72655C61646D696E2F5075626C6973682F52657075626C6973680630000000047472756501CFFFFFFFFCFFFFFF0632000000272F73697465636F72655C61646D696E2F5075626C6973682F5075626C6973684368696C6472656E093000000001CCFFFFFFFCFFFFFF0635000000282F73697465636F72655C61646D696E2F436F6E74656E7420456469746F722F4C616E67756167657306360000000B65742D45457C656E2D474201C9FFFFFFFCFFFFFF0638000000222F73697465636F72655C61646D696E2F4C69737476696577732F4974656D4C69737406390000000744657461696C7301C6FFFFFFFCFFFFFF063B0000001F2F73697465636F72655C61646D696E732F526563656E74557365724C697374063C0000001173697465636F72655C546573745573657201C3FFFFFFFCFFFFFF063E000000292F73697465636F72655C61646D696E2F486973746F72792F4164642E46726F6D2E54656D706C617465063F000000267B42463242384441322D334342412D343835442D384638352D3337383842384146424442467D01C0FFFFFFFCFFFFFF0641000000202F73697465636F72655C61646D696E2F486973746F72792F54656D706C6174650642000000267B42463242384441322D334342412D343835442D384638352D3337383842384146424442467D0B, CAST(0x0000A2F500D2B376 AS DateTime))
GO
INSERT [dbo].[aspnet_Users] ([ApplicationId], [UserId], [UserName], [LoweredUserName], [MobileAlias], [IsAnonymous], [LastActivityDate]) VALUES (N’e0656bf5-52dd-4d6b-a85a-733561eabf65′, N’b09bbcde-9b3c-4dcd-b69e-67f615ce01e9′, N’sitecore\Admin’, N’sitecore\admin’, NULL, 0, CAST(0x0000A3000151A230 AS DateTime))
GO
[/sql]