Zida Zatsopano mu SQL Server 2012 - RC0 yatulutsidwa
Microsoft SQL Server 2012 RC0 posachedwapa inatulutsidwa. RC imayimira Wopereka Wopereka Amene ali makamaka mawonekedwe omwe amakhala okonzeka. Microsoft imatchula kumasulidwa uku monga SQL Server Code yotchedwa "Denali" koma yasintha pa SQL Server 2012 monga dzina lomaliza la mankhwala. Business intelligence (BI) ndi ofunika kwambiri kwa mabungwe akuluakulu ndi aang'ono. Pa kumasulidwa kwatsopano kwa SQL Server, palibe kuchepa kwa zowonjezera BI kuphatikizapo zowonjezera zina zambiri.
Nkhaniyi ikukupatsani chithunzithunzi cha zofunika, zatsopano ndi zowonjezera mu SQL Server 2012 (chikhombo chotchedwa Denali) kuphatikizapo:
- Zida zamakono ndi Maofesi
- Kugwilitsila Powonongeka kwa Multi-Subnet
- Zosintha Zopanga Mapulogalamu, kuphatikizapo zochitika, funso loti ad-hoc paging ndi full-text search tweaks
- BI ndi Web Development Development Mawindo
- Kuwonetseratu kochokera pa Webusaiti
- Dipatimenti ya Utumiki wa Data
Kumbukirani kuti nkhaniyi ndi yawonetseratu zokhazokha ndipo ikusinthidwa ndi Microsoft.
Zida zamakono ndi Maofesi
- Microsoft ikuyamikira kugwiritsa ntchito fayilo ya fayilo ya NTFS mmalo mwa FAT32. FAT32 idzagwira ntchito koma mwina musayigwiritse ntchito.
- Simungathe kukhazikitsa SQL Server 2012 (wotchedwa code Denali) pamalo oyendetsa mapu kapena oyendetsedwa.
- Muyenera kukhala ndi phukusi la "non-reboot" lomwe linaikidwa musanayambe kukhazikitsa SQL Server 2012 (dzina loti Denali). Izi zikuphatikizidwa mu Windows 7 SP1 ndi Windows Server 2008 R2. Popanda kutero, mukhoza kukopera phukusi loyambanso ku Microsoft.
- SQL Server 2012 (dzina loti Denali) limafuna .NET Framework 4.0.
- Kutsatsa kumagwiritsidwa ntchito pogwiritsa ntchito matepi a Microsoft Hyper-V.
- Mufunikira zosachepera 3.6 GB ya disk space space.
- Microsoft imalimbikitsa kuti musamangire SQL Server 2012 (dzina loti Denali) pa controller domain.
- Ovomerezedwa Opanga & RAM
- Mapulogalamu 64: AMD Opteron, AMD Athlin 64, Intel Xeon ndi Intel EM64T Support kapena Intel Pentium IV yomwe imathandizira EM64T yokhala ndi 2.0 GHz kapena mofulumira. Ovomerezeka RAM ndi otsika kwambiri kuti opaleshoni ikuthandizira kapena osachepera 2 GB.
- Vuto la 32-bit: Pentium III kapena yogwirizana ndi 2.0 GHz mofulumira. Ovomerezeka RAM ndi otsika kwambiri kuti opaleshoni ikuthandizira kapena osachepera 2 GB.
- Windows PowerShell 2.0 ndiyomwe ikufunikira pakuyika SQL Server 2012 (dzina loti Denali). Mungathe kupeza pulogalamuyi kuchokera patsamba la Windows Management Framework.
Kugwilitsila Powonongeka kwa Multi-Subnet
Ndi SQL Server 2012 (dzina loti Denali), mungathe kukonza SQL Server pomwe zokopa zamagulu zosokoneza zingagwirizane ndi subnet yosiyana. Makina opondereza amatha kufalikira kumalo osiyanasiyana omwe amapereka chithandizo choopsa komanso kupezeka kwapamwamba. Kuti izi zigwire bwino, muyenera kufotokoza deta kudutsa mazithunzi omwe akukhudzidwa. SQL Server imalepheretsa masango kumadalira masitepe a Windows Server kutsegulira kotero izi ziyenera kukhazikitsidwa poyamba. Kumbukirani kuti zonsezi zomwe zikugwiritsidwa ntchito mukukonzekera izi ziyenera kukhala zofanana ndi Active Directory domain.
Zowonjezera Mapulogalamu
- Zotsatira : Zotsatira zafunsidwa ndi gulu la SQL Server kwa zaka, ndipo zikuphatikizidwa mu kumasulidwa uku. Zotsatira ndi chinthu chofotokozera chomwe chimapanga chiwerengero cha nambala. Pano pali chitsanzo pogwiritsa ntchito Sequence.
/ ****** Pangani Sequence Cholinga ****** /
DZIWANI ZOCHITA Zanga Zanga
YAMBANI NDI 1
ZOKHUDZA NDI 1;/ ****** Pangani Tayamba Loyamba ****** /
TUMIZANI @Person TABLE
(
ID int OSALIKIRE NULL PRIMARY KEY,
FullName nvarchar (100) OSATI NULL
);/ ****** Yesani Zina Zina ****** /
LOWANI @Person (ID, FullName)
ZINTHU ZOFUNIKA KWAMBIRI KWA MYSequence, 'Jim Johnson'),
(ZOCHITA ZOTSATIRA ZA MySequence, 'Bob Thompson'),
(ZOCHITA ZOTSATIRA ZA MySequence, 'Tim Perdue');/ ****** Onetsani Dongosolo ****** /
CHISANKHO * FROM @Person;Zotsatira zikanakhala ngati izi:
ID FullName
Jim Johnson
Bob Thompson
Tim Perdue
- Kufufuza P-Ad Paging: Kukhazikitsa zotsatira mu SQL Server kwafotokozedwa kwa zaka zambiri. Lamulo Mwachidwilo m'mawu a SQL SELECT yakulakitsidwa mu SQL Server 2012. Kugwiritsa ntchito ophatikiza OFFSET ndi FETCH pamodzi ndi ORDER BY kumakupatsani ulamuliro pa paging pogwiritsa ntchito zotsatira. Kugwiritsira ntchito njirayi kungathandize kwambiri ntchito pobwezeretsa zotsatira zokha zomwe mukufuna kuziwonetsera kwa ogwiritsa ntchito pamene mukufunikira. Tsambali ya TSQL yotsatizana ikutsutsana ndi Gome la Munthu muzithunzi zosungiramo zamagulu a AdventureWorks (zochokera ku Microsoft). Mu funso lachitsanzo pansipa, SQL Server idzabwezeretsa chiwerengero cha 10 kuyambira ndi mbiri 11. Lamulo la OFFSET limapereka chiyambi cha ndondomeko ya SELECT ponena za paging, ndipo lamulo la FETCH limapereka mauthenga angati abwerere panthawi.
Sankhani BusinessEntityID, FirstName, LastName
Kuchokera pa Munthu
YAM'MBUYO YOTSATIRA
OFFSET 10 MAFUNSO
YAM'MBUYO YOTSATIRA MITU YACHIWIRI;
- Kufufuza Kwathunthu : The Full Text Search mu SQL Server 2012 yakhala ikukulimbikitsani mwa kukulolani kuti mufufuze ndikuwonetseratu deta yosungidwa pazinthu zambiri kapena metadata. Ganizirani za pulogalamu ya PDF yomwe ili ndi "katundu" wodzazidwa monga Dzina, Mtundu, Folda njira, Kukula, Chilengedwe, ndi zina. Mu SQL Server yotulutsidwa mwatsopano, deta iyi ikhoza kukhala inde ndi kufufuza pamodzi ndi chidziwitso chomwe chili mu chikalata chomwecho. Deta iyenera kuti iwonetsedwe kuntchito, koma ndizotheka tsopano.
BI ndi Web Development Development Mawindo
Microsoft inayambitsa BI (Business Intelligence) pafupi ndi wogwiritsa ntchito yomaliza ndi SQL Server 2008 R2. Chida cha Excel PowerPivot chimathandiza ogwiritsa ntchito popanga chitsanzo chodziwitsa anthu. Uthenga wabwino ndi PowerPivot ukulimbikitsidwa mu SQL Server 2012 (dzina loti Denali). Microsoft ikuwonjezera KPIs ndikuyendetsa, yomwe idzakhala yothandiza kwa ogwiritsa ntchito onse.
Analysis Services idzaphatikizapo BI Semantic Model (BISM) yatsopano. BISM ndi chitsanzo chachitatu chophatikizapo:
- Chitsanzo cha Deta
- Malingaliro Amalonda
- Kupeza Deta
BISM idzalimbikitsa kutsindika kwa mapeto a Microsoft akukumana nawo kuphatikizapo Excel, Reporting Services ndi SharePoint Insights. Microsoft yanena kuti BISM siimalo m'malo mwa BI Models panopa koma ena mwachitsanzo. Mwachidule, BISM ndi chitsanzo choyanjana chomwe chimaphatikizapo kupanga BI monga ma KPIs ndi mazenera.
Mawonekedwe Owonetsekera pa Webusaiti - Chinsalu cha Project
Project Crescent ndi dzina la khodi la Microsoft la chida chatsopano chofotokozera komanso chowonetseratu choyembekezeredwa mu SQL Server 2012 (dzina loti Denali). Project Crescent ikupereka kukoka ndi kuponyera ntchito zowonetsera malonda ndipo idamangidwa kwathunthu pa Silverlight.
Imaphatikizapo chida champhamvu chofunsira komanso kukambirana zojambula zojambula zothandizira kuti wothandizira awonetseni mawonekedwe a ma datasti akuluakulu.
Dipatimenti ya Utumiki wa Data
Dipatimenti ya Utumiki wa Deta ndi njira yophunzirira yomwe imayenda mu SSIS (SQL Services Integration Services). Mkhalidwe wa data ndi chimodzi mwa zinthu zomwe simungakwanitse. Microsoft ikuyambitsa "Impact Analysis ndi Lineage" yomwe idzakupatsani inu kudziwa za zomwe deta yanu imadalira. Amasonyezanso mndandanda wa deta, kuphatikizapo komwe imachokera komanso machitidwe omwe ali kumbuyo kwake.