keeping track of the disk space on your computer ?

After a little bit of research, I’ve found a tiny yet powerful tool:

SpaceMonger

Nowdays this tool is commercial, but you can download the last free version (1.40) on their website.

 

SSAS 2008 – Remote Server Access (Insecure, Irresponsable way) – Just for Tests

If you aren’t member of a domain, then you can’t access a remote SSAS server, since the only authentication method available for it, is Win method.

However, I recently found a way, to bypass this security measure. I must say is for sure the worst solution in terms of security, but if you need to make a few tests inside your LAN, then maybe there wouldn’t harm your server.

So, the trick is dumb and simple, disable the authentication on your SSAS server (yes I know what you must be thinking, oh my god, that sucks!). But a least I had told you that before .

How you can disable the authentication ?. Simply, Open your SSMS , right click on the server -> Properties ->change the value of Security\RequireClient Authentication to false.

That’s it, but remember to turn this setting to true  after testing the remote server, otherwise the server’s security will be compromised.

 

Linksys WRT54G Hard-Reset Recovery

I have to say, the TFTP saved my day .

In case your linksys router seems to be a brick, you have to calm down and try this few steps, they have worked for me.

1. Connect your machine with the router using a ethernet cable (Disconnect the router from the internet);

2. Edit your connections settings in order to have an IP address like 192.168.1.2 (e.g) and the gateway 192.168.1.1;

3. Now, your router is pingable;

4. You need to activate your TFTP client (go to control panel, add/remove features) and activate this feature;

5. Now, you need to transfer the firmware from your PC to the router, how ?, just with one command!

tftp -i 192.168.1.1 PUT code.bin code.bin

where ‘code.bin’ is the TFTP version of the firmware, go to the DDWRT website (e.g) and download it.

6. After a minute (more or less) your power button stops flashing, and that’s it.

Your router is no longer a brick, and in fact it’s alive!!

 

Object Relational Mapping (ORM)

Something to be remembered:

Tool to generate the classes from a database automatically

Microsoft Entity Framework – Microsoft Best Practice

 

Avoid IIS redirecting to localhost (DotNetNuke)

If you are working with DNN on your localhost Machine, and want to see your site in another machine. You must add a new alias, in fact DNN just have localhost by default.

So, don’t forget to add the new alias, when you are planning to move your DNN site, somewhere else.

See the picture bellow:

 

Reset sa principal, after install SQL 05 Express

Personal Note, after install VS 2008 and the  SQL Server 05 Express that it’s embedded to it. My sa account was unavailable, so was impossible connect to my SQL Instance using SQL Server sa principal.

Solution ?

1. Log on as Win Authenticated user

2. Open the ‘master’ DB and type:

sp_password @old = null, @new = ‘lisber’,  @loginame =’sa’

go

ALTER LOGIN sa WITH PASSWORD = ‘lisber’ UNLOCK

ALTER LOGIN sa ENABLE
That should be enough

PD:

1) Some users have been writing that ‘For unlocking SA, you just have to connect as a machine administrator to the server, as you observed. The machine administrators are by default granted access to SQL Server’

2)I know that using the ‘sa’ is not recommendable, we must create users with the minimum permissions in order to perform their actions, so avoiding using the ‘sa’ principal. We must never forget that.

 

MCTS Certified :)

I’m very happy because yesterday i get the MCTS certification (Microsoft Certified Technology Specialist).

I made the 70-431 Test in order to get the ‘Microsoft Certified Technology Specialist – SQL Server 2005′ , to get the MCTS you need to achive a minimum of 70% in your final score!.

What’s next ? BI Certification !! that’s the next target

 

Windows Live Writer Test

It seams a very good app

 

Windows Seven – First Impressions

Well Microsoft does it again!. After Vista big mistake, Seven seems to be the next step from xp.

After using Seven for several hours i found it, easy to use. Visually appealing, but is not a miracle and it won’t change the OS world.

Microsoft put so much effort on the Vista performance issue, the boot loading time is faster than vista, the programs seems to be loading rapidly. I’m Seven comes with plenty of drivers, it was not necessary to find any driver there was all built in. Awesome!

Things i noticed:

• The preview on movies (yeah Mac OS have this feature for long time ….)
• The Stack (Well it’s called this way on OS 10.5)
• Paint is  improved
• The power Button finally is a ‘Shut down Button’ from default (One of the major mistakes on Win Vista User Interaction)

So they take Vista clean the mess and comes with a new fresh OS.

winseven

 

Avoid Cursors

Yes avoid them, hide from them each time someones tells you to use them. Why ?

Performance!!!!

These tinny row by row misters, can make your SS claim for more RAM or put your processor in a nonsense processing.

Instead of them i prefer temp Tables, yeah there is some drawbacks, like locks supports that are part of cursors (Dynamic and Keyset).

So when i need to use a row by row analysis to a rowSet i use temp tables and the Select INTO statement, so there is no need to create Table statement aside of the query, just put it all together and run. For example:

SELECT AlunoID

INTO #MyTempTable

FROM Aluno

WHERE Gender = ‘F’

Remember that when the connection holding this query is closed the MyTempTable will disappear, also remember that all temp Tables are created within the tempDB.

To avoid some dirty reads, it’s better to use some lock mechanism. (to be totally sure, use the serializable lock). It never fails…..