ONLY Architect Level Certification in Ireland
When Bob Duffy left Microsoft as a Senior SQL Consultant and subject matter expert for DW/BI in 2008, prodata became the SQL Centre of Excellence with a focus on SQL Server and Business Intelligence. We have architects and consults certified to the very highest levels on the Microsoft Platform for SQL Server achieved by only a handful globally.
We have been working on the SQL Server platform for over about 25 years with hundreds of engagement across Ireland for enterprise customers.
Experts at bring the SQL Platform to Azure
Running the SQL platform on azure can be challenging, whether you are just running traditional SQL in VMs (IaaS), running SQL DB (PaaS), or going the whole hog and running the scale out data warehouse Synapse (aka sqldw). In particularity you need to a good understanding of how resources and throttling affect your solution and capacity planning.
Regardless of the flavor of azure we can help implement and optimize having been involved in many Azure database projects and advanced tuning projects.
Some relevant presentations below:
SQL Storage Fundamentals for Azure IaaS
https://slideplayer.com/slide/14063867/#
Migrating SQL to the Cloud
https://slideplayer.com/slide/11189220/
SQL Performance and Scalability Exports
Over the last 10+ years, Prodata have performed hundreds of SQL engagements related to performance tuning, scalability, load testing, migration, consolidation, and enterprise Architecture.
Within a very short amount of time we can provide analysis and recommendations on any type of SQL performance issue. we also produce a comprehensive report on top issues, impact and recommended mitigation steps. Where design or coding changes are required we can woth with your development team to help explain issues and recommended changes.
If you have a SQL DBA in Ireland then chances are they will know us, worked on a Project, or at least attended some of our events.
Below is a presentation on us taking an OLTP from 100 to a million Transaction Per Minute
https://sqlbits.com/Sessions/Event14/Scaling_the_DVD_Store_from_100_to_a_million_TPM
Another presentation optimizing dot.net data access strategies
https://sqlbits.com/Sessions/Event9/SQL_tuning_from_the_dot_net_perspective
Community Recognition
Here at Prodata we help run the SQL Ireland user group with initiatives such as SQL MasterClass, regular meetups and annual conferences such as SqlSaturday and Data Ceili.
From 2008 Bob Duffy has been awarded MVP in Data Platform from Microsoft for community services such as speaking at International / local events and organizing events for the Irish data community.
SQL Server Related Blog Posts
DW Automation demo for Synapse SQL Pools (3/3)
This is the third blog in a series looking at the need for DW Automation focusing on Synapse SQL Pools (dedicated). In the first blog we looked at why we need DW Automation tools and what they look like:https://prodata.ie/2021/09/14/the-need-for-dw-automation-1-3/In the…
Do we need to maintain Columnstores in SQL Pools ?
TLDR The short answer is YES – if you have >= 60 million rows, then a poorly maintained column store was 100% slower due to trim fragmentation and 64% slower due to the delta row store with some updates in…
Top 10 SQL Partition Commandments
I wrote this in 2010, before Clustered Column Store Indexes, SQL Pools (so rule 3 looks a bit odd), and before date data type was mainstream, but the rest of these still look quite Thou Shalt use something that exists…
Top 10 SSIS/DW Commandments
Blast from the past. I wrote this is 2008 and at one point we had it made into a poster for the office rule whereby on code review we not say a word but just point to the poster. Not…
Standalone or Integrated flavour of your Dedicated Pool (sqldw)
Now that MSFT have released Synapse as an Integrated framework of tools for Data Engineering we have two different ways to provision our enterprise data warehouse in a dedicated sql pool. Which is the best one to use ? Firstly…
Synapse TSQL: variable assignment in SELECT statement cannot be included
When working with synapse as a TSQL developer, it does feel like you’ve gone in a time warp back to SQL 7.0 in terms of whats supported and whats not. Luckily most of the TSQL patterns not supported have some…
Why I’m looking forward to Data Ceili–Dublin 2020
Coming off the tails of the hugely successful SQL Saturday Dublin events, Data Ceili – Dublin 2020 is shaping up to be Irelands largest Microsoft Data Platform event. We still have till then end of Jan 2020 for speaker submissions…
Automating SSIS Build and Deployment with Powershell
Inspired by the DBA tools (https://dbatools.io/) library for automating all things SQL Server DBEngine I created some Powershell Library functions to automate SSIS Build and Deployment. We use this on projects to move SSIS closer to the world of DevOps…
Cannot Start PolyBase Services
One of my pet hates attending SQL talks is when the “expert” speaker spends most of the time blabbing on about “install” and “configuration” difficulties they had. It kinda paints a picture that they probably haven’t actually done much with…
Should I rent or buy SQL Licenses in the Cloud ?
If you are looking at running SQL Server in the cloud a key question you will ask is “Should I rent or Buy” SQL licenses. E.g. should you use the stock images and pay by the hour or should you…
Travelling to the Sql Saturday Hotel from Dublin Airport
If you are coming in from Dublin Airport there are a few options on getting to the Hilton hotel, Charlemont for Sql Saturday Dublin 2014 http://www.sqlsaturday.com/310 By Taxi There is a taxi rank to your right as you exit the…
Speaker Line Up for #SqlSatDublin 19th/20th Sept 2014
The speaker line up for #SqlSatDublin is announced with some 29 speakers including: 7 Speakers from MSFT including a principal architect on the SQL team.15 MVP’s from around the globe.3 SQL MCMs.2 Instructors from the SSAS Maestro course. To the…
Loading…
Something went wrong. Please refresh the page and/or try again.