MS BICOE All about data​: dig, distill, visualize, prognosticate & prescribe

  • Home
  • Archive
  • My Moments
    • Anna Bay and Camel Riding at Port Stevens
    • Sunset at Berowra Waters Lookout
    • Sydney Harbor View and Dishes at Altitude Restaurant
  • Contact

Steven Wang - 汪上洲

Steven Wang - Data Scientist

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 head of data science at QuintilesIMS at Sydney Office.

Tweets by @msbicoe

Month List

  • 2018
    • April (1)
  • 2016
    • February (2)
    • January (1)
  • 2015
    • December (1)
    • November (1)
    • March (1)
  • 2013
    • May (1)
    • April (1)
  • 2012
    • December (1)
    • November (1)
    • September (1)
    • July (1)
    • May (1)
    • April (6)
    • March (1)
  • 2011
    • December (1)
    • October (3)
    • August (1)

Categories

  • RSS feed for  Data Cleaning Data Cleaning (2)
  • RSS feed for BackupBackup (3)
  • RSS feed for Big DataBig Data (1)
  • RSS feed for Columnstore IndexColumnstore Index (4)
  • RSS feed for Data ExplorerData Explorer (2)
  • RSS feed for Data LoadData Load (2)
  • RSS feed for Data warehouseData warehouse (2)
  • RSS feed for Database AdministrationDatabase Administration (4)
  • RSS feed for DQSDQS (1)
  • RSS feed for IndexesIndexes (1)
  • RSS feed for Machine LearningMachine Learning (1)
  •    RSS feed for Random ForestRandom Forest (1)
  •    RSS feed for RPARTRPART (1)
  • RSS feed for Master Data ServiceMaster Data Service (1)
  • RSS feed for NLPNLP (1)
  • RSS feed for Power BIPower BI (1)
  • RSS feed for Power ViewPower View (1)
  • RSS feed for Predictive AnalyticsPredictive Analytics (1)
  • RSS feed for RR (2)
  • RSS feed for SQL Server 2012SQL Server 2012 (8)
  • RSS feed for SQL Server ProfilerSQL Server Profiler (1)
  • RSS feed for SQL Server SecuritySQL Server Security (1)
  • RSS feed for SSASSSAS (1)
  • RSS feed for SSISSSIS (4)
  • RSS feed for Trace FlagTrace Flag (2)
  • RSS feed for Transaction LogTransaction Log (2)
  • RSS feed for TriggersTriggers (1)
  •    RSS feed for T-SQLT-SQL (7)
  • RSS feed for Window FunctionsWindow Functions (2)

Calendar

<<  January 2021  >>
MonTueWedThuFriSatSun
28293031123
45678910
11121314151617
18192021222324
25262728293031
1234567

View posts in large calendar

Prediction of Correctness on Barbell Lifting Exercise Based on Accelerometer Data

November 24, 2015 at 2:45 AM — Steven Wang

26ec28ae-affc-4358-9bce-86b428f253f0|3|3.0|96d5b379-7e1d-4dac-a6ba-1e50db561b04

Posted in: Data Cleaning | Big Data | Data Load | Machine Learning | Random Forest | RPART | Predictive Analytics | R

Tags: Random Forest, Machine Learning, Predictive analysis

Submit to DotNetKicks...
Permalink | Comments (0)

Minimal Logging & Data Manoeuvring On very Large Tables

August 28, 2011 at 10:53 AM — Steven Wang

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)

df139ee6-d290-4b90-ae40-73edb74faeb1|1|5.0|96d5b379-7e1d-4dac-a6ba-1e50db561b04

Posted in: Data Load | Data warehouse | Transaction Log

Tags: Trace Flag 610, Data warehouse Data Loading, minimal logging, database log

Submit to DotNetKicks...
Permalink | Comments (0)
Newer posts >>
Copyright © MSBICOE 2016 reserved by Steven Wang

Search Site


---------------------------

My Links

  • Paul S. Randal
  • Kimberly L. Tripp
  • Sunil Agarwal
  • Adam Machanic
  • Denny Lee
  • Ola Hallengren
  • Jacob Sebastian
  • Marco Russo
  • Greg Low
  • Kalen Delaney
  • Mosha Pasumansky
  • Itzik Ben-Gan
  • Bob Beauchemin
  • Glenn Berry
  • Juergen Thomas
  • SQL Server Team Blog
  • SQL Server Security Team Blog
  • CSS SQL Server Engineers
  • Suhas De
  • Thomas Kejser
  • SSIS Team Blog
  • SSQA.net
  • SQL Server Performance
  • Cathy Dumas
  • Chris Webb
  • Tim Mallalieu
  • Denny Cherry
  • Jamie Thompson
  • Jorg Klein
  • Aaron Bertrand
  • Alex Tcherniakhovski
  • Matt Masson
  • SSAS and Powerpivot Team Blog
  • Joe Chang
  • James Serra
  • Jeffrey Wang
  • Boyan Penev
  • Thomas.I Micosoft BI
  • Kasper De Jonge
  • Microsoft BI Blog
  • SSRS Team Blog
  • Jonathan Kehaiyias
  • Joe Sack
  • John Huang
  • SQLCAT Blog
  • SQL Server Blogs
  • Sakthi's SQL Server Channel
  • SQL Server Manageability Team
  • Sean Boon
  • Peter Larsson
  • Bill Ramo
  • Jen Underwood
  • Cindy Gross
  • Cathy Dumas New
  • Samuel Lester
  • Data Visualization
  • Matthew Roche
  • Brent Ozar
  • Grant Fritchey
  • Data Explorer Preview
  • Maria Esteban
  • Nikoport
  • Andrew Pandre
  • TechPedia
  • Andrew Jaffe
  • Boris Evelson Analyst blog
  • Frank Mercier
  • WelslyB Blog
  • Paul Turley
  • Gil Raviv - DataChant