'보미아빠, 석이'에 해당되는 글 528건
- 2015.06.20 sql 2012 Developer Training Kit BOM
- 2015.06.19 Complex Event Processing
- 2015.06.16 SSAS Time Series 새 데이터를 이용한 예측
- 2015.06.15 SSAS 로지스틱 회귀분석
- 2015.06.15 Magic Quadrant for Operational Database Management System
- 2015.06.14 마이닝 구조 연속 -> 불연속 속성으로 변경하기
- 2015.06.14 SSAS 선형 회귀분석
- 2015.06.12 날짜
- 2015.06.08 How to (correctly) check file versions with PowerShell
- 2015.06.07 sql server free e-book
Complex Event Processing
https://en.wikipedia.org/wiki/Complex_event_processing
Event processing is a method of tracking and analyzing (processing) streams of information (data) about things that happen (events),[1] and deriving a conclusion from them. Complex event processing, or CEP, is event processing that combines data from multiple sources[2] to infer events or patterns that suggest more complicated circumstances. The goal of complex event processing is to identify meaningful events (such as opportunities or threats)[3] and respond to them as quickly as possible.
These events may be happening across the various layers of an organization as sales leads, orders or customer service calls. Or, they may be news items,[4] text messages, social media posts, stock market feeds, traffic reports, weather reports, or other kinds of data.[1] An event may also be defined as a "change of state," when a measurement exceeds a predefined threshold of time, temperature, or other value. Analysts suggest that CEP will give organizations a new way to analyze patterns in real-time and help the business side communicate better with IT and service departments.[5]
The vast amount of information available about events is sometimes referred to as the event cloud.[1]
Notable vendors and products[edit]
- SQLstream SQLstream’s stream processing platform, s-Server, provides a relational stream computing platform for analyzing large volumes of service, sensor and machine and log file data in real-time.
- Microsoft StreamInsight Microsoft CEP Engine implementation [20]
- openPDC — A set of applications for processing streaming time-series data in real-time.
- Apama - A Complex Event Processing Platform that monitors rapidly moving event streams, detects and analyzes important patterns, and takes action according to rules.[21]
- StreamBase Systems - A visual development platform and high performance event server for rapidly building and deploying real-time event-based applications. - Now Owned by TIBCO Software
- SAP ESP - A low-latency, rapid development and deployment platform that allows processing multiple streams of data in real time [22]
- TIBCO BusinessEvents & Streambase - CEP platform and High Performance Low Latency Event Stream Processing
- WebSphere Business Events
- Informatica RulePoint - High performant, scalable solution by Informatica.
- Drools Fusion
- GigaSpaces XAP
- Oracle Event Processing - A solution for building applications to filter, correlate, and process events in real time.
- Esper Complex event processing for Java and C#.
- Siddhi Complex event processing written in Java. Designed as part of a series of middleware components.
https://www.youtube.com/watch?v=UWq7uSXaoz8 내용중
제품
상용제품
TIBCO : TIBCO BusinessEvents : 업계 최고 제품
StreamBase Systems : StreamBase CEP : 정교한 CEP 제품
SAP : Sybase Event Stream Processor : Sysbase 인수
IBM : InfoSphere Streams : 테러 방지 목적으로 시작 멀티미디어 스트림 프로세싱 가능
Microsoft : StreamInsight :
Informatica : RulePoint
오픈소스
Esper
quick start project https://github.com/tedwon/cep-esper-quick-start
입력 (이벤트를 수집) 어뎁터를 만들어야 함
처리 (실시간 처리)
결과 (다양한 이벤트의 복합 영향도 패턴 인식 등을 구현할 수 있음)
EPL SQL 형식의 Event 처리 스크립트 언어
- Event filtering
- Sliding data windows and aggregation
- grouped windows and output rate limiting
- joins and outer joins
- subquery
- historical or reference data
Event Streams 에서 EPL Statements 를 이용해 데이터를 검색할 수 있음
join 은 RDBMS 나 Apache HBase UDF 와 할 수 있다.
Example
from pattern [a -> (b and c)]
b c 이벤트가 발생하고 a 가 발생하면 알람을 달라 라고 event 의 correlation 을 정할 수 있음
개발전략
모니터링 이벤트 정의
이벤트 타입(포멧) 정의
EPL 정의
output adapter 개발 등록
input adapter 개발 등록
CEP 개발 주요 포인트
Runtime 환경 결정
Zero-downtime 지원 여부 결정
Runtime 시 EPL 업데이트 지원 여부 결정
Event 타입과 용량 결정
솔루션 만들고 JBOSS RHQ 로 모니터링
SSAS Time Series 새 데이터를 이용한 예측
첨부는 실습 메모이다.
틀린부분? 없다.....
https://technet.microsoft.com/ko-kr/library/cc879295(v=sql.110).aspx
https://technet.microsoft.com/en-us/library/cc879295(v=sql.110).aspx
SSAS 로지스틱 회귀분석
msft 로지스틱 회귀분석은 msft 신경망 알고리즘의 한 형태이다. (신경망은 드릴쓰루가 안된다. )
나중에 좀 정리를 해야겠다. 저 표 읽을수 있다는게 참 다행이다. 하하하하하
모델을 만들고
분석하고 1
분석해서 2
예측한다.
Magic Quadrant for Operational Database Management System
https://www.microsoft.com/en-us/server-cloud/products/sql-server/
http://www.gartner.com/technology/reprints.do?id=1-237UHKQ&ct=141016&st=sb
장점은 왠지 저런 기관에서 중요하게 생각하는 기능을 열심히 만들어 넣는듯?한 분위기이고 , 단점은 심각하다. 어플라이언스가 없고(DW제외), 분류는 엔터프라이즈 급 디비라고 하지만 사용자는 엔터프라이즈 어플리케이션에 잘 안쓴다. 2012부터 가격은 돌아버렸고, 아주 정말 아우~~~~ 장난치나...HA/DR 구현이 쉽지 않단다....음? 이건 먼소리지?
아래 표로는 좋아 보이지만 향 후 데이터베이스 시장은 엔터프라이즈 시장과 비 엔터프라이즈 시장으로 길을 나누어 갈 것이고 비 엔터프라이즈 시장은 mysql 이나 다른 무료 데이터베이스를 쓰면 충분하고 (all flash storage 쓰면 속도 아주 좋음 latch 는 설계 잘 하면 회피 할 수 있음) 캐시가 필요한 일반적인 곳은 윗단에 캐싱 레이어만 따로 구축하면 된다.
그나마, 데이터가 중요한 게임사는 가격 정책에 밀려 이미 다 떠나버렸고, mssql을 아직 게임사에 쓰면 개발사가 능력이 없는 것으로 보이고, 커뮤니티 같은 분야는 쓸 이유가 없고, 은행은 또 엔터프라이즈 느낌 안나는 mssql 잘 안쓴다 이말이군..
DB 배우는 사람은 그나마 미션 크리티컬한 곳에서 mssql 쓰는 곳에 취직을 해야 한다는 것인데, 이런곳에 고만 고만한 사람은 안 뽑는다. 과연 살아남을까? 이제 db를 처음 배운다면 잘 선택해야 할 듯 하다. 나는 끝까지 해서 메인프레임 관리자 처럼 되어봐야지 하하하하하하
Microsoft
Headquartered in Redmond, Washington, U.S., Microsoft markets its SQL Server DBMS for the operational DBMS market, as well as Microsoft Azure SQL Database (a database platform as a service) and Microsoft Azure Tables. Microsoft now has in-memory row-store technology for transactions in SQL Server 2014.
Strengths
- Market vision: Microsoft's market-leading vision consists of in-memory computing (SQL Server 2014 now has full transaction in-memory support), NoSQL (with a new document-store DBMS), cloud offerings (both cloud-only and hybrid cloud), use of analytics in transactions (HTAP) and support of mobility. Its vision for in-memory computing and putting the "cloud first" is ahead of its competitors.
- Strong execution: Microsoft SQL Server is an enterprisewide, mission-critical DBMS capable of competing with products from the other large DBMS vendors. Gartner's 2013 market share data shows Microsoft taking second place from IBM in terms of total DBMS revenue.
- Performance and support: Reference customers were very positive, with the performance of SQL Server, documentation, support, ease of installation and operation all rated highly. Only 7% reported problems with the DBMS overall.
Cautions
- Lack of an appliance: Microsoft still lacks an appliance for transactions (one comparable to its SQL Server Parallel Data Warehouse appliance), whereas its major competitors (IBM, Oracle and SAP) all offer one.
- Market image: Although SQL Server is an enterprise-class DBMS, Microsoft continues to struggle to dispel a perception of weakness in this area. Inquiries from Gartner clients demonstrate a continuing perception that SQL Server is not used for mission-critical enterprisewide applications — a view that inhibits wider use of SQL Server as a primary, enterprise-class DBMS.
- HA/DR and pricing issues: Reference customers again found the pricing model for SQL Server unacceptable (they gave it the lowest overall rating of any vendor in this Magic Quadrant) and blamed the price changes that came with SQL Server 2012. Microsoft also received one of the lowest overall scores for ease of implementing HA/DR.
마이닝 구조 연속 -> 불연속 속성으로 변경하기
연속된 값을 discretized 로 구간을 만들 수 있다.
아래와 같이 설정하면 되고, 연봉정보가 다 다를때, 나이대를 구분해 작업하고자 할 때 불연속 버전을 만들수 있다.
데이터 속성의 종류는 아래와 같고 그 특징을 이해해야 한다.
SSAS 선형 회귀분석
1. 선형회귀분석은 종속 변수와 독립 변수 간의 관계를 계산하고 이 관계를 예측에 사용
2. Y=aX+b
를 구하는데, 모든 요소와 관련된 오류 수의 합계가 최소가 될 때까지 a와 b를 조정하여 회귀 수식을 구한다.
3. msft 의 선형회귀분석은 msft 의사 결정 트리의 변형이다. (트리의 분기가 없도록 조정한 것)
입력 연속된 숫자만 사용할 수 있다.
출력 연속된 숫자만 예측할 수 있다.
adventurework 에서 dimCustomer 의 평균연봉을 구하고자 한다면 다음과 같이 실습하면된다.
해당테이블에 나이가 없고 생일만 있으니 계산된 열을 이용해 추가한다.
dsv 에서 테이블에 계산된 컬럼을 추가한다. 일반적인 TSQL 이 먹는다.
선형 회귀분석 마이닝 구조와 모델을 만든다.
모델링 플래그를 설정한다. (컬럼의 수동 추가 삭제 등의 경우 자동으로 설정되지 않는다.)
알고리즘 매개 변수를 확인한다.
선형 회귀분석의 경우 특별히 건드릴 변수가 없다.
마이닝 모델 뷰에서 Yearly Income 을 계산한 수식을 얻을 수 있다.
Yearly Income = 57,403.129+468.492*(Age-53.379)
만약 20살의 수입이 해당 모델로 학습한 경우 얼마가 되는지 계산해보면
마이닝 모델 예측에서는 더 쉽게 할 수 있다.
아래와 같이 설정하고 왼쪽 상단의 쿼리 버튼을 누르면 된다.
테이블을 넣어서 할 수도 있고, 단일 쿼리도 가능하고 dmx 쿼리를 바로 뽑아 낼 수도 있다.
단일 쿼리를 구한것
단일 쿼리의 DMX 쿼리 확인
쿼리분석기에서 데이터베이스에서 DMX 쿼리를 하면 똑같은 결과를 얻을 수 있다.
아래는 마이닝 파라메터를 호출한 경우이다.
SELECT MINING_PARAMETERS
FROM $system.DMSCHEMA_MINING_MODELS
WHERE MODEL_NAME = 'LR_Customer_Income'
SELECT FLATTENED MODEL_NAME,
(SELECT ATTRIBUTE_VALUE, VALUETYPE
FROM NODE_DISTRIBUTION
WHERE VALUETYPE =7)
AS t
FROM LR_Customer_Income.CONTENT
SELECT FLATTENED NODE_DISTRIBUTION as t
FROM LR_Customer_Income.CONTENT
70% 샘플링을 해서 12939 건이 있고 연봉 평균값은 57403원이다.
계수는 (7번) 468 이고 평균 연령은 53세이다. 그래서 수식이
Yearly Income = 57,403.129+468.492*(Age-53.379) 이 나온것이다.
해석은 아래 링크를 보면 쉽게 할 수 있다.
https://msdn.microsoft.com/ko-kr/library/cc645906.aspx
이렇게 쉬운걸 ... 진작 공부해둘걸..... MSDN 만세~ !!!
IF OBJECT_ID('T_CALENDAR') IS NOT NULL
DROP TABLE T_CALENDAR
GO
CREATE TABLE T_CALENDAR
(IDX INT
,DATETIMEDATE DATETIME
,YYYYMMDD CHAR(8)
,IYEAR INT
,IMONTH INT
,IDAY INT
,IQUARTER INT
,IWEEK INT
,IWEEKDAY INT
,VWEEKDAY VARCHAR(10)
,HOLIDAY_YN INT
,HOLIDAY_NAME VARCHAR(100)
)
GO
INSERT INTO T_CALENDAR (
IDX
,DATETIMEDATE
,YYYYMMDD
,IYEAR
,IMONTH
,IDAY
,IQUARTER
,IWEEK
,IWEEKDAY
,VWEEKDAY
)
SELECT ROW_NUMBER() OVER (ORDER BY (SELECT 1)) IDX
, CAST('20140101' AS DATETIME) + ROW_NUMBER() OVER (ORDER BY (SELECT 1)) - 1
, CONVERT(VARCHAR(10), CAST('20140101' AS DATETIME) + ROW_NUMBER() OVER (ORDER BY (SELECT 1)) - 1, 112)
, DATEPART(YEAR, CAST('20140101' AS DATETIME) + ROW_NUMBER() OVER (ORDER BY (SELECT 1)) - 1)
, DATEPART(MONTH, CAST('20140101' AS DATETIME) + ROW_NUMBER() OVER (ORDER BY (SELECT 1)) - 1)
, DATEPART(DAY, CAST('20140101' AS DATETIME) + ROW_NUMBER() OVER (ORDER BY (SELECT 1)) - 1)
, DATEPART(QUARTER, CAST('20140101' AS DATETIME) + ROW_NUMBER() OVER (ORDER BY (SELECT 1)) - 1)
, DATEPART(WEEK, CAST('20140101' AS DATETIME) + ROW_NUMBER() OVER (ORDER BY (SELECT 1)) - 1)
, DATEPART(WEEKDAY, CAST('20140101' AS DATETIME) + ROW_NUMBER() OVER (ORDER BY (SELECT 1)) - 1)
, CASE DATEPART(WEEKDAY, CAST('20140101' AS DATETIME) + ROW_NUMBER() OVER (ORDER BY (SELECT 1)) - 1)
WHEN 1 THEN '일'
WHEN 2 THEN '월'
WHEN 3 THEN '화'
WHEN 4 THEN '수'
WHEN 5 THEN '목'
WHEN 6 THEN '금'
WHEN 7 THEN '토'
ELSE NULL END
FROM SYSOBJECTS A
, SYSOBJECTS B
--, SYSOBJECTS C
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '신정' WHERE YYYYMMDD = '20090101'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '설날' WHERE YYYYMMDD = '20090125'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '설날' WHERE YYYYMMDD = '20090126'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '설날' WHERE YYYYMMDD = '20090127'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '삼일절' WHERE YYYYMMDD = '20090301'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '석가탄신일' WHERE YYYYMMDD = '20090502'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '어린이날' WHERE YYYYMMDD = '20090505'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '현충일' WHERE YYYYMMDD = '20090606'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '광복절' WHERE YYYYMMDD = '20090815'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '추석' WHERE YYYYMMDD = '20091002'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '추석,개천절' WHERE YYYYMMDD = '20091003'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '추석' WHERE YYYYMMDD = '20091004'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '성탄절' WHERE YYYYMMDD = '20091225'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '신정' WHERE YYYYMMDD = '20100101'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '설날' WHERE YYYYMMDD = '20100213'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '설날' WHERE YYYYMMDD = '20100214'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '설날' WHERE YYYYMMDD = '20100215'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '삼일절' WHERE YYYYMMDD = '20100301'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '어린이날' WHERE YYYYMMDD = '20100505'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '석가탄신일' WHERE YYYYMMDD = '20100521'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '현충일' WHERE YYYYMMDD = '20100606'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '광복절' WHERE YYYYMMDD = '20100815'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '추석' WHERE YYYYMMDD = '20100921'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '추석' WHERE YYYYMMDD = '20100922'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '추석' WHERE YYYYMMDD = '20100923'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '개천절' WHERE YYYYMMDD = '20101003'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '성탄절' WHERE YYYYMMDD = '20101225'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '신정' WHERE YYYYMMDD = '20110101'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '설날' WHERE YYYYMMDD = '20110202'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '설날' WHERE YYYYMMDD = '20110203'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '설날' WHERE YYYYMMDD = '20110204'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '삼일절' WHERE YYYYMMDD = '20110301'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '어린이날' WHERE YYYYMMDD = '20110505'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '석가탄신일' WHERE YYYYMMDD = '20110510'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '현충일' WHERE YYYYMMDD = '20110606'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '광복절' WHERE YYYYMMDD = '20110815'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '추석' WHERE YYYYMMDD = '20110911'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '추석' WHERE YYYYMMDD = '20110912'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '추석' WHERE YYYYMMDD = '20110913'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '개천절' WHERE YYYYMMDD = '20111003'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '성탄절' WHERE YYYYMMDD = '20111225'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '신정' WHERE YYYYMMDD = '20120101'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '설날' WHERE YYYYMMDD = '20120122'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '설날' WHERE YYYYMMDD = '20120123'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '설날' WHERE YYYYMMDD = '20120124'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '삼일절' WHERE YYYYMMDD = '20120301'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '어린이날' WHERE YYYYMMDD = '20120505'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '석가탄신일' WHERE YYYYMMDD = '20120528'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '현충일' WHERE YYYYMMDD = '20120606'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '광복절' WHERE YYYYMMDD = '20120815'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '추석' WHERE YYYYMMDD = '20120929'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '추석' WHERE YYYYMMDD = '20120930'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '추석' WHERE YYYYMMDD = '20121001'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '개천절' WHERE YYYYMMDD = '20121003'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '성탄절' WHERE YYYYMMDD = '20121225'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '신정' WHERE YYYYMMDD = '20130101'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '설날' WHERE YYYYMMDD = '20130209'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '설날' WHERE YYYYMMDD = '20130210'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '설날' WHERE YYYYMMDD = '20130211'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '삼일절' WHERE YYYYMMDD = '20130301'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '어린이날' WHERE YYYYMMDD = '20130505'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '석가탄신일' WHERE YYYYMMDD = '20130517'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '현충일' WHERE YYYYMMDD = '20130606'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '광복절' WHERE YYYYMMDD = '20130815'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '추석' WHERE YYYYMMDD = '20130918'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '추석' WHERE YYYYMMDD = '20130919'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '추석' WHERE YYYYMMDD = '20130920'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '개천절' WHERE YYYYMMDD = '20131003'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '성탄절' WHERE YYYYMMDD = '20131225'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '신정' WHERE YYYYMMDD = '20140101'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '설날' WHERE YYYYMMDD = '20140130'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '설날' WHERE YYYYMMDD = '20140131'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '설날' WHERE YYYYMMDD = '20140201'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '삼일절' WHERE YYYYMMDD = '20140301'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '어린이날' WHERE YYYYMMDD = '20140505'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '석가탄신일' WHERE YYYYMMDD = '20140506'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '현충일' WHERE YYYYMMDD = '20140606'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '광복절' WHERE YYYYMMDD = '20140815'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '추석' WHERE YYYYMMDD = '20140907'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '추석' WHERE YYYYMMDD = '20140908'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '추석' WHERE YYYYMMDD = '20140909'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '개천절' WHERE YYYYMMDD = '20141003'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '성탄절' WHERE YYYYMMDD = '20141225'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '신정' WHERE YYYYMMDD = '20150101'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '설날' WHERE YYYYMMDD = '20150218'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '설날' WHERE YYYYMMDD = '20150219'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '설날' WHERE YYYYMMDD = '20150220'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '삼일절' WHERE YYYYMMDD = '20150301'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '어린이날' WHERE YYYYMMDD = '20150505'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '석가탄신일' WHERE YYYYMMDD = '20150525'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '현충일' WHERE YYYYMMDD = '20150606'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '광복절' WHERE YYYYMMDD = '20150815'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '추석' WHERE YYYYMMDD = '20150926'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '추석' WHERE YYYYMMDD = '20150927'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '추석' WHERE YYYYMMDD = '20150928'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '개천절' WHERE YYYYMMDD = '20151003'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '성탄절' WHERE YYYYMMDD = '20151225'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '신정' WHERE YYYYMMDD = '20160101'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '설날' WHERE YYYYMMDD = '20160207'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '설날' WHERE YYYYMMDD = '20160208'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '설날' WHERE YYYYMMDD = '20160209'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '삼일절' WHERE YYYYMMDD = '20160301'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '어린이날' WHERE YYYYMMDD = '20160505'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '석가탄신일' WHERE YYYYMMDD = '20160514'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '현충일' WHERE YYYYMMDD = '20160606'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '광복절' WHERE YYYYMMDD = '20160815'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '추석' WHERE YYYYMMDD = '20160914'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '추석' WHERE YYYYMMDD = '20160915'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '추석' WHERE YYYYMMDD = '20160916'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '개천절' WHERE YYYYMMDD = '20161003'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '성탄절' WHERE YYYYMMDD = '20161225'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '신정' WHERE YYYYMMDD = '20170101'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '설날' WHERE YYYYMMDD = '20170127'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '설날' WHERE YYYYMMDD = '20170128'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '설날' WHERE YYYYMMDD = '20170129'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '삼일절' WHERE YYYYMMDD = '20170301'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '석가탄신일' WHERE YYYYMMDD = '20170503'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '어린이날' WHERE YYYYMMDD = '20170505'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '현충일' WHERE YYYYMMDD = '20170606'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '광복절' WHERE YYYYMMDD = '20170815'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '개천절,추석' WHERE YYYYMMDD = '20171003'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '추석' WHERE YYYYMMDD = '20171004'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '추석' WHERE YYYYMMDD = '20171005'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '성탄절' WHERE YYYYMMDD = '20171225'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '신정' WHERE YYYYMMDD = '20180101'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '설날' WHERE YYYYMMDD = '20180215'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '설날' WHERE YYYYMMDD = '20180216'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '설날' WHERE YYYYMMDD = '20180217'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '삼일절' WHERE YYYYMMDD = '20180301'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '어린이날' WHERE YYYYMMDD = '20180505'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '석가탄신일' WHERE YYYYMMDD = '20180522'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '현충일' WHERE YYYYMMDD = '20180606'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '광복절' WHERE YYYYMMDD = '20180815'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '추석' WHERE YYYYMMDD = '20180923'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '추석' WHERE YYYYMMDD = '20180924'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '추석' WHERE YYYYMMDD = '20180925'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '개천절' WHERE YYYYMMDD = '20181003'
UPDATE DBO.T_CALENDAR SET HOLIDAY_YN = 1 , HOLIDAY_NAME = '성탄절' WHERE YYYYMMDD = '20181225'
UPDATE T_CALENDAR
SET HOLIDAY_YN = 1
WHERE VWEEKDAY IN ('토','일')
UPDATE T_CALENDAR
SET HOLIDAY_YN = 0
, HOLIDAY_NAME = ''
WHERE HOLIDAY_NAME IS NULL
DELETE T_CALENDAR WHERE YYYYMMDD > '20181225'
GO
SELECT * FROM T_CALENDAR
How to (correctly) check file versions with PowerShell
가끔 KB (https://support.microsoft.com/en-us/kb/2851149) 에서 파일 버전을 확인하고 처리해야 할 경우가 있다.
이때 다음과 같이 확인한다.
윈도우 버전을 확인 할 경우
cmd
powershell
PS C:\Users\민석> (get-item $env:windir\explorer.exe).VersionInfo | format-list * -force
PS C:\Users\민석> get-item $env:windir\explorer.exe | Format-List -Property *version*
위 kb 에서 파일 버전을 확인할때는
PS C:\Users\민석> get-item $env:windir\System32\Drivers\tcpip.sys | Format-List -Property *version*
과 같이 하면 된다.
-- 참고 --
Howdy folks Matthew Reynolds (@MatthewMWR) here. I focus on enterprise Windows optimization and security for Microsoft Services. You might remember me from How Many Coffees Can You Drink While Your PC Starts ( http://channel9.msdn.com/Events/TechEd/NorthAmerica/2014/WIN-B359 ) from TechEd or PowerShell Deep Dives ( http://www.amazon.com/dp/1617291315/ ) from Manning Press.
The following should be simple questions, but I was recently surprised to learn otherwise:
· Did that patch really install?
· Are my servers using the same version of ReallyImportant.dll?
File properties in Explorer has been a reliable one-off method to read version numbers, but in today’s automation-heavy world it’s all about the PowerShell.
Unfortunately the default presentation of file version info in PowerShell is… sub-optimal.
What the what? This image shows that for the very same file PowerShell and file properties (Explorer) can report different version numbers. You can try this on various machines and OSes and get fun weird results. Eagle-eyed friends of mine found that on Windows Server 2008 R2 machines with SP1 + additional patches installed PowerShell will show pre-SP1 versions numbers on various DLLs. The example above is from Windows Server 2012 R2.
If you’d like to see this default behavior in PowerShell changed, vote along at https://connect.microsoft.com/PowerShell/Feedback/Details/1027483 .
The workaround
My colleague Artem Pronichkin showed me that VersionInfo contains the information we want. It is just hidden by default.
Depending on your scripting preferences as a scripty scripter—you can use this freshly revealed truth in several ways.
The following is an example you can copy and paste that exposes the goods as a new property called FileVersionUpdated on all FileInfo objects (in the current session).
Update-TypeData -TypeName System.Io.FileInfo -MemberType ScriptProperty -MemberName FileVersionUpdated -Value {
New-Object System.Version -ArgumentList @(
$this.VersionInfo.FileMajorPart
$this.VersionInfo.FileMinorPart
$this.VersionInfo.FileBuildPart
$this.VersionInfo.FilePrivatePart
)
}
All FileInfos in my session now have FileVersionUpdated property. Due to default formatting our new property may not appear in some views. You can twiddle with the format descriptors or just use -Property on commands like Format-List as in the following example.
We can use our new property in scripts or commands to do things like compare versions between machines.
Geek mode: PowerShell type adaptation, SxS, and why this is happening
Executable files like EXEs & DLLs are described by several metadata fields including versions, dates, company, and so forth. Some of the fields are updated by patches and some are left alone. File properties (Explorer) and PowerShell were each showing a different subset of the available fields.
Get-Item (among others) in PowerShell returns a FileInfo (http://msdn.microsoft.com/en-us/library/system.io.fileinfo(v=vs.110).aspx) describing the file. For convenience PowerShell tacks on an extra property it calls VersionInfo based on FileVersionInfo (http://msdn.microsoft.com/en-us/library/system.diagnostics.fileversioninfo(v=vs.110).aspx) . FileVersionInfo exposes many fields describing the files. We can get the updated version info if we look at the right fields.
Speaking of metadata, you can get another view into which version is currently presented as being in %WinDir% by using fsutil.exe. The full SxS path also contains a version indicator.
Now go forth and correctly judge Windows binary version numbers!
Matt “Version Controlled” Reynolds
sql server free e-book
Free SQL Server Ebooks !!!
![]() |
5 Tips for a Smooth SSIS Upgrade to SQL Server 2012 Runying Mao, Carla Sabotta
Quick GuideMicrosoft SQL Server 2012 Integration Services (SSIS) provides significant improvements in both the developer and administration experience. This article provides tips that can help to make the upgrade to Microsoft SQL Server 2012 Integration Services successful. The tips address editing package configurations and specifically connection strings, converting configurations to parameters, converting packages to the project deployment model, updating Execute Package tasks to use project references and parameterizing the PackageName property. Applies to: SQL Server 2012 Source: White Paper E-book publication date: November 2012 |
![]() |
A Hitchhiker’s Guide to Microsoft StreamInsight Queries Ramkumar (Ram) Krishnan, Jonathan Goldstein, Alex Raizman
Step-by-StepThis paper is a developer’s introduction to the Microsoft StreamInsight Queries. The paper has two goals: (1) To help you think through stream processing in simple, layered levels of understanding, complementing the product documentation. (2) To reinforce this learning through examples of various use cases, so that you can design the query plan for a particular problem and compose the LINQ query. This ability for top-down composition of a LINQ query, combined with bottom-up understanding of the query model, will help you build rich and powerful streaming applications. The more advanced sections of this paper provide an overview of a query plan, the operators that constitute the query, and, where appropriate, the foundational query algebra itself. The paper is not a feature reference or a substitute for MSDN documentation. Applies to: StreamInsight Source: MSDN Library E-book publication date: November 2012 |
![]() |
Backup and Restore of SQL Server Databases SQL Server 2012 Books Online
ReferenceThis book describes the benefits of backing up SQL Server databases, basic backup and restore terms, and introduces backup and restore strategies for SQL Server and security considerations for SQL Server backup and restore. Applies to: SQL Server 2012 Source: SQL Server 2012 Books Online E-book publication date: June 2012 288 pages |
![]() |
Data Analysis Expressions (DAX) Reference SQL Server 2012 Books Online
ReferenceThe Data Analysis Expressions (DAX) language is a library of functions and operators that can be combined to build formulas and expressions. Applies to: SQL Server 2012 Source: SQL Server 2012 Books Online E-book publication date: June 2012 |
![]() |
Data Mining Extensions (DMX) Reference SQL Server 2012 Books Online
ReferenceData Mining Extensions (DMX) is a language that you can use to create and work with data mining models in Microsoft SQL Server Analysis Services. You can use DMX to create the structure of new data mining models, to train these models, and to browse, manage, and predict against them. DMX is composed of data definition language (DDL) statements, data manipulation language (DML) statements, and functions and operators. Applies to: SQL Server 2012 Source: Microsoft SQL Server 2012 Books Online E-book publication date: June 2012 |
![]() |
Data Quality Services SQL Server 2012 Books Online
ReferenceSQL Server Data Quality Services (DQS) is a knowledge-driven data quality product. DQS enables you to build a knowledge base and use it to perform a variety of critical data quality tasks, including correction, enrichment, standardization, and de-duplication of your data. DQS enables you to perform data cleansing by using cloud-based reference data services provided by reference data providers. DQS also provides you with profiling that is integrated into its data-quality tasks, enabling you to analyze the integrity of your data. Applies to: SQL Server 2012 Source: SQL Server 2012 Books Online E-book publication date: June 2012 |
![]() |
Extracting and Loading SharePoint Data in SQL Server Integration Services Kevin Idzi
Quick Step-by-StepThis article introduces the SharePoint List Source and Destination adapters, Applies to: SQL Server 2005, 2008, 2008 R2, and 2012 Source: White Paper E-book publication date: November 2012 |
![]() |
High Availability Solutions SQL Server 2012 Books Online
ReferenceThis book introduces two SQL Server high-availability solutions that improve the availability of servers or databases: AlwaysOn Failover Cluster Instances and AlwaysOn Availability Groups. A high-availability solution masks the effects of a hardware or software failure and maintains the availability of applications so that the perceived downtime for users is minimized. Applies to: SQL Server 2012 Source: Microsoft SQL Server 2012 Books Online E-book publication date: June 2012 |
![]() |
Integration Services: Extending Packages with Scripting SQL Server 2012 Books Online
ReferenceYou can extend the power of Integration Services (SSIS) by adding code within the wrappers provided by the Script task and the Script component. This section of the Developer Reference provides instructions and examples for extending the control flow and data flow of an SSIS package using the Script task and the Script component. Applies to: SQL Server 2012 Source: SQL Server 2012 Books Online E-book publication date: January 2013 |
![]() |
Master Data Services SQL Server 2012 Books Online
ReferenceMaster Data Services (MDS) is the SQL Server solution for master data management. Master data management (MDM) describes the efforts made by an organization to discover and define non-transactional lists of data, with the goal of compiling maintainable master lists. An MDM project generally includes an evaluation and restructuring of internal business processes along with the implementation of MDM technology. The result of a successful MDM solution is reliable, centralized data that can be analyzed, resulting in better business decisions. Applies to: SQL Server 2012 Source: SQL Server 2012 Books Online E-book publication date: June 2012 |
![]() |
Master Data Services (MDS) Operations Guide Karan Gulati
GuideThis article provides guidance about how to install, configure and manage SQL Server 2012 Master Data Services (MDS). You also learn how to deploy a Master Data Services model and create a SQL Server Integration Services (SSIS) solution to monitor MDS. Applies to: SQL Server Master Data Services (MDS), SQL Server Integration Services (SSIS) Source: White paper E-book publication date: October 2013 |
![]() |
Monitor and Tune for Performance SQL Server 2012 Books Online
Quick ReferenceThe goal of monitoring databases is to assess how a server is performing. Effective monitoring involves taking periodic snapshots of current performance to isolate processes that are causing problems, and gathering data continuously over time to track performance trends. Ongoing evaluation of the database performance helps you minimize response times and maximize throughput, yielding optimal performance. Applies to: SQL Server 2012 Source: SQL Server 2012 Books Online E-book publication date: June 2012 |
![]() |
Multidimensional Expressions (MDX) Reference SQL Server 2012 Books Online
ReferenceMultidimensional Expressions (MDX) is the query language that you use to work with and retrieve multidimensional data in Microsoft Analysis Services. MDX is based on the XML for Analysis (XMLA) specification, with specific extensions for SQL Server Analysis Services. MDX utilizes expressions composed of identifiers, values, statements, functions, and operators that Analysis Services can evaluate to retrieve an object (for example a set or a member), or a scalar value (for example, a string or a number). Applies to: SQL Server 2012 Source: SQL Server 2012 Books Online E-book publication date: June 2012 |
![]() |
Multidimensional Model Programming SQL Server 2012 Books Online
Reference Analysis Services provides several APIs that you can use to program against an Analysis Services instance and the multidimensional databases that it makes available. This section describes the approaches available to developers who want to create custom applications using Analysis Services multidimensional solutions. You can use this information to choose the programming interface that best meets the requirements of a particular project. Analysis Services development projects can be based on managed or non-managed code that runs on a Windows platform, or other platforms that support HTTP access.Applies to: SQL Server 2012 Source: SQL Server 2012 Books Online E-book publication date: |
![]() |
Optimized Bulk Loading of Data into Oracle Carla Sabotta, Debarchan Sarkar
Quick Step-by-StepSQL Server 2008 and SQL Server 2008 R2 (Enterprise and Developer editions) support bulk loading Oracle data using Integration Services packages with the Microsoft Connector for Oracle by Attunity. For SQL Server 2005 and the non-Enterprise and non-Developer editions of SQL Server 2008 and 2008 R2, there are alternatives for achieving optimal performance when loading Oracle data. This paper discusses these alternatives. Applies to: SQL Server 2005 (all editions), SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012 (non-Enterprise and non-Developer editions) Source: White Paper E-book publication date: November 2012 |
![]() |
Planning Disaster Recovery for Microsoft SQL Server Reporting Services in SharePoint Integrated Mode Jaime Tarquino
Quick GuideThis white paper discusses disaster recovery options for Microsoft SQL Server Reporting Services solutions configured to use SharePoint integrated mode. This paper extends best practices for Microsoft SharePoint solutions that include both SQL Server Reporting Services and SharePoint Products. This paper also contains procedures, examples, and scripts that you can use to apply these practices to your organization. Applies to: SQL Server 2012 Reporting Services in SharePoint 2010 (with SP1) and SharePoint 2013, SQL Server 2012 Reporting Services in SharePoint 2013, SQL Server 2008 R2 Reporting Services in SharePoint 2010 (with SP1) Source: White Paper E-book publication date: November 2012 |
![]() |
SQLCAT’s Guide to BI and Analytics Microsoft SQLCAT Team
Guide and ReferenceThis e-book is a collection of some of the more popular technical content that was available on the old SQLCAT.COM site. It covers SQL Server technology ranging from SQL Server 2005 to SQL Server 2012. However, this is not all the content that was available on SQLCAT.COM. To see additional content from that site you can follow the SQLCAT blog Applies to: SQL Server Business Intelligence and Analytics Source: SQLCAT Blog E-book publication date: September 2013 |
![]() |
SQLCAT’s Guide to High Availability Disaster Recovery Microsoft SQLCAT Team
Guide and ReferenceThis e-book is a collection of some of the more popular technical content that was available on the old SQLCAT.COM site. It covers SQL Server technology ranging from SQL Server 2005 to SQL Server 2012. However, this is not all the content that was available on SQLCAT.COM. To see additional content from that site you can follow the SQLCAT blog Applies to: SQL Server High Availability and Disaster Recovery Source: SQLCAT Blog E-book publication date: September 2013 |
![]() |
SQLCAT’s Guide to Relational Engine Microsoft SQLCAT Team
Guide and ReferenceThis e-book is a collection of some of the more popular technical content that was available on the old SQLCAT.COM site. It covers SQL Server technology ranging from SQL Server 2005 to SQL Server 2012. Applies to: SQL Server 2005 to 2012 Source: SQLCAT Blog E-book publication date: September 2013 |
![]() |
SQL Server Community FAQs Manual SQL Server Forum Support Team
ReferenceThe SQL Server Forum Support Team authored, collected and consolidated commonly asked questions in SQL Server MSDN and TechNet forums into this book so as to provide an offline reading and learning experience for IT professionals and people who are interested in SQL Server. The book includes about 101 items related to common problems with database administration, SSAS, SSIS and SSRS. (The book was originally published in June 2011.) Applies to: SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 Source: MSDN Blogs E-book publication date: January 2013 |
![]() |
SQL Server Distributed Replay SQL Server 2012 Books Online
Quick ReferenceThe Microsoft SQL Server Distributed Replay feature helps you assess the impact of future SQL Server upgrades. You can also use it to help assess the impact of hardware and operating system upgrades, and SQL Server tuning. Applies to: SQL Server 2012 Source: SQL Server 2012 Books Online E-book publication date: June 2012 |
![]() |
Transact-SQL Data Definition Language (DDL) Reference SQL Server 2012 Books Online
ReferenceData Definition Language (DDL) is a vocabulary used to define data Applies to: SQL Server 2012 Source: Microsoft SQL Server 2012 Books Online E-book publication date: June 2012 |
![]()
|
Transact-SQL Data Manipulation Language (DML) Reference SQL Server 2012 Books Online
ReferenceData Manipulation Language (DML) is a vocabulary used to retrieve and work with data in SQL Server 2012. Use these statements to add, modify, query, or remove data from a SQL Server database. Applies to: SQL Server 2012 Source: Microsoft SQL Server 2012 Books Online E-book publication date: May 2012 |
![]() |
XQuery Language Reference SQL Server 2012 Books Online
ReferenceXQuery is a language that can query structured or semi-structured XML data. With the xml data type support provided in the Database Engine, documents can be stored in a database and then queried by using XQuery. XQuery is based on the existing XPath query language, with support added for better iteration, better sorting results, and the ability to construct the necessary XML. Applies to: SQL Server 2012 Source: Microsoft SQL Server 2012 Books Online E-book publication date: June 2012 |
![]() |
Data Access for Highly-Scalable Solutions: Using SQL, NoSQL, and Polyglot Persistence patterns & practices
Guide The business requirements of many modern business applications often involve processing large amounts of data. Additionally, the performance requirements typically make it imperative that the application uses the most efficient means to store and retrieve this data. In the past, most application designers would have simply chosen to save this data in a SQL database, but the recent advances in NoSQL technology have brought about highly-scalable, non-relational databases that can handle vast amounts of information very efficiently. Each type of NoSQL database is often optimized for a particular pattern of data access, and application designers are now increasingly looking to integrate multiple NoSQL and SQL databases into their solutions. This guide describes how to design and build applications and services that can take best advantage of SQL and NoSQL databases by combining them into a polyglot solution. It provides an end to end walkthrough of a business application that uses SQL Server in conjunction with a variety of NoSQL databases, showing how the designers selected the databases to closely match the various business requirements. Applies to: SQL Server 2012
Source: MSDN Library (patterns & practices) E-book publication date: September 2013 |
![]() |
Introducing Microsoft SQL Server 2008 R2 Ross Mistry and Stacia Misner
Overview Our purpose in this book is to point out both the new and the improved in SQL Server 2008 R2. There are a lot of exciting enhancements and new capabilities engineered into SQL Server 2008 R2 that will have a positive impact on your applications, ranging from improvements in operation to those in management. Applies to: SQL Server 2008 R2 Publisher: Microsoft Press E-book publication date: April 2010 |
![]() |
Introducing Microsoft SQL Server 2012 Ross Mistry and Stacia Misner
Overview Microsoft SQL Server 2012 is Microsoft’s first cloud-ready information platform. It gives organizations effective tools to protect, unlock, and scale the power of their data, and it works across a variety of devices and data sources, from desktops, phones, and tablets, to datacenters and both private and public clouds. Our purpose in this book is to point out both the new and the improved capabilities as they apply to achieving mission-critical confidence, breakthrough insight, and using a cloud on your terms. Applies to: SQL Server 2012 Publisher: Microsoft Press E-book publication date: March 2012 |
Master Data Services Capacity Guidelines Yair Helman
Quick Guide This document provides capacity planning guidelines for Microsoft SQL Server 2012 Master Data Services (MDS). Applies to: SQL Server 2012 Source: TechNet Wiki |
![]() |
Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery LeRoy Tuttle, Jr.
Quick GuideThis white paper discusses how to reduce planned and unplanned downtime, maximize application availability, and provide data protection using SQL Server 2012 AlwaysOn high availability and disaster recovery solutions. A key goal of this paper is to establish a common context for related discussions between business stakeholders, technical decision makers, system architects, infrastructure engineers, and database administrators. Applies to: SQL Server 2012 Source: White paper E-book publication date : May 2012 |
![]() |
Microsoft SQL Server Analysis Services Multidimensional Performance and Operations Guide Thomas Kejser and Denny Lee
GuideDownload this book to learn about Analysis Services Multidimensional performance tuning from an operational and development perspective. This book consolidates the previously published SQL Server 2008 R2 Analysis Services Operations Guide and SQL Server 2008 R2 Analysis Services Performance Guide into a single publication that you can view on portable devices. Applies to: SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 Source: White paper E-book publication date: May 2012 |
![]() |
QuickStart: Learn DAX Basics in 30 Minutes Owen Duncan
Quick Step-by-StepThis QuickStart is for users new to PowerPivot or tabular model projects authored in SQL Server Data Tools. It is meant to give you a quick and easy introduction on how you can use Data Analysis Expressions (DAX) to solve a number of basic data modeling and analytical problems. Applies to: PowerPivot for Excel (all versions), SQL Server 2008 R2, SQL Server 2012 Source: TechNet Wiki E-book publication date: May 2012 |
![]() |
SQL Server 2012 Tutorials: Analysis Services – Data Mining SQL Server 2012 Books Online
Step-by-Step Microsoft SQL Server Analysis Services makes it easy to create sophisticated data mining solutions. The step-by-step tutorials in the following list will help you learn how to get the most out of Analysis Services, so that you can perform advanced analysis to solve business problems that are beyond the reach of traditional business intelligence methods.Applies to: SQL Server 2012 Source: SQL Server 2012 Books Online E-book publication date: June 2012 213 pages |
![]() |
SQL Server 2012 Tutorials: Analysis Services – Multidimensional Modeling SQL Server 2012 Books Online
Step-by-Step This tutorial describes how to use SQL Server Data Tools to develop and deploy an Analysis Services project, using the fictitious company Adventure Works Cycles for all examples.Applies to: SQL Server 2012 Source: SQL Server 2012 Books Online E-book publication date: June 2012 168 pages |
![]() |
SQL Server 2012 Tutorials: Analysis Services – Tabular Modeling SQL Server 2012 Books Online
Quick Step-by-StepThis tutorial provides lessons on how to create a SQL Server 2012 Analysis Services tabular model running in In-Memory mode by using SQL Server Data Tools (SSDT). Applies to: SQL Server 2012 Source: SQL Server 2012 Books Online E-book publication date: June 2012 57 pages |
![]() |
SQL Server 2012 Tutorials: Reporting Services SQL Server 2012 Books Online
Quick Step-by-StepThis book contains tutorials for SQL Server 2012 Reporting Services: Create a Data-Driven Subscription, Create a Basic Table Report, Create a Sample Report in Power View, and Optimize a Sample PowerPivot Model for Power View Reports. Applies to: SQL Server 2012 Source: SQL Server 2012 Books Online E-book publication date: June 2012 61 pages |
![]() |
SQL Server 2012 Tutorials: Writing Transact-SQL Statements SQL Server 2012 Books Online
Quick Step-by-StepThis tutorial is intended for users who are new to writing SQL statements. It will help new users get started by reviewing some basic statements for creating tables and inserting data. This tutorial uses Transact-SQL, the Microsoft implementation of the SQL standard. This tutorial is intended as a brief introduction to the Transact-SQL language and not as a replacement for a Transact-SQL class. The statements in this tutorial are intentionally simple, and are not meant to represent the complexity found in a typical production database. Applies to: SQL Server 2012 Source: SQL Server 2012 Books Online E-book publication date: June 2012 21 pages |