I got tagged by Denny Cherry (@mrdenny on twitter) to create an image of the most used words on our blog. As you can see SQL rules here, I wonder why???? So how did I create this image? I used Wordle, Wordle is a toy for generating “word clouds” from text that you provide. The clouds give greater prominence to words that appear more frequently in the source text. You can tweak your clouds with different fonts, layouts, and color schemes

Here we are with another super fascinating episode of the SQL Friday, The Best SQL Server Links Of The Past Week show Here is what I found interesting this past week in SQL Land: WMI Provider Error: Access is denied. [0x80070005] from SQL Server Computer Manager Explanation of the following: When you attempt to change the Login Account for the SQL services [SQL Server, SQL Agent, Full Text, Analysis Services] from the SQL Server Computer Manager tool, you may encounter the following error message:

Not too many moons ago when I started out with SQL Server I was convinced that there was a memory leak inside SQL Server. I ran it locally and the RAM usage just keep growing and growing until my computer was so slow that I had to restart SQL Server. This fixed things for a while but after I ran some poorly written queries it would spike up again and stay high.

I have a budget to buy a new developer machine at work. And this is it for the moment. I have no need for keyboard or software. Just some new fast hardware. I can keep the old one for testing. Quantity Product Price Subtotal 1 Western Digital VelociRaptor WD1500HLFS 150GB – 4,7ms/16MB/10000RPM – S-ATA – harddisk – Backplane Ready   € 182.

I’m setting only one goal this year and that is to start pursuing a career in teaching. My ultimate goal is to teach primarily on systems design and development. Nothing too tough 😉

Today I had to change the schema of a stored procedure. I couldn’t find a clicky click method to do this in SQL server management studio (which kinda worries me). So I looked on google for a method and found this. But not being an SQLguru I took a few seconds to sink in. So the syntax is. ALTER SCHEMA nameoftheschematotransferto TRANSFER nameandschemaoftheSP For example: We have an SP called username.

Today, Jimmy Bogard made a post over at LosTechies.com about DDD and it not being about patterns but all about the Domain and how you model it. Since his words are better then mine, I would like to quote him. One question Rob Conery asked me during a conversation on DDD was, “How do I recognize an application built with DDD?” We’ve already noted that you can’t look towards a set of patterns, so how do we recognize one?

What can I say in the face of so much expertise? I hope to stop messing about with free downloads of MySql, SQL Server, ASP.NET, etc and learn to work with them instead. I do small things cheaply for small companies, so up to now Access has fitted well, however, I do not think I will move to Access 2007, so I need to figure out what else can be so easily set-up and maintained.

Every year it seems to become more difficult to remain current on new technology. The following is definitely a bit ambitious, but if I accomplish fifty percent, I will be more than satisfied. .Net I’ve gone through various phases of my career where my responsibilities have switched from SQL Server centric to Visual Basic centric and back again as far as development is concerned. Although I’m now concentrating more on SQL Server/data modeling/ETL in my current role, I still need to stay current should the need arise.

After being tagged by AlexCuse in /index.php/ITProfessionals/EthicsIT/to-do-in-alex-land-2009, I had to have a sit down and think what I’d like to get into this year. Some of the things I’ve come up with are: Silverlight Although I can’t say this is an arena I’ve thought of going into, it’s probably something I should be aware of. At this point in time, it just seems like flash to me and I’ve always avoided flash so I’ll have get into the right frame of mind to take this up.