So Theodore tagged me in his post. So I guess I need to tell you the story that time when I had a perfectly good working system and started from scratch anyway. Well I rewrote my application 4 times already over the years. The first version was n MS-Access database an MDB. And it worked just fine. But I kept adding and adding to it. And the 2 gig limit came into range.

I was tagged by Ted Krueger in his Friday SQL Nugget #1 post. This Friday’s nugget is: Deciding I need to delete it all and start over again. Since programmers are lazy, they usually prefer to make changes to existing tables/packages/stored procedures to make something fit in instead of starting from scratch. This makes sense usually because the change is small and you don’t have to test that much. But then another changes comes along…and another…and another…and before you know it, you have created a patched up solution with so many band-aids that you better be standing close by with that mop to clean up all the leaks

I’m going to try to start a new Friday post here on LessThanDot called, SQL Nuggets. Yes, I said Nuggets! It’s commonly known that posting technical content on a Friday is less effective than publishing between Tuesday and Thursday. The simple fact that most readers will not be in a position to read RSS feeds is there. However, Friday still has a relaxing feel to it and SQL still has something to offer us in the form of a valuable but short post.

The above title is not entirly correct, sometimes I learn from listening to others. In essence my best method of learning is by doing and from doing I learn. Let’s take the whole android thing. In September 2011 I saw that on of the schools in my neighborhood gave classes about android development. I thought that was interesting and I subscribed. The class was going to be for a beginner level, which I don’t really mind because I was willing to learn.

I had a great time presenting for WiSSUG tonight! It’s always good to see old friends, and meet people I’ve talked to on Twitter for the first time. WiSSUG were witness to the debut of my newest presentation, “Filegroups: Putting the Pieces Together”. I want to thank everyone that attended for listening, asking questions, and offering opinions. I love to get my audience talking about a topic! We talked about this a lot:

I am a stranger in a strange land. I am a SQL Server DBA and developer wandering, lost, in the world of MySQL. Fundamentally, I know that a database is a database. Both MySQL and SQL Server are built on the same ANSI standards. However, as I started working with the MySQL databases of a couple websites, I ran into unexpected limitations in MySQL. SQL Server has one database engine.

Denis started us off earlier with his Meme Monday post, “Meme Monday: what is the first blogpost you wrote and when did you write it?“. This is a tricky question for me, mostly because my memory is poor and I’m having difficulty bending google’s time search to my will. LessThanDot My first LessThanDot post was a wall of text in April 2009 that talked about bringing transparency and a definition of success to all projects, no matter how small.

What was the first blogpost you wrote? When did you write it and what was it about. Here is mine, it is from September 15, 2005, it was about something that trips people up @@IDENTITY returns wrong identity field When using @@IDENTITY I get the wrong results I have seen this problem posted many times on newsgroups and It actually happened to a co-worker not too long ago This ‘problem’ can occur when you do an insert into Table A and there is at trigger defined that fires when the insert happens and this trigger does an insert into table B.

Over the past couple of weeks, we have looked at the new auditing feature introduced in SQL Server 2008. This post will finish up with the series and will cover the remaining subjects: 1.SQL Server 2008 vs. SQL Server 2012, 2.PBM – Last take on auditing your audits, 3.The Auditing Repository. SQL Server 2008 vs. SQL Server 2012 The new release of SQL Server is around the corner, and with it there are numerous enhancements to the various components as well as new features.

So after the Hanselminutes player I made a this developer’s life player for android. The principle is the same but the code and result is slightly different. You can find the apps on the market. And you can find the code on Github. Here are some screenshots.