Steven is a data scientist and a Microsoft Certified Solution Expert on Data Platform, MCSA on SQL server 2008/12 and MCITP on BI Developer, Database Developer and DBA.
He is very passionate about data insights, machine learning and MS SQL server technology and business intelligence and has designed and implemented a number of large scale enterprise BI solutions in a variety of industries.
Steven is an active SQL server community participant. He answers questions at MSDN SQL server forum and speaks at events like TechEd, CodeCamp, SQL User Group etc.
Steven is currently a Senior Manager, Data Analytics at IMS Health AUNZ.
Tweets by @msbicoe
Posted in: Data Cleaning | Big Data | Data Load | Machine Learning | Random Forest | RPART | Predictive Analytics | R
Tags: Random Forest, Machine Learning, Predictive analysis
Thanks all for attending my session at Auckland MS CodeCamp Summit 2011.
Please see the attached slides and code presented in the session.
Minimal_logging_maneuvering_data.pptx (2.50 mb)
01_Full_vs_Minimal.sql (3.02 kb)
02_Heap_Tablock_On_Off.sql (1.09 kb)
03_Clustered_Tablock_On_Off.sql (1.21 kb)
04_Clustered_trace610.sql (1.46 kb)
Posted in: Data Load | Data warehouse | Transaction Log
Tags: Trace Flag 610, Data warehouse Data Loading, minimal logging, database log