Click here to monitor SSC

Tony Davis


Tony Davis

Over-SQL-Engineering

13 comments

In a recent blog post, Jonathan Kehayias demonstrates a clever way to “multi-thread” maintenance tasks, when they need to run against very large (i.e. multiple terabyte) databases. The tool he used? Good old-fashioned Service Broker. Simply create some basic Service Broker objects, an activation procedure to automate Ola Hallengren’s maintenance procedures, bind the activation procedure […]

3 June 2016 10:30 am by
Tony Davis

SSMS Renaissance

8 comments

For many good reasons, DBAs and database developers use SQL Server Management Studio (SSMS), not SQL Server Data Tools (SSDT). It is a great relief for them, after several SQL Server releases-worth of general neglect, to see some renewed developmental vigor behind SSMS. Until the approach of SQL Server 2016, DBAs could have been forgiven […]

20 May 2016 11:11 am by
Tony Davis

9 Clickbait Simple-Talk Titles You Won’t Believe Exist!

7 comments

At Simple-Talk, we specialize in practical, down-to-earth technical articles, and usually choose our titles to match. There’s no mistaking what “Comparing Networking options in Azure“ might be about, for example. Nor is there much room to doubt what’s in store in “Debugging data flow in SQL Server Integration Services“. Are we wrong to be so […]

5 May 2016 4:03 pm by
Tony Davis

JSON-rise

4 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
Older posts

Blog archive