Tag Archives: sql server

Core T-SQL

Posted on November 22, 2013 by way0utwest

Often I find myself wondering about the minimum bar we expect people to clear to be competent in some field. Almost all fields are evolving these days as technology and new ideas are put into practice in medicine, art, construction, … Continue reading →

Posted in Editorial | Tagged , , , | Comments Off on Core T-SQL

What is SQL Server not good at?

Posted on November 21, 2013 by way0utwest

I was reading a post that had this quote: ” The MongoDB docs tell you what it’s good at, without emphasizing what it’s not good at. ” This isn’t to pick on MongoDB, but the post did make me wonder what SQL … Continue reading →

Posted in Editorial | Tagged | Comments Off on What is SQL Server not good at?

Backups and Consistency

Posted on November 20, 2013 by way0utwest

I wrote about transactional consistency recently. Why do we need this? Imagine that I have an orders table and an ordersdetail table in my database. The orders table has the order header (date, customer, etc) and the detail table includes … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

It Starts with Version Control

Posted on November 20, 2013 by way0utwest

As a software developer, I learned about the value of version control over time. My first forays into development were as a child, where I made a single backup of my code on a separate floppy disk in the event I had … Continue reading →

Posted in Editorial | Tagged , , , | Comments Off on It Starts with Version Control