Tag Archives: Pluralsight

Portico API

Sidwell’s flagship web product, Portico, is growing in so many ways. In addition to maintaining the original Silverlight control, I’ve developed a mobile website, and I am about to develop a whole new application containing several “widgets” using the Web AppBuilder for ArcGIS. We also have an Advanced Print Preview and some custom reports that access the backend. Portico has become so much more than a website — it’s a development platform — and I certainly will not predict the next applications to be built on this platform. So, I decided the time has come to separate the traditional Portico website from it’s backend services, and deliver the backend through a new API.
Continue reading Portico API

Index Fragmentation

Think of index fragmentation on SQL Server like hard drive fragmentation. Every time you edit a file, the computer stores pieces of the file all over the hard drive. Over time, this gets worse. Pretty soon, your computer has to jump all over the hard drive to find all the piece of a single file, and performance suffers. The same thing happens to indexes in a database. Every time somebody makes an insert, update or delete, the index becomes fragmented. Technically, the physical order of the index becomes increasingly different than the logical order. Pretty soon, the index needs to be rebuilt. This applies to clustered and nonclustered indexes.
Continue reading Index Fragmentation

Passed 70-486

I passed my 70-486 exam today. I would hope so, since this exam covers what I do all day, every day. This is called¬†Developing ASP.NET 4.5 MVC Web Applications.¬†Having already taken my first exam (70-480) a few weeks ago, I knew what to expect. I also knew the location of the testing center, how long it would take (two hours and thirty minutes through Denver’s rush hour traffic), etc. So, I was pretty relaxed.
Continue reading Passed 70-486