I’ve just posted an updated version of my SQL Script Mover utility on codeplex, here: https://sqlscriptmove.codeplex.com This is a utility for extracting schema from a sql server database. It supports views, stored procedures, functions, tables, triggers and DDL triggers.
Here are some thoughts on optimizing stored the performance of stored procedures. In no particular order: Clustered Indexes Make sure your tables have clustered indexes. It’s amazing to me that folks create tables without clustered indexes. A clustered index is the physical order of data in the table and it’s my understanding that it is difficult for SQL to reclaim space from a table without a clustered index when rows from that table are removed. A table without a clustered index is called a heap, and heaps are generally considered to be bad. Here’s the MSDN description of heap tables […]
We live in a time when the middle class is rapidly disappearing, when the divide between wealthy and not-wealthy is as great as it’s ever been, and when the future appears poised to bring us a bleak landscape of uber-wealthy gated cities separated by sophisticated technology from warring, impoverished multitudes. It’s right out of a Paolo Bacigalupi novel. Is this the future that has to be? What if those giant tech companies that have been so efficient at eliminating middle class employment were subject to rigorous anti-trust regulations designed to prevent too much of our country’s economic power from falling […]
I just happened across a great post by the guy (Jamie Salvatori) who runs VAT19: http://www.practicalecommerce.com/columns/the-ecommerce-corner-office/11024-Why-we-abandoned-Amazon-and-eBay In case you’re not familiar with them, VAT19 is a retailer of fun and funky things (giant lollypop, giant unicorn lamp) and I know them because my kids love surfing their web site (and watching their videos). Jamie argues (and I wholeheartedly agree) that Amazon and eBay have no interest in helping you grow your business. They are interested in having you help them grow theirs.
This past week my son brought home some math homework. The assignment was, given a list of coordinates, to graph those coordinates. The result would be a picture. My son made a couple of mistakes in his graph and so the picture was a little off. I thought the idea was intriguing. To help him I put together a web page that uses HTML5 canvas to help him chart the coordinates. The interactive coordinates charting page is here, in case you’d like to take a look: http://www.jlion.com/coordinates/
One of my favorite books is Zen and the Art of Motorcycle Maintenance, by Robert Pirsig. It’s about a lot of things, but mostly about quality, more specifically, “what is quality?” It’s not explicitly about software but it is about technology in a general sense. “Phaedrus”, the narrator of the novel, is a technical writer, and much of the book is about technology and how we work with it. There are a lot of lessons in the book that I think particularly apply to a personal philosophy of software development: Writer’s Block This one in which Phaedrus provides advice on how […]
“Our Software Sucks” I was once party to a contentious meeting. A senior executive made the statement that “our software sucks!”. When he said this, he was referring to all of the projects worked on by all of the developers at the company. And he was making this assessment on two points: First, that there were many bugs logged in our bug tracking software, and second, that other executives that he met with, representing customers who used our software, were complaining to him about those bugs. I found the statement a little offensive, although he wasn’t referring specifically to the project on which I had […]
My son recently assembled his own computer. While this isn’t his first computer, it’s the first one he’s put together himself and it’s the best computer in our house (fastest, best video card, most drive space, awesome LED lighting). My first computer was a TRS-80 Model III. I was about 14, about the same age as my son is now, and I subscribed to 80-Micro magazine. Each month I’d receive a fat magazine filled with printed source code. I’d spend hours laboriously typing in the listings, save my work to a cassette tape drive, then spend hours more finding typos […]
The excellent Joseph Albahari, author of LINQpad, wrote a blog post: Why LINQ beats SQL and while I really like LINQpad (how else would I debug LINQ?) I do think Joseph misses the point a little with SQL. He says: “Compared to SQL, LINQ is simpler, tidier, and higher-level” and my first reaction is that SQL and LINQ are bulldozers and Cadillacs here, not good subjects for direct comparison. I think there is a place for LINQ to entities but I do not believe that all database functions and access can be replaced by LINQ queries. I’d propose that any query […]