Inspired by the not-yet-best-seller XP and Scrum from the Trenches by Henrik Kniberg from now on I will start to share with you my war stories as a Product Owner in a Scrum team.
Expect it to be posted as quick and basic notes, since I am very busy these days and I'm studying Scrum hard :)
Today's note: Big stories (an "epic", as Mike Cohn would say in User Stories Applied) have the potential to fail being delivered no matter the size your sprint has.
That's why it is strongly recommended you slice your "epic" in small stories ;) PLUS, if you have a big story and your team fail miserably at the end of the sprint, delivering little to none "potentially shippable software", your team is going to feel so bad you are going to need team therapy :)
I appreciate ur feedback!
Nothing new in this post, just something that I wanted to share with you: how-to add Intellisense support to jQuery in Visual Studio 2008.
Below you can see an image with a sample using the "reference" directive and the Intellisense itself in action:
The documentation (and the library, of course) can be downloaded from the official jQuery website:
http://docs.jquery.com/Downloading_jQuery.
I appreciate ur feeback! Thanks!
A few day ago I installed Windows 7 RC plus the Visual Studio 2008 SP 1 and the .NET 3.5 SP1. I spent 2 days trying to find out why the Dynamic Data project templates and other Item templates, like the ADO.NET Entity Data Model. I really gave up on Windows 7 thinking that it could be the bad boy.
I swear at least these templates were missing:
I installed Vista Ultimate and tried .NET 3.5 SP1 on demand/off line installers. Still those templates were not there. I googled and found a lot of people talking about hot-fixes, Visual Studio command lines like devenv /vsinstalltemplates, which I believe may have worked for some but for me unfortunately it doesn't.
After some more formatting-then-installing-again Vista, I downloaded the Visual Studio 2008 SP1 which comes with the .NET 3.5 SP1 in the same bundle and it worked like a charm :)
Here is the magic link: Microsoft Visual Studio 2008 Service Pack 1 (iso)
I'm working in a small project which is designed with a MySQL database. As you and
I know, MySQL fits perfectly this type of project. I'm not saying that it doesnt
fit big projects, but MySQL is great for small projects ;)
We could have used SQL Express too, but hey, it is cool to be versatile ;)
Since it is a small project, I though we could use ASP.NET controls to display data.
I've been working for years with ASP.NET but never worked with the SqlDataSource,
for example, just with the ObjectDataSource which were bounded to Business Objects.
But I knew SqlDataSource capabilities, since I studied it for certification exams
:)
One mistake I found very common while googling is to think that the SqlDataSource
objects doesnt work with other databases than Microsoft SQL Server. SqlDataSource
works with every database that has a ADO.NET provider implemented, including MySQL.
MySQL has the marvelous MySQL Net/Connector, which is at version 6 and can be downloaded
here.
MySQL Net/Connector has alot of "gotchas", some things works different with the MySQL
database as a data source for the SqlDataSource, specially the SELECT querys with
"LIKE" clauses, and that's what this post is all about.
First things first, let's make the MySQL Net/Connector work. Close all yours Visual
Studio instances, then you install the MySQL Net/Connector, which is next, next,
next, finish.
Fires up your Visual Studio again and you can add a SqlDataSource to a Web Form.
Right click the SqlDataSource object and click "Configure Data Source", a Wizard
is going to start. Click "New connection" in the first screen and you are going
to see an option to connect to a MySQL database, like this:
Choose "MySQL Database", click "Ok" and fulfill the connection
information to your database:
Click "Next", choose to save connection string in the web.config file
(we all know this isn't safe, but this is an example) and click "Next"
again.
The query statement wizard starts, and this is where things starts to get interesting,
specially if you need to add a LIKE clause to your query:
Click the "WHERE" button and add a LIKE clause, like in the screen below:
Click "Add" and then "OK".
Back to the query statement wizard, click "Next" and watch as the wizard mounted
the query in the "SELECT statement" box:
If you click the "Test Query" button and add a value to the parameter you added
two steps ago, a error is going to occur:
After hours bumping my head against the wall, I found out that the query statement
that Visual Studio generated isn't MySQL compliant:
The query's syntax demonstrated above works with SQL Server, but not with MySQL,
which should be:
SELECT * FROM conteudo WHERE Titulo LIKE Concat('%', ?Texto, '%')
The "Test Query" will still not work and I don't know why, but it works at runtime.
I appreciate your comments ;)
Updates:
- I found out that the images I posted were too large, so I decreased its size.
- I don't even know how my post was submited to DotNetShoutOut. Whoever made it, thank you. From now on I'm going to post the "Shout it" in every post! If you like the content, please shout it!
This is my first post in weblogs.asp.net/marcio.
First and foremost I wanna thank Joe Stagner for giving me the oportunity to have a blog on ASP.NET.
Around here I intend to exchange knowledge and experiences with people around the world about everything technology related, especially .NET.
Enough talk, let's code a little bit.
Soundtrack to this post: Too Short feat. Keak da Sneak - Going dumb
PS: I often blog about my personal life @ oguri.blogspot.com (in portuguese).