Posts by
Tony Davis

8 January 2019

8 January 2019

The Database DevOps Challenges SQL Provision Solves

SQL Provision helps to accelerate the delivery of database updates by enabling an organization to provide database copies, and the right data, to all parts of the deployment pipeline that need it, with a light footprint, and securely. It removes much of the administrative burden of providing a ‘database refresh’, while still allowing operations... Read more

22 December 2018

22 December 2018

Picking over the Bones of a SQL Injection Attack

Some developers are like bikers. They think that accidents and disasters are things that happen to other people. They aren’t. The Developer Joe De Vell sat blinking in some confusion at the unexpected errors scrolling suddenly down his command line screen. It was output from his new SQL Server REST interface, built using NodeJS.... Read more

28 September 2018

28 September 2018

Merging a Conflict with SQL Source Control and Beyond Compare

SQL Source Control (SoC) plugs directly into SQL Server Management Studio (SSMS) and is built with the singular purpose of providing an efficient interface between each developer’s local, working copy of the database, in SSMS, and the source control repository. It allows each developer to work freely, on their own sandbox database, committing tested... Read more

17 July 2018

17 July 2018

Scaling SQL Monitor to Large SQL Server Estates

Most organizations are finding that the size and number of databases that need to be monitored is increasing, unlike the number of people available to do the work. Now that it is possible for the organization to scale out to cloud-hosted databases, the constraints of the available infrastructure have ceased to govern the growth... Read more

7 December 2017

7 December 2017

Why your Development team needs SQL Prompt

Alongside specialists, an IT department needs people who are broadly skilled and adaptable, who can pivot quickly to new projects, slot easily into new teams, and be productive quickly. SQL Prompt is the industry-leading SQL IntelliSense and code-formatting tool, and is an investment in developer versatility and productivity. It will both increase personal coding... Read more

23 October 2017

23 October 2017

A day in the life of a developer with SQL Prompt

I’ve a a busy day ahead of me, working on a new reporting query, plus reviewing some initial database designs for the team. We’ve done the morning stand-up meeting, I’ve had my morning coffee, SQL Server Management Studio and SQL Prompt are open, and I’m ready to start work! 10.00AM – Prompt Tab History... Read more