Andre Kamman

André is a Data Platform MVP. He has done a lot of DBA work on 1000’s of servers where he discovered his love for Powershell, Azure DevOps, Python, Azure DW and Databricks. He loves to tinker with 100TB+ databases.
André is a Data Platform MPV, Dutch PASS Chapter Leader and involved in organizing Data Saturday Holland and Techorama Holland

Andre Kamman's Sessions

Visualizing performance tuning dataSQLBits 2015

Over the years I've tried various ways to look at output from SQL Server for performance tuning reasons. We will look at virtual_file_stats, waitstats, the buffer cache etc. and we will visualize them in various ways

ORM Tuning From A Database PerspectiveSQLBits 2015

Most ORM's tend to be very chatty and generate complex queries. In this session we will look at optimizing database access in ORM's. Using Nhibernate, LINQ &Entity Framework in the demos, we will examine how your ORM talks to the database and why.

Build your own Monitoring Environment with PowershellSQLBits 2015

Learn how to write Powershell that will use Remoting to run scripts parallel on any number of servers. We'll talk about remoting, background jobs and how to collect and report on the results

How to write professional Powershell scriptsSQLBits 2014

It's time to take your ad-hoc Powershell scripts turn them into your very own module. And while we're at it we will add proper error handling, parameterization & pipeline support. I will also demonstrate how to build help, force and whatif support.

Running SQL Server 2014 on a Scale Out File ServerSQLBits 2014

In this session I will show you how to use Storage Spaces and Auto Tiering and some other features to build a highly available, fast, scale out file server. And then we'll use it to host SQL Server data & log files on it.

ETL shootout-SSIS vs PowershellSQLBits 2013

I know what you're thinking, Powershell is not an ETL tool. And you're probably right. But I keep running into weird requests that were just easier to fix with Powershell. I'll show you why some things are not easy in SSIS.

A better SSIS? Migrating a datawarehouse to SQL Server 2012SQLBits 2012

SSIS in SQL Server 2012 has a lot of new features to help control larger projects. I'm doing a trial migration of our datawarehouse (100+ packages, 1TB+ db size) This session will be a will be a walkthrough of this process and a lessons learned

How DBAs can use PowerPivot for Performance Tuning / TroubleshootingSQLBits 2011

PowerPivot can be a great troubleshooting / performance tuning tool for a dba besides just loading all the data in a database and start querying. I'll show the pro's and cons of PowerPivot while trying work with waitstats, profiler data etc.

RoboDBASQLBits 2011

I'll explain how to manage a large environment of 400+ instances in such a way that it's also useful if you have only 5 instances. Expect 50% processes and war stories and 50% demos and scripts (lots of PowerShell of course, but not everything)

Automating SSISSQLBits 2010

I had to import and process 100+ files for my latest project and wondered if there was a way to generate SSIS packages based on a repository table containing the rules. As it turns out, this can be done but the programming model is a bit awkward. The samples that you can find online are not allways functional and debugging is difficult. I did get it to work though and will show you how I did it and what problems I ran into. After this session you will know how to generate packages that contain sources, destinations, cached lookups, derived columns, conditional splits, sorts, union all, etc. This session is not about the script component inside SSIS but about generating SSIS packages and programmatically reading and changing properties of existing packages.This session should also be usefull if you're not a full blown developer but more of a DBA type. I'm a DBA and I got through this :-)