Author: Tony Rogerson

Data Science Project Example Walk-through: Predictive Analytics on London Cycle Hire Data using the CRISP-DM and TDSP process models: #2 Waterfall v Agile (Scrum v Kanban)

In Part #1 – Backgrounder we covered a basic introduction to CRISP-DM and Microsoft TDSP, in this article we put our project framework in place. As Benjamin Franklin said, “By failing to prepare, you are preparing to fail”; I wasn’t expecting to talk about the project management side in a lot if any detail but after I… Read More »

Read more
Agile Data Science, Data Science, Example, Kanban Board, Modelling, SQLFAQ

Data Science Project Example Walkthrough: Predictive Analytics on London Cycle Hire Data using the CRISP-DM and TDSP process models: #1 Backgrounder

I’m embarking on a series of articles covering an end to end example of applying Data Science to a problem, we don’t just throw at data into a tool, like any other form of development work we follow a standard process, in the data space there are just a handful of process models to guide us through… Read More »

Read more
Data Science, Example, Modelling, SQLFAQ

SQL Server – Making Backup Compression work with Transparent Data Encryption by using Page Compression

Encrypted data does not compress well if at all so using the BACKUP with COMPRESSION feature will be ineffective on an encrypted database using Transparent Data Encryption (TDE), this post deals with a method of combining Page Compression with TDE and getting the best of both worlds. Transparent Data Encryption (TDE) feature encrypts data at rest i.e.… Read More »

Read more
Engine, SQLFAQ

SQL Cardiff

SQL Cardiff is a group dedicated to bringing it’s members more knowledge about SQL Server whether it’s straight database administration & development, business intelligence, or using it in scalable or cloud-based solutions. We have evening events every other month with two or three speakers on different topics, 6sq ft of pizza and plenty of opportunity to chat and network. The […]

Read more
User Groups, Wales

SQL Midlands

We normally hold meetings every other month, after work in the centre of Birmingham, usually on a Thursday. It’s an informal gathering of like minded people, with a couple of speakers presenting tips, techniques and information on old, new and upcoming technology. We like to get a mixture of world leading speakers as well as providing an opportunity for our members […]

Read more
England, Midlands, User Groups
1 2