Thursday, October 30, 2008

New SQL Skills I have learned from jobs - Part 1

I initlaly thought SQL Server was all about Transact SQL (T-SQL) programming and development, as that was how I started working with SQL Server 2000, extensively.

Then, last couple years I have came across opportunities at work to expand my knowledge of SQL Server to just about everything (shows you how little I knew)

Let's take a walk down memory lane by SELECT Name, Skills FROM Memory (NOLOCK) ORDER BY [Date] DESC

SQL Server Reporting Service (SSRS)

  • Developed over 100 SSRS 2005 reports from scratch
  • Learned by reading the books (very helpful) and reading online contents
  • Deployed and integrated with SharePoint intranet
  • Email subscriptions to management
  • SSRS was quite powerful for a free product, almost can replace Crystal Reports easily
SQL Service Analysis Service (SSAS)

  • Followed the book and built a demo Datawarehouse with Cubes and Dimensions, Slice & Dice!
  • Connected SSRS report to report off the Cube and Dashboard/KPI
  • Unfortunately didn't have the opportunity to fully try the Analysis models or Decision Trees to "predict future" from the history. That would've been very cool and helpful for business sales
More to comment later:
  • High Availability Features - Mirroring and Log Shipping
  • XML/XQuery
  • SQL Server 2008 Spatial Index
  • SQL Server 2008 Full-Text Search
  • SQL Server Integration Service

No comments:

Post a Comment