How to reset lost SA password in SQL Express

Overview

If you ever find yourself in a situation where you need to reset the sa password on a SQL Express instance then you are not alone. I recently inherited a PC from a previous developer that already had SQL Express installed. This normally wouldn’t be a bad thing, except in this case it was not setup in mixed mode and my logged in account had no sysadmin rights on the instance.

In this article I hope to enlighten you as to how to reset the sa password in SQL Express without having any sort of administrator rights to the SQL instance.

You will need to be somewhat comfortable with editing the registry, starting and stopping windows services and working with a command prompt.

Steps to SQL Express sysadmin access

In order to gain sysadmin access to the SQL instance there were a few things that I needed to accomplish. Here is the basic goals I needed to achieve:

  • Change the login method from Windows Authentication to Mixed mode
  • Enable the sa user account
  • Reset the password to the sa user account

Doesn’t seem like that daunting of a list does it? I didn’t think so either.

Change the login method

In order to change the login method I had to change a registry setting. Why, you ask? Because, I say, we don’t have sysadmin rights so we can’t just change the database properties using SSMS.

  • Open the registry editor
  • Navigate to…
    HKEY_LOCAL_MACHINE
       \SOFTWARE
          \Microsoft
             \Microsoft SQL Server
                \MSSQL.10.SQLEXPRESS
                   \MSSQLServer
    
  • Change the value of LoginMode from 1 to 2
  • Close the registry editor

One thing to note is I had a few different options under the “Microsoft SQL Server” branch so you may need to take an educated guess if yours is different.

Enable the sa user account and reset its password

I lumped these two into one section because the commands for them are entered at the same place.

  1. Open the Services applet in the Control Panel
  2. Find the “SQL Server (SQLEXPRESS)” entry and open its properties
  3. Stop the service
  4. Enter “-m” into the “Start parameters” field
  5. Start the service
  6. Open a Command Prompt
  7. Enter the command:
    osql -S PC_NAME\SQLEXPRESS -E

    Be sure to change PC_NAME to whatever your PC name is or you will get a big long message saying you messed up.

  8. At the next prompts enter the following commands:
    1> alter login sa enable
    2> go
    1> sp_password NULL,'new_password','sa'
    2> go
    1> quit
  9. Stop the “SQL Server (SQLEXPRESS)” service
  10. Remove the “-m” from the Start parameters field
  11. Start the service

At this point you should be able to login to SSMS using the sa user account and the new password you gave it.

Piwik C# Tracking API

This is an extension of the unofficial C# implementation of the Piwik Tracking API. You find my code on GitHub.

Usage

Three Visual Studio Solutions are provided : 

How to contribute

The Piwik C# Tracking API is a translation of the official PHP Tracking API in C#.

Translating the project is currently a manual process.

Manually translating the project is tedious because it requires

  • identifying features that have already been translated
  • merging code

We would ideally like to automate this process, we welcome contributions aimed towards this goal.

To ease the process in the mean time, the following rules are applied to any new code contributions :

  • a commit in the PHP project implies a commit in the C# project with the same message and content
  • one-to-one tag mapping between the PHP and C# projects
  • the C# code should mirror as close as possible the PHP code

As long as we do not have an automated process, we welcome suggestions in improving the manual process.

Code style

To mirror as close as possible the PHP code, we copy-paste the PHP code in the C# class and alter it so it compiles.

This can lead in a loss of C# best practices. We consider the time savings an acceptable trade-off.

Publishing the project to NuGet

Requirements

  1. The process detailed in this section must be executed right before adding a release tag to git.
  2. Publishing the project to NuGet must be done by a member of the Piwik team, holder of the private NuGet Key.

Happy new 2016!

Amazon, Kindle e Liquavista: novità importanti, ma non per forza a colori

Amazon, Liquavista e un inedito ebook reader a colori, è una di quelle storie che di tanto in tanto vengono fuori in cerca di conferme. Sappiamo che Liquavista fa parte dell'azienda di Jeff Bezos dalla primavera 2013, da quando Samsung ne ha ceduto la proprietà dopo aver cercato di capire come sfruttare quella particolare tecnologia su tablet ed ebook reader. Da allora non è più successo nulla.

Ora Amazon pubblica il video "Meet the Liquavista Team" nel suo canale Youtube, e sostituisce il vecchio logo di liquavista.com con uno nuovo e moderno. E il tutto avviene a ridosso del periodo autunnale, del fine estate, storicamente il momento buono per la presentazione dei nuovi Kindle. Può essere un caso? Forse, ma tutta l'operazione ricorda le attività che si fanno per dare vita ad un marchio, per introdurlo e per crearci una storia. D'altro canto, perché Amazon avrebbe dovuto presentare ufficialmente l'acquisizione di Liquavista solo adesso, solo 2 anni dopo?

