http___marktab.net_datamining_bs_category_integration-services__1.xml
1.1 1.2 1.3 2.1 3.1 3.2 3.3 3.4 4.1 5.1 6.1 6.2 6.3 7.1 8.1 9.1 10.1 11.1 12.1 13.1 14.1 15.1 15.2 15.3 16.1 16.2 16.3 16.4 16.5 16.6 17.1 18.1 18.2 18.3 19.1 20.1 21.1 22.1 23.1 24.1 25.1 26.1 27.1 28.1 28.2 28.3 28.4 29.1 30.1 30.2 30.3 31.1 32.1 33.1 33.2 33.3 34.1 35.1 36.1 36.2 36.3 37.1 38.1 38.2 38.3 39.1 39.2 39.3 39.4 40.1 41.1
PASS Summit is a paid conference in Seattle, WA from November 5 צו 7, 2014 (some preconference sessions precede the conference on November 3 און 4, and have an additional charge). The purpose of this blog post is to provide a guide to the PASS Summit for people interested in data science. To support this goal, this post has both a slide deck and YouTube video (16 minutes). פאָרזעצן לייענען “Data Science Guide for PASS Summit 2014” » איך איז געווען צופרידן צו באַקומען מיין קאָפּיע פון בנין ינטעגראַטעד ביזנעס ינטעלליגענסע סאַלושאַנז מיט סקל סערווירער 2008 ר 2 & אָפיס 2010 אין די פּאָסט לעצט אָפּרוטעג. דער בוך איז וועגן ניצן די גאנצע מייקראָסאָפֿט ביי (ביזנעס ינטעלליגענסע) אָנלייגן צו בויען פאַרנעמונג-מדרגה סאַלושאַנז. סטאַסיאַ מיסנער פארבעטן מיר צו באריכטן איר דאַטן מיינינג קאַפּיטל לעצטע יאָר. דער בוך איז פֿאַר פאַרקויף אין ביידע פּייפּערבאַק און קינדלע פֿאָרמאַט. אין דעם בלאָג פּאָסטן איך וועל רעדן וועגן דעם בוך, און אויך טיילן די טיש פון אינהאַלט פֿאַר די דאַטן מיינינג קאַפּיטל. פאָרזעצן לייענען “מאַרקטאַב איבערבליקן דאַטאַ מינינג טשאַפּטער” » I had a good trip to Columbia, SC on March 19. At the event I presented on the topic “Enterprise Data Mining for SQL Server Professionals”, whose slides and demos are now online. Based on the free dataset called Contoso Retail, the technology included: - סקל סערווירער פאַרוואַלטונג סטודיאָ (ססמס) - דמקס (Data Mining Extensions) - קסמלאַ (XML for Analysis) - בידס (ביזנעס ינטעלליגענסע אנטוויקלונג סטודיאָ) - ססיס (SQL Server Integration Services) - PowerShell version 2.0 (the version with exception handling) - and of course, סקל סערווירער דאַטאַ מינינג The links for the slides and the demos are at the end of this post. אויך, it was good to continue to develop friendships among the regular SQL Server speakers and vendors. Having these events helps bring SQL Server related technology to regional if not local communities. Many speakers at this conference speak at other regional and national technical conferences. Brian Kelley was the lead organizer for the event. The event started again with a nice speaker dinner at a Greek restaurant. Those attending had the chance to introduce themselves. The main value I get at these dinners is meeting others passionate for technology and learning their stories. Nothing mimics an actual event, and not all stories get captured on the Internet. I go to these events to meet people, and for others to meet me too. פאָרזעצן לייענען “סקל שבת 70 Columbia SC Post Event Wrap-Up” » I discovered that, in upgrading my home network, I had not set SQL Server 2008 R2 to allow for remote connections. Opening Windows Firewall in Windows 7 (any version) or Windows 2008 R2 requires making some choices. Having searched for advice, I found the answers in several places (instead of just one), so I decided to blog on this topic. Overall Advice — See http://msdn.microsoft.com/en-us/library/cc646023.aspx for advice on the Database Engine (which people commonly call “סקל סערווירער”), ינטעגראַטיאָן באַדינונגס, Analysis Services and Reporting Services SQL Server Database Engine On http://msdn.microsoft.com/en-us/library/ms175043.aspx: Microsoft says to follow one of two configurations: - Open a port, either the default 1433 or what you have manually defined that port to be - List the SQL Server executable sqlservr.exe as an exception — this option allows for the optional dynamic port setting to work Dynamic ports graciously allow SQL Server to listen on an unused port as explained on http://support.microsoft.com/kb/823938. סקל סערווירער אַנאַליסיס באַדינונגס (ססאַס) SSAS is of central concern for data mining, and the advice is at http://msdn.microsoft.com/en-us/library/ms174937.aspx Windows Firewall for Windows 7 and Windows 20o8 R2 Microsoft has a good downloadable document detailing the firewall settings (including screen shots, which is why I believe they decided on the MS Word document format instead of the normal web page). Windows Firewall is set through Control Panel, but an alternative way is to use the netsh command, also mentioned in this document. See http://www.microsoft.com/downloads/en/details.aspx? FamilyId=DF192E1B-A92A-4075-9F69-C12B7C54B52B&displaylang=en דאַטע מינינג מיט מייקראָסאָפֿט סקל סערווירער 2008 איבערבליק טשאַפּטער 14 So last week was about Analysis Services, and the most relevant cousin technology to data mining within the Microsoft BI stack. This week is about Integration Services, what I conisder the GUI-driven service facility for moving and manipulating data. Manipulation is not a evil action for people with good morals and ethics. “So are you a data manipulator?” “יאָ, I use Microsoft’s Integration Services” With potency and potential peril, people use Integration Services to perform most any type of data manipulation. The functions of Integration Services are similar if not identical to the abilities that earned SAS licensing revenue on mainframes and other large computer systems in the 1980s and 1990s. Consider the similarity: - Control flow — the order of execution, also inherent in the SAS program flow, which allows for asychronous and remote job submissions - Data flow — record level manipulation, similar to the SAS Data Step (also somewhat possible in SAS’ PROC SQL) כאָטש, we focus on Integration Services in this post because of the inherent capabilities in working with Data Mining. Specifcally, this subject includes how to put a data mining model into production. פאָרזעצן לייענען “Data Mining with SQL Server Integration Services (ססיס)” » מיקראָסאָפט סקל סערווירער 2008 Analysis Services Unleashed איבערבליק טשאַפּטער 22 This chapter discusses leveraging SQL Server Integration Services to load data into a cube. If you have Analysis Services you also have Integration Services, no additional licensing required. אָבער, you may have to install this software. As I covered in the previous chapter, Analysis Services has some native abilities and default choices through its own default processing technology. This default technology works best with standard relational sources, simplex schemas, and SQL Server in particular. In general, anyone could use SSIS as a good alternative when departing from these simpler conditions, and also to leverage additional SSIS ETL capabilities as part of the loading process. Loading is made possible by two SSIS data flow destinations, one for dimensions and one for partitions: ווידער, there is no cube destination, since data are stored in partitions. פאָרזעצן לייענען “Using SQL Server Integration Services to Load Data” »
1.1 1.2 1.3 2.1 3.1 3.2 3.3 3.4 4.1 5.1 6.1 6.2 6.3 7.1 8.1 9.1 10.1 11.1 12.1 13.1 14.1 15.1 15.2 15.3 16.1 16.2 16.3 16.4 16.5 16.6 17.1 18.1 18.2 18.3 19.1 20.1 21.1 22.1 23.1 24.1 25.1 26.1 27.1 28.1 28.2 28.3 29.1 30.1 30.2 30.3 31.1 32.1 33.1 33.2 33.3 34.1 35.1 36.1 36.2 36.3 37.1 38.1 38.2 38.3 39.1 39.2 39.3 39.4 40.1 41.1
PASS Summit is a paid conference in Seattle, WA from November 5 u 7, 2014 (some preconference sessions precede the conference on November 3 i 4, and have an additional charge). The purpose of this blog post is to provide a guide to the PASS Summit for people interested in data science. To support this goal, this post has both a slide deck and YouTube video (16 minutes). Nastaviti čitanje “Data Science Guide for PASS Summit 2014” » Bio sam sretan da primi moju kopiju Izgradnja Integrated Business Intelligence Solutions sa SQL Server 2008 R2 & Ured 2010 u pošti prošlog vikenda. Knjiga je o korištenju cijelog Microsoft BI (Business Intelligence) stog za izgradnju poduzeća na razini rješenja. Stacia Misner me je pozvao da pregledate joj data mining poglavlje prošle godine. Knjiga se prodaje u oba paperback i Kindle formatu. U ovom blog postu ću govoriti o ovoj knjizi, i dijeliti sadržaj za data mining poglavlje. Nastaviti čitanje “MarkTab Recenzije Data Mining Chapter” » Imao sam dobar izlet u Columbia, SC na marta 19. Na događaju sam predstavio na temu “Enterprise Data Mining za SQL Server Professionals”, čije slajdova i demo su online. Na osnovu slobodne skup podataka pod nazivom Contoso Retail, tehnologije uključene: - SQL Server Management Studio (SSMS) - DMX (Data Mining proširenja) - XMLA (XML za analizu) - PONUDA (Business Intelligence Development Studio) - SSIS (SQL Server Integration Services) - PowerShell verzije 2.0 (u verziji s izuzetkom rukovanje) - i, naravno,, SQL Server Data Mining Veze za slajdove i demo se na kraju ovog posta. Takođe, bilo je dobro da se nastavi razvijati prijateljstva među regularnom SQL Server zvučnike i prodavaca. Imajući ove događaje pomaže donijeti SQL Server povezane tehnologije na regionalnim ako ne i lokalnih zajednica. Mnogi govornici na ovoj konferenciji govoriti na drugim regionalnim i nacionalnim tehničkim konferencijama. Brian Kelley je bio glavni organizator za događaj. Manifestacija je počela opet sa lijepim zvučnika večeru u grčki restoran. Prisutnima su imali priliku da se predstave. Glavni vrijednost dobijem na tim večerama ispunjava druge strastveno za tehnologiju i učenje njihove priče. Ništa imitira stvarni događaj, i nisu sve priče se zarobljeni na Internetu. Ja idem na ove događaje upoznati ljude, i za druge da ispuni i meni. Nastaviti čitanje “SQL subota 70 Columbia SC Post Event Wrap-up” » Otkrio sam da, u unapređenje moj dom mrežu, Nisam postaviti SQL Server 2008 R2 kako bi se omogućilo za udaljene veze. Otvaranje Windows Firewall u Windows 7 (bilo koja verzija) ili Windows 2008 R2 zahtijeva donošenje neke odluke. Nakon što je tražio savjete, Našao sam odgovore na nekoliko mjesta (umjesto samo jednog), pa sam odlučio da blog na ovu temu. Sveukupna savjeti — Vidjeti http://msdn.microsoft.com/en-us/library/cc646023.aspx za savjete o Database Engine (koje ljudi obično zovu “SQL Server”), Integration Services, Analysis Services i Reporting Services SQL Server baze podataka motora Na http://msdn.microsoft.com/en-us/library/ms175043.aspx: Microsoft kaže da prati jednu od dvije konfiguracije: - Otvorite luka, ili zadani 1433 ili ono što ste ručno definisano da port bude - Navedite SQL Server izvršnu sqlservr.exe kao izuzetak — ova opcija omogućava opcijski dinamički port postavke za rad Dinamički portovi milostivo dopustiti SQL Server slušati na neiskorištene port kao što je objašnjeno u http://support.microsoft.com/kb/823938. SQL Server Analysis Services (SSAS) SSAS je centralno pitanje za data mining, i savjet je na http://msdn.microsoft.com/en-us/library/ms174937.aspx Windows Firewall za Windows 7 i Windows 20o8 R2 Microsoft ima dobar preuzeti dokument sa detaljnim firewall postavke (uključujući i snimke ekrana, i zato mislim da su se odlučili na MS Word dokument formatu umjesto normalne web stranice). Windows Firewall je postavljen kroz Control Panel, ali alternativni način je da koristite naredbu netsh, također spominje u ovom dokumentu. Vidjeti http://www.microsoft.com/downloads/en/details.aspx?FamilyId=DF192E1B-A92A-4075-9F69-C12B7C54B52B&displaylang=en Data Mining s Microsoft SQL Server 2008 Review Chapter 14 Dakle, prošle sedmice je oko Analysis Services, i najrelevantnije rođak tehnologiju za istraživanje podataka u Microsoft BI stog. Ovaj tjedan je oko Integration Services, ono što sam conisder GUI-driven servis za kretanje i manipulaciju podataka. Manipulacija nije zlo akcije za osobe sa dobrom moralu i etici. “Dakle, jesi li ti podaci manipulator?” “Da, Koristim Microsoftov Integration Services” Uz moć i potencijal opasnosti, ljudi koriste Integration Services za obavljanje većine bilo koji tip podataka manipulacije. Funkcije Integration Services su slična ako ne i identična sa sposobnostima koje zaradio SAS licence prihoda na mainframe i drugih velikih kompjuterskih sistema u 1980-ih i 1990-ih godina. Razmotrite sličnost: - Kontrola protoka — redoslijed izvršenja, također inherentna u SAS programu toka, koji omogućava asychronous i daljinski posao podnesaka - Protok podataka — rekordan nivo manipulacije, sličan SAS Data Korak (također nešto moguće u SAS’ PROC SQL) Iako, mi smo se fokusirati na Integration Services u ovom post zbog inherentne sposobnosti u radu s Data Mining. Specifcally, ovu temu: kako staviti data mining modela u proizvodnju. Nastaviti čitanje “Data Mining s SQL Server Integration Services (SSIS)” » Microsoft SQL Server 2008 Analysis Services Unleashed Review Chapter 22 Ovo poglavlje razmatra Oslanjajući SQL Server Integration Services za učitavanje podataka u kocki. Ako imate Analysis Services imate Integration Services, bez dodatnih zahtijeva licenciranje. Međutim, možda ćete morati instalirati ovaj softver. Kao što sam pokrivena u prethodnom poglavlju, Analysis Services ima neki native sposobnosti i default izbora kroz svoje default tehnologije obrade. Ova tehnologija default najbolje radi sa standardnim izvorima relacijskim, simplex shemama, i SQL Server posebno. Uglavnom, svako može koristiti SSIS kao dobra alternativa kada polaskom iz ovih jednostavnijih uvjeta, kao i da iskoriste dodatne SSIS ETL sposobnosti kao dio procesa učitava. Učitava je omogućeno dva SSIS protok podataka destinacijama, jedan za dimenzije i jedna za particije: Opet, ne postoji kocka odredište, jer podaci se pohranjuju u particije. Nastaviti čitanje “Korištenje SQL Server Integration Services za učitavanje podataka” »