Click here to monitor SSC

Tony Davis


Tony Davis

D.R.Y. with SQL Scripts

9 comments

Developers strive to write well-tested, reusable code with well-defined interfaces so that when they need to update the functionality, they need do so in one place only. It is the principle of ‘Don’t Repeat Yourself’ (D.R.Y.). However, it is common for developers to be poor at applying D.R.Y. to their own past work. When it […]

28 March 2014 3:54 pm by
Tony Davis

Build, Buy or Rent?

11 comments

In the pioneering years of the PC industry, people mainly created for themselves whatever tools they needed, because there wasn’t much of an option. I’ve lost count of the number of developers who claim to have invented their own text editor. These days, we simply buy the product or editing module that best suits our […]

14 March 2014 3:41 pm by
Tony Davis

DevOps Dilemma

5 comments

The term ‘DevOps’ has been widely misunderstood because the different teams within any really substantial development project understand the work of the other teams so poorly. There will be several teams, including business analysts, technical architects (maybe), UX specialists, designers, testers, and developers. No development specialists, however, have until recently had the production environment firmly […]

14 February 2014 1:21 pm by
Tony Davis

Should IT Managers Code?

23 comments

In one of his first ever Simple-talk articles, Phil Factor tells the story of a freelance Sybase programmer who created a reporting system using exquisitely complex dynamically compiled stored procedures, and then promptly departed when he failed to secure a doubling of his contract rate. As Phil struggled to make sense of the code, with […]

17 January 2014 11:40 am by
Tony Davis

Cloud Insecurity

5 comments

Often, one sees the views of those raising reasoned doubts about cloud security dismissed as fogeyish and cloud-phobic. Of course, it’s a persuasive argument that cloud security is actually a non-issue, since under-investment means that the on-premise infrastructure of many organizations is a less secure environment for their applications than the cloud. The ClimateGate evidence, […]

22 November 2013 2:56 pm by
Tony Davis

What the Hekaton?

11 comments

Hekaton, the power behind SQL Server 2014′s In-Memory OLTP technology, is intended to make data operations run orders of magnitude faster on SQL Server. This works its magic partly by serving database workloads entirely from main memory, using memory-optimized table structures. It replaces the relational engine’s standard locking model with an optimistic concurrency model based […]

25 October 2013 11:09 am by
Tony Davis

PASS 13 Dispatches: moving to the cloud

0 comments

PASS Summit 13, Day 1 keynote by Quentin Clarke and we're hearing about “redefiniing mission critical in the cloud”. With a move to the Windows Azure cloud comes the promise of capacity on demand, automatic HA, backups, patching and so on, as well as passing responsibility to MS for managing hardware, upgrades and so on. […]

16 October 2013 1:39 pm by
Tony Davis

PASS 13 Dispatches: Memory Optimized = On

0 comments

I'm at the PASS Summit in Charlotte for the Day 1 keynote by Quentin Clarke, Corporate VP of the data platform group at Microsoft. He's talking about how SQL Server 2014 is “pushing boundaries” and first up is SQL Server 2014's In-Memory OLTP technology (former codename “hekaton”) It is a feature that provokes a lot […]

16 October 2013 12:59 pm by
Tony Davis

It’s the thought that counts…

7 comments

I recently finished editing a book called Tribal SQL, and it was a fantastic experience. It’s a community-sourced book written by first-timers. Fifteen previously unpublished authors contributed one chapter each, with the seemingly simple remit to write about “what makes them passionate about working with SQL Server, something that all SQL Server DBAs and developers […]

9 October 2013 3:59 pm by
Tony Davis

Going with the Flow

9 comments

Every so often, a new programming model or framework emerges, promising to tackle the burgeoning complexity of the software development process. This week, the potential savior of the sanity of web developers everywhere is an “Arcane Coding Method from 1970s Banking Software“. The arcane method in question is Flow-based Programming (FBP) and, at its core, […]

30 August 2013 2:27 pm by
Older posts