本網站為了分析、個人化內容和廣告目的而使用 Cookie。繼續瀏覽本網站,表示您同意這個用途。 了解詳情
  • TechNet
  • 產品
  • 資源
  • 下載
  • 培訓
  • 支援
產品
  • Windows
  • Windows Server
  • System Center
  • Microsoft Edge
 
  • Office
  • Office 365
  • Exchange Server
 
  • SQL Server
  • SharePoint 產品
  • Skype for Business
  • 查看所有產品 »
Resources
  • Channel 9 Video
  • 評估中心
  • 學習資源
  • Microsoft Tech 小幫手應用程式
  • Microsoft Technical Communities
  • Microsoft Virtual Academy
  • 指令碼中心
  • 伺服器和工具部落格
  • TechNet 部落格
 
  • TechNet Flash 電子報
  • TechNet 組件庫
  • TechNet 文件庫
  • TechNet 雜誌
  • TechNet Wiki
  • Windows Sysinternals
  • 虛擬實驗室
Solutions
  • 網路連線
  • 私用雲端
  • 安全性
  • 虛擬化
更新
  • Service Pack
  • 資訊安全公告
  • Microsoft Update
試用版
  • Windows Server 2016
  • System Center 2016
  • Windows 10 Enterprise
  • SQL Server 2016
  • 查看所有試用版 »
相關網站
  • Microsoft 下載中心
  • Microsoft Evaluation Center
  • 驅動程式
  • Windows Sysinternals
  • TechNet 組件庫
培訓
  • 由專家帶領的虛擬課程
  • 訓練目錄
  • 課程地點
  • Microsoft Virtual Academy
  • 免費的 Windows Server 2012 課程
  • Free Windows 8 courses
  • SQL Server 訓練課程
  • e-Learning 概觀
認證
  • 認證概觀
  • MCSA: Windows 10
  • Windows Server 認證 (MCSE)
  • 私用雲端認證 (MCSE)
  • SQL Server 認證 (MCSE)
其他資源
  • Microsoft 活動
  • 重考認證
  • Born To Learn 部落格
  • Find technical communities in your area
產品支援
  • 企業用戶
  • 適用於開發人員
  • 適用於 IT 專業人員
  • 取得技術支援
  • 提供支援服務
其他支援連結
  • Microsoft Premier Online
  • TechNet 論壇
  • MSDN 論壇
  • 安全公佈欄及諮詢
不是 IT 專業人員嗎?
  • Microsoft 客戶支援
  • Microsoft 社群論壇
Windows 用戶端技術中心
 
登入
台灣 (中文)Drop down arrow
Brasil (Português)Česká republika (Čeština)Deutschland (Deutsch)España (Español)France (Français)Indonesia (Bahasa)Italia (Italiano)România (Română)Türkiye (Türkçe)United States (English)Россия (Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)中国 (中文)日本 (日本語)대한민국 (한국어)
 
 
首頁Windows 10Windows 8.1Windows 7舊版Windows PhoneMDOPSurface文件庫論壇
發問
快速存取
  • 論壇首頁
  • 瀏覽論壇使用者
  • FAQ
查看 84 個公告

SQL Server Forumu 公告

  • 連結
    Siz Değerli Forum Kullanıcılarının Dikkatine !
    Ali Rıza İnceoğlu 2012年8月29日 上午 10:43
    Değerli Forum kullanıcıları;

    Öncelikle hepinize selamlar. Msdn Forum bünyesi ve Microsoft ailesi olarak sizlerden bir kaç küçük ricamız var.


    İlk olarak lütfen sorduğunuz sorular konusundaki hassasiyetinize özen gösterin. Soracağınız sorunun hangi kategoriye ait olması gerektiği, en net biçimde hangi başlıkla sunulabileceği ve tabi ki sorulan sorunun açıklayıcı ve problem tam olarak detaylı bir şekilde açıklanmış olması hem bizler hem de yardımcı olmak isteyecek ya da yardım alacak kullanıcılarımız açısından büyük önem arz ediyor.

    İkinci olarak dikkat etmenizi istediğimiz husus sorduğunuz soruları takip etmeniz. Lütfen soruların takibini özenli bir şekilde sürdürün. Başka bir kullanıcı soru ile ilgili detay ister ya da farklı bir şey sorarsa lütfen probleminizle ilgili onları bilgilendirin. Verilen bir cevap probleminizde sizi çözüme yönlendiriyorsa "yanıt olarak işaretle" kısmına tıklayın. Hem soruyu soran hem de o soruyu takip eden diğer kullanıcılarımız ise lütfen çözüme katkıda bulunan cavapları "yardımcı olarak oyla" kısmından oylayın ve problemin çözümünde işe yarayacağından emin olduğunuz hatta denediğiniz bir cevap varsa lütfen "yanıt olarak öner" kısmını işaretleyiniz. Tüm bunları söylerken, sizi rahatsız eden herhangi bir ifade ya da sorulan soruda herhangi bir olumsuzluk tesbit ettiğinizde uygunsuz olarak işaretlemeyi de ihmal etmeyin.

    *Son ve en önemli konu olarak foruma verilen katkılardan bahsetmek istiyorum. Biz Msdn olarak her kullanıcımızın foruma katkısının maksimum seviyede olmasını istiyoruz. Bu noktada sizlerden soru sormak dışında cevaplayabileceğiniz her türlü soruya yanıt vermekten çekinmemenizi ayrıca bilgi ve tecrübeleriniz dahilinde yukarıda bahsettiğim adımları gerçekleştirmenizi bekliyoruz. Katkıları belli bir süre üzerinde aktif olarak artan kullanıcılarımızı ilgili forumlara sırasıyla "yanıtlayıcı" ve "moderatör" olarak atıyoruz. Biliyorsunuz ki MVP için her yıl bir çok aday değerlendiriliyor ve bu değerlendirmeler de Community'e olan katkılar göz önüne alınarak gerçekleştiriliyor. Bu konuda öncelik her daim forum üzerinde aktif olan kullanıcılara veriliyor. Bunun da tüm kullanıcılarımızı bu konuda biraz olsun teşvik edeceğini düşünüyoruz.*



    Yukarıda bahsi geçen konular hakkındaki duyarlılığınız ve dikkatiniz için şimdiden hepinize çok çok teşekkür ediyor, saygılarımızı sunuyoruz.
  • 連結
    Sosyal Medya Bağlantıları
    Serkan Bark 2012年3月16日 上午 10:54

    Merhaba,

    Arkadaşlar forumlarımız üzerinde, profil sayfamız'a Sosyal Medya bağlantıları eklendi. Sizlere ulaşabilmemiz için lütfen sosyal media bağlantılarınızı güncelleyiniz.

     

    Teşekkürler.

  • 連結
    Forum Platformuna İlişkin Geri Bildirimler
    Emre Gunerturk 2012年2月16日 下午 02:26

    Merhaba arkadaşlar,

    Kullandığınız forum platformuyla ilgili her görüş,öneri ve problemi aşağıdaki konuda paylaşmanızı rica ediyorum.

    http://social.msdn.microsoft.com/Forums/tr-TR/konudisitr/thread/215a4de2-1e8f-42da-86ec-aa2327df06b7

    İyi forumlar.

  • 連結
    MSDN Forum Assistant - Türkçe!
    Emre Gunerturk 2011年8月4日 上午 11:42

    MSDN Forum Asistanı ile tarayıcınızı açıp forum URL'sini girmenize gerek yok. Masaüstünüzden bir tık ile forumlara ulaşın,soru sorun,konuları takip edin,sıkça sorulan sorular arasında gezinin! Bu masaüstü aracı vasitasıyla bir tık ile forumlar üzerinde konu açabilir,forumlar ya da kullanıcılar için son aktiviteleri görebilir,sıkça sorulan soruları inceleyebilirsiniz. Aracı indirip kurduktan sonra tek yapmanız gereken Options menüsünden takip etmek istediğiniz forumları ya da kişiyi belirlemeniz.

    http://social.msdn.microsoft.com/Forums/tr-TR/konudisitr/thread/6d50060b-3d8c-49dd-8fea-c83168d862bb

  • 連結
    Microsoft Community Contributor Programı
    Ekrem Önsoy 2011年5月13日 上午 08:34

    Günden güne ulaşabileceğimiz online kaynaklar artmakta ve teknolojiyle ilgilenen insanlar bu kaynakları sorunlarını gidermek,bilgi alışverişi yapmak için çok sık kullanmaktalar. Microsoft'ta bu noktadan yola çıkarak MSDN-TechNet ya da MS Answers forumlarında gönüllü olarak katkı yapan,zaman ve enerjisini harcayan kullanıcıları takip ederek bu kullanıcılara Microsoft Community Contributor ödülünü layık görüyor.

    Microsoft tarafından seçilecek ödül sahipleri ayrıca derin teknik bilgi ve tecrübeye sahip topluluk liderleri olan değerli MVP'ler tarafından aday gösterilerekte bu ödülü alabilecekler.

    Geçmişte yapılan katkılar kıstas alınarak yapılacak değerlendirme sonucunda kazanılacak olan bu ödül için Microsoft herhangi bir ödeme yapmamakla beraber,forumlarda ödül sahibine MCC olduğunu belirtir bir ünvan ile Microsoft Press E-Referans Kütüphanesine 1 senelik ücretsiz üyelik gibi fırsatlar sunulmakta. Ödül 3 aylık bir süreç için kazanılıyor ancak yapılan sürekli katkılar sonrası yenilenmesi de mümkün.

    2010 Yılında Amerika Birleşik Devletlerinde uygulamaya başlanan bu program artık diğer ülkelerde hayata geçmiş durumda.

    Ödül ile ilgili detaylı bilgiyi aşağıdaki adresten bulabilirsiniz.
    https://www.microsoftcommunitycontributor.com/overview.aspx

    Resmi Facebook Sayfası
    http://www.facebook.com/pages/Microsoft-Community-Contributor/113784705335192


  • 連結
    TechNet Türkiye Forumları - Konu Dışı Kategorisi
    Serkan Bark 2011年1月17日 下午 03:16

    Merhaba Arkadaşlar,

    TechNet Türkiye Forumları sizlere daha iyi hizmet verebilmek için yeni bir kategori açmış bulunmaktadır.

    Kategori: Konu Dışı
    Amaç: Genel olarak TechNet üzerindeki ürünlere yönelik olmayan ancak bilgi almak istenilen soruların sorulabileceği yeni kategorimiz.

    http://social.technet.microsoft.com/Forums/tr-TR/konudisitntr/threads
     
    Konu Dışı Forumumuzda görüşmek üzere!

    İyi Çalışamalar.

