블로그 이미지
010-9967-0955 보미아빠

카테고리

보미아빠, 석이 (500)
밥벌이 (16)
싸이클 (1)
일상 (1)
Total
Today
Yesterday

달력

« » 2024.4
일 월 화 수 목 금 토
1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30

공지사항

최근에 올라온 글

AdventureWorks2008R2 스크립트

카테고리 없음 / 2011. 5. 18. 13:50

instawdb.sql

1. http://msftdbprodsamples.codeplex.com/releases/view/55926 다운로드
2. 압축풀기 (실행하지 말고....)
3. blog 에 첨부된 instawdb.sql 편집 (데이터베이스 경로와 로딩할 csv 위치 수정)
4. sqlcmd 모드에서 돌리면 되며, filestream 과 fulltext 기능은 제외한 버전이다.

filestream 이랑 fulltext 같은 기능은 쓸일 없는데 노트북에 못 깔겠다.

Posted by 보미아빠
, |

PowerPivot

카테고리 없음 / 2011. 5. 17. 21:38

Demo: Self-Service Analysis with SQL Server 2008 R2 PowerPivot for Excel 2010

 

예제
http://channel9.msdn.com/Blogs/rdoherty/Demo-Self-Service-Analysis-with-SQL-Server-2008-R2-PowerPivot-for-Excel-2010


파워피봇 설치
http://www.microsoft.com/showcase/ko/kr/details/dda64af2-052c-4e6c-ba93-10c722cc82b5

powerpivot website
http://www.powerpivot.com/
powerpivot dax information
http://www.powerpivot-info.com
Team Blog
http://blogs.msdn.com/powerpivot

dax example
http://www.powerpivot-info.com/post/744-video-enriching-your-bi-semantic-models-using-da

User Name: guest@cfq965

Password: Pass@word1

Posted by 보미아빠
, |

심심할때 놀곳들

카테고리 없음 / 2011. 5. 17. 21:19

Blogs from the SQL Server team SQL Azure Bloggers OPML

SQL Server Online Resources: CTP, Troubleshooting | Microsoft MSDN

#
PSS SQL Server Engineers
SharePoint Adventures : ADFS Setup – Part 1
Monday, May 16
#
Development Customer Advisory Team
Announcing SSAS Maestros v1.2
Wednesday, May 11
#
Buck Woody - DBA
Computer books are dead. Well, some of them, anyway.
Tuesday, May 10
#
SQL Server Security
Integrity checks with EncryptByKey
Tuesday, Apr 5
#
PowerPivot Team Blog
PowerPivot TechCenter
Tuesday, Feb 22
#
SQL Server Manageability Team Blog
T-SQL IntelliSense enhancements in SSMS –Denali
Tuesday, Jan 4
#
SQL Server User Education
Watch new PowerPivot Videos on TechNet Wiki
Wednesday, Aug 18
#
Euan Garden
When is a bug a bug and when is it an incomplete feature
Tuesday, Apr 21

Community Blogs SQL Azure Bloggers OPML

SQL Server Online Resources: CTP, Troubleshooting | Microsoft MSDN

#
Kevin Kline
From SQLMag Tool Time Column: SSMS Plug-in News
Thursday, May 12
#
Phil Brammer
Quick Tip: Error: 18456, Severity: 14, State: 38.
Friday, May 6
#
Adam Machanic
Twenty Nine Days of Activity Monitoring (A Month of Activity Monitoring, Part 30 of 30)
Saturday, Apr 30
#
Tibor Karaszi
Restricting memory using Resource Governor
Tuesday, Apr 19
#
Andrew Kelly
New Book on the Query Optimizer
Saturday, Apr 9
#
Linchi Shea
Linked servers: set them up in QA
Tuesday, Apr 5
#
Kalen Delaney
Geek City: What gets logged for SELECT INTO operations?
Tuesday, Mar 15
Posted by 보미아빠
, |

최근에 달린 댓글

최근에 받은 트랙백

글 보관함

티스토리툴바