Posts Categorized in Database development

2 March 2018

2 March 2018

Things to consider for a cloud migration

Introducing a cloud migration is becoming an integral facet of modernization in any business strategy, and these days there are more than a handful of aspects to consider. The number of operational locations, remote or local users, and each user’s unique accessibility must also be taken into account to better understand the kind of... Read more

18 January 2018

18 January 2018

Right-sizing for a cloud service

When it’s time to purchase new resources for one or more applications, the non-scientific approach of guesstimating the requirements can be expensive, whether for on-premises capital expenditures or cloud-based services. For stakeholders deciding on how to provision the data services, is it better to start small and grow the resources as needed? Certainly the... Read more

4 December 2017

4 December 2017

The top 10 considerations when designing a data platform

Designing a data platform for a new product or service is a fascinating and exciting challenge. It’s also a daunting one. Instead of plugging a new feature into an existing platform that is proven and reliable, the onus is on you. You have to start from scratch and create a platform that becomes just... Read more

1 November 2017

2 Comments

1 November 2017

2 Comments

Preparing your data platform for peak period sales

In the last few years, Black Friday and Cyber Monday have become synonymous with both getting a good bargain and causing retail pandemonium. However, times are changing. News items about people queueing outside shops at 4am have been replaced with stories about how much consumer spending has moved online. Quite some achievement for a... Read more

20 September 2017

1 Comment

20 September 2017

1 Comment

The importance of bringing Python to SQL Server

When SQL Server 2017 launched, Microsoft proudly announced that it was the first relational database engine to ship with built-in artificial intelligence (AI) capabilities. In the future, database servers running its software won’t just be able to store, query, and analyse data. Instead, they’ll also be able to perform machine learning, natural language, and neural... Read more

23 August 2017

1 Comment

23 August 2017

1 Comment

Why don’t you unit test SQL Server code?

The download count of the tSQLt unit testing framework is surprisingly low, yet this outstanding open source software can revolutionize your SQL Server development process. Hopefully, this post will show the benefits of test-driven development and including automated SQL Server unit testing within your release pipeline. This simple technique can have a profound effect... Read more

19 June 2017

19 June 2017

Provisioning just got BIGGER with SQL Clone v2

Today, we launched SQL Clone v2, which removes the previous 2TB size limit and now supports cloning databases up to 64TB. In this article, I’ll explain why I think this is big news for many organizations, and describe briefly the changes to SQL Clone v2 that made it possible. In larger organizations, such as... Read more