This week Stack Overflow shared a blog post titled Stack Overflow Isn’t Very Welcoming. It’s Time for That to Change. I admire the courage and the transparency a great deal. It takes guts to admit mistakes and serious guts to publicly air the dirty laundry. Kudos to Stack Overflow. Why I Stopped Contributing to the Stack Overflow Conversation I …
Continue reading Stack Overflow Wants to Change
Who is Exhibiting at the PASS Summit 2018? Enterprise Data & Analytics, That’s Who!
I am honored and excited to announce that Enterprise Data & Analytics will be an exhibitor at the PASS Summit 2018! If you browse on over to the PASS Summit Sponsors page and scroll to the Exhibitors section, you’ll find us listed: Honored and excited – that’s me! I see – and have lived – …
Continue reading Who is Exhibiting at the PASS Summit 2018? Enterprise Data & Analytics, That’s Who!
Deploying to the SSIS Catalog Changes the Protection Level
I recently answered a question on the SQL Community Slack #ssis channel about SSIS and security. Let me begin by stating that SSIS security is complex, made up of many moving parts, and not trivial. If you struggle with SSIS security configuration, you are struggling with one of the harder parts of SSIS. Protection Level …
Continue reading Deploying to the SSIS Catalog Changes the Protection Level
Honored to be a Certified Microsoft Big Data Professional
I’m so excited and honored to be a Microsoft Certified Big Data Professional! I enjoyed the courses and learned a lot the past seven months. It was super cool to work with Frank La Vigne – co-host of the Data Driven podcast – on the capstone project. (Any time I get to work with Frank, it’s …
Continue reading Honored to be a Certified Microsoft Big Data Professional
Data Flow Buffer Size
I started answering a question on SQL Community Slack’s #ssis channel and I realized this would be better served as a blog post. The question was about three SSIS Data Flow properties: DefaultBufferSize, Engine Thread and DefaultBufferMaxRows. I rarely change the EngineThreads property. DefaultBufferSize and DefaultBufferMaxRows are two ways of managing the size limits of a Data …
Continue reading Data Flow Buffer Size
Completed: Microsoft Big Data Professional Program Capstone Project
I’m excited to announce that I’ve completed – with help from my friend and brother and co-host of the Data Driven podcast, Frank La Vigne (Blog | @Tableteer) – the Microsoft Big Data Professional Program Capstone project! The capstone is the last course requirement (of 10 courses) to complete the Microsoft Professional Program in Big …
Continue reading Completed: Microsoft Big Data Professional Program Capstone Project
Honored to Deliver Intelligent Data Integration – a PASS Summit 2018 Precon
I’m honored to deliver my full-day precon, Intelligent Data Integration with SSIS, at the PASS Summit 2018! You can see a list of other precons at the PASS Summit 2018 Pre-Conference Sessions page. I refer to this group as “a bunch of really smart people… plus me!” Abstract What is Intelligent Data Integration? SSIS (SQL Server …
Continue reading Honored to Deliver Intelligent Data Integration – a PASS Summit 2018 Precon
Honored to Present Faster SSIS at SQL Saturday Albuquerque on Cinco de Mayo!
I am honored to present Faster SSIS at SQL Saturday #720 – Albuquerque 5 May 2018! Abstract Ever wonder why SSIS runs so slow? Watch SSIS author Andy Leonard as he runs test loads using sample and real-world data and shows you how to tune SQL Server 2016 Integration Services (SSIS 2016) packages. We’ll start …
Continue reading Honored to Present Faster SSIS at SQL Saturday Albuquerque on Cinco de Mayo!
Experience Matters
This is a picture of Kent Bradshaw, Microsoft Certified Data Scientist. Kent and I work together at Enterprise Data & Analytics delivering data engineering, business intelligence, and data-based solutions that help businesses turn their data into actionable information. We do not do this alone, we are surrounded by an excellent team that holds diverse skills, …
Continue reading Experience Matters
The Recording for Introduction to Loading the Cloud with SSIS is Now Available
The recording for the free webinar titled Introduction to Loading the Cloud with SSIS is now available (registration required). Abstract The cloud is coming, ready of not. In this session, presenter and author Andy Leonard discusses and demonstrates some patterns for loading cloud destinations using SSIS. For more information on data integration in the cloud, …
Continue reading The Recording for Introduction to Loading the Cloud with SSIS is Now Available