Sql Server Profiler allows to read *XML exported files from MS SQL Server Profiler *TRC files.
Those trace files can have fields filtered using bash *NEW.XML files.
Those light files can be opened using MS Excel and be saved as *NEW.XLS files.
Sql Server Profiler allows also to read reagular *NEW.XLS result files from Sql queries.
SqlServerProfiler can read *NEW.XLS files into a a data frame to start treatment in R.
This also does the graphics and all for static objects on the data base.
R version 3.3.0 (2016-05-03)
Platform: x86_64-w64-mingw32/x64 (64-bit)
Running under: Windows >= 8 x64 (build 9200)
- LC_COLLATE=English_United States.1252
- LC_CTYPE=English_United States.1252
- LC_MONETARY=English_United States.1252
- LC_NUMERIC=C
- LC_TIME=English_United States.1252
- stats
- graphics
- grDevices
- utils
- datasets
- methods
- base
- xlsx_0.5.7
- xlsxjars_0.6.1
- rJava_0.9-8
- wordcloud_2.5
- RColorBrewer_1.1-2
- tm_0.6-2
- NLP_0.1-9
- gridExtra_2.2.1
- ggplot2_2.1.0
- tibble_1.2-12
- data.table_1.9.8
- RevoUtilsMath_3.2.5
- Rcpp_0.12.8
- knitr_1.15.2
- magrittr_1.5
- munsell_0.4.3
- colorspace_1.2-6
- stringr_1.1.0
- plyr_1.8.4
- tools_3.3.0
- parallel_3.3.0
- grid_3.3.0
- gtable_0.2.0
- htmltools_0.3.5
- yaml_2.1.14
- assertthat_0.1
- rprojroot_1.1
- digest_0.6.10
- slam_0.1-34
- evaluate_0.10
- rmarkdown_1.2
- stringi_1.1.2
- scales_0.4.1
- backports_1.0.4
R followed S. The S language was conceived by John Chambers, Rick Becker, Trevor Hastie, Allan Wilks and others at Bell Labs in the mid 1970s. S was made publically available in the early 1980's. R, which is modeled closely on S, was developed by Robert Gentleman and Ross Ihaka in the early 1990's while they were both faculty members at the University of Auckland. R was established as an open source project (www.r-project.org) in 1995. Since 1997 the R project has been managed by the R Core Group. When AT&T spun of Bell Labs in 1996, S was no longer freely available. S-PLUS is a commercial implementation of the S language developed by the Insightful corporation which is now sold by TIBCO software Inc. The R Core Group: http://www.r-project Download R: http://cran.r-project.org/
R is an interpreted functional language with objects. The core of R language contains the
data manipulation and statistical functions.
Most of R's capabilities are delivered as user contributed packages that may be downloaded from CRAN.
R ships with the "base and recommended" packages:
http://cran.r-project.org/doc/FAQ/R-FAQ.html#Which-add_002don-packages-exist-for-R_003f
What is R? the movie: http://www.youtube.com/watch?v=TR2bHSJ_eck Search for R topics on the web: http://www.rseek.org Search or R packages: http://www.rdocumentation.org A list of R Resources: http://www.revolutionanalytics.com/what-is-open-source-r/r-resources.php Quick R: http://www.statmethods.net/ R Reference Card: http://cran.r-project.org/doc/contrib/Short-refcard.pdf An online book: http://www.cookbook-r.com/ Hadley Wickham's book, Advanced R: http://adv-r.had.co.nz CRAN Task Views: http://cran.r-project.org/web/views/ Some help with packages: http://crantastic.org/ The BIOCONDUCTOR PROJECT FOR GENOMICS: http://www.bioconductor.org/
Revolutions blog: http://blog.revolutionanalytics.com/ RBloggers: http://www.r-bloggers.com
The code has been quickly written to publish a story as rapidy as possible. No guarantee is offered of its completeness, correctness or up-to-date nature. No liability is accepted for damage or loss incurred from the use of this script or the information drawn from it. This exclusion of liability also applies to third-party content that is accessible via this offer.
Licensed under a MIT License.
Enrique dot Escobar @ Askida dot com