Liquavista non significa solo schermi a colori, ma anche pannelli in bianco e nero (sarebbe più corretto dire: scala di grigi) basati sulle stesse logiche di funzionamento ma con una riflettanza e un rapporto di contrasto davvero vicino alla carta stampata. Se un E-Ink Carta arriva al 44% di riflettanza e 15:1 di contrasto, un Liquavista fa 60% e 12:1. La carta stampata è su 70-80% e 12:1.

Kindle Textbook Creator è ora disponibile in italiano

Kindle Textbook Creator

Amazon ha rilasciato Kindle Textbook Creator, il proprio software dedicato alla creazione ed impaginazione di libri di testo e altri contenuti a scopo didattico ha ricevuto un importante aggiornamento che ha introdotto la localizzazione in numerosi paesi, tra i quali figura l’italiano, oltre a francese, tedesco, spagnolo, portoghese, brasiliano e olandese. 


Gli autori possono ora creare libri per l’apprendimento anche in lingua straniera, raggiungendo in questo modo studenti provenienti da ogni angolo del mondo. Quest’ultimi potranno usufruire dei sopracitati contenuti attraverso le applicazioni di lettura Kindle, disponibili gratuitamente per iPad, iPhone, dispositivi Android, oppure Mac e PC Windows.

La nuova versione di Kindle Textbook Creator è scaricabile a questo indirizzo.

Windows Live Writer For Windows 8.1

Windows Live Writer, developed by Microsoft, is a desktop blog-publishing application that is part of the Windows Live range of products. It features WYSIWYG authoring, photo-publishing and map-publishing functionality, and is currently compatible with Windows Live Spaces, SharePoint blogs, Blogger, LiveJournal, TypePad, WordPress, Telligent Community, PBlogs.gr, JournalHome, the MetaWeblog API, the Movable Type API, Blogengine, Squarespace, and all blogs that support Really Simple Discovery.

Windows Live Writer introduces the Provider Customization API that enables both rich customization of Windows Live Writer's behavior as well as the opportunity to add new functionality to the product. Currently Windows Live Spaces, WordPress, and TypePad have all taken advantage of this API to expose additional service-specific features within Windows Live Writer.

Windows Live Writer is currently available in 48 different languages.

wlsetup-web.rar (494.3KB)

How to Send Email Using Telnet

Sending emails with Telnet can be very easy if you know how to do it. In this article, you'll use SMTP mail Server to send email.

900px-Send-Email-Using-Telnet-Step-1-Version-2Open the cmd prompt. To open the command window, go to Start-> Run. Or press win key + R, type "cmd," and click OK.

 

 

 

900px-Send-Email-Using-Telnet-Step-2-Version-2Ping the server. Type "telnet mail.server.com 25" where "mail.server.com" is the name of the smtp server of your email provider (such as smtp-server.austin.rr.com) and 25 is the port number used by the SMTP service. (This number can be found by checking your account info in the program you normally use for email.) After you enter the above command you should receive a reply like "Trying xxx.xxx.xxx, Connected to mail.server.com".

900px-Send-Email-Using-Telnet-Step-3-Version-2Specify the domain you're using to send mail. To specify the domain, type in the below command:

  • HELO local.domain.com (use your fully qualified domain name here).
  • You should receive a reply like: "250 mail.server.com Hello local.domain.name pleased to meet you".

900px-Send-Email-Using-Telnet-Step-4Enter your email address. Enter a space after the colon (:), and enter your email address as follows:

  • MAIL FROM: yourname@domin.com
  • This should give you a message ending with "250 ...Sender OK".

900px-Send-Email-Using-Telnet-Step-5Enter the email address of the recipient. Type in the below command:

  • RCPT TO: friend@otherdomain.com
  • Note that you can enter more addresses if you intend to email more than one person.
  • You should see a message ending with "250 ...Recipient OK".

 

900px-Send-Email-Using-Telnet-Step-6-Version-2Compose your message. To start writing, type DATA and press Enter.

  • On the next line, type "SUBJECT: [your subject here]" and press Enter twice.
  • Continue typing your message.
  • To end your message, put a single period (.) on a line by itself, and press Enter.
  • You should see something saying "Message accepted for delivery."

 

900px-Send-Email-Using-Telnet-Step-7-Version-2Exit telnet. Type QUIT to exit.

Problems with partitions?


Partition Logic is a free hard disk partitioning and data management tool. It can create, delete, erase, format, defragment, resize, copy, and move partitions and modify their attributes. It can copy entire hard disks from one to another.

