Posts Categorized in Database development

9 July 2019

9 July 2019

What are the biggest challenges in monitoring SQL Server, and what should you expect from a third-party tool?

Redgate has just published the 2019 State of SQL server Monitoring Report, so I thought I’d read it to find out if the results it reveals chime with my own experience talking to large, distributed enterprises about the challenges they face when it comes to monitoring. Based on a survey of 820 database professionals... Read more

13 June 2019

13 June 2019

Managing your server estate – can we help?

Here in the Redgate Foundry, we’ve been conducting research to understand ways to help data professionals manage their server estates more effectively. Our aim is to support you in providing a single source of truth about what is happening in your estate, provide a foundation for you to build and plan from, and empower... Read more

13 June 2019

13 June 2019

Database provisioning and containers

You might have heard of the concept of containers, at least in passing – or maybe you’re already using them widely in both dev/test and production. Containers are a great way to isolate your application code from the environment it’s running in, and they offer a range of benefits from easier deployments and scaling... Read more

23 May 2019

23 May 2019

Loading data into SQL Data Warehouse

In this step-by-step guide, we’ll be walking through the process of moving data from an on-premises SQL Server to Azure SQL Data Warehouse using the Copy Data feature in Azure Data Factory. The use case we’ll focus on is the first-time loading of data. Skip to instructions A note to Data Platform Studio users... Read more