SQL Server 公告

  • 連結
    כללי התנהגות בפורום, נא לקרוא לפני פירסום שאלה !
    Meir Pinto 2011年1月31日 上午 09:59

    כללי התנהגות בפורומים של מיקרוסופט ישראל.

    שלום וברוכים הבאים לפורום TechNet\MSDN של מיקרוסופט.
    אם זהו ביקורך הראשון בפורום, לפני התחלת השימוש בפורומים ממולץ לקרוא את עמוד
    השאלות הנפוצות לפעולות הראשוניות בפורום.

    שימו לב: כל המשתמשים אשר עונים לשאלות בפורום עושים זאת מזמנם החופשי ובהתנדבות
    המשיבים והמגיבים, בו, תורמים מזמנם הפנוי ומהידע אותו רכשו במהלך השנים על מנת לסייע לחברי הקהילה.
    מילת ברכה והערכה בתחילה ההודעה כמו "שלום" ובסוף ההודעה כמו "תודה רבה" יראו על כבוד והערכה לחברי הפורום.

    רוצים לשאול שאלה בפורום? מומלץ לבצע חיפוש לשאלה שלכם, ייתכן והשאלה כבר נשאלה ונענתה

    לפני שתתחילו לפרסם הודעה בפורום אנא כבדו את כללי הפורום הבאים:

    1. כבדו איש את רעהו והשתמשו בשפה נאותה כלפי חברי הפורום באשר הם (מנהלי הדיון, חברי הפורום וכו').

    2. בחרו בקפידה כותרת מתאימה לשאלה שתפרסמו.

    3. בהתאם לשאלה רשמו כמה שיותר פרטים רלוונטים שיכולים לעזור כמו: גירסת מערכת ההפעלה, גירסת התוכנה בה הנכם משתמשים, סוג הדפדפן, פעולות שבצעתם וכו'.

    4. שאלתם שאלה וקיבלתם תשובה לשאלתכם? סמנו את התשובה הנראית לכם כמועילה ביותר (לחיצה על "סמן כתשובה" ליד סימן ה- V הירוק בתחתית ההודעה).

    5. לעולם אל תמסרו את הסיסמה שלכם או פרטי כרטיס אשראי בפורום בתמורה למידע כזה או אחר.

    6. אין לפרסם תוכן שיווקי, פרסומות, קישורים שיווקים, פרסום חברות, מכרזים ועוד.

    7. אין לפרסם תוכן פורנוגרפי, תוכן גזעני, קישורים להורדות לא חוקיות, קישורים לאתרים עם תוכן דומה, בהודועת, בחתימה או בתגובה לשאלה בפורום. הודעות מסוג זה ימחקו לאלתר.

    8. התוכן המופיע באתר זה הינו תוכן שנכתב על ידי הגולשים. התוכן אינו מטעם או בשליטת/פיקוח מיקרוסופט והיא אינה אחראית לו בכל צורה או אופן.

    9. תהנו J

    למען הסר ספק ההוראות המצוינות לעיל באות להוסיף בלבד על תנאי השימוש הכלליים באתר (להלן: "תנאי השימוש") ובכל מקרה לא ייגרעו ממי מהוראות תנאי השימוש.
    בכל מקרה של סתירה בין הוראות תנאי השימוש ובין ההוראות לעיל תגברנה הוראות תנאי השימוש.

  • 連結
    שימוש נאות בפורום לפרסום שירותים\מוצרים מסחריים
    Ami Levin 2010年12月6日 下午 12:21

    למרות שאין מטרת הפורום לשמש כבמה פרסומית מסוג כלשהוא, במהלך השנים התרנו לגופים המעוניינים לפרסם שירותים או מוצרים מסחריים שיש בהם תועלת אמיתית ורלוונטיות מובהקת לנושא הפורום.

    על מנת שנוכל להמשיך ולהתיר זאת, נבקש להקפיד על הכללים הבאים:

    1. יש לקבל אישור מראש לתוכן ההודעה מאחד ממנהלי הפורום.

    2. בכותרת ההודעה יש לרשום במפורש את התגית [פרסומת] על מנת להקל על מי שלא מעוניין לקרוא פרסומות לדלג עליה.

    כמובן שתוכן ההודעות הוא באחריותו הבלעדית של המפרסם ואין למיקרוסופט, למנהלי הפורום או מי מטעמם כל אחריות ישירה או עקיפה לכל עניין הקשור לתוכן ההודעות ו\או לכל עניין הקשור לפרסומן או אי פרסומן על גבי הפורום.

    הודעות שיפורסמו ללא אישור מראש או ללא התגית יימחקו ותוגש תלונה למחלקה המשפטית של מיקרוסופט נגד המשתמש שפרסם אותן.

SQL Server 公告

  • 連結
    כללי התנהגות בפורום, נא לקרוא לפני פירסום שאלה !
    Meir Pinto 2011年1月31日 上午 09:59

    כללי התנהגות בפורומים של מיקרוסופט ישראל.

    שלום וברוכים הבאים לפורום TechNet\MSDN של מיקרוסופט.
    אם זהו ביקורך הראשון בפורום, לפני התחלת השימוש בפורומים ממולץ לקרוא את עמוד
    השאלות הנפוצות לפעולות הראשוניות בפורום.

    שימו לב: כל המשתמשים אשר עונים לשאלות בפורום עושים זאת מזמנם החופשי ובהתנדבות
    המשיבים והמגיבים, בו, תורמים מזמנם הפנוי ומהידע אותו רכשו במהלך השנים על מנת לסייע לחברי הקהילה.
    מילת ברכה והערכה בתחילה ההודעה כמו "שלום" ובסוף ההודעה כמו "תודה רבה" יראו על כבוד והערכה לחברי הפורום.

    רוצים לשאול שאלה בפורום? מומלץ לבצע חיפוש לשאלה שלכם, ייתכן והשאלה כבר נשאלה ונענתה

    לפני שתתחילו לפרסם הודעה בפורום אנא כבדו את כללי הפורום הבאים:

    1. כבדו איש את רעהו והשתמשו בשפה נאותה כלפי חברי הפורום באשר הם (מנהלי הדיון, חברי הפורום וכו').

    2. בחרו בקפידה כותרת מתאימה לשאלה שתפרסמו.

    3. בהתאם לשאלה רשמו כמה שיותר פרטים רלוונטים שיכולים לעזור כמו: גירסת מערכת ההפעלה, גירסת התוכנה בה הנכם משתמשים, סוג הדפדפן, פעולות שבצעתם וכו'.

    4. שאלתם שאלה וקיבלתם תשובה לשאלתכם? סמנו את התשובה הנראית לכם כמועילה ביותר (לחיצה על "סמן כתשובה" ליד סימן ה- V הירוק בתחתית ההודעה).

    5. לעולם אל תמסרו את הסיסמה שלכם או פרטי כרטיס אשראי בפורום בתמורה למידע כזה או אחר.

    6. אין לפרסם תוכן שיווקי, פרסומות, קישורים שיווקים, פרסום חברות, מכרזים ועוד.

    7. אין לפרסם תוכן פורנוגרפי, תוכן גזעני, קישורים להורדות לא חוקיות, קישורים לאתרים עם תוכן דומה, בהודועת, בחתימה או בתגובה לשאלה בפורום. הודעות מסוג זה ימחקו לאלתר.

    8. התוכן המופיע באתר זה הינו תוכן שנכתב על ידי הגולשים. התוכן אינו מטעם או בשליטת/פיקוח מיקרוסופט והיא אינה אחראית לו בכל צורה או אופן.

    9. תהנו J

    למען הסר ספק ההוראות המצוינות לעיל באות להוסיף בלבד על תנאי השימוש הכלליים באתר (להלן: "תנאי השימוש") ובכל מקרה לא ייגרעו ממי מהוראות תנאי השימוש.
    בכל מקרה של סתירה בין הוראות תנאי השימוש ובין ההוראות לעיל תגברנה הוראות תנאי השימוש.

  • 連結
    שימוש נאות בפורום לפרסום שירותים\מוצרים מסחריים
    Ami Levin 2010年12月6日 下午 12:21

    למרות שאין מטרת הפורום לשמש כבמה פרסומית מסוג כלשהוא, במהלך השנים התרנו לגופים המעוניינים לפרסם שירותים או מוצרים מסחריים שיש בהם תועלת אמיתית ורלוונטיות מובהקת לנושא הפורום.

    על מנת שנוכל להמשיך ולהתיר זאת, נבקש להקפיד על הכללים הבאים:

    1. יש לקבל אישור מראש לתוכן ההודעה מאחד ממנהלי הפורום.

    2. בכותרת ההודעה יש לרשום במפורש את התגית [פרסומת] על מנת להקל על מי שלא מעוניין לקרוא פרסומות לדלג עליה.

    כמובן שתוכן ההודעות הוא באחריותו הבלעדית של המפרסם ואין למיקרוסופט, למנהלי הפורום או מי מטעמם כל אחריות ישירה או עקיפה לכל עניין הקשור לתוכן ההודעות ו\או לכל עניין הקשור לפרסומן או אי פרסומן על גבי הפורום.

    הודעות שיפורסמו ללא אישור מראש או ללא התגית יימחקו ותוגש תלונה למחלקה המשפטית של מיקרוסופט נגד המשתמש שפרסם אותן.

SQL Server Forumu 公告

  • 連結
    Siz Değerli Forum Kullanıcılarının Dikkatine !
    Ali Rıza İnceoğlu 2012年8月29日 上午 10:43
    Değerli Forum kullanıcıları;

    Öncelikle hepinize selamlar. Msdn Forum bünyesi ve Microsoft ailesi olarak sizlerden bir kaç küçük ricamız var.


    İlk olarak lütfen sorduğunuz sorular konusundaki hassasiyetinize özen gösterin. Soracağınız sorunun hangi kategoriye ait olması gerektiği, en net biçimde hangi başlıkla sunulabileceği ve tabi ki sorulan sorunun açıklayıcı ve problem tam olarak detaylı bir şekilde açıklanmış olması hem bizler hem de yardımcı olmak isteyecek ya da yardım alacak kullanıcılarımız açısından büyük önem arz ediyor.

    İkinci olarak dikkat etmenizi istediğimiz husus sorduğunuz soruları takip etmeniz. Lütfen soruların takibini özenli bir şekilde sürdürün. Başka bir kullanıcı soru ile ilgili detay ister ya da farklı bir şey sorarsa lütfen probleminizle ilgili onları bilgilendirin. Verilen bir cevap probleminizde sizi çözüme yönlendiriyorsa "yanıt olarak işaretle" kısmına tıklayın. Hem soruyu soran hem de o soruyu takip eden diğer kullanıcılarımız ise lütfen çözüme katkıda bulunan cavapları "yardımcı olarak oyla" kısmından oylayın ve problemin çözümünde işe yarayacağından emin olduğunuz hatta denediğiniz bir cevap varsa lütfen "yanıt olarak öner" kısmını işaretleyiniz. Tüm bunları söylerken, sizi rahatsız eden herhangi bir ifade ya da sorulan soruda herhangi bir olumsuzluk tesbit ettiğinizde uygunsuz olarak işaretlemeyi de ihmal etmeyin.

    *Son ve en önemli konu olarak foruma verilen katkılardan bahsetmek istiyorum. Biz Msdn olarak her kullanıcımızın foruma katkısının maksimum seviyede olmasını istiyoruz. Bu noktada sizlerden soru sormak dışında cevaplayabileceğiniz her türlü soruya yanıt vermekten çekinmemenizi ayrıca bilgi ve tecrübeleriniz dahilinde yukarıda bahsettiğim adımları gerçekleştirmenizi bekliyoruz. Katkıları belli bir süre üzerinde aktif olarak artan kullanıcılarımızı ilgili forumlara sırasıyla "yanıtlayıcı" ve "moderatör" olarak atıyoruz. Biliyorsunuz ki MVP için her yıl bir çok aday değerlendiriliyor ve bu değerlendirmeler de Community'e olan katkılar göz önüne alınarak gerçekleştiriliyor. Bu konuda öncelik her daim forum üzerinde aktif olan kullanıcılara veriliyor. Bunun da tüm kullanıcılarımızı bu konuda biraz olsun teşvik edeceğini düşünüyoruz.*



    Yukarıda bahsi geçen konular hakkındaki duyarlılığınız ve dikkatiniz için şimdiden hepinize çok çok teşekkür ediyor, saygılarımızı sunuyoruz.
  • 連結
    Sosyal Medya Bağlantıları
    Serkan Bark 2012年3月16日 上午 10:54

    Merhaba,

    Arkadaşlar forumlarımız üzerinde, profil sayfamız'a Sosyal Medya bağlantıları eklendi. Sizlere ulaşabilmemiz için lütfen sosyal media bağlantılarınızı güncelleyiniz.

     

    Teşekkürler.

  • 連結
    Forum Platformuna İlişkin Geri Bildirimler
    Emre Gunerturk 2012年2月16日 下午 02:26

    Merhaba arkadaşlar,

    Kullandığınız forum platformuyla ilgili her görüş,öneri ve problemi aşağıdaki konuda paylaşmanızı rica ediyorum.

    http://social.msdn.microsoft.com/Forums/tr-TR/konudisitr/thread/215a4de2-1e8f-42da-86ec-aa2327df06b7

    İyi forumlar.

  • 連結
    MSDN Forum Assistant - Türkçe!
    Emre Gunerturk 2011年8月4日 上午 11:42

    MSDN Forum Asistanı ile tarayıcınızı açıp forum URL'sini girmenize gerek yok. Masaüstünüzden bir tık ile forumlara ulaşın,soru sorun,konuları takip edin,sıkça sorulan sorular arasında gezinin! Bu masaüstü aracı vasitasıyla bir tık ile forumlar üzerinde konu açabilir,forumlar ya da kullanıcılar için son aktiviteleri görebilir,sıkça sorulan soruları inceleyebilirsiniz. Aracı indirip kurduktan sonra tek yapmanız gereken Options menüsünden takip etmek istediğiniz forumları ya da kişiyi belirlemeniz.

    http://social.msdn.microsoft.com/Forums/tr-TR/konudisitr/thread/6d50060b-3d8c-49dd-8fea-c83168d862bb

  • 連結
    Microsoft Community Contributor Programı
    Ekrem Önsoy 2011年5月13日 上午 08:34

    Günden güne ulaşabileceğimiz online kaynaklar artmakta ve teknolojiyle ilgilenen insanlar bu kaynakları sorunlarını gidermek,bilgi alışverişi yapmak için çok sık kullanmaktalar. Microsoft'ta bu noktadan yola çıkarak MSDN-TechNet ya da MS Answers forumlarında gönüllü olarak katkı yapan,zaman ve enerjisini harcayan kullanıcıları takip ederek bu kullanıcılara Microsoft Community Contributor ödülünü layık görüyor.

    Microsoft tarafından seçilecek ödül sahipleri ayrıca derin teknik bilgi ve tecrübeye sahip topluluk liderleri olan değerli MVP'ler tarafından aday gösterilerekte bu ödülü alabilecekler.

    Geçmişte yapılan katkılar kıstas alınarak yapılacak değerlendirme sonucunda kazanılacak olan bu ödül için Microsoft herhangi bir ödeme yapmamakla beraber,forumlarda ödül sahibine MCC olduğunu belirtir bir ünvan ile Microsoft Press E-Referans Kütüphanesine 1 senelik ücretsiz üyelik gibi fırsatlar sunulmakta. Ödül 3 aylık bir süreç için kazanılıyor ancak yapılan sürekli katkılar sonrası yenilenmesi de mümkün.

    2010 Yılında Amerika Birleşik Devletlerinde uygulamaya başlanan bu program artık diğer ülkelerde hayata geçmiş durumda.

    Ödül ile ilgili detaylı bilgiyi aşağıdaki adresten bulabilirsiniz.
    https://www.microsoftcommunitycontributor.com/overview.aspx

    Resmi Facebook Sayfası
    http://www.facebook.com/pages/Microsoft-Community-Contributor/113784705335192


  • 連結
    TechNet Türkiye Forumları - Konu Dışı Kategorisi
    Serkan Bark 2011年1月17日 下午 03:16

    Merhaba Arkadaşlar,

    TechNet Türkiye Forumları sizlere daha iyi hizmet verebilmek için yeni bir kategori açmış bulunmaktadır.

    Kategori: Konu Dışı
    Amaç: Genel olarak TechNet üzerindeki ürünlere yönelik olmayan ancak bilgi almak istenilen soruların sorulabileceği yeni kategorimiz.

    http://social.technet.microsoft.com/Forums/tr-TR/konudisitntr/threads
     
    Konu Dışı Forumumuzda görüşmek üzere!

    İyi Çalışamalar.

Für IT-Professionals: SQL Server 公告

  • 連結
    Microsoft® SQL Server® 2012 Release Candidate 0 (RC0) - steht zum Download bereit
    Alex Pitulice 2011年11月18日 下午 05:03

    Hallo Community,

    Release Candidate 0 von SQL Server 2012 ist ab jetzt verfügbar.

    Weitere Informationen zum Release und Download findet man unter den Links.

    Im Nathaniel Scharer's Artikel (Program Manager - SQL Server Content and Community team) können sie auch wichtige Versionsanmerkungen für Microsoft SQL Server 2012 RC 0 (de-DE) herausfinden.

    Gruss,

    Alex

  • 連結
    TechNet Hotline - Hilfe per Telefon und E-Mail
    Andrei Talmaciu 2010年10月25日 上午 06:12

    Sie haben Fragen zu TechNet Online, dem deutschsprachigen Portal für IT-Professionals? Sie benötigen technische Ressourcen zu den Server-, Client- und Verwaltungsprodukten von Microsoft? Sie suchen bestimmte Downloads, Tools oder Testversionen? Dann nutzen Sie die TechNet Hotline, um schnell an die richtigen Informationen zu kommen.

    http://technet.microsoft.com/de-de/ff959330.aspx?ocid=otc-n-de-sat

Für IT-Professionals: SQL Server 公告

  • 連結
    Microsoft® SQL Server® 2012 Release Candidate 0 (RC0) - steht zum Download bereit
    Alex Pitulice 2011年11月18日 下午 05:03

    Hallo Community,

    Release Candidate 0 von SQL Server 2012 ist ab jetzt verfügbar.

    Weitere Informationen zum Release und Download findet man unter den Links.

    Im Nathaniel Scharer's Artikel (Program Manager - SQL Server Content and Community team) können sie auch wichtige Versionsanmerkungen für Microsoft SQL Server 2012 RC 0 (de-DE) herausfinden.

    Gruss,

    Alex

  • 連結
    TechNet Hotline - Hilfe per Telefon und E-Mail
    Andrei Talmaciu 2010年10月25日 上午 06:12

    Sie haben Fragen zu TechNet Online, dem deutschsprachigen Portal für IT-Professionals? Sie benötigen technische Ressourcen zu den Server-, Client- und Verwaltungsprodukten von Microsoft? Sie suchen bestimmte Downloads, Tools oder Testversionen? Dann nutzen Sie die TechNet Hotline, um schnell an die richtigen Informationen zu kommen.

    http://technet.microsoft.com/de-de/ff959330.aspx?ocid=otc-n-de-sat

SQL Server, Azure SQL Database 公告

  • 連結
    Corsi su Microsoft Virtual Academy
    Irina Turcu 2014年8月12日 下午 02:06

    La Microsoft Virtual Academy (MVA) offre centinaia di corsi online gratuiti, realizzati in 12 diverse lingue da persone esperte, per aiutare chi si occupa di tecnologia ad imparare e migliorare. Il servizio di MVA è gratuito ed è destinato ad aiutare gli sviluppatori, gli IT Professional e gli studenti ad imparare le ultime tecnologie, accrescendo le proprie competenze, per costruirsi una carriera professionale sempre migliore.

    Se volete imparare come sfruttare le funzioni di SQL Server nelle vostre applicazioni potete andare a guardare il corso di seguito:

    Querying Microsoft SQL Server 2012 Databases Jump Start

    Buon studio!


  • 連結
    [Manifesto] Regole e Aspetti generali sul uso dei forum MSDN
    Mila Daniel Ovidiu 2011年4月19日 下午 12:09
    Regole e Aspetti generali sul uso dei forum MSDN
  • 連結
    Linee guida per l'utilizzo del Forum
    Anca Popa 2010年9月16日 上午 08:12

    Linee guida per l'utilizzo del Forum

SQL Server, Azure SQL Database 公告

  • 連結
    Corsi su Microsoft Virtual Academy
    Irina Turcu 2014年8月12日 下午 02:06

    La Microsoft Virtual Academy (MVA) offre centinaia di corsi online gratuiti, realizzati in 12 diverse lingue da persone esperte, per aiutare chi si occupa di tecnologia ad imparare e migliorare. Il servizio di MVA è gratuito ed è destinato ad aiutare gli sviluppatori, gli IT Professional e gli studenti ad imparare le ultime tecnologie, accrescendo le proprie competenze, per costruirsi una carriera professionale sempre migliore.

    Se volete imparare come sfruttare le funzioni di SQL Server nelle vostre applicazioni potete andare a guardare il corso di seguito:

    Querying Microsoft SQL Server 2012 Databases Jump Start

    Buon studio!


  • 連結
    [Manifesto] Regole e Aspetti generali sul uso dei forum MSDN
    Mila Daniel Ovidiu 2011年4月19日 下午 12:09
    Regole e Aspetti generali sul uso dei forum MSDN
  • 連結
    Linee guida per l'utilizzo del Forum
    Anca Popa 2010年9月16日 上午 08:12

    Linee guida per l'utilizzo del Forum

Data Mining 公告

  • 連結
    Live at BI Labs: SQL Server Data Mining for the Cloud
    Raman Iyer 2011年4月29日 下午 07:37

    Microsoft BI Labs went live today featuring a look into the future of SQL Server Data Mining in the Cloud. The SQL Server Data Mining team presents a set of prototype web services  in the cloud that mirror some of the great predictive analytics functionality available in the Table Analysis Tools for Excel add-in from the SQL Server 2008 Data Mining Add-ins for Office package. No installation required.

     

    This blog post provides more details.

     

    Explore these predictive services from your browser - on your own data - and give us your feedback!

Data Mining 公告

  • 連結
    Live at BI Labs: SQL Server Data Mining for the Cloud
    Raman Iyer 2011年4月29日 下午 07:37

    Microsoft BI Labs went live today featuring a look into the future of SQL Server Data Mining in the Cloud. The SQL Server Data Mining team presents a set of prototype web services  in the cloud that mirror some of the great predictive analytics functionality available in the Table Analysis Tools for Excel add-in from the SQL Server 2008 Data Mining Add-ins for Office package. No installation required.

     

    This blog post provides more details.

     

    Explore these predictive services from your browser - on your own data - and give us your feedback!

SQL Server Reporting Services, Power View 公告

  • 連結
    Reporting Services Migration Tool v1
    Tristan Fernando 2012年4月22日 下午 10:54

    We have released a beta version of the Reporting Services Migration Tool.  The tool is available for download at:

    http://www.microsoft.com/download/en/details.aspx?id=29560

    This tool essentially allows you to create a backup store of a native mode Report Server and then migrate that content to a SharePoint-integrated mode Report Server.  Migrated content includes all report items (reports, shared data sources, models, shared datasets, report parts), along with associated metadata (shared schedules, subscriptions, history snapshots, etc.).  Some additional details are in this blog post, along with the download link:

    http://blogs.msdn.com/b/jameswu/archive/2012/04/21/reporting-services-migration-tool.aspx

    We are working on enabling more features in this tool, so feel free to share any feedback or report any issues.  Thanks!

  • 連結
    Reporting Services 2008 R2 - Resources & Latest Downloads
    Robert Bruckner 2010年5月24日 下午 03:45

    Last Update: Mar 4, 2011.

    SQL Server 2008 R2 was released to manufacturing on April 21, 2010.  You can read more about it here.

    Downloads available: 

    • Report Builder 3.0 RTM 
    • SQL Server 2008 R2 RTM - Developer Trial Edition
    • SQL Server 2008 R2 RTM - Express Edition with Advanced Services
    • SQL Server 2008 R2 RTM - Documentation
    • SQL Server 2008 R2 RTM - Feature Pack (with Report Builder and PowerPivot for Excel 2010)
    • Reporting Services 2008 R2 Add-in for SharePoint 2010
    • Visual Studio 2010 Report Viewer Redistributable

    Cumulative Updates:

    • SQL Server 2008 R2 RTM Cumulative Update #6 (build 10.50.1765)
    • SQL Server 2008 R2 RTM Cumulative Update #5 (build 10.50.1753)
    • SQL Server 2008 R2 RTM Cumulative Update #4 (build 10.50.1746)
    • SQL Server 2008 R2 RTM Cumulative Update #3 (build 10.50.1734)
    • SQL Server 2008 R2 RTM Cumulative Update #2 (build 10.50.1720)
    • SQL Server 2008 R2 RTM Cumulative Update #1 (build 10.50.1702)

    You can read about specific new Reporting Services features added in November CTP on top of what was available in August CTP.  You can research and ask questions on the dedicated MSDN forum. 

  • 連結
    ** Please Include SSRS Version When Posting Questions
    Sean Boon 2009年4月22日 上午 04:45
    When posting questions in this forum, please include the version of SQL Server Reporting Services you are using.  This will help us be more efficient in answering questions.  If you are using the Report Viewer Control, it will helpful if you include the version of the control as well. 

    Thanks,
    Sean
  • 連結
    Reporting Services 2008 - Resources & Latest Downloads (SP2)
    Robert Bruckner 2009年2月5日 下午 09:44
    Last update: Mar 27, 2011.


    Get an overview and the latest information on Reporting Services 2008 at the MSDN aggregation page for Reporting Services! 

    Important downloads for Reporting Services 2008:  

    SP2:

    • Report Builder 2.0 (SP2 Download)
      for Reporting Services 2008 (build 10.00.4000)
       
    • SQL Server 2008 SP2 Cumulative Update #3 (build 10.00.4279)
    • SQL Server 2008 SP2 Cumulative Update #2 (build 10.00.4272)
    • SQL Server 2008 SP2 Cumulative Update #1 (build 10.00.4266)
    • Download SQL Server 2008 SP2
    • Download SQL Server 2008 SP2 Express
    • Download SQL Server 2008 SP2 Feature Packs
       
    • RS 2008 SP2 Add-In for SharePoint Integrated Mode (build 10.00.4000) 
      Note: updates for the SharePoint add-in are available for each CU as well, just make sure to select the "..._RSSharepoin" download package.

    SP1:

    • RS 2008 SP1 Add-In for SharePoint Integrated Mode (build 10.00.2531) 
      Note: updates for the SharePoint add-in are available for each CU as well, just make sure to select the "..._RSSharepoin" download package.
       
    • SQL Server 2008 SP1 Cumulative Update #13 (build 10.00.2816)
    • SQL Server 2008 SP1 Cumulative Update #12 (build 10.00.2808)
    • SQL Server 2008 SP1 Cumulative Update #11 (build 10.00.2804)
    • SQL Server 2008 SP1 Cumulative Update #10 (build 10.00.2799)
    • SQL Server 2008 SP1 Cumulative Update #9 (build 10.00.2789)   
    • SQL Server 2008 SP1 Cumulative Update #8 (build 10.00.2775)   
    • SQL Server 2008 SP1 Cumulative Update #7 (build 10.00.2766)   
    • SQL Server 2008 SP1 Cumulative Update #6 (build 10.00.2757)   
    • SQL Server 2008 SP1 Cumulative Update #5 (build 10.00.2746)
    • SQL Server 2008 SP1 Cumulative Update #4 (build 10.00.2734)
    • SQL Server 2008 SP1 Cumulative Update #3 (build 10.00.2723) 
    • SQL Server 2008 SP1 Cumulative Update #2 (build 10.00.2714) 
    • SQL Server 2008 SP1 Cumulative Update #1 (build 10.00.2710)
    • SQL Server 2008 Service Pack 1 (build 10.00.2531)

    RTM:

    • SQL Server 2008 RTM Cumulative Update #10 (build 10.00.1835)    
    • SQL Server 2008 RTM Cumulative Update #9 (build 10.00.1828)   
    • SQL Server 2008 RTM Cumulative Update #8 (build 10.00.1823)
    • SQL Server 2008 RTM Cumulative Update #7 (build 10.00.1818)
    • SQL Server 2008 RTM Cumulative Update #6 (build 10.00.1812)
    • SQL Server 2008 RTM Cumulative Update #5 (build 10.00.1806)
    • SQL Server 2008 RTM Cumulative Update #4 (build 10.00.1798)
    • SQL Server 2008 RTM Cumulative Update #3 (build 10.00.1787) 
    • SQL Server 2008 RTM Cumulative Update #2 (build 10.00.1779)
    • SQL Server 2008 RTM Cumulative Update #1 (build 10.00.1763)
    • SQL Server 2008 RTM (build 10.00.1600.22)
       
    • Updated SQL Server 2008 Books Online (July 2009 Update)


    Also check related discussion threads in this forum about the Reporting Services 2008 release, and Report Builder 2.0 release.

  • 連結
    Reporting Services 2005 - Resources & Latest Downloads (SP4)
    Robert Bruckner 2009年2月5日 下午 09:44

    Last update: Mar 27, 2011.

    MSDN information aggregator site for Reporting Services 2005. 

    Important downloads for Reporting Services 2005:

    SP4:

    • SQL Server 2005 SP4 Cumulative Update #3 (build 9.00.5266)
    • SQL Server 2005 SP4 Cumulative Update #2 (build 9.00.5259)
    • SQL Server 2005 SP4 Cumulative Update #1 (build 9.00.5254)
    • SQL Server 2005 SP4 RTM, Express Edition RTM (build 9.00.5000)

    SP3:

    • SQL Server 2005 SP3 Cumulative Update #15 (build 9.00.4325) 
    • SQL Server 2005 SP3 Cumulative Update #14 (build 9.00.4317) 
    • SQL Server 2005 SP3 Cumulative Update #13 (build 9.00.4315) 
    • SQL Server 2005 SP3 Cumulative Update #12 (build 9.00.4311)
    • SQL Server 2005 SP3 Cumulative Update #11 (build 9.00.4309) 
    • SQL Server 2005 SP3 Cumulative Update #10 (build 9.00.4305)  
    • SQL Server 2005 SP3 Cumulative Update #9 (build 9.00.4294)   
    • SQL Server 2005 SP3 Cumulative Update #8 (build 9.00.4285)    
    • SQL Server 2005 SP3 Cumulative Update #7 (build 9.00.4273)   
    • SQL Server 2005 SP3 Cumulative Update #6 (build 9.00.4266)  
    • SQL Server 2005 SP3 Cumulative Update #5 (build 9.00.4230) 
    • SQL Server 2005 SP3 Cumulative Update #4 (build 9.00.4226)   
    • SQL Server 2005 SP3 Cumulative Update #3 (build 9.00.4220)   
    • SQL Server 2005 SP3 Cumulative Update #2 (build 9.00.4211)   
    • SQL Server 2005 SP3 Cumulative Update #1 (build 9.00.4207) 
    • SQL Server 2005 SP3 RTM (build 9.00.4035)  

    SP2:

    • SQL Server 2005 SP2 Cumulative Update #17 (build 9.00.3356) - Final CU for SP2   
    • SQL Server 2005 SP2 Cumulative Update #16 (build 9.00.3355)   
    • SQL Server 2005 SP2 Cumulative Update #15 (build 9.00.3330)  
    • SQL Server 2005 SP2 Cumulative Update #14 (build 9.00.3328) 
    • SQL Server 2005 SP2 Cumulative Update #13 (build 9.00.3325) 
    • SQL Server 2005 SP2 Cumulative Update #12 (build 9.00.3315) 
    • SQL Server 2005 SP2 Cumulative Update #11 (build 9.00.3301) 
    • SQL Server 2005 SP2 RTM (build 9.00.3042) 
       
    • RS Add-in for SharePoint Integrated Mode (SP3 download, SP2 download) 
    • SQL Server 2005 Books Online (December 2008 Update)

     

SQL Server Reporting Services, Power View 公告

  • 連結
    Reporting Services Migration Tool v1
    Tristan Fernando 2012年4月22日 下午 10:54

    We have released a beta version of the Reporting Services Migration Tool.  The tool is available for download at:

    http://www.microsoft.com/download/en/details.aspx?id=29560

    This tool essentially allows you to create a backup store of a native mode Report Server and then migrate that content to a SharePoint-integrated mode Report Server.  Migrated content includes all report items (reports, shared data sources, models, shared datasets, report parts), along with associated metadata (shared schedules, subscriptions, history snapshots, etc.).  Some additional details are in this blog post, along with the download link:

    http://blogs.msdn.com/b/jameswu/archive/2012/04/21/reporting-services-migration-tool.aspx

    We are working on enabling more features in this tool, so feel free to share any feedback or report any issues.  Thanks!

  • 連結
    Reporting Services 2008 R2 - Resources & Latest Downloads
    Robert Bruckner 2010年5月24日 下午 03:45

    Last Update: Mar 4, 2011.

    SQL Server 2008 R2 was released to manufacturing on April 21, 2010.  You can read more about it here.

    Downloads available: 

    • Report Builder 3.0 RTM 
    • SQL Server 2008 R2 RTM - Developer Trial Edition
    • SQL Server 2008 R2 RTM - Express Edition with Advanced Services
    • SQL Server 2008 R2 RTM - Documentation
    • SQL Server 2008 R2 RTM - Feature Pack (with Report Builder and PowerPivot for Excel 2010)
    • Reporting Services 2008 R2 Add-in for SharePoint 2010
    • Visual Studio 2010 Report Viewer Redistributable

    Cumulative Updates:

    • SQL Server 2008 R2 RTM Cumulative Update #6 (build 10.50.1765)
    • SQL Server 2008 R2 RTM Cumulative Update #5 (build 10.50.1753)
    • SQL Server 2008 R2 RTM Cumulative Update #4 (build 10.50.1746)
    • SQL Server 2008 R2 RTM Cumulative Update #3 (build 10.50.1734)
    • SQL Server 2008 R2 RTM Cumulative Update #2 (build 10.50.1720)
    • SQL Server 2008 R2 RTM Cumulative Update #1 (build 10.50.1702)

    You can read about specific new Reporting Services features added in November CTP on top of what was available in August CTP.  You can research and ask questions on the dedicated MSDN forum. 

  • 連結
    ** Please Include SSRS Version When Posting Questions
    Sean Boon 2009年4月22日 上午 04:45
    When posting questions in this forum, please include the version of SQL Server Reporting Services you are using.  This will help us be more efficient in answering questions.  If you are using the Report Viewer Control, it will helpful if you include the version of the control as well. 

    Thanks,
    Sean
  • 連結
    Reporting Services 2008 - Resources & Latest Downloads (SP2)
    Robert Bruckner 2009年2月5日 下午 09:44
    Last update: Mar 27, 2011.


    Get an overview and the latest information on Reporting Services 2008 at the MSDN aggregation page for Reporting Services! 

    Important downloads for Reporting Services 2008:  

    SP2:

    • Report Builder 2.0 (SP2 Download)
      for Reporting Services 2008 (build 10.00.4000)
       
    • SQL Server 2008 SP2 Cumulative Update #3 (build 10.00.4279)
    • SQL Server 2008 SP2 Cumulative Update #2 (build 10.00.4272)
    • SQL Server 2008 SP2 Cumulative Update #1 (build 10.00.4266)
    • Download SQL Server 2008 SP2
    • Download SQL Server 2008 SP2 Express
    • Download SQL Server 2008 SP2 Feature Packs
       
    • RS 2008 SP2 Add-In for SharePoint Integrated Mode (build 10.00.4000) 
      Note: updates for the SharePoint add-in are available for each CU as well, just make sure to select the "..._RSSharepoin" download package.

    SP1:

    • RS 2008 SP1 Add-In for SharePoint Integrated Mode (build 10.00.2531) 
      Note: updates for the SharePoint add-in are available for each CU as well, just make sure to select the "..._RSSharepoin" download package.
       
    • SQL Server 2008 SP1 Cumulative Update #13 (build 10.00.2816)
    • SQL Server 2008 SP1 Cumulative Update #12 (build 10.00.2808)
    • SQL Server 2008 SP1 Cumulative Update #11 (build 10.00.2804)
    • SQL Server 2008 SP1 Cumulative Update #10 (build 10.00.2799)
    • SQL Server 2008 SP1 Cumulative Update #9 (build 10.00.2789)   
    • SQL Server 2008 SP1 Cumulative Update #8 (build 10.00.2775)   
    • SQL Server 2008 SP1 Cumulative Update #7 (build 10.00.2766)   
    • SQL Server 2008 SP1 Cumulative Update #6 (build 10.00.2757)   
    • SQL Server 2008 SP1 Cumulative Update #5 (build 10.00.2746)
    • SQL Server 2008 SP1 Cumulative Update #4 (build 10.00.2734)
    • SQL Server 2008 SP1 Cumulative Update #3 (build 10.00.2723) 
    • SQL Server 2008 SP1 Cumulative Update #2 (build 10.00.2714) 
    • SQL Server 2008 SP1 Cumulative Update #1 (build 10.00.2710)
    • SQL Server 2008 Service Pack 1 (build 10.00.2531)

    RTM:

    • SQL Server 2008 RTM Cumulative Update #10 (build 10.00.1835)    
    • SQL Server 2008 RTM Cumulative Update #9 (build 10.00.1828)   
    • SQL Server 2008 RTM Cumulative Update #8 (build 10.00.1823)
    • SQL Server 2008 RTM Cumulative Update #7 (build 10.00.1818)
    • SQL Server 2008 RTM Cumulative Update #6 (build 10.00.1812)
    • SQL Server 2008 RTM Cumulative Update #5 (build 10.00.1806)
    • SQL Server 2008 RTM Cumulative Update #4 (build 10.00.1798)
    • SQL Server 2008 RTM Cumulative Update #3 (build 10.00.1787) 
    • SQL Server 2008 RTM Cumulative Update #2 (build 10.00.1779)
    • SQL Server 2008 RTM Cumulative Update #1 (build 10.00.1763)
    • SQL Server 2008 RTM (build 10.00.1600.22)
       
    • Updated SQL Server 2008 Books Online (July 2009 Update)


    Also check related discussion threads in this forum about the Reporting Services 2008 release, and Report Builder 2.0 release.

  • 連結
    Reporting Services 2005 - Resources & Latest Downloads (SP4)
    Robert Bruckner 2009年2月5日 下午 09:44

    Last update: Mar 27, 2011.

    MSDN information aggregator site for Reporting Services 2005. 

    Important downloads for Reporting Services 2005:

    SP4:

    • SQL Server 2005 SP4 Cumulative Update #3 (build 9.00.5266)
    • SQL Server 2005 SP4 Cumulative Update #2 (build 9.00.5259)
    • SQL Server 2005 SP4 Cumulative Update #1 (build 9.00.5254)
    • SQL Server 2005 SP4 RTM, Express Edition RTM (build 9.00.5000)

    SP3:

    • SQL Server 2005 SP3 Cumulative Update #15 (build 9.00.4325) 
    • SQL Server 2005 SP3 Cumulative Update #14 (build 9.00.4317) 
    • SQL Server 2005 SP3 Cumulative Update #13 (build 9.00.4315) 
    • SQL Server 2005 SP3 Cumulative Update #12 (build 9.00.4311)
    • SQL Server 2005 SP3 Cumulative Update #11 (build 9.00.4309) 
    • SQL Server 2005 SP3 Cumulative Update #10 (build 9.00.4305)  
    • SQL Server 2005 SP3 Cumulative Update #9 (build 9.00.4294)   
    • SQL Server 2005 SP3 Cumulative Update #8 (build 9.00.4285)    
    • SQL Server 2005 SP3 Cumulative Update #7 (build 9.00.4273)   
    • SQL Server 2005 SP3 Cumulative Update #6 (build 9.00.4266)  
    • SQL Server 2005 SP3 Cumulative Update #5 (build 9.00.4230) 
    • SQL Server 2005 SP3 Cumulative Update #4 (build 9.00.4226)   
    • SQL Server 2005 SP3 Cumulative Update #3 (build 9.00.4220)   
    • SQL Server 2005 SP3 Cumulative Update #2 (build 9.00.4211)   
    • SQL Server 2005 SP3 Cumulative Update #1 (build 9.00.4207) 
    • SQL Server 2005 SP3 RTM (build 9.00.4035)  

    SP2:

    • SQL Server 2005 SP2 Cumulative Update #17 (build 9.00.3356) - Final CU for SP2   
    • SQL Server 2005 SP2 Cumulative Update #16 (build 9.00.3355)   
    • SQL Server 2005 SP2 Cumulative Update #15 (build 9.00.3330)  
    • SQL Server 2005 SP2 Cumulative Update #14 (build 9.00.3328) 
    • SQL Server 2005 SP2 Cumulative Update #13 (build 9.00.3325) 
    • SQL Server 2005 SP2 Cumulative Update #12 (build 9.00.3315) 
    • SQL Server 2005 SP2 Cumulative Update #11 (build 9.00.3301) 
    • SQL Server 2005 SP2 RTM (build 9.00.3042) 
       
    • RS Add-in for SharePoint Integrated Mode (SP3 download, SP2 download) 
    • SQL Server 2005 Books Online (December 2008 Update)

     

SQL Server Analysis Services 公告

  • 連結
    FAQ - Analysis Services Information, Webcasts, Tools, Samples
    Edward Melomed 2008年12月16日 下午 11:27
     References:

    Books On-Line Homepage

    Analysis Services Information Hub

    Tutorials

    Guded Tours

    SQL Server Customer Advisory Team

    TechNet Webcasts

    Videos on LernMicrosoftBI.com

    Product Code Samples

    Community Samples

    MDX Studio Project

SQL Server Analysis Services 公告

  • 連結
    FAQ - Analysis Services Information, Webcasts, Tools, Samples
    Edward Melomed 2008年12月16日 下午 11:27
     References:

    Books On-Line Homepage

    Analysis Services Information Hub

    Tutorials

    Guded Tours

    SQL Server Customer Advisory Team

    TechNet Webcasts

    Videos on LernMicrosoftBI.com

    Product Code Samples

    Community Samples

    MDX Studio Project

.NET Framework inside SQL Server 公告

  • 連結
    Scope and purpose of this forum
    Bob Beauchemin 2012年8月14日 下午 08:28

    This forum covers questions regarding .NET assemblies and database objects running as part of SQL Server including user-defined types, user-defined aggregates, UDFs, triggers, and stored procedures implemented in .NET code. supported by SQL Server 2005 and later versions. Other questions regarding SQL Server database access and other related technologies should be directed to the most appropriate forum to obtain the best response.

    Questions on SQL Server .NET Client (SqlClient) data access should be posted to the ADO.NET data provider forum: http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/threads

    Questions on using SQL Server with ASP.NET should be posted to the ASP.NET forums: http://forums.asp.net/

    Questions on writing Transact-SQL code, including T-SQL stored procedures, UDFs, and triggers: http://social.technet.microsoft.com/Forums/en-US/transactsql/threads

    Questions on installation problems pertaining to .NET installations should be posted to the SQL Server Setup and Upgrade forum: http://social.technet.microsoft.com/Forums/en-US/sqlsetupandupgrade/threads

    Questions on problems using SQL Server Data Tools: http://social.technet.microsoft.com/Forums/en-US/sqltools/threads

    Questions on using other Data Access APIs (e.g. ODBC, OLE DB): http://social.technet.microsoft.com/Forums/en-US/sqldataaccess/threads

    Questions on writing code for SQL Server Compact Edition: http://social.technet.microsoft.com/Forums/en-US/sqlce/threads

    Questions on SQL Server Express-specific issues: http://social.technet.microsoft.com/Forums/en-US/sqlexpress/threads

    Questions that are off-topic in this forum may be moved to one of the other, more relevent, forums to ensure the best, most prompt response and facilitate forum-specific searchng for similar questions that have already been resolved.

.NET Framework inside SQL Server 公告

  • 連結
    Scope and purpose of this forum
    Bob Beauchemin 2012年8月14日 下午 08:28

    This forum covers questions regarding .NET assemblies and database objects running as part of SQL Server including user-defined types, user-defined aggregates, UDFs, triggers, and stored procedures implemented in .NET code. supported by SQL Server 2005 and later versions. Other questions regarding SQL Server database access and other related technologies should be directed to the most appropriate forum to obtain the best response.

    Questions on SQL Server .NET Client (SqlClient) data access should be posted to the ADO.NET data provider forum: http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/threads

    Questions on using SQL Server with ASP.NET should be posted to the ASP.NET forums: http://forums.asp.net/

    Questions on writing Transact-SQL code, including T-SQL stored procedures, UDFs, and triggers: http://social.technet.microsoft.com/Forums/en-US/transactsql/threads

    Questions on installation problems pertaining to .NET installations should be posted to the SQL Server Setup and Upgrade forum: http://social.technet.microsoft.com/Forums/en-US/sqlsetupandupgrade/threads

    Questions on problems using SQL Server Data Tools: http://social.technet.microsoft.com/Forums/en-US/sqltools/threads

    Questions on using other Data Access APIs (e.g. ODBC, OLE DB): http://social.technet.microsoft.com/Forums/en-US/sqldataaccess/threads

    Questions on writing code for SQL Server Compact Edition: http://social.technet.microsoft.com/Forums/en-US/sqlce/threads

    Questions on SQL Server Express-specific issues: http://social.technet.microsoft.com/Forums/en-US/sqlexpress/threads

    Questions that are off-topic in this forum may be moved to one of the other, more relevent, forums to ensure the best, most prompt response and facilitate forum-specific searchng for similar questions that have already been resolved.

SQL Server Replication 公告

  • 連結
    SQL Server 2005 SP3 is now available
    Greg Y 2008年12月18日 上午 05:10
    SQL Server 2005 SP3 is released, access it here.

    Read about what's new for Replication here.

    Many replication bugs were fixed in SP3, you can find your way through them here.

SQL Server Replication 公告

  • 連結
    SQL Server 2005 SP3 is now available
    Greg Y 2008年12月18日 上午 05:10
    SQL Server 2005 SP3 is released, access it here.

    Read about what's new for Replication here.

    Many replication bugs were fixed in SP3, you can find your way through them here.

SQL Server Setup & Upgrade 公告

  • 連結
    AVAILABLE: SQL Server 2012 Upgrade Technical Guide
    Ahmed Ibrahim - MSFT 2012年5月16日 上午 05:01
    • Customer-ready SQL Server 2012 Upgrade Technical Guide(How to upgrade).
    • What's new.(Why upgrade)

SQL Server Setup & Upgrade 公告

  • 連結
    AVAILABLE: SQL Server 2012 Upgrade Technical Guide
    Ahmed Ibrahim - MSFT 2012年5月16日 上午 05:01
    • Customer-ready SQL Server 2012 Upgrade Technical Guide(How to upgrade).
    • What's new.(Why upgrade)

SQL Server Notification Services 公告

  • 連結
    Please Direct SQLDependency/Query Notification and DBMail Questions to the Appropriate Forums
    Lukasz Pawlowski -- MS 2010年5月21日 下午 07:36

    The following forums can be used to post questions and discussion about the topics: SQLDependency/Query Notification and DBMail.

    Please use
    http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/threads for SQLDependency and Query Notification.

    Please use http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/threads for DBMail.

    (Attribution: Jang-uk In)

    Hope that helps,

    -Lukasz

SQL Server Notification Services 公告

  • 連結
    Please Direct SQLDependency/Query Notification and DBMail Questions to the Appropriate Forums
    Lukasz Pawlowski -- MS 2010年5月21日 下午 07:36

    The following forums can be used to post questions and discussion about the topics: SQLDependency/Query Notification and DBMail.

    Please use
    http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/threads for SQLDependency and Query Notification.

    Please use http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/threads for DBMail.

    (Attribution: Jang-uk In)

    Hope that helps,

    -Lukasz

SQL Server Compact 公告

  • 連結
    SQL Server Compact 4.0 downloads and feature information
    ErikEJ 2011年4月3日 下午 01:11
    This post on my blog should have links to all required information.

SQL Server Compact 公告

  • 連結
    SQL Server Compact 4.0 downloads and feature information
    ErikEJ 2011年4月3日 下午 01:11
    This post on my blog should have links to all required information.

SQL Server Express 公告

  • 連結
    Some useful links to download SQL Server 2008 and 2008 R2 Express (RTM)
    Papy Normand 2011年5月9日 下午 03:29

    Hello,

    Many thanks to Rick Byham who provided me these links :

    - SQL Server 2008 Express RTM http://www.microsoft.com/downloads/en/details.aspx?FamilyID=58ce885d-508b-45c8-9fd3-118edd8e6fff

    - SQL Server 2008 Express with Advanced services RTM http://www.microsoft.com/downloads/en/details.aspx?FamilyID=b5d1b8c3-fda5-4508-b0d0-1311d670e336

    - SQL Server 2008 R2 Express RTM http://www.microsoft.com/downloads/en/details.aspx?FamilyID=8b3695d9-415e-41f0-a079-25ab0412424b

    - SQL Server 2008 R2 Express with Advanced services RTM http://www.microsoft.com/downloads/en/details.aspx?FamilyID=e08766ce-fc9d-448f-9e98-fe84ad61f135

    I will try to update these links when a new Service Pack or SQL Server "Denali" ( 2011 ? ) will be released

     

SQL Server Express 公告

  • 連結
    Some useful links to download SQL Server 2008 and 2008 R2 Express (RTM)
    Papy Normand 2011年5月9日 下午 03:29

    Hello,

    Many thanks to Rick Byham who provided me these links :

    - SQL Server 2008 Express RTM http://www.microsoft.com/downloads/en/details.aspx?FamilyID=58ce885d-508b-45c8-9fd3-118edd8e6fff

    - SQL Server 2008 Express with Advanced services RTM http://www.microsoft.com/downloads/en/details.aspx?FamilyID=b5d1b8c3-fda5-4508-b0d0-1311d670e336

    - SQL Server 2008 R2 Express RTM http://www.microsoft.com/downloads/en/details.aspx?FamilyID=8b3695d9-415e-41f0-a079-25ab0412424b

    - SQL Server 2008 R2 Express with Advanced services RTM http://www.microsoft.com/downloads/en/details.aspx?FamilyID=e08766ce-fc9d-448f-9e98-fe84ad61f135

    I will try to update these links when a new Service Pack or SQL Server "Denali" ( 2011 ? ) will be released

     

Database Design 公告

  • 連結
    Database Design Resources
    Arnie Rowland 2009年12月23日 下午 08:40

    The following list of database design resources is not intended to be exhaustive or ‘the correct list’. Items are included simply because one of the Moderators knew the material and offered it as a suggestion. If you wish to offer suggestions for inclusion, please do so.

     

    Books

     

    A Developer's Guide to Data Modeling for SQL Server: Covering SQL Server 2005 and 2008

    Eric Johnson and Joshua Jones

    An Introduction to Database Systems

    Chris Date

    Applied Mathematics for Database Professionals

    Lex de Haan, Toon Koppelaars

    Architecting Regulatory-Compliant Architectures
    Mike Walker, Microsoft

    Data Modeling Essential

    Graeme Simsion and Graham Witt

    Database Modeling and Design: Logical Design

    Toby Teorey

    Information Modeling and Relational Databases

    Terry Halpin

    Practical Issues in Database Management: A Reference for the Thinking Practitioner

    Fabian Pascal

    Pro SQL Server 2008 Relational Database Design and Implementation

    Louis Davidson, Kevin Kline, et al

     

    Online Resources

     

    A Simple Guide to Five Normal forms and Relational Database Theory
    http://www.bkent.net/Doc/simple5.htm

    Data Modeling vs. Database Design
    http://www.aisintl.com/case/library/R-Theory_vs_ER/r-theory_vs_er.html

    Data Models
    http://www.databaseanswers.org/data_models/index.htm

    Database Design - Ten Common Database Design Mistakes, Louis Davidson
    http://www.simple-talk.com/sql/database-administration/ten-common-database-design-mistakes/

    Database Design Issues -EAV Model Discussion (Querying an EAV Table)
    http://tinyurl.com/yks8hu

    Database Design Issues –EAV and OTLT
    http://tonyandrews.blogspot.com/2004/10/otlt-and-eav-two-big-design-mistakes.html

    Database Design ROI by Paul Nielsen
    http://www.sqlserverbible.com/files/databasedesignroi.pdf

    Introduction to the Unified Dimensional Model (UDM)
    http://technet.microsoft.com/en-us/library/ms345143(SQL.90).aspx

    Library of database models
    http://www.databaseanswers.org/data_models/

    On Normalization and Repeating Groups by Fabian Pascal
    http://www.dbdebunk.com/page/page/622318.htm

    ORM white paper
    http://www.orm.net/pdf/ORMwhitePaper.pdf

    Overview of the Relational Model
    http://www.utexas.edu/its/archive/windows/database/datamodeling/rm/overview.html   

    Understanding Data Model Quality, Graeme Simsion
    http://www.tdan.com/view-articles/5100

     

  • 連結
    Please READ before Posting or Replying to Posts
    Arnie Rowland 2009年12月7日 下午 06:27

     


    Out of Scope
     

    Some topics are out of scope for this forum.

    1. Bugs, Product Decisions, and Feedback: The purpose of this forum is not to ask the product team why decisions were made and to ask them to make other changes. That feedback belongs in Connect. The purpose of this forum is to help you out with specific issues, if possible. Please post your feedback via Connect:

    https://connect.microsoft.com/SQLServer

      

    Rules of Conduct

    ·         Relevance to Topics: We encourage you to keep your postings as close to the subject as possible.

    ·         Respect: Please be respectful of other participants, and their contributions; avoiding insults, demeaning remarks and slurs.

    ·         Tolerance: Please don’t assume someone’s curtness was meant to insult, slur, or demean you.

    ·         Confidentiality: Confidential information should not be posted. This is a publicly available forum.

    ·         Appropriate Language: Please keep the conversation on a professional level, avoiding any hint of profanity in your interactions.

    ·         Advertising/Solicitation: Advertisements should not be posted, and will be removed.

    Forum Moderators may, at their discretion, edit posts for clarity, readability and inappropriate language; split post into separate threads when appropriate; and delete post that do not positively contribute to the thread. Failure to comply with these 'Rules of Conduct' may result in your posts being edited to remove the offending comments, censure, or expulsion from participating in the Forums. The bottom line is: this Forum should feel like a ‘safe’ place to ask hard questions that invoke passionate responses.

    Marking Answers

    By their very nature, many database design questions will not have a easily decernible 'answer'. You are encouraged to give folks 'credit' for helping you when appropriate. If someone's response was 'Helpful', use the 'Vote as Helpful' button. If a response answered some part of your question, or provided you one or more clues that led you to a solution, then use the 'Mark as Answer' option. Just as a thread may evolve into multiple questions, it may also have more than one 'Answer'.

    Welcome to the Database Design Forum

    This is a Forum for questions and discussions about database designs for Microsoft technologies, including: SQL Server, Access, SQL Azure, SQL Express, SQL Compact, etc. Often Database Designs will be generic and can be ported to any vendor's technology. Design problems that are best solved with other technologies will be welcomed and addressed to the best of our knowledge and ability.

    We ask that you recognize that database design is a mixture of art and science. You may receive conflicting suggestions, for there can be multiple paths to a workable solution. You will have to use your own judgment and knowledge of your business requirements to determine the best solution for your particular problem. The 'right' design is compounded by many factors, including business, regulatory, hardware/software requirements, as well as staff expertise. We also encourage you to share your experiences with a particular design issue if it will serve to help others encountering similar problems.

    In order to receive useful responses, please spend some time and properly present your scenario. Attempts to 'save time and effort' by cutting out parts of the scenario will often lead to wasted time and effort as the suggestions have to be discarded because they don't work with other parts of the unseen puzzle.


    But there are limits to what you can expect from volunteers through a disconnected medium. The questions most likely to receive a good and targeted answer, are those that present a small problem, that give a very clear description of that problem within its context, and that are placed by people with a fair understanding of the subject who need help getting over a few nasty bumps. The questions that are almost impossible to answer satisfactorily are those that present a huge problem, with no clear description, and asked by someone totally new to the subject matter.

    We hope that you will understand when we say that most of us that volunteer our time on this Forum do so in order to help folks learn. We will be pleased if you find the Forum to be useful. However, it is difficult or impossible for us to engage with folks privately. We don't have time to do both, and our commitment is help folks using the Forums.

    Do not hesitate to read all of the threads, join in the discussions, offer your own experiences and information, and ask questions to increase your knowlege. Seek out blogs from those who write in a manner that you appreciate, and consider reviewing the Database Design Resources for additional guidance and help.

     

Database Design 公告

  • 連結
    Database Design Resources
    Arnie Rowland 2009年12月23日 下午 08:40

    The following list of database design resources is not intended to be exhaustive or ‘the correct list’. Items are included simply because one of the Moderators knew the material and offered it as a suggestion. If you wish to offer suggestions for inclusion, please do so.

     

    Books

     

    A Developer's Guide to Data Modeling for SQL Server: Covering SQL Server 2005 and 2008

    Eric Johnson and Joshua Jones

    An Introduction to Database Systems

    Chris Date

    Applied Mathematics for Database Professionals

    Lex de Haan, Toon Koppelaars

    Architecting Regulatory-Compliant Architectures
    Mike Walker, Microsoft

    Data Modeling Essential

    Graeme Simsion and Graham Witt

    Database Modeling and Design: Logical Design

    Toby Teorey

    Information Modeling and Relational Databases

    Terry Halpin

    Practical Issues in Database Management: A Reference for the Thinking Practitioner

    Fabian Pascal

    Pro SQL Server 2008 Relational Database Design and Implementation

    Louis Davidson, Kevin Kline, et al

     

    Online Resources

     

    A Simple Guide to Five Normal forms and Relational Database Theory
    http://www.bkent.net/Doc/simple5.htm

    Data Modeling vs. Database Design
    http://www.aisintl.com/case/library/R-Theory_vs_ER/r-theory_vs_er.html

    Data Models
    http://www.databaseanswers.org/data_models/index.htm

    Database Design - Ten Common Database Design Mistakes, Louis Davidson
    http://www.simple-talk.com/sql/database-administration/ten-common-database-design-mistakes/

    Database Design Issues -EAV Model Discussion (Querying an EAV Table)
    http://tinyurl.com/yks8hu

    Database Design Issues –EAV and OTLT
    http://tonyandrews.blogspot.com/2004/10/otlt-and-eav-two-big-design-mistakes.html

    Database Design ROI by Paul Nielsen
    http://www.sqlserverbible.com/files/databasedesignroi.pdf

    Introduction to the Unified Dimensional Model (UDM)
    http://technet.microsoft.com/en-us/library/ms345143(SQL.90).aspx

    Library of database models
    http://www.databaseanswers.org/data_models/

    On Normalization and Repeating Groups by Fabian Pascal
    http://www.dbdebunk.com/page/page/622318.htm

    ORM white paper
    http://www.orm.net/pdf/ORMwhitePaper.pdf

    Overview of the Relational Model
    http://www.utexas.edu/its/archive/windows/database/datamodeling/rm/overview.html   

    Understanding Data Model Quality, Graeme Simsion
    http://www.tdan.com/view-articles/5100

     

  • 連結
    Please READ before Posting or Replying to Posts
    Arnie Rowland 2009年12月7日 下午 06:27

     


    Out of Scope
     

    Some topics are out of scope for this forum.

    1. Bugs, Product Decisions, and Feedback: The purpose of this forum is not to ask the product team why decisions were made and to ask them to make other changes. That feedback belongs in Connect. The purpose of this forum is to help you out with specific issues, if possible. Please post your feedback via Connect:

    https://connect.microsoft.com/SQLServer

      

    Rules of Conduct

    ·         Relevance to Topics: We encourage you to keep your postings as close to the subject as possible.

    ·         Respect: Please be respectful of other participants, and their contributions; avoiding insults, demeaning remarks and slurs.

    ·         Tolerance: Please don’t assume someone’s curtness was meant to insult, slur, or demean you.

    ·         Confidentiality: Confidential information should not be posted. This is a publicly available forum.

    ·         Appropriate Language: Please keep the conversation on a professional level, avoiding any hint of profanity in your interactions.

    ·         Advertising/Solicitation: Advertisements should not be posted, and will be removed.

    Forum Moderators may, at their discretion, edit posts for clarity, readability and inappropriate language; split post into separate threads when appropriate; and delete post that do not positively contribute to the thread. Failure to comply with these 'Rules of Conduct' may result in your posts being edited to remove the offending comments, censure, or expulsion from participating in the Forums. The bottom line is: this Forum should feel like a ‘safe’ place to ask hard questions that invoke passionate responses.

    Marking Answers

    By their very nature, many database design questions will not have a easily decernible 'answer'. You are encouraged to give folks 'credit' for helping you when appropriate. If someone's response was 'Helpful', use the 'Vote as Helpful' button. If a response answered some part of your question, or provided you one or more clues that led you to a solution, then use the 'Mark as Answer' option. Just as a thread may evolve into multiple questions, it may also have more than one 'Answer'.

    Welcome to the Database Design Forum

    This is a Forum for questions and discussions about database designs for Microsoft technologies, including: SQL Server, Access, SQL Azure, SQL Express, SQL Compact, etc. Often Database Designs will be generic and can be ported to any vendor's technology. Design problems that are best solved with other technologies will be welcomed and addressed to the best of our knowledge and ability.

    We ask that you recognize that database design is a mixture of art and science. You may receive conflicting suggestions, for there can be multiple paths to a workable solution. You will have to use your own judgment and knowledge of your business requirements to determine the best solution for your particular problem. The 'right' design is compounded by many factors, including business, regulatory, hardware/software requirements, as well as staff expertise. We also encourage you to share your experiences with a particular design issue if it will serve to help others encountering similar problems.

    In order to receive useful responses, please spend some time and properly present your scenario. Attempts to 'save time and effort' by cutting out parts of the scenario will often lead to wasted time and effort as the suggestions have to be discarded because they don't work with other parts of the unseen puzzle.


    But there are limits to what you can expect from volunteers through a disconnected medium. The questions most likely to receive a good and targeted answer, are those that present a small problem, that give a very clear description of that problem within its context, and that are placed by people with a fair understanding of the subject who need help getting over a few nasty bumps. The questions that are almost impossible to answer satisfactorily are those that present a huge problem, with no clear description, and asked by someone totally new to the subject matter.

    We hope that you will understand when we say that most of us that volunteer our time on this Forum do so in order to help folks learn. We will be pleased if you find the Forum to be useful. However, it is difficult or impossible for us to engage with folks privately. We don't have time to do both, and our commitment is help folks using the Forums.

    Do not hesitate to read all of the threads, join in the discussions, offer your own experiences and information, and ask questions to increase your knowlege. Seek out blogs from those who write in a manner that you appreciate, and consider reviewing the Database Design Resources for additional guidance and help.

     

SQL Server Master Data Services 公告

  • 連結
    SQL16 CTP2.3 is available for download
    Sherry_Li 2015年9月3日 下午 08:21

    We are excited to share the new features which shipped in SQL CTP2.3 public release.  You can download the product here:http://www.microsoft.com/en-us/download/details.aspx?id=48726, and Excel add-in here: http://www.microsoft.com/en-us/download/details.aspx?id=47343

    In this monthly release, we added a few highly asked features.  Please give it try and look forward to hearing your feedback.

    Manage Business Rules (MDS Add-in for Excel)

    In the Master Data Services Add-in for Excel you can manage Business Rules, such as creating and editing business rules. Business rules are used to validate data. For more information, see Manage Business Rules (MDS Add-in for Excel).

    Many-to-Many Relationships in Derived Hierarchies

    You can now create a Derived Hierarchy that displays  many-to-many relationships. A many-to-many relationship between two entities may be modeled through the use of a third entity that provides a mapping between them. The mapping entity is an entity that has two or more domain-based attributes referencing other entities.

    For example, entity M has a domain-based attribute that references A and a domain-based attribute that references B. You can create a hierarchy from A to B using the mapping entity.

    For more information, see Show Many-to-Many Relationships in Derived Hierarchies (Master Data Services)

    Merge Conflicts

    If you try to publish data that has been changed by another user, the publish will fail with a conflict error. To resolve this error, you can perform merge conflicts and republish the changes. For more information, see Merge Conflicts (Master Data Services) and Merge Conflicts (MDS Add-in for Excel). 

     SQL Master Data Services Team

  • 連結
    Master Data Services SQL2016 CTP2.2(July) Release is public available
    Sherry_Li 2015年7月31日 下午 05:02

    Please give it a try and let us know your feedback!

    SQL Server 2016 Community Technology Preview 2.2 is publicly released and the latest bits can be found at http://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016

    In CTP2.2 MDS introduced following changes:

    1. Custom Indexes

    You can create a non-clustered index on one attribute (single index) or on a list of attributes (composite index), in an entity, to help improve the query performance. For more information, see Custom Index (Master Data Services).

    2. Entity Sync Relationship

    You can share entity data between different models by creating an entity sync relationship. For more information, see Entity Sync Relationship (Master Data Services).

    3. Member Revision History

    A member revision history is recorded when a member is changed. You can rollback a revision history, as well as view and annotate revisions. Using the Log Retention Days property, you can specify how long historical data is retained. For more information, see Member Revision History (Master Data Services).

  • 連結
    New release on MDS Excel add-in available for download
    Sherry_Li 2015年1月13日 下午 09:46

    Hi, we are pleasured to announce the release of MDS Excel add-in. You can download it here:

    http://www.microsoft.com/en-us/download/details.aspx?id=42298

    This release includes a number of performance improvements – most users will see a 4x improvement when loading data from an MDS server, without any additional server or environment changes. For an additional performance increase (2-4x), you can enable Dynamic Content Compression in IIS.

    It works with both SQL12 or SQL14.  The installation will be in place upgrade so the users don't need to uninstall previous installation.  All the MDS connections will be preserved through the installation. 

    Please download the new version of Excel add-in.  Your feedback is welcome!

    Thanks,

    SQL MDS Team

  • 連結
    Please Indicate "Mark as Answer" if a Post has Answered the Question
    edhickey 2010年6月23日 下午 08:39

    While reading a reply to your question, you will notice a button with an icon that says "Mark as Answer."   Please select this button when a reply answers your question.

     

    There are several reasons to do this:

     

    • Our search engine weights Answered questions more highly. By marking Answers you increase the chances that others searching this forum will find the answer directly rather than re-posting the question.
    • You give credit to the hard working folks who answer your questions. This is peer to peer support, so recognition is our only reward. (Check out the Top Answerers in 30 Days chart at the bottom of the thread list to see who is currently answering questions.)
    • You help Microsoft to track the health of this forum. Our forum gets 'measured' based on how many unanswered questions are in it at any time and we work hard to keep those numbers to as low a level as possible. By marking answers, others get a more accurate understanding of how well (or badly) things are going on the forum.

     

    You can also vote "Yes" or "No" if the reply was helpful.

     

    Thank you!

     

    Ed Hickey

SQL Server Master Data Services 公告

  • 連結
    SQL16 CTP2.3 is available for download
    Sherry_Li 2015年9月3日 下午 08:21

    We are excited to share the new features which shipped in SQL CTP2.3 public release.  You can download the product here:http://www.microsoft.com/en-us/download/details.aspx?id=48726, and Excel add-in here: http://www.microsoft.com/en-us/download/details.aspx?id=47343

    In this monthly release, we added a few highly asked features.  Please give it try and look forward to hearing your feedback.

    Manage Business Rules (MDS Add-in for Excel)

    In the Master Data Services Add-in for Excel you can manage Business Rules, such as creating and editing business rules. Business rules are used to validate data. For more information, see Manage Business Rules (MDS Add-in for Excel).

    Many-to-Many Relationships in Derived Hierarchies

    You can now create a Derived Hierarchy that displays  many-to-many relationships. A many-to-many relationship between two entities may be modeled through the use of a third entity that provides a mapping between them. The mapping entity is an entity that has two or more domain-based attributes referencing other entities.

    For example, entity M has a domain-based attribute that references A and a domain-based attribute that references B. You can create a hierarchy from A to B using the mapping entity.

    For more information, see Show Many-to-Many Relationships in Derived Hierarchies (Master Data Services)

    Merge Conflicts

    If you try to publish data that has been changed by another user, the publish will fail with a conflict error. To resolve this error, you can perform merge conflicts and republish the changes. For more information, see Merge Conflicts (Master Data Services) and Merge Conflicts (MDS Add-in for Excel). 

     SQL Master Data Services Team

  • 連結
    Master Data Services SQL2016 CTP2.2(July) Release is public available
    Sherry_Li 2015年7月31日 下午 05:02

    Please give it a try and let us know your feedback!

    SQL Server 2016 Community Technology Preview 2.2 is publicly released and the latest bits can be found at http://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016

    In CTP2.2 MDS introduced following changes:

    1. Custom Indexes

    You can create a non-clustered index on one attribute (single index) or on a list of attributes (composite index), in an entity, to help improve the query performance. For more information, see Custom Index (Master Data Services).

    2. Entity Sync Relationship

    You can share entity data between different models by creating an entity sync relationship. For more information, see Entity Sync Relationship (Master Data Services).

    3. Member Revision History

    A member revision history is recorded when a member is changed. You can rollback a revision history, as well as view and annotate revisions. Using the Log Retention Days property, you can specify how long historical data is retained. For more information, see Member Revision History (Master Data Services).

  • 連結
    New release on MDS Excel add-in available for download
    Sherry_Li 2015年1月13日 下午 09:46

    Hi, we are pleasured to announce the release of MDS Excel add-in. You can download it here:

    http://www.microsoft.com/en-us/download/details.aspx?id=42298

    This release includes a number of performance improvements – most users will see a 4x improvement when loading data from an MDS server, without any additional server or environment changes. For an additional performance increase (2-4x), you can enable Dynamic Content Compression in IIS.

    It works with both SQL12 or SQL14.  The installation will be in place upgrade so the users don't need to uninstall previous installation.  All the MDS connections will be preserved through the installation. 

    Please download the new version of Excel add-in.  Your feedback is welcome!

    Thanks,

    SQL MDS Team

  • 連結
    Please Indicate "Mark as Answer" if a Post has Answered the Question
    edhickey 2010年6月23日 下午 08:39

    While reading a reply to your question, you will notice a button with an icon that says "Mark as Answer."   Please select this button when a reply answers your question.

     

    There are several reasons to do this:

     

    • Our search engine weights Answered questions more highly. By marking Answers you increase the chances that others searching this forum will find the answer directly rather than re-posting the question.
    • You give credit to the hard working folks who answer your questions. This is peer to peer support, so recognition is our only reward. (Check out the Top Answerers in 30 Days chart at the bottom of the thread list to see who is currently answering questions.)
    • You help Microsoft to track the health of this forum. Our forum gets 'measured' based on how many unanswered questions are in it at any time and we work hard to keep those numbers to as low a level as possible. By marking answers, others get a more accurate understanding of how well (or badly) things are going on the forum.

     

    You can also vote "Yes" or "No" if the reply was helpful.

     

    Thank you!

     

    Ed Hickey

SQL Server PowerPivot for SharePoint 公告

  • 連結
    PowerPivot Beta will not work with released versions of Excel, Sharepoint 2010 and others. Pls read!!
    Vikram Jayaram 2010年2月5日 下午 09:17

    Summary

    =============================

    If PowerPivot for Excel 2010, Excel 2010, SharePoint 2010, or the Reporting Services Addin for SharePoint 2010 are beta versions, PowerPivot and its related functionality will not work with the Released versions of these components.

     More Information
    =============================

    The beta versions of the components listed above are not compatible with the released versions of these components. If the beta versions of the components are installed, they will not function with the released versions. For example, if you have a beta version of the PowerPivot download installed and upgrade to the released version of Excel 2010, the PowerPivot addin will not be available in Excel.

  • 連結
    Windows 2008 R2 and Windows 7 Patch Now Available
    Kathy MacDonald [MSFT] 2009年11月20日 下午 10:50
    Some of you may have been waiting for the Windows 7 and Windows 2008 R2 QFE to be released before installing SharePoint 2010 and PowerPivot for SharePoint. The QFE has just been released!

    To read more about how to install the QFE with SharePoint 2010, please see: http://blogs.msdn.com/opal/archive/2009/11/16/installation-notice-for-sharepoint-2010-public-beta.aspx.

    Thanks ~

    Kathy MacDonald 

SQL Server PowerPivot for SharePoint 公告

  • 連結
    PowerPivot Beta will not work with released versions of Excel, Sharepoint 2010 and others. Pls read!!
    Vikram Jayaram 2010年2月5日 下午 09:17

    Summary

    =============================

    If PowerPivot for Excel 2010, Excel 2010, SharePoint 2010, or the Reporting Services Addin for SharePoint 2010 are beta versions, PowerPivot and its related functionality will not work with the Released versions of these components.

     More Information
    =============================

    The beta versions of the components listed above are not compatible with the released versions of these components. If the beta versions of the components are installed, they will not function with the released versions. For example, if you have a beta version of the PowerPivot download installed and upgrade to the released version of Excel 2010, the PowerPivot addin will not be available in Excel.

  • 連結
    Windows 2008 R2 and Windows 7 Patch Now Available
    Kathy MacDonald [MSFT] 2009年11月20日 下午 10:50
    Some of you may have been waiting for the Windows 7 and Windows 2008 R2 QFE to be released before installing SharePoint 2010 and PowerPivot for SharePoint. The QFE has just been released!

    To read more about how to install the QFE with SharePoint 2010, please see: http://blogs.msdn.com/opal/archive/2009/11/16/installation-notice-for-sharepoint-2010-public-beta.aspx.

    Thanks ~

    Kathy MacDonald 

Power Pivot 公告

  • 連結
    Fix for PowerPivot November CTP Expiration Released
    Kathy MacDonald [MSFT] 2010年4月7日 下午 10:07

    The PowerPivot team is pleased to report that the fix for the November CTP expiration issue has been released. We know many of you have been eagerly awaiting this fix since last week when the PowerPivot for Excel add-in expired. We do sincerely apologize for the inconvenience this may have caused you.

    We have released a new version of the November CTP for the PowerPivot for Excel add-in. This new version is functionally identical to the old one except that it extends the expiration date to end of the year. You can download it from the same locations as in the past:

    • http://powerpivot.com/download.aspx
    • http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=48a5b47b-8c9c-450f-ab6e-178600a733ca

    Please note that the new version will take some time to replicate across all servers in the Microsoft download center. If you download it from the above links and still get the expiration error message, then try again periodically. It might also help to clear any browser/download caches on your computer.

  • 連結
    PowerPivot for Excel 2010 November CTP Expired
    Kathy MacDonald [MSFT] 2010年4月2日 下午 09:18

    If you are running the November 2009 CTP version of the PowerPivot for Excel 2010 add-in, your add-in expired on April 1st. We apologize for any inconvenience this may have caused you.

    The SQL Server team will re-release the November 2009 CTP version of the PowerPivot for Excel 2010 add-in with an extended expiration date very soon. We will post an availability announcement with the download location and installation instructions on the PowerPivot blogs and forums as soon as possible.

    Kathy MacDonald
    SQL Server Analysis Services

  • 連結
    PowerPivot Beta will not work with released versions of Excel, Sharepoint 2010 and others. Pls read!!
    Vikram Jayaram 2010年2月5日 下午 09:16


    Summary

    =============================

    If PowerPivot for Excel 2010, Excel 2010, SharePoint 2010, or the Reporting Services Addin for SharePoint 2010 are beta versions, PowerPivot and its related functionality will not work with the Released versions of these components.

     

    More Information

    =============================

    The beta versions of the components listed above are not compatible with the released versions of these components. If the beta versions of the components are installed, they will not function with the released versions. For example, if you have a beta version of the PowerPivot download installed and upgrade to the released version of Excel 2010, the PowerPivot addin will not be available in Excel.

     

    The solution is to upgrade the beta components to their released versions when they become available.

Power Pivot 公告

  • 連結
    Fix for PowerPivot November CTP Expiration Released
    Kathy MacDonald [MSFT] 2010年4月7日 下午 10:07

    The PowerPivot team is pleased to report that the fix for the November CTP expiration issue has been released. We know many of you have been eagerly awaiting this fix since last week when the PowerPivot for Excel add-in expired. We do sincerely apologize for the inconvenience this may have caused you.

    We have released a new version of the November CTP for the PowerPivot for Excel add-in. This new version is functionally identical to the old one except that it extends the expiration date to end of the year. You can download it from the same locations as in the past:

    • http://powerpivot.com/download.aspx
    • http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=48a5b47b-8c9c-450f-ab6e-178600a733ca

    Please note that the new version will take some time to replicate across all servers in the Microsoft download center. If you download it from the above links and still get the expiration error message, then try again periodically. It might also help to clear any browser/download caches on your computer.

  • 連結
    PowerPivot for Excel 2010 November CTP Expired
    Kathy MacDonald [MSFT] 2010年4月2日 下午 09:18

    If you are running the November 2009 CTP version of the PowerPivot for Excel 2010 add-in, your add-in expired on April 1st. We apologize for any inconvenience this may have caused you.

    The SQL Server team will re-release the November 2009 CTP version of the PowerPivot for Excel 2010 add-in with an extended expiration date very soon. We will post an availability announcement with the download location and installation instructions on the PowerPivot blogs and forums as soon as possible.

    Kathy MacDonald
    SQL Server Analysis Services

  • 連結
    PowerPivot Beta will not work with released versions of Excel, Sharepoint 2010 and others. Pls read!!
    Vikram Jayaram 2010年2月5日 下午 09:16


    Summary

    =============================

    If PowerPivot for Excel 2010, Excel 2010, SharePoint 2010, or the Reporting Services Addin for SharePoint 2010 are beta versions, PowerPivot and its related functionality will not work with the Released versions of these components.

     

    More Information

    =============================

    The beta versions of the components listed above are not compatible with the released versions of these components. If the beta versions of the components are installed, they will not function with the released versions. For example, if you have a beta version of the PowerPivot download installed and upgrade to the released version of Excel 2010, the PowerPivot addin will not be available in Excel.

     

    The solution is to upgrade the beta components to their released versions when they become available.

SQL Server Samples and Community Projects 公告

  • 連結
    How to Use this Forum - Please Read Before Posting
    Mr. Wharty 2012年10月2日 上午 04:49

    Welcome to the SQL Server Samples and Community Projects Forum.

    This forum is the place to discuss all things "samplish" in the SQL Server community and samples space, whether it's an "official Microsoft sample" or a community project in CodePlex or Code Gallery. This is*not* the place to discussion specific nuances of T-SQL syntax or wage data modeling methodology wars: there are lots of other forums for those purposes. This one is for questions about samples, community projects and conversations between the collaborators that build them.

    Some examples of projects that are open for discussion can be found here: http://www.codeplex.com/SqlServerSamples. It doesn't have to be listed there to be fair game, but it's a good bet that it is fair game if it's already listed there.

    Below are a few guidelines to help you find your answer quickly and also to help the people who answer the questions, answer yours correctly.

    • Is your question about SQL Server Samples and Community Projects . If it's not please locate the correct forum otherwise your question may be moved, closed/locked or deleted.
    • Try searching the forum . Search the forum to see if your question has been asked before and answered.  If you cannot find what you are looking for, please start a new thread rather than adding to an old one as some people do not see answered questions in their forum views so you may not get the assistance you're looking for.
    • Don't be brief . The more information you can give in your question, the better the response will be.
    • Check your alerts . You can subscribe to a question so that you can see any update on it (ReferSetting up your alerts below).
    • No Spam. Spamming will have your thread deleted and may also result in your account being banned.
    • Be polite.  You will get better assistance if you're polite to other members so no flaming or trolling.  If you persist with flaming or trolling, your accountmay get banned.
    • Mark your question answered. If someone answers your question please mark their reply as the answer to your question. You can also mark multiple replies as answers if you think they answered your question.  Marking replies not only assists others with similar questions, it also let's people know that you're grateful for their assistance.

    Dead thread/Answer policy.

    Where possible the moderators will allow sufficient time for the original poster to come back and mark the replies to their questions as answers. The amount of time is at the discretion of the individual moderator but is suggested that it will be declared dead after a week if the original poster does not respond . We will always try to be fair and mark suitable replies as answers.

    Setting up your alerts

    If you are having trouble receiving alerts on the threads you have created or replied to please see thisthread for troubleshooting advice.

  • 連結
    Samples bugs and suggestions.
    David Reed (Glacier Peak) 2009年2月2日 下午 04:26
    All of the work items for our community projects and product samples are in TFS on CodePlex. If you want to report a bug, suggest a change for an existing sample or suggest a new sample, create a work item in the appropriate project so that our community team (not just Microsoft employees) can vote on them, help us triage and prioritize them.

    For example, here's the URL for the work items for AdventureWorks: http://www.codeplex.com/MSFTDBProdSamples/WorkItem/AdvancedList.aspx
  • 連結
    Welcome aboard! Community & Samples Forum Intro
    David Reed (Glacier Peak) 2009年1月29日 下午 09:58

    This forum is the place to discuss all things "samplish" in the SQL Server community and samples space, whether it's an "official Microsoft sample" or a community project in CodePlex or Code Gallery. This is *not* the place to discussion specific nuances of T-SQL syntax or wage data modeling methodology wars: there are lots of other forums for those purposes. This one is for questions about samples, community projects and conversations between the collaborators that build them.

     

    Some examples of projects that are open for discussion can be found here: http://www.codeplex.com/SqlServerSamples/ It doesn't have to be listed there to be fair game, but it's a good bet that it is fair game if it's already listed there.

     

    Also, please post your project announcements here when you create a new release or a whole new project. If you're looking for people to work on your project or looking for a project to work on, this would be a good place to do both.

     

    Let us know what's missing, let know what could be better and let us know what we're doing right!

SQL Server Samples and Community Projects 公告

  • 連結
    How to Use this Forum - Please Read Before Posting
    Mr. Wharty 2012年10月2日 上午 04:49

    Welcome to the SQL Server Samples and Community Projects Forum.

    This forum is the place to discuss all things "samplish" in the SQL Server community and samples space, whether it's an "official Microsoft sample" or a community project in CodePlex or Code Gallery. This is*not* the place to discussion specific nuances of T-SQL syntax or wage data modeling methodology wars: there are lots of other forums for those purposes. This one is for questions about samples, community projects and conversations between the collaborators that build them.

    Some examples of projects that are open for discussion can be found here: http://www.codeplex.com/SqlServerSamples. It doesn't have to be listed there to be fair game, but it's a good bet that it is fair game if it's already listed there.

    Below are a few guidelines to help you find your answer quickly and also to help the people who answer the questions, answer yours correctly.

    • Is your question about SQL Server Samples and Community Projects . If it's not please locate the correct forum otherwise your question may be moved, closed/locked or deleted.
    • Try searching the forum . Search the forum to see if your question has been asked before and answered.  If you cannot find what you are looking for, please start a new thread rather than adding to an old one as some people do not see answered questions in their forum views so you may not get the assistance you're looking for.
    • Don't be brief . The more information you can give in your question, the better the response will be.
    • Check your alerts . You can subscribe to a question so that you can see any update on it (ReferSetting up your alerts below).
    • No Spam. Spamming will have your thread deleted and may also result in your account being banned.
    • Be polite.  You will get better assistance if you're polite to other members so no flaming or trolling.  If you persist with flaming or trolling, your accountmay get banned.
    • Mark your question answered. If someone answers your question please mark their reply as the answer to your question. You can also mark multiple replies as answers if you think they answered your question.  Marking replies not only assists others with similar questions, it also let's people know that you're grateful for their assistance.

    Dead thread/Answer policy.

    Where possible the moderators will allow sufficient time for the original poster to come back and mark the replies to their questions as answers. The amount of time is at the discretion of the individual moderator but is suggested that it will be declared dead after a week if the original poster does not respond . We will always try to be fair and mark suitable replies as answers.

    Setting up your alerts

    If you are having trouble receiving alerts on the threads you have created or replied to please see thisthread for troubleshooting advice.

  • 連結
    Samples bugs and suggestions.
    David Reed (Glacier Peak) 2009年2月2日 下午 04:26
    All of the work items for our community projects and product samples are in TFS on CodePlex. If you want to report a bug, suggest a change for an existing sample or suggest a new sample, create a work item in the appropriate project so that our community team (not just Microsoft employees) can vote on them, help us triage and prioritize them.

    For example, here's the URL for the work items for AdventureWorks: http://www.codeplex.com/MSFTDBProdSamples/WorkItem/AdvancedList.aspx
  • 連結
    Welcome aboard! Community & Samples Forum Intro
    David Reed (Glacier Peak) 2009年1月29日 下午 09:58

    This forum is the place to discuss all things "samplish" in the SQL Server community and samples space, whether it's an "official Microsoft sample" or a community project in CodePlex or Code Gallery. This is *not* the place to discussion specific nuances of T-SQL syntax or wage data modeling methodology wars: there are lots of other forums for those purposes. This one is for questions about samples, community projects and conversations between the collaborators that build them.

     

    Some examples of projects that are open for discussion can be found here: http://www.codeplex.com/SqlServerSamples/ It doesn't have to be listed there to be fair game, but it's a good bet that it is fair game if it's already listed there.

     

    Also, please post your project announcements here when you create a new release or a whole new project. If you're looking for people to work on your project or looking for a project to work on, this would be a good place to do both.

     

    Let us know what's missing, let know what could be better and let us know what we're doing right!

SQL Server Migration 公告

  • 連結
    Welcome to the SQL Server Migration forum
    Keshav Ramarao 2010年4月28日 上午 02:14

    Need help with migration to SQL Server? Have any questions related to SQL Server Migration Assistant (SSMA) products for Oracle/Sybase/MySQL/Access? Feel free to discuss any SQL Server migration related topics or post any questions related to SSMA.

SQL Server Migration 公告

  • 連結
    Welcome to the SQL Server Migration forum
    Keshav Ramarao 2010年4月28日 上午 02:14

    Need help with migration to SQL Server? Have any questions related to SQL Server Migration Assistant (SSMA) products for Oracle/Sybase/MySQL/Access? Feel free to discuss any SQL Server migration related topics or post any questions related to SSMA.

Machine Learning Services (R & Python) 公告

  • 連結
    Get started with R analytics on SQL server
    Jitendra Kulshreshtha 2018年4月20日 下午 11:09

    Overview

    The process of building an end to end solution typically consists of obtaining and cleaning data, data exploration and feature engineering, model training and tuning, and finally deployment of the model in production. Development and testing of the actual code is best performed using a dedicated development environment. For R, that might mean RStudio or R Tools for Visual Studio.

    However, after the solution has been created, you can easily deploy it to SQL Server using Transact-SQL stored procedures in the familiar environment of Management Studio.

    In this tutorial, we assume that you have been given all the R code needed for the solution, and focus on building and deploying the solution using SQL Server.

    • Lesson 1: Download the sample data

      Download the sample dataset and the sample SQL script files to a local computer.

    • Lesson 2: Import data to SQL Server using PowerShell

      Execute a PowerShell script that creates a database and a table on the SQL Server 2017 instance and loads the sample data to the table.

    • Lesson 3: Explore and visualize the data

      Perform basic data exploration and visualization, by calling R packages and functions from Transact-SQL stored procedures.

    • Lesson 4: Create data features using T-SQL

      Create new data features using custom SQL functions.

    • Lesson 5: Train and save an R model using T-SQL

      Build a machine learning model using R in stored procedures. Save the model to a SQL Server table.

    • Lesson 6: Operationalize the model

      After the model has been saved to the database, call the model for prediction from Transact-SQL by using stored procedures.

  • 連結
    Run machine learning directly on SQL Server !!!
    Jitendra Kulshreshtha 2018年4月20日 下午 11:05

    What is SQL Server Machine Learning Services?


    • THIS TOPIC APPLIES TO: yesSQL Server (Windows only)

    SQL Server Machine Learning Services is an embedded, predictive analytics and data science engine that can execute R and Python code within a SQL Server database as stored procedures, as T-SQL script containing R or Python statements, or as R or Python code containing T-SQL.

    The key value proposition of Machine Learning Services is the power of its proprietary packages to deliver advanced analytics at scale, and the ability to bring calculations and processing to where the data resides, eliminating the need to pull data across the network.

    There are two options for using machine learning capabilities in SQL Server:

    • SQL Server Machine Learning Services (In-Database) operates within the database engine instance, where the calculation engine is fully integrated with the database engine. Most installations are this option.
    • SQL Server Machine Learning Server (Standalone) is a non-SQL installation. Although you use SQL Server Setup to install the server, it is completely decoupled from SQL Server. Functionally, it is equivalent to the non-SQL Microsoft Machine Learning Server for Windows.

    R and Python packages

    Support for each language is through proprietary Microsoft packages used for creating and training models of various types, scoring data, and parallel processing using the underlying system resources.

    Because the proprietary packages are built on open-source R and Python distributions, script or code that you run in SQL Server can also call base functions and use third-party packages compatible with the language version provided in SQL Server (Python 3.5 and recent versions of R, currently 3.3.3).

    RPythonDescription
    RevoScaleRrevoscalepyFunctions in these libraries are among the most widely used. Data transformations and manipulation, statistical summarization, visualization, and many forms of modeling and analyses are found in these libraries. Additionally, functions in these libraries automatically distribute workloads across available cores for parallel processing, with the ability to work on chunks of data that are coordinated and managed by the calculation engine.
    MicrosoftMLmicrosoftmlIndustry-leading machine learning algorithms for image featurization, classification problems, and more.
    olapRnoneBuild or execute an MDX query in R script.
    sqlRUtilsnoneFunctions for putting R scripts into a T-SQL stored procedure, registering a stored procedure with a database, and running the stored procedure from an R development environment.
    mrsdeploynonePrimarily used on a non-SQL installation of Machine Learning Server, such as the (Standalone) version. Use this package to deploy and host web services, build scale-out topologies with dedicated web and compute nodes, toggle between local and remote sessions, run diagnostics, and more. For an (In-Database) installation, use this package in a client capacity: for example, to access a web service on a remote server dedicated to running just Machine Learning Services workloads.

    Portability of your custom R and Python code is addressed through package distribution and interpreters that are built into multiple products. The same packages that ship in SQL Server are also available in several other Microsoft products and services, including a non-SQL version called Microsoft Machine Learning Server. Free clients that include our R and Pyton interpreters include Microsoft R Client and the Python libraries.

RRS feed

  • Remove From My Forums

個論壇 [ 檢視全部 ]

選取的論壇

清除
SQL Server Forumu
x
Microsoft SQL Server
x
Microsoft SQL Server
x
SQL Server
x
SQL Server
x
SQL Server Forumu
x
Für IT-Professionals: SQL Server
x
Für IT-Professionals: SQL Server
x
SQL Server, Azure SQL Database
x
SQL Server, Azure SQL Database
x
SQL Server - Desenvolvimento Geral
x
SQL Server
x
SQL Server - Desenvolvimento Geral
x
SQL Server
x
SQL Server Data Warehousing
x
SQL Server Data Warehousing
x
Für Entwickler: SQL Server
x
Für Entwickler: SQL Server
x
SQL Server Business Intelligence
x
SQL Server - Infra Geral
x
SQL Server - Infra Geral
x
SQL Server Business Intelligence
x
SQL Server Integration Services
x
SQL Server Integration Services
x
SQL Server Express
x
SQL Server Express
x
SQL Server Analysis Services (BI e Data Mining)
x
Microsoft Japan BI Data Platform(SQL) Support Team
x
SQL Server Analysis Services (BI e Data Mining)
x
Data Mining
x
Data Mining
x
SQL Server - Reporting Services
x
SQL Server - Reporting Services
x
SQL Server Reporting Services, Power View
x
SQL Server Reporting Services, Power View
x
Programação avançada com o SQL Server
x
Programação avançada com o SQL Server
x
SQL Server Analysis Services
x
SQL Server Analysis Services
x
Gerenciamento, Configuração, Instalação, e Segurança
x
Gerenciamento, Configuração, Instalação, e Segurança
x
SQL Server Tools
x
SQL Server Tools
x
SQL Server - Express e CE/Compact
x
SQL Server - Express e CE/Compact
x
Transact-SQL
x
SQL Server Integration Services
x
SQL Server Integration Services
x
.NET Framework inside SQL Server
x
.NET Framework inside SQL Server
x
SQL Server Data Access
x
SQL Server Data Access
x
Alta Disponibilidade
x
Alta Disponibilidade
x
SQL Server SMO/DMO
x
SQL Server SMO/DMO
x
SQL Server XML
x
SQL Server XML
x
SQL Server Replication
x
SQL Server Replication
x
SQL Service Broker
x
SQL Service Broker
x
SQL Server Security
x
SQL Server Security
x
SQL Server Database Engine
x
SQL Server Database Engine
x
SQL Server Documentation
x
SQL Server Documentation
x
SQL Server Setup & Upgrade
x
SQL Server Setup & Upgrade
x
SQL Server High Availability and Disaster Recovery
x
SQL Server High Availability and Disaster Recovery
x
SQL Server Notification Services
x
SQL Server Notification Services
x
SQL Server Compact
x
SQL Server Compact
x
Getting started with SQL Server
x
Getting started with SQL Server
x
Database Mirroring
x
Database Mirroring
x
SQL Server Express
x
SQL Server Express
x
Microsoft Drivers for PHP for SQL Server
x
Microsoft Drivers for PHP for SQL Server
x
SQL Server Search
x
SQL Server Search
x
SQL Server Spatial
x
SQL Server Spatial
x
Database Design
x
Database Design
x
SQL Server Master Data Services
x
SQL Server Master Data Services
x
SQL Server Application and Multi-Server Management
x
SQL Server Manageability
x
SQL Server Manageability
x
SQL Server PowerPivot for SharePoint
x
SQL Server PowerPivot for SharePoint
x
Power Pivot
x
Power Pivot
x
SQL Server Application and Multi-Server Management
x
SQL Server Samples and Community Projects
x
SQL Server Samples and Community Projects
x
SQL Server Migration
x
SQL Server Migration
x
SQL Server Data Quality Services
x
SQL Server Data Quality Services
x
SQL Server Distributed Replay
x
SQL Server Distributed Replay
x
SQL Database Managed Instance - Cloud Lifter
x
Machine Learning Services (R & Python)
x
+ 100 more