James is a Microsoft Certified Master of SQL Server and has been consulting through his own company for seven years. He started life as a developer over seventeen years ago and has progressed from being an MSCD on Visual Basic 6 to an MCM. In the pie that is SQL Server, he has his fingers in every slice; administration, development, automation, and Azure. He loves nothing more than making things that are large, fast, and low maintenance. He is currently automating an agile metadata-driven Anchor modeling DWH, where all the ETL is automatically generated.
He has presented sessions at SQL Bits, SQL Relay, SQL Saturday, and at SQL User Groups across the country.
James Skipwith has submitted 3 sessions for SQLBits XIV, although the agenda hasn't been chosen yet. See all submitted sessions
Database partitioning. What is it? Do you need it? How do you implement it? With one session dedicated to Standard Edition and one to Enterprise, all will be explained.
Yes, there's more than 3 normal forms and the 6th one is awesome. This session showcases Anchor Modelling and how it enables agile development, low deployment risk, and a scalable architecture that can be scaled out as well as up.
Need to automate a process in your database? Create audit tables, generate stored procedures, or any other type of manually repeatable process? In this session we'll look at how to start and the thought processes and design considerations involved.
Ever had to write a large number of similar stored procedures, audit triggers, archive tables, views, etc.? Let SQL Server do the work for you! With some custom functions, stored procedures and extended properties, this no longer has to be a chore.