Tuesday, July 9, 2013

MSSQL Server 2008

p.103. CH 7. Partitioning

p.219. CH 15. DB snapshots. CREATE database AS Snapshot

p.375. Part VII. Business Intelligence.
CH24. SSIS - SQL Server Integration Services
CH25. SSRS - SQL Server Reporting Services
CH26. SSAS - SQL Server Analysis Services

SSMS - SQL Server Management Studio

Big Data for Dummies

- Part I. Big Data. 3 characteristics: volume, velocity, variety
   - technology: MapReduce, BigTable, Hadoop (started at Yahoo)
- Part II. Tech foundations. p. 68. Hypervisor
   - cloud: Amazon (EC2, 2006), Google (Big Data), MS (Azure), Rackspace, NASA (OpenStack).
- Part III. Management
   - CH 7. Relational Database. CRUD, ACID.
                Non-relational Database.
   - CH 8. MapReduce
   - CH 9. Hadoop
- Part IV. Analytics & Big Data
   - p.145. Data Mining: classfication, log regression, NN, clustering (k-means etc).

Some C#, ASP.NET and SQL books

Browsed some C#, ASP.NET and SQL books. Quickly get through large amount of material, to review and refresh old knowledge, and gain an understanding of new advancement. Most of these books are written for beginners. However, each more or less covers things I did not notice in the past.

- ASP.NET 2.0 in C# 2005
- Learn Microsoft Visual C# 2010. By John Paul Mueller
- murach's ASP.NET web programming with C# 2010, 4th Edition.
- Visual C# 2008. By John Sharp
- Visual C# 2012. By John Sharp. (This book is a minor update from the 2008 version)
- Sams Teach Yourself SQL in 24 hours
- MS SQL Server 2008, by Mike Hotek.
- Big Data for Dummies

Long words short, ASP.NET evolution (see wiki page on ASP.NET):

- 2002.1   1.0  OO, based on windows programming, can use DLL. ADO.NET. VS.NET
- 2003.4   1.1  Automatic input validation; mobile controls. Bug fix, performance increase. VS.NET 2003.
- 2005.11  2.0 Major updates: Partial class, Generics, Anonymous methods, Iterators, master page, theme, navigation, Grid/Form/DetailsView, Login, skin etc. VS.NET 2005
- 2006.11  3.0 WCF, WPF, WFF,
- 2007.11  3.5 MVC (easier to test and for plugable IoC containers etc.), Silverlight, LINQ, Ajax, ADO.NET Entity Framework, ListView, DataPager etc. VS.NET 2008. Windows Server 2008.
- 2012.4    4.0 Parallel extensions.
- 2012.8    4.5 VS.NET 2012. Windows Server 2012. Window 8.

Wednesday, July 3, 2013

sed

Use sed to replace some string in a large file (example tested is 2GB in size):

sed -i 's/old_value/new_value/g' filename

Some more examples are there. It seems like in vi using "%s/old_value/new_value/g" is much slower.

Saturday, June 15, 2013

Some more books read recently

编程之美.
数学之美. 吴军著.
Big Data (大数据时代, 2013). Viktor Mayer-Schonberger, Kenneth Cukier.
晓说2. 高晓松著.

Blog Archive

Followers