Usability and Security – an oxymoron?

by Kalai Elumalai – Data Platform Solution Architect This article attempts to answer, Why Enterprise Architects should care about usability and security controls? How the latest features in SQL Server 2016 (and Azure SQL Database) can help to address those challenges? Usability and Security: I recently attended a course (one of the best I’ve been…

0

Using a ‘User Query Store’ for Exceptions and Timeouts

by Mike Boswell – Data Platform Solution Architect. In the previous post, I mentioned that as a Data Solution Architect we regularly work with clients to pilot new data platforms and with SQL Server 2016 an increasing number of clients are looking to modernise those SQL Platforms. We spoke of how you could create a…

0

Exporting SQL Server 2016 Query Store

By Mike Boswell – Data Platform Solution Architect. As a Data Solution Architect, we regularly work with clients to pilot new data platforms and with SQL Server 2016 an increasing number of clients are looking to modernise their SQL Server, Oracle and DB2 Platforms. During the piloting phase we will run performance labs and pilot…

0

The case for building a consolidated SSIS environment

By Jonathan Ball – Data Platform Solution Architect. SQL Server Integration Services, SSIS, can be memory intensive, CPU hungry and will generally want to max out the server that it is running on. Your typical DBA is not going to want this running on the same server as the database engine taking up resources and…

0

Live Query Statistics

By Mike Reed – Data Platform Solution Architect. So you work in an organisation who run ‘mission critical’ applications but don’t want to pay for tooling. You know, they want you to keep the lights on but won’t invest in any of the great 3rd party monitoring tools that Microsoft’s partners have written to make…

0

Power BI in Your Organisation

By Michael Robson – Technical Solution Professional (Data Platform / BI). Since the launch of Power BI last July there’s been a lot of interest and, it’s fair to say, a lot of confusion as to exactly what Power BI is and where it fits. Is it Microsoft’s replacement for SSRS? Do I need Office365?…

0

Moving Schema and Data: SQL Azure Migration Wizard

By Dan Stillwell – Data Platform Solution Architect. In my previous blog I wrote about a scenario where one of my customers wanted to utilise the flexibility of Azure for their SQL Server provisioning. The deployment started as a POC but very quickly became more than that with senior members of the organisation using the…

0

Transactional Replication Using an Azure SQL Database Subscriber

By Graeme Scott – Data Platform Solution Architect. For companies that have geographically dispersed operating models which may involve physical stores, outlets, venues or branches; data replication from individual stores to data centres is often a key technical function that enables companies to measure overall business performance. It is not uncommon for geographically dispersed companies…

1

Back on the mat

By Craig Clayton – Technical Solution Professional. I recently went back to Brazilian jiu-jitsu after a lay off due to injury (due to old age!). BJJ is a ground based martial art that “promotes the concept that a smaller, weaker person can successfully defend against a bigger, stronger, heavier assailant by using proper technique, leverage,…

0

Quick way of achieving HA when a POC becomes dependable to the business!

By Dan Stillwell – Data Platform Solution Architect. The great thing about Azure is the flexibility that it offers to customers and how they can use it. I have been working with customers who have various levels of strategy when it comes to the cloud, some customers are actively moving workloads, whilst others are testing…

0