Partition Logic is free software, available under the terms of the GNU General Public License. It is based on the Visopsys operating system. It boots from a CD or floppy disk and runs as a standalone system, independent of your regular operating system.

Partition Logic is intended to become a free alternative to such commercial programs as Partition Magic, Drive Image, and Norton Ghost.

SYSTEM REQUIREMENTS

Partition Logic supports most basic PC hardware without any additional work or configuration.  It has very modest (by today’s standards) requirements:

  • Pentium-class or better x86 processor.  Supports all modern Intel x86 and AMD processors.
  • 32 megabytes RAM memory (16 megabytes if operating in text mode).
  • IDE (ATA) or SATA hard disks, or USB disks for partitioning.
  • IDE (ATAPI) or SATA CD-ROM drive, if booting from the CD version.
  • Standard PC floppy disk, if booting from the floppy disk version.
  • For graphics mode, a VESA 2-compatible graphics card with linear framebuffer support.
  • USB or PS/2-syle keyboard.
  • USB or PS/2-style mouse, if operating in graphics mode.

LIMITATIONS

Partition logic has the following limitations:

  • No hardware support for non-USB SCSI hard disks
  • No support for Sun or BSD disk labels.
  • Cannot format partitions as NTFS or EXT3.
  • Cannot resize FAT or EXT filesystems.

Download


partlogic-0.77-iso.zip (3,5MB)

CodeColorizer: Free Tool to Colorize Code in Html for Windows Live Writer

Windows-Live-Writer-Colorize-Code

      
  • Just copy the file in the zip file to the Windows Live Plugin folder, typically C:\Program Files\Windows Live\Writer\Plugins
  • Open Windows Live Writer
  • You can launch the plugin by using the Menu Insert->Colorized Code, or use the Insert Colorized Code... in the Insert list in the right hand side panel
  • Select the right language, and now you can write the code, paste it into the window.
  • When you are done just click OK. and the right HTML will be inserted in your blog

CarlosAg.WindowsLive.Writer.Plugins.zip (37.7KB)


Amazon presenta il nuovo Kindle Paperwhite 2015

Kindle Paperwhite Voyage

Amazon presenta ufficialmente il suo nuovo Kindle Paperwhite 2015, un concentrato di tecnologia per leggere nel modo migliore i propri ebook. La novità più importante del nuovo dispositivo è sicuramente rappresentata dalla risoluzione elevatissima di 300 ppi, che facilità la lettura rendendo estremamente più definiti i caratteri del testo, persino più di quelli tradizionali stampati su carta. In fatto di user experience, per rendere ancora più leggibile il testo, nel Kindle Paperwhite 2015 è stato introdotto il nuovo font Bookerly, realizzato su misura per il nuovo ebook reader. Come nel predecessore l’illuminazione integrata, permetterà di non affaticare la vista durante le ore notturne di lettura, regolandone l’intensità.

Il particolare schermo antiriflesso, permette di leggere il Kindle Paperwhite 2015 direttamente alla luce del sole, senza alcun riflesso, tipico invevce di altri dispositivi come tablet e smartphone; inoltre con la nuova batteria, la durata sarà molto più longeva, promettendo ricariche mensili. In sostanza grosse novità che promettono di migliorare l’esperienza di lettura con i più famosi lettori di ebook di casa Amazon. Per quanto riguarda il prezzo, si parte da 129,99 euro per la versione Wi-Fi con offerte pubblicitarie, tuttavia non visualizzate quando si legge un ebook, oppure per soli 10 euro in più sarà possibile avere la versione Wi-Fi senza offerte pubblicitarie. Se invece puntate ad avere un dispositivo sempre connesso e gratuitamente, è possibile prenotare il Kindle Paperwhite 2015 con 3G gratuito con Wi-Fi con offerte speciali a 189,99 euro e senza a 199,99 euro.

La connessione 3G gratuita permetterà di accedere al Kindle Cloud per scaricare i libri direttamente da Amazon, senza alcun costo relativo alla chiamata: con il rivoluzionario 3G gratuito non ci sono SIM, ricariche o abbonamenti telefonici, ma è tutto spesato da Amazon, che paga la connettività cosiddetta Wireless 3G a tutto vantaggio del cliente. Attualmente il sito italiano di Amazon, permette di prenotare in prevendita il proprio dispositivo, mentre le consegne inizieranno a partire dal prossimo 30 giugno. Kindle Paperwhite 2015: un’occasione da non perdere per tutti gli amanti degli ebook.

Advertsing

125X125_06

Planet Xamarin

Planet Xamarin




TagCloud

MonthList