UPDATED: Deploying SQL CE 4.0 in a Hosted Environment

by Doug 26. August 2011 12:54

 

sqlserverlogo

        COMPACT EDITION

 

As promised, Mark Wisecarver has finished his webcast regarding SQL CE 4.0. Check it out over here: http://www.dasptv.com/avc-view.aspx?videoid=39

 

Mark provides a very nice overview of this latest version, including some excellent blogs and other online resources that can will help you decide if it’s the right version of SQL for your project (remember kids, it’s not a replacement for SQL Server), and has a tutorial on creating a new app with Visual Studio using CE 4.0.

 

If you’re among those who have DiscountASP.Net as your web hosting provider, don’t forget to come back here, since I’ve outlined the steps to deploy your ASP.Net web app using SQL CE to DiscountASP.Net web hosting:

http://www.mooremediaone.com/blog/post/2011/07/11/Deploying-SQL-CE-40-in-a-Hosted-Environment.aspx

Book Review: Pro CSS for High Traffic Websites

by Doug 22. June 2011 21:22

 

 

Jeff Atwood (of StackOverflow.com fame) recently posted on his blog CodingHorror.com (http://www.codinghorror.com/blog/2011/06/performance-is-a-feature.html) that when it comes to high performance websites, speed is a competitive advantage - a feature if you will. Getting your site to perform under the strain of high traffic is difficult at best, but there is evidence that speed (or lack there of) affects the bottom line ($$).  Among other very interesting aspects in his post, Jeff writes:

 

"In A/B tests, [Amazon] tried delaying the page in increments of 100 milliseconds and found that even very small delays would result in substantial and costly drops in revenue." 

 

Talk about performance in the granular. But he's absolutely spot on in his case for "the need for speed".

 

There are many factors to keeping a high traffic web site fast.  Beefed up hardware. Content Delivery Networks. Optimized code and database queries.   But don't forget your CSS files. If you thought you've tweaked everything but you're still wondering about how to trim the load time of your home page, optimizing your CSS might be the very thing you're missing.

 

Enter "Pro CSS for High Traffic Websites" by Anthony Kennedy and Inayaili de Leon to the rescue. Published by Apress, this book delves deep (very very deep) into keeping your CSS robust, small and efficient.  

 

You'll learn about devices that consume your site, testing and debugging, dynamic CSS and many others -  but before it gets to actual CSS related topics, it starts with a chapter named "The Value of Process". This outlines best practices to organize your development staff in a practical hierarchy,  defines the typical job types such as Project Manager, Team Lead and Developer, introduces some tools that can help when the projects and staff grow  as well as  some additional project management philosophies.   

 

It makes sense to include this chapter, because when dealing with a high traffic website (upward of 10,000 unique visitors a day - a definition suggested by the authors ), you're probably working for a larger company with considerable  bureaucracy which can make changes to your website a slow process.  Using the management tools and strategies suggested can help productivity and streamline the process.  This chapter covers topics above and beyond CSS that can be used by all types of developers and managers.

 

This chapter also is indicative of how the rest of this books info is presented.  Authors Kennedy and Leon skip any CSS retrospect or refreshers to get you up to speed with advanced CSS topics before plunging in head first.  I wouldn't give this book high marks for ease of readability. There's a certain density that weights it down somewhat.   However with that one complaint out of the way, I must emphasize that these two really know their stuff and award it high marks for content.

 

I'm not sure where you'd find a more comprehensive look at CSS and its effect on site performance.  Nothing goes without thorough examination.   Folder names and file paths for example.  You're probably used to linking to your images like so:

/images/mainContentPage/background_homepage.jpeg

 

What could be so wrong with that?  Wow, you're just asking for a performance hit with such verbose folder names - that's what. There's a "scale of negative performance magnification" (OK, I just made that up) that goes with each bit that isn't optimized when asking your pages to load at lightning speed under the strain of high traffic and a busy web server.  What to do in this case?

 

Shorten your images folder to "i".

Shorten your mainContentPage folder to "main".

Abbrieviate your image file names.  "background_homepeage.jpeg" should become "bg_home.jpg" - and compress those images appropriately while your at it.

 

/images/mainContentPage/background_homepage.jpeg now becomes becomes

/i/main/bg_home.jpg.

 

You've just shaved 29 chars,  a 40% reduction in size.   Now you get the picture.

 

This is just one simple example of the world of CSS efficiency that's explored.  You'll also get thorough enlightenment on CSS Frameworks such as Blueprint, 960 and YUI.  And Object Oriented CSS.  Building flexible CSS to accept site expansion. Don't forget Accessibility too.  Your high traffic site is probably visited by many impaired visitors and consumed by special devices such as braille printers.  What? You've never taken precautions to make sure your site is properly printable for the blind?  Yeah. Neither have I.  Like I mentioned, this book is scarily comprehensive. 

 

What will appeal to most developers though, will come in chapters 8 and 10.      Chapter 8 deals with the meat of the matter: Performance.  Get ready to redo your naming conventions, start minifying, get concatenating, setting up compression on your web server, examining delays during DNS look ups and the advantages of using a CDN (Content Delivery Network).  Oh, and don't forget caching content, dealing with animation and proper use of JavaScript.

 

Chapter 10 deals with Testing and Debugging.   Here is a treasure trove of advice that developers will find useful.  Automated testing. Manual testing. Debugging processes and suggested tools to use.  Getting on track with efficient and fast CSS development. Oh and how about that dreaded Internet Explorer version 6 that we all curse during development?  Not only in this chapter but throughout the book, there are many examples of how to overcome IE bugs.

 

We developers usually have many books at hand to refer to.  This one may get more dog eared than others on your shelf depending on what sort of developer you are.  Myself, being a C# middle-tier type of coder, CSS isn't foremost in my typical day at the office. This is why my CSS horizon has been blasted wide open during this read - and why I'm glad it'll be at hand as a core CSS reference for me.

 

 

 

 

Book Review: Pro Expression Blend 4 by Andrew Troelsen

by Doug 21. April 2011 19:35

 

 

Apress Publishing contacted me (along with others from the Microsoft development community) about reveiwing a new technical book by Andrew Troelsen.   Since I had the time, and was already familiar with the subject mattar (a program called Blend that is used to create web applications and more) I took them up on the offer.  I enjoyed the book, and I think the publisher and author will like my review which appears on Amazon.com, BarnsAndNoble.com and Slashdot.org and of course A Doug's Life:

 

 

 

 

Andrew Troelson has written a great book that breaks down Microsoft Expression Blend 4 into easy to understand  concepts.   Blend isn't necessarily a simple program to use.  This is the case for many programs that are used to create sophisticated applications. The programs used by developers (and designers!) are somewhat sophisticated as well.

 

 

Should you buy this book?  Absolutely - if you need to learn the Blend IDE. But you should really take a few moments to read the introduction.  Troelson's key point is clear: "This is Not a Programming Book, and Graphical Artists are Welcome!"  In other words, even though it's not a book that delves deep into programming,  .Net programming guru's will find this book very useful in getting up to speed with using Blend 4 as well as designers too.

 

 

In my first real world Silverlight projects I had used Blend 2 and 3, so moving through the book I felt right at home.  However there was much to learn about version 4 and some of it's capabilities that I'd never touched in my previous Silverlight projects.  I had never used custom control templates or custom UserControls.  Never tried a Windows Phone 7 project.  I have used SketchFlow - but discovered I wasn't using it to it's full potential.  

 

 

Following Troelson through the exercises is easy as everything is very clear. There are a generous  amount of color screen shots and the code samples (yes there is code  - but not too much) are in the same color format as when working in Blend code view.  I should say that his writing style is very casual.   Many technical books can make your eyes glaze while managing a heavy buzz kill of your excitement about learning the technology.  Troelson keeps things light and makes the technical point at the same time.

 

 

As well, there are lots of extra bits if info in the form of Notes (separated from the rest of the page content) and  detailed footnotes.  Troelson also provides a generous amount of links, references and images to help you follow up with subjects lightly touched upon, but are outside the scope of the book.

 

 

What I find exciting, is that once you develop some skills using Blend,  you can apply them to web applications (via Silverlight), Windows apps (via WPF) or mobile apps  (via Win Phone 7).  Having that kind of flexibility as a "deviner" (developer/designer) creates more value in learning Blend. 

 

 

I read the entire book, did all the exercises and tried much of the suggested extra stuff too. If you do the same, you will have worked with all the features of Blend 4 in one way or another.  Keep the book handy.  You'll probably take it off the shelf  during your next Silverlight, WPF or mobile Phone project.

 

 

 

Doug's Latest Tweets

Doug Who?

Hey, Doug here.  Thanks for visiting "A Doug's Life". 

 

I enjoy packaging my thoughts, pictures, video clips and other fragments into what hopefully makes up some interesting stuff to share.  

 

I've checked the list that gives you a better idea about me!

 

Love Web Technology
Sunday is for Pro Football
Hike or bike on trail most mornings
Halloween Rocks!
Chase the latest electronic gadgets
Married
(Happily Married)
Drama
Simplicity

 

My wife and I live in the shadow of Mt Lukens on the edge of the Angeles National Forest:

 

Tujunga, CA

More Stuff