Click here to monitor SSC

Tony Davis


Tony Davis

JSON-rise

3 comments

Microsoft was slow to meet the demand to be able to store and retrieve data in JSON, the native data format of ubiquitous JavaScript-driven web sites and mobile applications. Its late entry into the market, Azure DocumentDB, still has a lot of ground to make up; in the meantime, MongoDB has managed to fill the […]

21 April 2016 3:35 pm by
Tony Davis

Goodwill and hard learning at SQL Bits 15

1 comment

SQL Bits XV, the official launch event for SQL Server 2016, begins in Liverpool, UK, on May 4, 2016. Simple-Talk is a strong supporter of this event, and for good reasons; it’s a fantastic training event, and also one of those that feels “right” from the moment you enter the venue. There are so many […]

8 April 2016 5:06 pm by
Tony Davis

A Programmer Walks Into a Bar…

26 comments

Conference season is upon us. Sessions, hands-on labs, round table debates, so many opportunities for learning! Of course what they don’t admit on the conference websites and brochures is that all the important business at a conference takes place not in the sessions, but at the many impromptu social events, usually at a local ale […]

11 March 2016 10:06 am by
Tony Davis

Push-Button Database Deployment?

5 comments

Much of what we do in IT seems easy, from a distance; even the modification of a live functioning database while preserving production data. However, any DBA who isn’t gripped by a cold terror at the prospect has probably never been responsible for a live trading OLTP system, on which an organization depends. A lot […]

25 February 2016 11:21 am by
Tony Davis

Does Anyone Do This Stuff

17 comments

“Does anyone actually do this stuff?” This question came from a member of the audience at one of Brent Ozar’s training classes on SQL Server Database Continuous Integration. Mercifully, plenty of people confirmed in the comments that Database CI was alive and well, which was a relief, since I’d been toiling for several days on […]

11 February 2016 6:00 pm by
Tony Davis

A Database to Diagram for

9 comments

I’m no database designer but I do occasionally need to build a very simple database model, no more than a small handful of tables, to test out some code for an article or presentation. The other day, I was indulging in my usual habit of slowly tapping out CREATE and ALTER TABLE statements in SQL, […]

28 January 2016 6:00 pm by
Tony Davis

Real Developer Heroics

8 comments

One of the strange paradoxes of team development is that effort beyond the call of duty is generally discouraged. Developers who are new to team working assume that, if they work wonders to solve apparently intractable programming problems in record time, then all around them will smile in gratitude. The instinct to solve problems is […]

14 January 2016 3:04 pm by
Tony Davis

The Genuine Article

5 comments

On Simple-Talk, we try to make sure that Information Technology is presented in an interesting way. We all tend to have more patience with a pedestrian article or blog that has information that solves an immediate problem, and we find the necessary energy to wade through the dull bits to get to the nectar. More […]

31 December 2015 1:03 pm by
Tony Davis

Workplace Politics

4 comments

The IT workplace can often be stressful when untoward things happen. Maybe, it is business managers who demand new platforms, applications, and functionality to support bold new strategic objectives. The IT team, perhaps, begins to crack under pressure of an ever-increasing backlog of work to unrealistic deadlines while somehow holding together a creaking and patched-together […]

18 December 2015 10:40 am by
Tony Davis

Squaring the NoSQL Circle

9 comments

NoSQL was a bold new revolution. Many of these databases are schema-less, or rather the schema is implicitly defined by the developer, and therefore is flexible and can evolve. NoSQL databases lend themselves to very simple key-value access patterns; there is no need to design complex relations, or perform joins in ‘archaic’ languages such as […]

3 December 2015 3:08 pm by
Older posts

Blog archive