حصريا: تحميل جميع نسخ قاعدة بيانات (Microsoft SQL Server)

تم تحميل الصفحة في 0,2241314 ثانية
حصريا: تحميل جميع نسخ قاعدة بيانات (Microsoft SQL Server)

Black General

مُراقب عام أقسام الفحص والإنمي
rankrankrankrankrankrank
طاقم الإدارة
إنضم
15 مارس 2013
المشاركات
3,636
الإعجابات
4,204
النقاط
113
الإقامة
JO
مجاني Microsoft SQL Server, كيجن برنامج Microsoft SQL Server, مفتاح Microsoft SQL Server, كراك تفعيل Microsoft SQL Server, الشرح الكامل لبرنامج Microsoft SQL Server, تفعيل مجاني Microsoft SQL Server, تفعيل برنامج Microsoft SQL Server, شرح برنامج Microsoft SQL Server, شرح تفعيل Microsoft SQL Server, اعادة الفترة التجريبية لبرنامج Microsoft SQL Server, تشغيل Microsoft SQL Server, تجاوز الفترة التجريبية Microsoft SQL Server, طريقة إعادة الفترة التجريبية Microsoft SQL Server, باتش Microsoft SQL Server, شرح تشغيل Microsoft SQL Server, Serial generator Microsoft SQL Server, تكريك برنامج Microsoft SQL Server, تحميل Microsoft SQL Server, تشغيل برنامج Microsoft SQL Server, تحميل مجاني Microsoft SQL Server, تفعيل برنامج Microsoft SQL Server, تفعيل و تشغيل Microsoft SQL Server, تفعيل Microsoft SQL Server, تحميل Microsoft SQL Server, كراك موثوق Microsoft SQL Server, شرح Microsoft SQL Server, تجازو تفعيل Microsoft SQL Server, كراك نظيف Microsoft SQL Server, شرح الإصدار Microsoft SQL Server, تحميل و تفعيل Microsoft SQL Server, برنامج Microsoft SQL Server, كراك برنامج Microsoft SQL Server, شرح Microsoft SQL Server, كيجن نظيف Microsoft SQL Server, شرح تفعيل Microsoft SQL Server, كراك مفعل Microsoft SQL Server, كراك مجاني Microsoft SQL Server, إعادة الفترة التجريبية Microsoft SQL Server, سيريال برنامج Microsoft SQL Server, تكريك برنامج Microsoft SQL Server, كيجن Microsoft SQL Server, شرح كامل خصائص Microsoft SQL Server, باتش برنامج Microsoft SQL Server, طريقة تشغيل Microsoft SQL Server, تشريح برنامج Microsoft SQL Server, كراك Microsoft SQL Server, شرح تفعيل Microsoft SQL Server, شرح تشغيل برنامج Microsoft SQL Server, كيجن برنامج Microsoft SQL Server, سيريال Microsoft SQL Server, شرح كامل البرنامج Microsoft SQL Server, شرح تفعيل برنامج Microsoft SQL Server, كراك Microsoft SQL Server, تحميل برنامج Microsoft SQL Server, كراك برنامج Microsoft SQL Server, كيجن موثوق Microsoft SQL Server, شرح كامل عن Microsoft SQL Server, activate Microsoft SQL Server, Full Version Microsoft SQL Server, Crack Microsoft SQL Server, Full Crack Microsoft SQL Server, free Microsoft SQL Server, Serial Microsoft SQL Server, Serial key Microsoft SQL Server, Full version Microsoft SQL Server, Free download Microsoft SQL Server, download Microsoft SQL Server, key generator Microsoft SQL Server, generate key Microsoft SQL Server, terial reset Microsoft SQL Server, License Microsoft SQL Server, registeration key Microsoft SQL Server,



بسم الله الرحمن الرحيم
السلام عليكم ورحمة الله وبركاته
والصلاة والسلام على أشرف الانبياء والمُرسلين سيدنا مُحمد عليه أفضل الصلاة وأتم التسليم وبعد
السلام عليكم ورحمة الله وبركاته ، أسعد الله اوقاتكم بكل خير أخوتي زوار ورواد و محبي أقسام البرامج.


كما عودتكم في مواضيعي ، دائما الجديد و لا شيء غير الجديد ، مع موضوع آخر لهذا العملاق في مجاله
و إن شاء الله الموضوع ينال اعجابكم .


=*---------------------------------------------------------------------------------*=



بعد مجهود تجميع شهرين بشكل متواصل

قدم لكم مكتبة الشامل جميع برامج (Microsoft SQL Server)

+

جميع برمجيات اضافية :

( EMS SQL Management Studio for SQL Server )

( Microsoft DeployR for SQL Server Enterprise Edition )

( Microsoft Mouse Pro Sql Server )

( MS SQL Maestro )

( SQL Assistant )

=*---------------------------------------------------------------------------------*=

( *** شرح *** )



شركة مايكروسوفت (Microsoft Corporation ) :

شركة مايكروسوفت (بالإنجليزية: Microsoft Corporation) شركة متعددة الجنسيات تعمل في مجال تقنيات الحاسوب، يبلغ عائدها لسنة 2016 أكثر من 85 مليار دولار،[4] ويعمل بها 114,000 موظف (2016)[4] وهي أكبر مصنع للبرمجيات في العالم من ناحية العائدات اعتباراً من عام 2016.[5] تطوّر وتصنِّع وترخِّص مدى واسعا من البرمجيات للأجهزة الحاسوبيّة. يقع المقر الرئيسي للشركة في ضاحية ريدمونت، سياتل، بولاية واشنطن، الولايات المتحدة.
عند تأسيس شركة مايكروسوفت، اتخذ كل من بيل غيتس وبول ألين من مدينة ألبوكيرك في ولاية نيو مكسيكو مقرا للشركة ومن ثم انتقلت الشركة إلى موقعها الحالي. تجدر الإشارة أن بيل غيتس وبول ألين هما المؤسسين والملاك لهذه الشركة قبل أن تصبح من الشركات العامة والمتداولة في أسواق الأسهم.


=*---------------------------------------------------------------------------------*=

تاريخ:

تأسست شركة مايكروسوفت العملاقة من قبل بيل غيتس وبول ألين في 4 نيسان/ابريل من عام 1975م، كشركة لتسويق معالجات بيسك وأشتهرت شركة مايكروسوفت بهذا المنتج نظراً لجودته وتسابقت باقي الشركات لتزويد السوق بمعالجات بيسك المتوافقة مع معالج بيسك من شركة مايكروسوفت. ونتيجة لتكالب الشركات في السباق آنف الذّكر، أصبح معالج بيسك والمُنتج من قِبل شركة مايكروسوفت بمثابة المقياس في معالجات بيسك وهيمنت شركة مايكروسوفت على سوق معالجات بيسك وقام كل من بيل غايتس وبول آلان بتسجيل الماركة التجارية "مايكروسوفت" في 26 نوفمبر 1976.

أوّل نظام تشغيل أصدرته مايكروسوفت كان نسخة من نظام يونكس في عام 1980. ولقد أشترتها من شركة إيه تي آند تي عبر ترخيص توزيع، وأسمته ميكروسوفت بالاسم زينيكس ووظفت شركةSanta Cruz Operation لتطويعه ليعمل على أكثر من منصّة تشغيل. ولم تبِع شركة مايكروسوفت هذا النظام للمستخدم مباشرة، بل عبر بيعه لمصنِّعي الحواسيب. ومع منتصف الثمانينات خرجت شركة مايكروسوفت من سوق يونكس تماما.

وفي أواخر عام 1980م احتاجت شركة أي بي أم نظام تشغيل لجهاز الحاسوب الشخصي المزمع طرحه في الأسواق فقامت شركة مايكروسوفت بدور الوسيط بين شركة "سياتل كومبيوتر برودكتس" وشركة IBM لاستعمال نظام التشغيل QDOS من قبل الشركة الأولى على الأجهزة الشخصية IBM. وقامت شركة مايكروسوفت في النهاية بشراء الحقوق التجارية لـ QDOS وأسمته إم إس-دوس. وقامت شركة IBM بطرح الحاسوب الشخصي في عام 1981م، وكان نظام التشغيل الملحق بالجهاز يسمى PC-DOS وقامت شركة مايكروسوفت بحفظ حقوقها تجاه المنتج MS-DOS ومنح ترخيص تجاري لـ IBM لتسويق PC-DOS كنظام لتشغيل أجهزة IBM. CACA - TETA - CULO - ILDE ES TONTO - BRRL

سمحت الصفقة مع IBM لشركة مايكروسوفت بأن تتحكم في نسختها الخاصة من النظام، ومع انتشار أجهزة الحواسيب المتوافقة مع IBM وسياسة التسويق الواسعة تحوّلت شركة مايكروسوفت من لاعب صغير إلى أحد المنتجين الرئيسيين للبرمجيات في سوق الحواسيب المنزليّة.

لم تكن البرامج المستخدمة على أجهزة الحواسيب الشخصية أفضل من الناحية الفنية عن نظيراتها المستخدمة على أجهزة الحواسيب العملاقة ولكن امتازت الأولى عن الثانية بأنها أعطت درجة من الحرية في استخدام هذه البرامج بشكل أفضل ناهيك عن رخص تكلفة البرامج التي تعمل على أجهزة الحاسوب الشخصية بالمقارنة مع تكلفة نفس البرامج التي تعمل على أجهزة الحاسوب العملاقة. تجدر الأشارة أن أحد أهم أسباب سرعة هيمنة شركة مايكروسوفت على عالم البرمجيات هي الطفرة في انتشار الحاسب الشخصي في حقبة الثمانينات من القرن العشرين.

في 29 يوليو 2009 تم الاتفاق بين شركتي ياهوو ومايكروسوفت على صفقة لمدة عشر سنوات تسمح لشركة مايكروسوفت باستخدام محرك البحث الخاص بشركة ياهوو لصالحها.[6]

إن كلا من بيل غيتس وبول ألين كانا صديقان منذ الطفولة، ولديهما شغف وحب لبرمجة الحاسب الآلى وكانا يسعيان لعمل أعمال تجارية ناجحة للاستفادة من مهاراتهما المشتركة. وفي عام 1972، أسس الأثنان شركتهما الأولى ترافوداتا التي وفرت الحاسب الآلي البدائي، والذي تعقب وحلل بيانات حركة السيارات. ولقد سافر بول ألين للحصول على درجة علمية في علم الحاسب الآلي في جامعة واشنطن، ولاحقا ترك الدراسة للعمل في هانيويل. بدأ جيتس دراسته في هارفيد[7] أوضحت قضية يناير عام 1975 الخاصة بالأكترونيات الشعبية والأجهزة الدقيقة وأنظمة القياس عن بعد ألتير 8800.

لاحظ ألين أنهم يستطيعوا برمجة بيسيك للجهاز؛ بعد أن أجري جيتس مكالمة هاتفية يَدعي انه يعمل كمترجم طلبت الشركة إثباتا لكلامه حيث أنها في ذلك الوقت لم تكن تملك مترجماً؛ عمل ألين في مجال المحاكاة لدي ألتير 8800 بينما طور جيتس المترجم، وبالرغم من أنهما طورا المترجم وثبتاه مع جهاز المحاكاة وليس الجهاز الفعلي إلا أن المترجم عمل بلا أي مشاكل عندما أظهروا المترجم في ألباكركي، نيومكسيكو في مارس 1975. ولقد وافقت الشركة على توزيعه وتسويقه كألتير بيسيك.

وأسسوا شركة مايكروسوفت رسمياً في الرابع من إبريل عام 1975 مع جيتس كالمدير التنفيذى. وخطرت علي بال ألين فكرة الأسم الأصلي لشركة مايكروسوفت والخلط بين كلمات المايكروكمبيوتر والسوفت واير كسرد أو روي ل1995 Fortune magazine article. وفي أغسطس عام 1977؛ عقدت الشركة اتفاقاً مع مجلة ASCII في اليابان، مما أدى إلى إنشاء أول مكتب دولي [2]. وأنتقلت الشركة إلى مكانها الجديد في بالفيو، في مدينة واشنطن في يناير عام 1979.

لقد شاركت شركة مايكروسوفت في مجال أنظمة التشغيل عام 1980 مع إصدارها الخاص يونكس الذي يسمى زينيكس. ولكن كان هذا إم إس-دوس الذي عزز هيمنة الشركة. وبعد محاولات فاشلة مع البحوث الرقمية، عقدت شركة إم بي آي أتفاقا مع شركة مايكروسوفت في نوفمبر عام 1980 لتدعم إصدار أنظمة التشغيل الخاصة بالتحكم بالحواسيب الذي كان من المقرر أن يستخدم في أجهزة الحاسوب الخاصة ب إم بي آي. ولهذه الصفقة اشترت مايكروسوفت إستنساخاً لأنظمة التشغيل يسمى دوس_86 من سياتل لمنتجات الحاسوب؛ واصفين إياها إم-إس دوس الذي غيرت شركة إم بي آي علامته التجارية إلي بي سي دوس. وعقب صدور الأجهزة الشخصية لشركة آي بي إم في أغسطس عام 1981؛ احتفظت مايكروسوفت بملكية إم-إس دوس. منذ حقوق التأليف والنشر لشركة آي بي إم؛ الأجهزة الشخصية بيوس، شركات أخرى اضطرت إلي الهندسة عكسية وذلك من أجل الاجهزة غير المملوكة لشركة آي بي إم لتعمل كمتوافقات للاجهزة الشخصية لشركة آي بي إم، ولكن لا يوجد مثل هذا التقييد المطبق على أنظمة التشغيل. ونتيجة لعوامل مختلفة منها اختيار البرامج المتاحة ل إم إس دوس ؛أخيراً أصبحت مايكروسوفت المورد الرائد لبيع أنظمة التشغيل للاجهزة الشخصية. وتوسعت الشركة وتفتحت لها أسواقاً جديدة وذلك بصدور جهاز الفأرة الخاص بشركة مايكروسوفت في 1983؛ بالإضافة إلي النشر المقسم تحت اسم صحافة مايكروسوفت. ولقد استقال بول ألين من شركة مايكروسوفت في فبراير بسبب إصابته بمرض لمفومة هودجكين

=*---------------------------------------------------------------------------------*=

مايكروسوفت دوت نت "Microsoft .NET"

اشتهرت شركة مايكروسوفت بقدرتها على الابتكار وتقديم أفضل التقنيات والحلول المعتمدة على احتياجات العملاء والبحث والتطوير. وبعد النجاح الذي حققته مايكروسوفت في التطبيقات الخاصة بأجهزة الحاسوب الشخصية وهو ما يعرف لدى التقنيين باسم "ثورة ويندوز" بدأت مايكروسوفت في توسيع استخدامات الحاسوب الشخصي لتضيف أبعاداً جديدة من الفعالية على هذه التقنيات وذلك من خلال استراتيجيتها الشهيرة "دوت نت".

ويعد إطلاق مايكروسوفت لإطار العمل التقني "مايكروسوفت دوت نت" و"فيجيوال ستديو دوت نت" "Visual Studio.NET" في فبراير الماضي حجر الزاوية والأساس الحقيقي لاستراتيجية مايكروسوفت دوت نت، ويمثل البداية الفعلية لرؤية مايكرسوفت في بناء مواقع الانترنت بالاعتماد على لغة "إكس إم إل" "XML". تعتبر "مايكروسوفت دوت نت" إطار عمل تقني مبني وفق معايير تقنية مفتوحة، ووفقاً للغة الأعمال، وتعد استراتيجية "دوت نت" خدمة تقنية شاملة تحول برامج الحاسوب إلى خدمة مرنة وفعالة تزود قطاعات الأعمال المختلفة بالتقنيات الضرورية للحفاظ على قدراتها التنافسية في الأسواق في عصر التقنيات الرقمية.

وتوفر النقلة الحالية في المعايير التقنية المتمثلة في الانتقال من الاعتماد على أجهزة الحاسوب الشخصي والتوجه نحو الاعتماد بشكل أكبر على أجهزة الاتصال والحاسوب المحمول وخدمات الإنترنت المختلفة، كقوة دفع كبيرة لتعزيز الحاجة لاستراتيجية مايكروسوفت الجديدة. وتسعى مايكروسوفت من خلال استراتيجيتها إلى تزويد المستخدمين بتقنيات أفضل للحصول على المعلومات بسهولة وتمكينهم من التحكم في وقت ومكان وكيفية الحصول على المعلومة. وستسهل التقنيات الجديدة وسيلة التخاطب وتبادل المعلومات بين أجهزة الحاسوب الشخصي والأنظمة المعلوماتية المحمولة والأجهزة التقنية الأخرى، الأمر الذي سيمكن المؤسسات وقطاعات الأعمال من عرض منتجاتها وخدماتها المختلفة عبر شبكة الإنترنت من خلال وسائل تقنية متطورة.

=*---------------------------------------------------------------------------------*=



ميكروسوفت إس كيو إل سيرفر (بالإنجليزية: Microsoft SQL Server)

هو برنامج لقواعد البيانات العلائقية من إنتاج مايكروسوفت، لغة الاستعلام الرئيسية فيه هي إس كيو إل وتي-سكيول

تسريع وتيرة الابتكار في أماكن العمل

تعتبر المعلومات والأمان عنصرين مُضمنين في Microsoft SQL Server 2017. وتحصل على ميزات إضافية بلا أي تكلفة زائدة، جنبًا إلى جنب مع الأداء والمرونة الأفضل في فئتهما لتلبية احتياجاتك في أماكن العمل.

تسريع انتقالك إلى السحابة‬

استفد من كفاءة السحابة وبراعتها من خلال الترحيل بسهولة إليها دون تغيير التعليمات البرمجية. أطلق العنان للرؤى وأجرِ التنبؤات بشكل أسرع مع Azure.

بناء التطبيقات الذكية

استمتع بالتطوير باستخدام تقنيات من اختيارك، بما في ذلك المصدر المفتوح، بدعم من ابتكارات Microsoft. ادمج البيانات في تطبيقاتك واستخدم مجموعة ثرية من الخدمات المعرفية لبناء معلومات تُشبه الأداء البشري عبر أي نطاق من البيانات بسهولة.

اكتساب رؤى تحويلية

يعتبر الذكاء الاصطناعي عنصرًا أصيلاً في النظام الأساسي للبيانات؛ يمكنك إطلاق العنان للرؤى بشكل أسرع من جميع بياناتك، في أماكن العمل وفي السحابة. ادمج البيانات الفريدة لمؤسستك والبيانات العالمية لتخلق مؤسسة قائمة على المعلومات.

=*---------------------------------------------------------------------------------*=

يتبع ...
 
التعديل الأخير:

Black General

مُراقب عام أقسام الفحص والإنمي
rankrankrankrankrankrank
طاقم الإدارة
إنضم
15 مارس 2013
المشاركات
3,636
الإعجابات
4,204
النقاط
113
الإقامة
JO
( Microsoft SQL Server 6.5 )



( Information )

No, Hydra's not a B-grade remake of an old Godzilla movie. It's Microsoft's latest release of SQL Server 6.5 (formerly code named Hydra). Despite the small bump in version number, version 6.5 includes major enhancements that programmers and administrators can incorporate quickly and easily into their databases. Some important improvements are in key functional areas such as Internet support, Object Linking and Embedding (OLE) support, distributed data management, data-warehousing support, and utilities.

SQL WWW Page Wizard
SQL Server 6.5's Internet strength begins with the SQL WWW Page Wizard, an intelligent assistant that helps you publish data on the Web, using standard Hypertext Markup Language (HTML) pages. The SQL Server development team added the wizard in response to Bill Gates' decree that all Microsoft products be "World Wide Web enabled."


The SQL WWW Page Wizard asks questions to obtain data to insert into the HTML page. Version 6.5 provides a visual query builder, but experienced SQL developers may want to enter a Transact SQL (T-SQL) query or stored procedure directly. Then a dialog asks you to provide a publishing schedule, which you can use to publish an HTML page for one-time-only release, refresh a page on a predefined schedule, or update a page when the underlying data changes.

The SQL WWW Page Wizard generates HTML code by calling on three new stored procedures: sp_dropwebtask, sp_makewebtask, and sp_runwebtask. The result is an easy-to-access interface for generating Web pages from any program that can call a stored procedure, including Visual Basic (VB), Delphi, and most development environments that access Open Database Connectivity (ODBC) data sources. For example, developers can call these stored procedures to create their own Web wizard.

Internet Database Connector
Microsoft's new Internet Information Server (IIS) is another manifestation of Internet commitment. IIS is available for free at www.microsoft.com and will be part of NT 4.0. IIS includes Internet Database Connector (IDC), which lets IIS access data from any ODBC-compliant data source.


Although IDC is not new to version 6.5, it's significant because it simplifies Web integration. IDC uses Microsoft's new Internet Server API (ISAPI), which lets you create server-based applications that users can activate from any standard Web browser. The ISAPI application grabs data from the client's HTML page, acts on it, and returns information to the Web browser, using standard HTML.

ISAPI is similar to the popular Common Gateway Interface (CGI), but superior in two important ways. First, ISAPI is a Windows-standard API, so most programming languages that call Dynamic Link Libraries (DLLs) can use ISAPI. This capability eliminates the need for text processing languages, such as Perl, that CGI uses. Second, ISAPI applications typically perform better than their CGI counterparts because ISAPI applications can encapsulate their logic in standard DLLs that load once at runtime. This initial loading eliminates the need to start a separate process for each request and reduces the processing overhead that can bog down busy servers.

IDC relies on a new DLL, httpodbc.dll, for data access. This DLL uses two file types: IDC (.idc) files to control how users access the database and HTML Extension (.htx) files to control construction of the output Web page. The best way to learn about IDC for creating database-ready Web pages is to experiment with the sample applications that ship with IIS.

I recommend that you look at the Guest Book application, a handy program that sets up a user registration form so users can insert, modify, and retrieve data from an ODBC-compliant database. The Guest Book .idc file references an ODBC data source and provides login information. A select query in the file returns an HTML-formatted result set to the Web browser. This .idc file will also insert and format data for the client, using information in a complementary .htx file. The contents of the Guest Book .idc file are

Datasource: Web SQL
Username: sa
Template: sample.htx
SQLStatement:
+SELECT au_lname, ytd_sales
+ from pubs.dbo.titleview
+ where ytd_sales>5000


Improved OLE Support
OLE doesn't get the attention that the Internet enjoys, but developers understand its power. Microsoft has significantly improved SQL's OLE capabilities. OLE Automation is a standard mechanism that lets you take advantage of and access data from one application (the automation server) while you're in another (the application controller).


In version 6.0, SQL Distributed Management Objects (SQL-DMOs) let developers control most aspects of the server from an OLE Automation interface. SQL-DMOs (similar to "functions" in a 3- or 4GL environment) have adjustable properties that describe their state and methods and affect their actions. SQL Server 6.5 adds to this by providing several OLE-based enhancements. Two new DMOs are BulkCopy and Transfer.

The BulkCopy Object: The BulkCopy Object provides an interface from an OLE-controller application for high-speed data transfer in and out of SQL Server. By setting advanced properties, the user controls key aspects of the data transfer process such as the type of BulkCopy Object (e.g., character or native mode), whether to truncate the transaction log before data loading, and whether to drop nonprimary key indexes before data loading. If the user drops existing indexes, the BulkCopy Object automatically re-creates them after data loading.

The Transfer Object: Developers often need to transfer specific objects or even entire databases between servers. Using 25 properties, the Transfer Object lets you control all aspects of such transfers. Listing 1 shows how easily you can move databases around your network with the Transfer Object. In fact, the transfer capability built into the new SQL Enterprise Manager is based on this Transfer Object.

Extended Stored Procedures
An important version 6.5 enhancement is that you can create extended stored procedures. These procedures rely on languages other than T-SQL (the native programming environment for SQL Server) to encapsulate business processing in server-based objects. Previous releases of SQL Server forced developers to write these extended stored procedures with C or C++, which limited the procedures' mainstream use.


Although nothing is inherently difficult about writing code in C, many developers and corporate IS shops are more comfortable with high-level tools such as VB. Now that you can build extended stored procedures with VB, these procedures will become more common in client/server applications. Listing 2 shows a VB-generated extended stored procedure (identified as xp) that echoes a parameter the user supplies.

=*---------------------------------------------------------------------------------*=

( صور )



=*---------------------------------------------------------------------------------*=

يتبع ...
 

Black General

مُراقب عام أقسام الفحص والإنمي
rankrankrankrankrankrank
طاقم الإدارة
إنضم
15 مارس 2013
المشاركات
3,636
الإعجابات
4,204
النقاط
113
الإقامة
JO
( Microsoft SQL Server 7.0 )



( Information )

March 1999

Summary: This article is a guide to storage engine architecture and recommends configuration parameters, best hardware to purchase with SQL Server 7.0, and innovative ways to store large amounts of data through files and file groups. This article also discusses new features in the SQL Server 7.0 storage engine. (29 printed pages)
Contents


Storage Engine Capacity Planning Overview
SQL Server 7.0 Storage Engine Highlighs
Files and Filegroups
Assigning Files to Filegroups for Maintenance Reasons
Assigning Files to Filegroups for Performance Reasons
Hardware I/O Layout for Files and Filegroups
SQL Server Memory Planning
SQL Server 7.0 Processor Planning
Storage Engine Capacity Planning: Overview


The I/O subsystem (storage engine) is a key component of any relational database management system (RDBMS). A successful RDBMS implementation requires careful planning at the early stages of the project. The storage engine comprises much of this planning, including what hardware to purchase, how to store data on the hardware, and how to set the configuration parameters appropriately. To accomplish these tasks requires an extensive understanding of the RDBMS architecture.

This article includes:

Descriptions of the new dynamic features of Microsoft® SQL™ Server 7.0 and recommendations for when to use them
Descriptions of the architecture of the I/O subsystem, memory, processor threading, and utilities to improve capacity planning
Recommendations for setting system configurations to exploit resources more effectively


SQL Server 7.0 Storage Engine Highlights

Microsoft SQL Server 7.0 reduces the configuration and tuning required to implement and run database applications. A major goal of SQL Server 7.0 is to minimize the need for database expertise. This is accomplished by new features, including but not limited to: on-demand memory, on-demand disk, and dynamic tuning of configuration parameters. Many users can now implement a database application successfully without knowledge about the internal architecture of the database system; however, a small percentage of high-end applications always require more detailed knowledge.

The following table describes the changes and new features included in the Microsoft SQL Server 7.0 storage engine:

Table 1. Microsoft SQL Server 7.0 storage engine features

*Performance improvements

Performance for both OLTP and decision support is improved by implementing new features and improving existing systems. New features include:

Fibers (lightweight threads scheduled within a single operating-system thread)
Larger I/O sizes
Spinlock contention reduction
Faster searches
Parallel data access
Faster utilities


*Complete row-level locking

The benefits of dynamic locking (choosing the right level of lock: row, key range, page, multiple pages, or table on the fly) are extended to all database operations: updates, deletes, and reads.

Scalable storage, including
VLDB support


The on-disk format and the storage subsystem can provide storage that is scalable from the very small database (fits on a floppy) to very large databases (VLDB). Specific changes include:

The ability to grow the database automatically within limits. The database administrator can set a maximum, but no longer has to preallocate space and manage extents

Simplified mapping of database objects to files. On the small scale, this means a database, including metadata, can be in a single file, allowing a simple copy of the database. For large databases, database objects can be mapped to specific disks to load balance I/O

More efficient space management including increasing page size from 2 KB to 8 KB, 64-KB I/O, rows that span pages, lifting of the column limit, variable length character fields up to 8 KB, and the ability to add and delete columns from existing tables without unloading or reloading the data

Redesigned utilities to support terabyte-size databases efficiently

*Improved text and image support

SQL Server has complete content text query capability with new full-text search engine additions, which include full-text indexing.

Files and Filegroups

In Microsoft SQL Server version 6.5, devices and segments are used to physically allocate space for storing data, indexes, and logs. This can be cumbersome for applications with large amounts of data. In Microsoft SQL Server version 7.0, files and filegroups are used to allocate space for data, indexes, and logs, giving you many more choices for setting up data.

A file is a physical allocation of space and can be one of three types: primary, secondary, or log.

A primary file is the starting point of the database and contains the pointers to the rest of the files in the database. Every database has one primary data file. The recommended file extension for primary data files is: .mdf (E:\Mssql7\Data\Master.mdf). Some databases may not have secondary data files, and others may have multiple secondary data files. The recommended file extension for secondary data files is: .ndf (E:\Mssql7\Data\Mydata1.ndf). Log files hold all of the log information used to recover the database. There must be at least one log file for each database, although there can be more than one. The recommended file extension for log files is: ldf (E:\Mssql7\Data\Mylog.ldf).

Database objects can be grouped in filegroups for allocation, performance, and administration purposes. There are two types of filegroups: user-defined filegroups and the primary filegroup. The primary filegroup or any of the user filegroups can be the default filegroup. The primary file is assigned to the primary filegroup. Secondary files can be assigned to user filegroups or the primary filegroup. Log files are never a part of a filegroup. Log space is managed separately from data space.

Note The preceding illustration shows a primary filegroup assigned as the default.

Care must be taken with the size of the primary filegroup, especially if it is also the default filegroup. Because the primary filegroup contains all the system tables, if it runs out of space, no new catalog information can be added to the system tables. In contrast, if a user-defined filegroup fills up, only the user tables specifically allocated to that filegroup are affected. The primary filegroup fills if the autogrow feature is off or if the disk holding the primary filegroup runs out of space. If either of these should occur, set autogrow on or move other files off the disk to free more space.

When creating objects such as tables and indexes, you can specify the filegroup to which the tables and indexes are assigned. A table can be assigned to one filegroup, and that table’s index(es) can be assigned to a different filegroup. If you do not specify a filegroup, the table or index is assigned to the default filegroup.

=*---------------------------------------------------------------------------------*=

( صور )



=*---------------------------------------------------------------------------------*=

يتبع ...
 

Black General

مُراقب عام أقسام الفحص والإنمي
rankrankrankrankrankrank
طاقم الإدارة
إنضم
15 مارس 2013
المشاركات
3,636
الإعجابات
4,204
النقاط
113
الإقامة
JO
( Microsoft SQL Server 2000 )



( Information )


Troubleshooting SQL Server 2000 installation issues

By Alexander Chigrik

Should you have problems installing SQL Server 2000, review this troubleshooting checklist to find potential solutions.

1. Check the hardware requirements.

You should have:

Intel or compatible platform
Pentium 166 MHz or higher (Pentium II, III, IV and compatible)
32MB RAM (minimum for Desktop Engine), 64MB RAM (minimum for all other editions) 128 MB RAM or more recommended
270MB (full installation), 250MB (typical), 95MB (minimum), 44 MB (Desktop Engine) plus Analysis Services: 50 MB minimum and 130 MB typical and 80 MB for the English Query


2. Check the software requirements.

You should have:

For the Enterprise Edition and Standard Edition:
Windows NT Server 4.0 with service pack 5 or later
Windows NT Server 4.0 Enterprise Edition with service pack 5 or later
Windows 2000 Server/Advanced Server/Datacenter


For the Personal Edition and Desktop Engine:
Windows 98
Windows NT Server/Workstation 4.0 with Service Pack 5
Windows NT Server 4.0 Enterprise Edition with Service Pack 5
Windows 2000 (all editions)


For the Developer Edition:
Windows NT Server/Workstation 4.0 with Service Pack 5
Windows NT Server 4.0 Enterprise Edition with Service Pack 5
Windows 2000 (all editions)


For the SQL Server CE:
Windows CE


3. Check that your hardware is listed in the hardware compatibility list.

For more information about the specific supported hardware, look at the hardware compatibility list at http://www.microsoft.com/hwdq/hcl/search.asp

4. Login as a Local Administrator on the Server.

SQL Server needs the administrator's permissions to create registry entries, create services and so on.

5. Use the LocalSystem account for MSSQLServer and SQLServerAgent services.

You can change it later to an appropriate domain account, once you have successfully installed SQL Server. Using the LocalSystem account helps to reduce potential SQL Server installation problems.

6. Close the Service Manager icon in the taskbar.

Microsoft recommends closing the Service Manager icon in the taskbar because it may cause SQL Server Setup to fail.

7. Stop some services, which can cause installation failure.

Because some services may cause installation failure of SQL Server due to a Windows NT/2000 logon failure or time out, you should stop these services before installing SQL Server 2000, and then restart them once SQL Server has been successfully installed. Stop the following services:

IIS - Internet Information Server
Exchange Server
SNA Server
Disk Keeper
SNMP Service
Anti-virus software (such as McAfee)
Backup products (such as ARC Server)


8. Close all extraneous programs that are running.

Because extraneous programs use some system resources, it is a good idea to close all extraneous programs before installing SQL Server 2000. Be sure that there are no any programs on the taskbar except the Setup application.

9. Problems installing MS DTC on computers with multiple network cards or SPX installed.

If you cannot install MS DTC on a server with multiple network cards or SPX installed, uninstall one of the network cards or SPX, and then retry the SQL Server Setup.

10. You can get the error during installation of SQL Server 2000 Personal Edition or SQL Server 2000 Desktop Engine if there is a previous edition of SQL Server 7.0 Desktop Edition or MSDE 1.0 installed.

The cause of this error is that there is not enough system memory to run all of the necessary SQL scripts. You should have at least 48 Mb of RAM (for Windows 9x) rather than the 32 MB of RAM as stated in SQL Server Books Online.

11. Before reinstalling SQL Server 2000 after a failed install, delete the following registry entries:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLServerAgent
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server


and delete the target installation directory.

12. If you install SQL Server 2000 on Windows 9x, you should install Microsoft Client for Networks.

To install Microsoft Client for Networks, click Start -> Control Panel -> Network -> Add Microsoft Client for Networks.

13. To locate any problems during setup, check the sqlstp.log, setup.log and errorlog files.

The following files, found on your server, can provide valuable error messages if your SQL Server installation fails:

sqlstp.log (located in your \Windows or \WinNT directory)
errorlog file (located in the \Log directory of the target installation directory)
setup.log file (located in your \Windows or \WinNT directory)


=*---------------------------------------------------------------------------------*=

( صور )











=*---------------------------------------------------------------------------------*=

يتبع ...
 

Black General

مُراقب عام أقسام الفحص والإنمي
rankrankrankrankrankrank
طاقم الإدارة
إنضم
15 مارس 2013
المشاركات
3,636
الإعجابات
4,204
النقاط
113
الإقامة
JO
( Microsoft SQL Server 2005 )



( Information )

Microsoft SQL Server 2005 Product Overview
Published: April 1, 2005


By Michelle Dumler

Summary: This paper provides an overview of the new benefits and functionality available in SQL Server 2005.
On This Page


Introduction
Microsoft SQL Server 2005 Overview
What’s New in SQL Server 2005
Windows Server System Common Engineering Roadmap
Introduction


Organizations today face numerous data challenges; for example, the need for faster and more data-driven decisions, the need to increase the productivity and flexibility of development staff, and pressure to reduce overall Information Technology budgets while at the same time scaling the infrastructure to meet ever-increasing demands.

The next release of Microsoft® SQL Server™ is designed to help enterprises address these challenges. Microsoft SQL Server 2005 is a next-generation data management and analysis solution that delivers increased security, scalability, and availability to enterprise data and analytical applications, while making them easier to build, deploy, and manage.

Building on the strengths of SQL Server 2000, SQL Server 2005 provides an integrated data management and analysis solution that will help organizations of any size to:


Build, deploy, and manage enterprise applications that are more secure, scalable, and reliable.

Maximize Information Technology productivity by reducing the complexity of building, deploying, and managing database applications.

Share data across multiple platforms, applications, and devices to make it easier to connect internal and external systems.

Control costs without sacrificing performance, availability, scalability, or security.

Read on to learn more about SQL Server 2005 advancements in three key areas: enterprise data management, developer productivity, and business intelligence as well pricing and licensing, upgrading to SQL Server 2005, and the Microsoft Windows Server System™.

Microsoft SQL Server 2005 Overview
SQL Server Data Platform


SQL Server is a comprehensive, integrated end-to-end data solution that empowers users across your organization by providing them with a secure, reliable, and productive platform for enterprise data and business intelligence (BI) applications. SQL Server 2005 delivers powerful, familiar tools to Information Technology professionals as well as to information workers, reducing the complexity of creating, deploying, managing, and using enterprise data and analytical applications on platforms ranging from mobile devices to enterprise data systems. Through a comprehensive feature set, interoperability with existing systems, and automation of routine tasks, SQL Server 2005 provides a complete data solution for enterprises of all sizes. Figure 1 shows the layout of the SQL Server 2005 data platform.

Figure 1: The SQL Server 2005 Data Platform

The SQL Server data platform includes the following tools:

Relational database: Secure, reliable, scalable, highly available relational database engine with improved performance and support for structured and unstructured (XML) data.

Replication Services: Data replication for distributed or mobile data processing applications, high systems availability, scalable concurrency with secondary data stores for enterprise reporting solutions, and integration with heterogeneous systems, including existing Oracle databases.

Notification Services: Advanced notification capabilities for the development and deployment of scalable applications that can deliver personalized, timely information updates to a variety of connected and mobile devices.

Integration Services: Extract, transform, and load capabilities for data warehousing and enterprise-wide data integration

Analysis Services: Online analytical processing (OLAP) capabilities for the rapid, sophisticated analysis of large and complex datasets using multidimensional storage.

Reporting Services: A comprehensive solution for creating, managing, and delivering both traditional, paper-oriented reports and interactive, Web-based reports.

Management tools: SQL Server includes integrated management tools for advanced database management and tuning as well as tight integration with tools such as Microsoft Operations Manager (MOM) and Microsoft Systems Management Server (SMS). Standard data access protocols drastically reduce the time it takes to integrate data in SQL Server with existing systems. In addition, native Web service support is built into SQL Server to ensure interoperability with other applications and platforms.

Development tools: SQL Server offers integrated development tools for the database engine, data extraction, transformation, and loading (ETL), data mining, OLAP, and reporting that are tightly integrated with Microsoft Visual Studio® to provide end-to-end application development capabilities. Every major subsystem in SQL Server ships with it’s own object model and set of APIs to extend the data system in any direction that is unique to your business.

The SQL Server 2005 data platform provides organizations of all sizes with the following benefits:

Leverage data assets: In addition to delivering a secure, reliable database for line-of-business and analytical applications, SQL Server 2005 enables customers to get more value from their data by including embedded functionality such as reporting, analysis, and data mining.

Increase productivity: Through comprehensive business intelligence capabilities and integration with familiar tools such as the Microsoft Office System, SQL Server 2005 provides information workers across your organization with critical, timely business information that is tailored to their specific needs. The goal is to extend BI to all users within an organization and ultimately to allow users at all levels of the organization to make better business decisions based on one of their most valuable assets—their data.

Reduce Information Technology complexity: SQL Server 2005 simplifies the development, deployment, and management of line-of-business and analytical applications by providing a flexible development environment for developers and integrated, automated management tools for database administrators.

Lower total cost of ownership (TCO): The integrated approach and focus on ease-of-use and deployment provides the industry’s lowest upfront, implementation, and maintenance costs for rapid return on your database investment.

What’s New in SQL Server 2005
Enterprise Data Management


In today’s connected world, data and the systems that manage that data must always be secure yet available to your users. With SQL Server 2005, users and Information Technology professionals across your organization will benefit from reduced application downtime, increased scalability and performance, and tight yet flexible security controls. SQL Server 2005 also includes many new and improved capabilities to help make your Information Technology staff more productive. SQL Server 2005 includes key enhancements to enterprise data management in the following areas:

Manageability

Availability

Scalability

Security

Manageability

SQL Server 2005 makes it simpler and easier to deploy, manage, and optimize enterprise data and analytical applications. As an enterprise data management platform, it provides a single management console that enables data administrators anywhere in your organization to monitor, manage, and tune all of the databases and associated services across your enterprise. It provides an extensible management infrastructure that can be easily programmed using SQL Management Objects (SMO), enabling users to customize and extend their management environment and Independent Software Vendors (ISVs) to build additional tools and functionality to further extend the capabilities that come out of the box.
SQL Server Management Studio


SQL Server 2005 simplifies management by providing one integrated management console to monitor and manage the SQL Server relational database, as well as Integration Services, Analysis Services, Reporting Services, Notification Services, and SQL Mobile across large numbers of distributed servers and databases. Database administrators can perform several tasks at the same time including: authoring and executing a query, viewing server objects, managing an object, monitoring system activity, and viewing online help. SQL Server Management Studio hosts a development environment for authoring, editing and managing scripts and stored procedures using Transact-SQL, Multidimensional Expressions (MDX), XMLA, and SQL Server Mobile Edition. Management Studio is readily integrated with source control. Management Studio also hosts tools for scheduling SQL Server Agent jobs and managing maintenance plans to automate daily maintenance and operation tasks. The integration of management and authoring in a single tool coupled with the ability to manage all types of servers provides enhanced productivity for database administrators.

“We have thousands of stored procedures, and with SQL Server 2000 I used to have to use a separate tool to check out code, and then open the query analyzer to edit the code. With SQL Server 2005 all of this is integrated with Management Studio. I’m able to accomplish routine tasks 20 percent faster using Management Studio.”
--Joyce Behrendt, Senior Development Manager, Information Technology Corporate Strategy Planning and Analysis, Microsoft
Proactive Performance Monitoring and Performance Tuning


SQL Server 2005 exposes more than 70 new measures of internal database performance and resource usage from memory, locking, and scheduling to transactions and network and disk I/O. These Dynamic Management Views (DMVs) provide greater transparency and visibility into the database and a powerful infrastructure for proactive monitoring of database health and performance.
SQL Management Objects


SQL Management Objects (SMO) is a new set of programming objects that exposes all of the management functionality of the SQL Server database. In fact, Management Studio was built with SQL Management Objects. SMO is implemented as a Microsoft .NET Framework assembly. You can use SMO to automate common SQL Server administrative tasks, such as programmatically retrieving configuration settings, creating new databases, applying Transact-SQL scripts, creating SQL Server Agent jobs, and scheduling backups. The SMO object model is a more secure, reliable, and scalable replacement for Distributed Management Objects (DMO), which was included with earlier versions of SQL Server.
Availability


Investments in high availability technologies, additional backup and restore capabilities, and replication enhancements will enable enterprises to build and deploy highly available applications. Innovative high availability features such as; database mirroring, failover clustering, database snapshots, and enhanced online operations will minimize downtime and help to ensure that critical enterprise systems remain accessible. We will review these enhancements in greater detail in this section.
Database Mirroring


Database mirroring allows continuous streaming of the transaction log from a source server to a single destination server. In the event of a failure of the primary system, applications can immediately reconnect to the database on the secondary server. The secondary instance detects failure of the primary server within seconds and accepts database connections immediately. Database mirroring works on standard server hardware and requires no special storage or controllers. Figure 2 shows the basic configuration of database mirroring.

=*---------------------------------------------------------------------------------*=

( صور )





=*---------------------------------------------------------------------------------*=

يتبع ...
 

Black General

مُراقب عام أقسام الفحص والإنمي
rankrankrankrankrankrank
طاقم الإدارة
إنضم
15 مارس 2013
المشاركات
3,636
الإعجابات
4,204
النقاط
113
الإقامة
JO
( Microsoft SQL Server 2008 )



( Information )

MS SQL Server 2008 Overview

MS SQL Server is Microsoft’s product for delivering database functionality. It is used for storing and retrieving information from different applications. It is considered a relational database server and uses T-SQL and ANSI SQL for querying languages. In this article we will focus on the 2008 edition. This is available in 6 different editions as follows:

– Express – intended to be used as a stand-alone solution for lightweight applications; it supports just 1GB of memory, one CPU, and a maximum database size of 4GB (extended to 10 GB in SQL Server 2008 R2)

– Workgroup – intended for small applications; it supports 2 CPUs and 4GB of memory

– Standard – intended for the general purchasing audience and most applications; it has all the main functionalities and supports 4 CPUs and unlimited memory

– Enterprise – exceeds the features provided by the Standard edition by offering Database mirroring and snapshots, online indexing, online page restores, and distributed partitioned views, along with some advanced features for business intelligence (BI); (limited to support only 8 CPUs in SQL Server 2008 R2)

– Web – intended for large web applications, supports 4 CPUs and unlimited memory

– Developer – Essentially the same product as the Enterprise edition, but it’s free and is licensed to be used in a test environment only, never in production

– Compact – intended for embedded environments; it’s free

As you can see the main differences between the versions are the supported resources. Let’s take a look at the features that SQL 2008 offers:

– SQL Server Integration Services (SSIS) – offers the ability to extract/transform/load (ETL) data. In essence, it allows data movement by performing data manipulation and transformation of the data and delivering it to one or more data destinations.

– SQL Server Reporting Services (SSRS) – is responsible for creating custom reports which summarize the information in an easy-to-understand format for the business users. The reports can be created in two ways. The first is with Report Designer which gives you unlimited options but requires technical knowledge of the structure of your data and how to use Visual Studio. The second option is to use Report Builder which is much simpler, and is targeted mostly at business users, not to the actual developers.

– SQL Server Analytical Services (SSAS) – is used for Online Analytical Processing (OLAP) analysis. It analyzes the data in advance, which does consume some additional space and computing power, however this significantly reduces the response time for future queries.

– Business Intelligence (BI) – uses all the features mentioned above to help make intelligent decisions using the existing data. It organizes the raw data in such a way that it can make sense to the decision makers. It can show the management why a lower, or a bigger rating, of the company is reached and what the rating will look like in the foreseeable future.

– Support of unstructured data – this is a critical functionality in today’s businesses where data comes in many forms, not only tables. There are pictures, videos, and documents, all needing to be categorized. They are all now supported through the FILESTREAM data.

– Full-text search – can be used by developers for performing full-text search queries against character based data stored in an SQL table.

– PowerPivot for Office 2010 (introduced with SQL Server 2008 R2) – allows you to interact with SQL directly from Excel

All these amazing features come at a price. The three scenarios for licensing SQL Server are as follows (cited from Microsoft):

– Server plus device client access license (CAL). Requires a license for the computer running the Microsoft server product, as well as CALs for each client device.

– Server plus user client access license (CAL). Requires a license for the computer running the Microsoft server product, as well as CALs for each user.

– Processor license. Requires a single license for each CPU in the operating system environment running SQL Server. This license includes unlimited client device access.

Stay tuned to Monitis for more articles on MS SQL Server.

=*---------------------------------------------------------------------------------*=

( صور )











=*---------------------------------------------------------------------------------*=

يتبع ...
 

Black General

مُراقب عام أقسام الفحص والإنمي
rankrankrankrankrankrank
طاقم الإدارة
إنضم
15 مارس 2013
المشاركات
3,636
الإعجابات
4,204
النقاط
113
الإقامة
JO
( Microsoft SQL Server 2012 )



( Information )

In this chapter from Microsoft SQL Server 2012 Step by Step, you will examine the components and features of Microsoft SQL Server 2012 and determine how they fit into your installation.

After completing this chapter, you will be able to

Explain SQL Server components and features and their uses.
Identify SQL Server features vital to your environment.
Define and scope your SQL Server installation topology from a high level.

The process of learning a new technology can be daunting and sometimes involves a tremendous amount of time and effort. Each step of the process, from installing and configuring the software to deploying the first project, introduces new challenges. These challenges often grow when the technology includes several components and features, so the first step, especially with a multicomponent technology, is to identify the components your environment requires and gain a good understanding of the functionality of each component. To that end, in this chapter, you will examine the components and features of Microsoft SQL Server 2012 and determine how they fit into your installation.

Like most relational database management systems (RDBMS), SQL Server 2012 includes several components. The product itself, however, is often divided into two distinct categories: business intelligence (BI) and the Database Engine.
Business intelligence

Business intelligence (BI) refers to data transformed into knowledge that can then be used to make more informed business decisions. For example, a company whose primary purpose is to sell bikes could use its data to identify sales trends and the purchasing patterns of its customers. From that analysis, the company could decide to focus sales efforts on a particular area or region, which in turn could lead to better opportunities and offer the company competitive advantages in its industry.

While the BI features of SQL Server 2012 can add highly visible and effective value to business users and data consumers, in this book you’ll focus primarily on the features specific to the Database Engine.

Database Engine

The Database Engine sits at the core of the SQL Server components. The engine operates as a service on a machine, which is often referred to as an instance of SQL Server. You can run multiple instances of SQL Server on a given server. When you connect to SQL Server, the instance is the target of the connection. Once an application is connected, it sends Transact-SQL (T-SQL) statements to the instance. The instance in return sends data back to the client. Within the connection is a security layer that validates access to the data as specified by the database administrators (DBAs). The Database Engine enables you to leverage the full capabilities of all of the other components, such as accessing, storing, and securing the data.

The storage component of the Database Engine determines how the data is stored on disk. When designing your databases, you will specify various aspects that will dictate how your tables, indexes, and, in some cases, views are physically organized on your disk subsystem. You will examine the concepts of tables, indexes, and views in detail in later chapters. In SQL Server 2012, you can physically distribute data across disks by partitioning it, or dividing the data into distinct, independent parts. Partitioning not only improves query performance, but it also simplifies the process of managing and maintaining your data. With the release of SQL Server 2012, Microsoft increased the number of supported partitions to 15,000 per table.

Within the Database Engine itself, the storage engine is the primary component. Surrounding it are several additional components that depend on the engine. These components include the following:

T-SQL programming interface (Microsoft’s implementations of the SQL ANSI standard language)
Security subsystem
Replication
SQL Server Agent
High availability and disaster recovery tools
SQL Server Integration Services
SQL Server Management tools

The following sections provide a brief explanation of each component.

T-SQL programming interface

What is the value in storing data if you cannot access it? SQL Server provides a rich programming language that allows you to write simple and complex queries against the underlying storage structures. Using T-SQL, you can write data manipulation queries that enable you to modify and access the data on demand. You can create objects such as views, stored procedures, triggers, and user-defined functions that act as a means of surfacing that data. Applications written in programming languages such as Visual Basic and C# .NET can send T-SQL queries from applications to the Database Engine. The Database Engine will then resolve the queries and send the results back to the client.

In addition, you can write data definition queries to create and modify objects that act as mechanisms for surfacing the data. T-SQL also allows you to manage server configurations and security seamlessly. T-SQL is a set-based language, meaning that it performs optimally when interacting with data in sets as opposed to manipulating strings or iterating over rows of data. While T-SQL is capable of these cursor-based operations, these types of operations are less efficient than a properly designed set-based approach. If you find you are using T-SQL to perform cursor-based operations, consider leveraging a common language runtime (CLR) language. Using your favorite compiler (Visual Studio, for example), you can extend the functionality of T-SQL.

SQL Server 2012 introduces several new T-SQL programming enhancements, including a simpler form of paging, windowing functions, and error handling. A THROW statement is introduced that provides a way to elegantly handle errors by raising exceptions. You can now create a FileTable that builds on the FileStream technology introduced in SQL Server 2008. Coupling the FileTable with FullTextSearch allows you to run complicated queries against massive amounts of text data (such as the complete text of this book). SQL Server 2012 also introduces several new conversion, string, logical, data, and time functions.

Security subsystem

In most organizations, data is the most valuable asset, and keeping that data secure is a major concern. Any vulnerability in an organization’s security might end up triggering a series of events that could prove catastrophic to the business. This is why SQL Server 2012 consists of a robust security subsystem that allows you to control access via two modes of authentication, SQL and Windows. As an administrator, you are able to configure SQL Server security at multiple levels. Using T-SQL or SQL Server Management Studio, you can control access to a particular instance of SQL Server, to specific databases, to objects within those databases, and even to columns within a particular table.

SQL Server also includes native encryption. For example, if you want to secure employees’ Social Security numbers, using column level encryption, you could encrypt a single column in a table. SQL Server also includes Transparent Data Encryption (TDE), which allows you to encrypt an entire database without affecting how clients and applications access the data. However, if someone were to breach your network security and obtain a copy of a data file or backup file, the only way that person could access the data is with an encryption key that you set and store.

Even with all of these security capabilities, SQL Server provides you with the ability to audit your server and databases proactively. In SQL Server 2012, you can filter audit events before they are written to the audit log. Chapter 26, “Security,” describes how to plan and deploy your SQL Server security strategy. You will learn specific concepts around creating logins and users, and you will examine how to create a security approach and maintain security accounts.

Also in SQL Server 2012, you can create user-defined server roles, which can assist in providing a more secure method of allocating server-level access to server administrators. Microsoft has included the ability to create users within a database without requiring you to create a server login, known as contained databases. In past versions of SQL Server, prior to granting access at the database level, an administrator was required to create a server login. With the advent of SQL Server 2012, a user can be self-contained within a database.

Replication

SQL Server replication has been available in most releases of the product. Over time, replication types were introduced to ensure that users could configure replication architectures that satisfied a wide range of scenarios. Using SQL Server replication technology, you can distribute data locally, to different locations, using File Transfer Protocol (FTP), over the Internet, and to mobile users. Replication can be configured to push data, pull data, and merge data across local area networks (LANs) and wide area networks (WANs).

The simplest form of replication, snapshot replication, periodically takes a snapshot of the data and distributes it to servers that are subscribed to the publication. Snapshot replication is typically used to move data at longer intervals, such as daily or nightly. While this method is effective, it is often insufficient in satisfying the high demands of users for near real-time data. If higher throughput is required, users often leverage transactional replication. Instead of distributing snapshots of data, transactional replication continuously sends data changes as they happen to the subscribers. Transactional replication is typically used in a server-to-server topology where one server is the source of the data and the other server is used as a backup copy or for reporting.

Both replication types are one-way data movements. But what if you need bidirectional movement? For example, assume you have mobile users who work offline. While they are offline, they enter information into a database residing on an instance of SQL Server running on their laptops. What happens when they return to the office and connect to the network? In this scenario, the local instance will synchronize with the company’s primary SQL Server database. Merge replication will move transactions between the publisher and subscriber since the last time synchronization occurred.

SQL Server professionals debate the use of replication as a high availability (HA) or disaster recovery (DR) technology. Could it be used for either? There is a possibility; however, replication moves only schema changes and data. To provide an effective HA or DR topology, every aspect of the instance should be included such as security, maintenance, jobs, and so on. Therefore, using replication in either case could pose potential problems in the event of hardware failure or a disaster.

QL Server Agent

SQL Server Agent runs as a separate service on an instance of SQL Server. Each instance of SQL Server has an accompanying SQL Agent service. The primary use of SQL Server Agent is to execute scheduled tasks, such as rebuilding indexes, backing up databases, loading the data warehouse, and so on. It allows you to schedule the jobs to run at various intervals throughout the day or night.

To ensure that you are notified in the event of a job failure, SQL Server Agent allows you to configure operators and alerts. An operator is simply an individual and an email address. Once you configure an operator, you can send notifications or alerts to that person when a job succeeds, completes, or fails.
High Availability and Disaster Recovery Tools

With growing demands on server availability and uptime, it is vital that your RDBMS include several mechanisms that will ensure the consistency and availability of your data. SQL Server 2012 provides four technologies for high availability:

AlwaysOn Availability Groups In SQL Server 2012, Microsoft introduces AlwaysOn Availability Groups. An Availability Group supports failover for a set of databases and leverages the existing database mirroring technology to maintain secondary replicas of the database on local or remote instances of SQL Server. This technology differs from traditional failover clustering in two ways:

You can configure automatic failover without the use of a Storage Area Network (SAN).

You can configure one or more of the secondary replicas to support read-only operations.

Since a SAN is no longer required, you now have the ability to configure HA and DR using one technology. By leveraging the database mirroring capability to move data over distances using TCP/IP, you can have a copy of the database stored in a data center located in a different geographic area.

Failover clustering SQL Server failover cluster instances provide high availability support at the server level. Prior to building an AlwaysOn SQL Server failover instance, you must create and configure a Windows Server failover cluster.

Database mirroring A predecessor of AlwaysOn, database mirroring provides high availability at the database level. It maintains two copies of the database on instances of SQL Server running on separate servers. Typically, the servers are hosted in separate geographic locations, not only ensuring HA, but also providing DR. If you want to incorporate automatic failover, you must include a third server (witness) that will change which server is the owner of the database. Unlike with AlwaysOn, with database mirroring you cannot directly read the secondary copy of the database. You can, however, create a snapshot of the database for read-only purposes. The snapshot will have a different name, so any clients connecting to it must be aware of the name change. Please note that this feature has been deprecated and replaced by AlwaysOn; therefore, going forward, you should use AlwaysOn instead of database mirroring.

Log shipping This is another technology that provides high availability at the database level, which is ideal for very low-latency networks. The transaction log for a specific database is sent to a secondary server from the primary server and restored. Just as with AlwaysOn and database mirroring, you can configure log shipping in a way that allows the secondary database to be read.

SQL Server Integration Services

SQL Server Integration Services (SSIS) is a platform that allows you to build high-performance extraction, transformation, and loading (ETL) frameworks for data warehouses. So why is it included in here in a list of Database Engine components? In most cases SSIS is used for ETL; however, it offers a number of tasks and transformations that extend its usage well beyond ETL.

For example, if you are new to administering a SQL Server environment, SSIS provides you with the tools needed to perform several administrative tasks, including rebuilding indexes, updating statistics, and backing up databases, which make up the primary list of maintenance items that should be performed on any database. Without SSIS, as a new administrator you could spend a lot of time writing T-SQL just to get these activities running on a regular basis. But this is not the extent of the capabilities of SSIS for administrators. How often are you asked for an export of data to Microsoft Excel or to move data from one server to another? Using SSIS, you can quickly export or import data from various sources, including Excel, text files, Oracle, and DB2.
SQL Server Management Tools

SQL Server 2012 includes two graphical user interfaces that enable you to manage, monitor, maintain, and develop in a SQL Server environment. The first is SQL Server Management Studio (SSMS), which allows you to perform just about any action you can think of against an instance of SQL Server. It is an integrated environment where you can access many instances of SQL Server. It consists of a broad set of tools with a rich set of interfaces and script editors that simplify the process of developing and configuring SQL Server instances.

In addition to SSMS, SQL Server 2012 introduces SQL Server Data Tools (SSDT). SSDT is another integrated environment, but it was designed specifically for database developers. You can explore the database and database objects using the SQL Server Object Explorer. So far, some of the most talked-about features of SSDT are the ability to easily create or edit database objects and data, and run queries directly from the interface. Using the visual Table Designer, you can change table schemas for both database projects and online database instances.

Summary

SQL Server offers a robust set of components and tools to enable you to design an efficient, flexible, and highly available database topology for your organization. Each component either complements or supplements the capabilities and functionality of the others. Throughout the rest of this book, you will discover how the components work independently and together.


=*---------------------------------------------------------------------------------*=

( صور )









=*---------------------------------------------------------------------------------*=

يتبع ...
 
التعديل الأخير:

Black General

مُراقب عام أقسام الفحص والإنمي
rankrankrankrankrankrank
طاقم الإدارة
إنضم
15 مارس 2013
المشاركات
3,636
الإعجابات
4,204
النقاط
113
الإقامة
JO
( Microsoft SQL Server 2014 )



( Information )

Integration with Microsoft's Azure and new business intelligence and Big Data tools are among the most striking features of SQL Server 2014, finds reviewer Paul Ferrill.

Microsoft releases new versions of its main products on a relatively predictable schedule. SQL Server releases or major updates have appeared at roughly two-year intervals going back to SQL Server 2008. A bit of a naming anomaly occurred with SQL Server 2008 R2, but that name coincided with Windows Server 2008 R2 which was released around the same time.

For most enterprise organizations upgrades of existing production applications and the underlying database application is typically driven by cost. Unless there's a compelling reason such as discontinued support or a significant increase in performance, the impetus to upgrade just isn't there.

That brings us to Microsoft's current release, SQL Server 2014. This release of SQL Server includes the technology known as Hekaton, which was developed by Microsoft Research. Hekaton is essentially an in-memory database optimized for online transaction processing (OLTP). Specifically, it implements memory-optimized tables and natively compiled stored procedures to increase the overall performance of the database. Determining the merits of these new capabilities and the benefits they might bring to an enterprise application will be a task worth the effort to undertake.
SQL Server Performance Improvements

Making things go faster seems to be an important part of every new product release, whether it is an operating system or a database server. SQL Server 2014 addresses performance on a number of different fronts. In addition to the in-memory work already mentioned, a number of areas demonstrate improvement for both performance and high availability.

Clustering is Microsoft's primary mechanism for providing highly available resources from Hyper-V virtual machines to storage using Cluster Shared Volumes (CSV). Windows Server 2012 introduced CSV based on the SMB 3.0 protocol, bringing a significant boost in performance and resiliency to file-based storage. Prior to SQL Server 2014, you had to use an iSCSI LUN for each SQL instance in order to connect to a clustered storage device. Another previous cluster limitation was due to drive letter limitations, meaning you were restricted to a maximum of 24 instances per cluster. This limitation is also lifted when deploying SQL Server 2014 using CSV, as the number of cluster mount points is unlimited.

One of the most common things you do with a database is a query. Cardinality Estimation is an algorithm used to optimize queries against large OLTP or data warehousing workloads. SQL Server 2014 includes a re-designed and tunable algorithm to help improve query performance using this approach. Other query improvements include the ability to use clustered columnstore indices for both resilience and performance purposes.
Cloud Integration via Azure

Microsoft Azure provides a SQL Server offering which makes it possible to create a hybrid on/off-premises database solution. SQL Server 2014 contains new wizards in SQL Server Management Studio, including Deploy Database to a Windows Azure VM and Deploy Database to Windows Azure SQL, to make the integration part easier

Speaking of SQL Server Management Studio (see Figure 1), it includes other new features and improvements to make the database administrator more productive including an integrated script editor with a new interface for viewing XML results and integrated source control for solution and script projects.

While backing up a database might not be the most glamorous feature, it is an important one. SQL Server 2014 provides a number of new enhancements tied to the Azure cloud to make protecting your data even easier. SQL Server 2014 now supports the native use of an Azure Blob storage service as a target for backup job. You can also use a URL from within SQL Server Management Studio whereas previously you had to use a command line utility.

Another new feature in the 2014 release is the ability to encrypt a backup using industry-standard algorithms such as AES 128, AES 192, AES256 and Triple DES.

Extending Business Intelligence Capabilities

Cloud integration extends to the Office suite in the form of Power BI for Office 365. This new solution extends the existing self-service business intelligence (BI) capabilities currently available in Excel to Office 365. Now users can share their work to the cloud using a secure connection to data located either in Azure or on-premises. This feature also utilizes SharePoint for use as a document repository for reports and graphs created with Power BI for Office 365.
Big Data and Business Intelligence Tools

Dealing with Big Data is a prescient issue on the minds of IT administrators and C-level executives alike. Making use of the data locked inside corporate enterprise resource planning (ERP) applications and, ultimately, the databases storing the information can provide strategic advantages to a wide range of industries. Microsoft looks to provide new capabilities for both the storage and the processing of Big Data using the Azure cloud platform and SQL Server 2014.

Microsoft has made significant strides in providing tools to unlock the data hidden in SQL databases and continues to deliver new features related to business intelligence. SQL Server 2014 includes features to interoperate with Big Data sources such as Microsoft's HDInsight, a Hadoop-based distributed processing implementation running on Microsoft Azure.

SQL Server Management Studio for Business Intelligence provides the interface for developing scripts using Multidimensional Expressions (MDX), Data Mining Extensions (DMX), and XML for Analysis (XMLA). Individual scripts can be combined to build an analysis solution to ultimately produce results in the forms of graphical charts or reports. Results can also be processed using the new Power BI for Office 365.

The SQL Server Data Tools (SSDT) work from within Microsoft's Visual Studio integrated development environment (IDE) to support database development projects. Versions of Visual Studio prior to the 2013 release required an external installer, while the latest release has them built in. You may, however, need to run an update (see Figure 2) to get the most up-to-date version.
Final Analysis of SQL Server 2014

Deciding on an upgrade is not an easy decision and depends greatly on each situation. Benefits such as the cloud integration do not exist in previous versions, so any project with an eye on the cloud will have to use SQL Server 2014 to take full advantage of these features.

Most organizations will use pilot projects running in parallel with existing implementations to measure performance gains. Running multiple instances of SQL Server at different version levels is not the most optimum configuration from an administrative and management perspective, but it can be done. The final answer for most organizations will undoubtedly be "it depends."

The best way to learn is to download a trial version and check it out.

Paul Ferrill has been writing in the IT trade press for over 25 years. He's written hundreds of articles for publications like Datamation, Federal Computer Week, InfoWorld, Network Computing, Network World and PC Magazine and is the author of two books. He is a regular contributor to ServerWatch.com and several other QuinStreet Enterprise properties.


=*---------------------------------------------------------------------------------*=

( صور )











=*---------------------------------------------------------------------------------*=

يتبع ...
 
التعديل الأخير:

Black General

مُراقب عام أقسام الفحص والإنمي
rankrankrankrankrankrank
طاقم الإدارة
إنضم
15 مارس 2013
المشاركات
3,636
الإعجابات
4,204
النقاط
113
الإقامة
JO
( Microsoft SQL Server 2016 )



( Information )

SQL Server 2016 became publically available on the 1st of June 2016. Some might feel that a new SQL Server release every 2 years might be too frequent with many organization still lagging behind by running SQL Server 2012 or earlier.

So what is the fuss all about? Microsoft proudly mentions the following 5 topics as the pinnacle of SQL Server 2016’s offerings.

OLTP with increased performance, scalability and high availability

Enhanced data security with Always Encrypted

Mobile Business intelligence

Advanced analytics with R Services

Consistency between your database servers and your database as a service (Azure)

So what’s new? In this article I will do a quick summary of the new or improved features which will certainly open up a whole new world of excitement for the data professional.
Faster results

No one likes to wait for query results. We want it to be instantaneous. SQL Server 2016 gets closer than ever to delivering this with significant enhancements to In-memory OLTP, in-memory analytics and improvements to Analysis services.

In-memory OLTP

Memory optimized tables can now have foreign keys, check and unique constraints, triggers (WITH NATIVE_COMPILATION), large object type columns and can use any collation. Statistics for memory-optimized tables are now also auto updated.

A couple of enhancements were also made to indexes from memory-optimized tables which now allows Unique indexes, columns using any collation and Nullable index key columns.

In-memory analytics

Column store indexes can be added to memory-optimized OLTP tables which allows real time analytics to be performed on your OLTP database without the risk of resource contention between your OLTP workload and your analytics workload. In order to minimize the overhead caused by maintaining clustered column store indexes, filtered column store indexes can be used.

Analysis Services

Analysis Services continues to offer 2 modes of data storage both of which have been optimized for performance in 2016.

Multi-dimensional mode

The multi-dimensional engine has been improved to return data faster, these enhancements do not need any configuration in order to be taken advantage of but will only really be evident if you compare the baseline of your current server to that of SQL Server Analysis Services 2016.

Tabular mode

Tabular mode which is based on the same technology as column store indexes has been improved by enhancements to DAX, storage engine caching and T-SQL generation of DirectQuery mode.
Database engine enhancements

TempDB

TempDB has been improved with performance in mind. You no longer have to determine how many TempDB files you have to add for yourself. Instead SQL server 2016 decides on a default to use by taking into account the number of logical processors on the server. This circumvents the latch contention issue caused by having only 1 TempDB file, (as was the default in previous versions). This is of course still configurable, but now you can do this during your SQL Server install.

Trace flags for improved performance

Trace flags 1117 and 1118 which had to be enabled specifically in the past, has now been included in the database engine and has such no longer need to be activated manually.

The Query Store

The Query Store is a completely new feature which will help DBA’s to troubleshoot performance issues resulting from changes in the query plan. Historical data is captured to allow for comparisons to be made between queries, plans and statistics. They Query Store is not enabled by default, so in order to use it you can enable it with this command:

ALTER DATABASE AdventureWorks SET QUERY_STORE = ON;

Once enabled the following 4 dashboards are immediately available:

Regressed Queries

Overall Resource Consumption

Top Resource Consuming Queries

Tracked Queries

All of which will allow you to see the data captured in the Query Store.

Stretch Database

The purpose of the new Stretch Database feature is to essentially split hot, warm and cold data and seamlessly move the warm data to Azure, thereby improving the performance of your hot data, reduces your on-site hardware requirements while at the same time allowing you to keep all of your data indefinitely.

Data access still occurs through your on-site database, and no changes to applications are required and the security model of the tables involved remains the same.

Stretch Database supports Transparent Data Encryption which can be enabled to address any concerns about the security of the data in the remote data center as well as data in transit between the local and the remote data centers.
Increased security

There are 3 new security features introduces in SQL Server 2016.

Always Encrypted

With Always Encrypted, the data is, well… always encrypted. The encryption takes place on the client side when it is written, and requires a special driver and an encryption key in order to be able to read the encrypted data.

Row Level Security

Row level security allows you to restrict the rows that a user is able to see, allowing them only to see rows which are relevant to their function. Row level security is implemented by creating inline table functions. This allows a lot of flexibility in terms of what criteria could be used to determine a user’s access but could also have a performance impact if not handled with care.

Dynamic Data Masking

SQL Server 2016 contains 4 new masking functions which can prevent users from viewing sensitive data unless they have been explicitly granted permission to view it. The masking is applied to the query results and as such do not require any changes to existing applications. A DBA running a query in SSMS for instance will also only see the obfuscated data.
Better High Availability

AlwaysOn availability groups

Although not new to SQL Server 2016 there has been some significant improvements to availability groups in this version.

AlwaysOn Basic Availability Groups

This is similar to database mirroring and will be available in the SQL Server 2016 standard. Just like mirroring this is configured on the database level, and only one secondary is allowed which is not readable.

Group Managed Service Accounts

The purpose of this is to facilitate the management of service accounts in large organizations. This has actually been around since SQL 2012, but in SQL Server 2016 gMSAs can be used with availability groups and failover clusters.

Database failure failover

In previous versions a failover of an Availability group was only triggered if the sp_server_diagnostics procedure returned and error, the SQL Server service has stopped or if the instance is not responsive. I did not take into account the state of any database. Enabling the Database Level Health Detection option allows for the availability group to also trigger a failover in case a database becomes inaccessible for whatever reason.

Distributed Transaction Coordinator (DTC) support

DTC is now supported for AlwaysOn Availability groups provided that you are running either Windows 2016 or Windows 2012 R2 with KB3090973 and that your Availability Groups have been created with the WITH DTC_SUPPORT = PER_DB option.

Load balancing for readable secondary replicas

In previous version read traffic always got directed to the first readable replica. In SQL Server 2016 multiple replicas can be specified in the READ_ONLY_ROUTING_LIST and grouped for load balancing using parenthesis. Such as :

READ_ONLY_ROUTING_LIST = (('SVR1','SVR2','SVR3'),'SVR4')

In this instance SVR1, SVR2 and SVR3 will be accessed as a load balanced set and SVR4 will only be accessed if none of the servers in the load balanced set is accessible.

Multiple automatic failover targets

In SQL Server 2016 you can now specify up to 3 automatic failover targets , as long as one of the targets are in sync failover can occur automatically with no data loss.

Improved log transport performance

The log-capture step on the primary server and the redo step on the secondary used to be single threaded in previous versions of SQL. In SQL Server 2016 these two steps are multi-threaded which significantly increases performance.
Seamless Data Integration

SQL Server 2016 introduces some useful features which facilitates access to different types of data, including integration between relational data, unstructured and semi-structured data.

Temporal data

SQL Server 2016 introduces temporal tables for keeping track of the state of data at any specific point in time. Temporal tables actually consists out of 2 tables. The current or temporal table and the historical table which uses page compression for space considerations. As changes occur on the temporal table a copy of the data is stored in the historical table.

JSON

The addition JavaScript Object Notation support in SQL Server 2016 allows you to import and export data to and from JSON format into your relational database. This means that both relational and non-relational data structures can live together in one environment.

PolyBase

SQL Server 2016 improves the 2014 implementation of PolyBase by now allowing you to directly query data in Hadoop or Azure blob storage, and have the computation performed on Hadoop for optimized performance. You can use transact SQL to communicate between the non-relational databases such as Hadoop or Azure blob storage and the relational SQL Server database.
Reporting Services Enhancements

There are 3 key things to mentions when it comes to the enhancements to SQL Server Reporting Services. 2016 has a better development environment with more data visualizations and new report content types. Mobile access to reports are now possible and a new development environment to support those mobile reports.
Deeper Analysis

A vast array of improvements have been made to improve the analytics capabilities of SQL Server 2016.

R

SQL Server 2016 no has R Services which allows statisticians, analysts and scientists to execute R code directly on their SQL Server database. The Enterprise Edition of R Services support high speed computations by using multi processors, multicores and multithreading.

Tabular improvements

Access data using DirectQuery mode

More data sources are now supported for Direct Query. These are:
SQL Server 2008 or later, Azure, Analytics Platoform System, Oracle 9i and higher and Teradata V2R6, V2

All data is no longer required when modeling with a DirectQuery source

You now have the option to choose to model with no data, a subset of data or all data as in previous version.

Calculated Tables

Calculated tables can be built with DAX in models that are not using DirectQuery mode, which will allow you to combine columns from different tables, apply logic to filter the data or apply calculations.

Bi-directional cross-filtering

You are now able to choose the filter direction of your table relationships. Previously filters could only be applied in one direction which required complex DAX queries in order to avoid duplicates. A relationship can now be filtered in two ways, either single like before or both directions with.

Enhancements to DAX

The formula bar has been improved to facilitate the writing of DAX formulas. Many new DAX functions have been added and variables can now be used in DAX expressions.
SQL Server Azure

Initially Azure only offered a subset of the features which are available in a regular SQL Server database engine. Most of the limitations of the initial Azure SQL Database has now been overcome leaving SQL Database close to par with on-premises servers. Size limitations has been increased, additional security has been added and many database features included. All Azure SQL Databases come standard with high availability, and a minimum of 3 replicas exist which can be promoted to primary in the event of a hardware failure.

SQL Database Security

Azure security has been enhanced built to be trustworthy with advanced strategies and policies to ensure that only authorized users are able to access your data. The policies are regularly audited by accredited third-parties.

SQL Database Auditing

Auditing is included in Azure and logs are written to Azure storage. The following events can be audited.

T-SQL whether plain or parametrized

Schema modifications

Data modifications

Stored procedures

Logins

Transaction management

Data Protection

SQL Database has various features implemented to help protect your data, some I’ve already mentioned in the on-site SQL Server 2016 version. These include:

Transparent Data Encryption

TDE takes place on file level. The data in the tables are not encrypted. This prevents unauthorized use of database files and backups, but does not prevent users who have access to the data from viewing it.

Cell Level Encryption

The purpose of CLE is to hide certain sensitive data such as social security numbers by encrypting a column of data.

Always Encrypted

Row level security

Dynamic Data Masking

Elastic databases

The elastic database feature is a cost saving mechanism to prevent over provisioning of resources which is common if resources are estimated on a per database basis. Instead Azure allows you to group databases into an Elastic Database Pool and provision resources for the pool instead of for each database individually. When databases are in a pool they can automatically adjust to utilize the amount of eDTU (Database Transaction Units) as required. Sometimes some databases will use less and sometime some databases will use more. So any surplus can be used by other databases in the pool when they encounter a heavier load.
Azure Data Warehouse

Azure data warehouse is basically the APS (Analytics Platform System) in the cloud. The aim is to provide a massively parallel computing capabilities to everyone. The SQL Data Warehouse is targeted at databases which encompass at least a Terabyte of data. It includes quite a few optimizations to increase the performance of data warehouse queries, such as a distributed query optimizer and clustered column store indexes.
Wrapping it up

This was a quick summary of the new features available in SQL Server 2016 and Azure. Please check out the references below for more in-depth details of each topic.


=*---------------------------------------------------------------------------------*=

( صور )











=*---------------------------------------------------------------------------------*=

يتبع ...
 
التعديل الأخير:

Black General

مُراقب عام أقسام الفحص والإنمي
rankrankrankrankrankrank
طاقم الإدارة
إنضم
15 مارس 2013
المشاركات
3,636
الإعجابات
4,204
النقاط
113
الإقامة
JO
( Microsoft SQL Server 2017 )



( Information )

SQL Server 2017 represents a major step towards making SQL Server a platform that gives you choices of development languages, data types, on-premises or cloud, and operating systems by bringing the power of SQL Server to Linux, Linux-based Docker containers, and Windows. This topic summarizes what is new for specific feature areas and includes links to additional details. For more information related to SQL Server on Linux, see SQL Server on Linux Documentation

SQL Server 2017 Database Engine

SQL Server 2017 includes many new Database Engine features, enhancements, and performance improvements.

CLR assemblies can now be added to a whitelist, as a workaround for the clr strict security feature described in CTP 2.0. sp_add_trusted_assembly, sp_drop_trusted_assembly, and sys.trusted_asssemblies are added to support the white list of trusted assemblies (RC1).
Resumable online index rebuild resumes an online index rebuild operation from where it stopped after a failure (such as a failover to a replica or insufficient disk space), or pauses and later resumes an online index rebuild operation. See ALTER INDEX and Guidelines for online index operations. (CTP 2.0)
The IDENTITY_CACHE option for ALTER DATABASE SCOPED CONFIGURATION allows you to avoid gaps in the values of identity columns if a server restarts unexpectedly or fails over to a secondary server. See ALTER DATABASE SCOPED CONFIGURATION. (CTP 2.0)
A new generation of query processing improvements that will adapt optimization strategies to your application workload’s runtime conditions. For this first version of the adaptive query processing feature family, we have three new improvements: batch mode adaptive joins, batch mode memory grant feedback, and interleaved execution for multi-statement table valued functions. See Adaptive query processing in SQL databases.
Automatic database tuning provides insight into potential query performance problems, recommends solutions, and can automatically fix identified problems. See Automatic tuning. (CTP 2.0)
New graph database capabilities for modeling many-to-many relationships include new CREATE TABLE syntax for creating node and edge tables, and the keyword MATCH for queries. See Graph Processing with SQL Server 2017. (CTP 2.0)
An sp_configure option called clr strict security is enabled by default to enhance the security of CLR assemblies. See CLR strict security. (CTP 2.0)
Setup now allows specifying initial tempdb file size up to 256 GB (262,144 MB) per file, with a warning if the file size is set greater than 1GB with IFI not enabled. (CTP 2.0)
The modified_extent_page_count column in sys.dm_db_file_space_usage tracks differential changes in each database file, enabling smart backup solutions that perform differential backup or full backup based on percentage of changed pages in the database. (CTP 2.0)
SELECT INTO T-SQL syntax now supports loading a table into a FileGroup other than the user's default by using the ON keyword. (CTP 2.0)
Cross database transactions are now supported among all databases that are part of an Always On Availability Group, including databases that are part of same instance. See Transactions - Always On Availability Groups and Database Mirroring (CTP 2.0)
New Availability Groups functionality includes clusterless support, Minimum Replica Commit Availability Groups setting, and Windows-Linux cross-OS migrations and testing. (CTP 1.3)
New dynamic management views:
sys.dm_db_log_stats exposes summary level attributes and information on transaction log files, helpful for monitoring transaction log health. (CTP 2.1)
sys.dm_tran_version_store_space_usage tracks version store usage per database, useful for proactively planning tempdb sizing based on the version store usage per database. (CTP 2.0)
sys.dm_db_log_info exposes VLF information to monitor, alert, and avert potential transaction log issues. (CTP 2.0)
sys.dm_db_stats_histogram is a new dynamic management view for examining statistics. (CTP 1.3)
sys.dm_os_host_info provides operating system information for both Windows and Linux. (CTP 1.0)
The Database Tuning Advisor (DTA) has additional options and improved performance. (CTP 1.2)
In-memory enhancements include support for computed columns in memory-optimized tables, full support for JSON functions in natively compiled modules, and the CROSS APPLY operator in natively compiled modules. (CTP 1.1)
New string functions are CONCAT_WS, TRANSLATE, and TRIM, and WITHIN GROUP is now supported for the STRING_AGG function. (CTP 1.1)
There are new bulk access options (BULK INSERT and OPENROWSET(BULK...) ) for CSV and Azure Blob files. (CTP 1.1)
Memory-optimized object enhancements include sp_spaceused and elimination of the 8 index limitation for memory-optimized tables, sp_rename for memory-optimized tables and natively compiled T-SQL modules, and CASE and TOP (N) WITH TIES for natively compiled T-SQL modules. Memory-optimized filegroup files can now be stored, backed up and restored on Azure Storage. (CTP 1.0)
DATABASE SCOPED CREDENTIAL is a new class of securable, supporting CONTROL, ALTER, REFERENCES, TAKE OWNERSHIP, and VIEW DEFINITION permissions. ADMINISTER DATABASE BULK OPERATIONS is now visible in sys.fn_builtin_permissions. (CTP 1.0)
Database COMPATIBILITY_LEVEL 140 is added. (CTP 1.0).

For more information, see What's new in SQL Server 2017 Database Engine.

SQL Server 2017 Integration Services (SSIS)

The new Scale Out feature in SSIS has the following new and changed features. For more info, see What's New in Integration Services in SQL Server 2017. (RC1)
Scale Out Master now supports high availability.
The failover handling of the execution logs from Scale Out Workers is improved.
The parameter runincluster of the stored procedure [catalog].[create_execution] is renamed to runinscaleout for consistency and readability.
The SSIS Catalog has a new global property to specify the default mode for executing SSIS packages.
In the new Scale Out for SSIS feature, you can now use the Use32BitRuntime parameter when you trigger execution. (CTP 2.1)
SQL Server 2017 Integration Services (SSIS) now supports SQL Server on Linux, and a new package lets you run SSIS packages on Linux from the command line. For more information, see the blog post announcing SSIS support for Linux. (CTP 2.1)
The new Scale Out for SSIS feature makes it much easier to run SSIS on multiple machines. See Integration Services Scale Out. (CTP 1.0)
OData Source and OData Connection Manager now support connecting to the OData feeds of Microsoft Dynamics AX Online and Microsoft Dynamics CRM Online. (CTP 1.0)

For more info, see What's New in Integration Services in SQL Server 2017.

SQL Server 2017 Master Data Services (MDS)

Experience and performance are improved when upgrading from SQL Server 2012, SQL Server 2014, and SQL Server 2016 to SQL Server 2017 Master Data Services.
You can now view the sorted lists of entities, collections and hierarchies in the Explorer page of the Web application.
Performance is improved for staging millions of records using the staging stored procedure.
Performance is improved when expanding the Entities folder on the Manage Groups page to assign model permissions. The Manage Groups page is located in the Security section of the Web application. For more information about the performance improvement, see https://support.microsoft.com/help/4023865?preview. For more information about assigning permissions, see Assign Model Object Permissions (Master Data Services).


SQL Server 2017 Analysis Services (SSAS)

SQL Server Analysis Services 2017 introduces many enhancements for tabular models. These include:

Tabular mode as the default installation option for Analysis Services. (CTP 2.0)
Object-level security to secure the metadata of tabular models. (CTP 2.0)
Date relationships to easily create relationships based on date fields. (CTP 2.0)
New Get Data (Power Query) data sources, and existing DirectQuery data sources support for M queries. (CTP 2.0)
DAX Editor for SSDT. (CTP 2.0)
Encoding hints, an advanced feature for optimizing data refresh of large in-memory tabular models. (CTP 1.3)
Support for the 1400 Compatibility level for tabular models. To create new or upgrade existing tabular model projects to the 1400 compatibility level, download and install SQL Server Data Tools (SSDT) 17.0 RC2. (CTP 1.1)
A modern Get Data experience for tabular models at the 1400 compatibility level. See the Analysis Services Team Blog. (CTP 1.1)
Hide Members property to hide blank members in ragged hierarchies. (CTP 1.1)
New Detail Rows end-user action to Show Details for aggregated information. SELECTCOLUMNS and DETAILROWS functions for creating Detail Rows expressions. (CTP 1.1)
DAX IN operator for specifying multiple values. (CTP 1.1)

For more information, see What's new in SQL Server Analysis Services 2017.

SQL Server 2017 Reporting Services (SSRS)

SQL Server Reporting Services is no longer available to install through SQL Server setup. Go to the Microsoft Download Center to download Microsoft SQL Server 2017 Reporting Services.

Comments are now available for reports, to add perspective and collaborate with others. You can also include attachments with comments.
In the latest releases of Report Builder and SQL Server Data Tools, you can create native DAX queries against supported SQL Server Analysis Services tabular data models by dragging and dropping desired fields in the query designers. See the Reporting Services blog.
To enable development of modern applications and customization, SSRS now supports a fully OpenAPI compliant RESTful API. The full API specification and documentation can now be found on swaggerhub.

For more information, see What's new in SQL Server Reporting Services (SSRS).

Machine Learning in SQL Server 2017

SQL Server R Services has been renamed SQL Server Machine Learning Services, to reflect support for Python in addition to the R language. You can use Machine Learning Services (In-Database) to run R or Python scripts in SQL Server, or install Microsoft Machine Learning Server (Standalone) to deploy and consume R and Python models that don't require SQL Server.

SQL Server developers now have access to the extensive Python ML and AI libraries available in the open-source ecosystem, along with the latest innovations from Microsoft:

revoscalepy - This Python equivalent of RevoScaleR includes parallel algorithms for linear and logistic regressions, decision tree, boosted trees and random forests, as well as a rich set of APIs for data transformation and data movement, remote compute contexts, and data sources.
microsoftml - This state-of-the-art package of machine learning algorithms and transforms with Python bindings includes deep neural networks, fast decision trees and decision forests, and optimized algorithms for linear and logistic regressions. You also get pre-trained models based on ResNet models that you can use for image extraction or sentiment analysis.
Python operationalization with T-SQL - Deploy Python code easily by using the stored procedure sp_execute_external_script. Get great performance by streaming data from SQL to Python processes and using MPI ring parallelization.
Python in SQL Server compute contexts - Data scientists and developers can execute Python code remotely from their development environments to explore data and develop models without moving data around.
Native scoring - The PREDICT function in Transact-SQL can be used to perform scoring in any instance of SQL Server 2017, even if R isn't installed. All that's required is that you train the model using one of the supported RevoScaleR and revoscalepy algorithms and save the model in a new, compact binary format.
Package management - T-SQL now supports the CREATE EXTERNAL LIBRARY statement, to give DBAs greater management over R packages. Use roles to control prviate or shared package access, store R packages in the database and share them among users.
Performance improvements - The stored procedure sp_execute_external_script has been optimized to support batch mode execution for columnstore data.


=*---------------------------------------------------------------------------------*=

( صور )











=*---------------------------------------------------------------------------------*=

يتبع ...
 
التعديل الأخير:

Black General

مُراقب عام أقسام الفحص والإنمي
rankrankrankrankrankrank
طاقم الإدارة
إنضم
15 مارس 2013
المشاركات
3,636
الإعجابات
4,204
النقاط
113
الإقامة
JO
( EMS SQL Management Studio for SQL Server )



( Information )

EMS SQL Management Studio for SQL Server is a complete solution for Microsoft SQL Server database administration and development. With components that focus on all critical MS SQL Server database management tasks, SQL Studio is a single workbench that provides you with must-have tools for administering SQL Server databases, managing database schema and objects as well as for MSSQL Server database design, migration, extraction, SQL Server query building, data import, export and database comparison. SQL Studio unites these database tools for SQL Server in one powerful and easy-to-use environment that can work round the clock. With SQL Management Studio many database administration objectives, such as migration, data loading and synchronization, database backup and extraction can be automated, allowing SQL Server database administrators and SQL Server application developers to perform complex tasks on a regular basis with the minimum number of efforts and a high level of flexibility. Whether you are a database or application developer, DBA or business analyst, SQL Studio for SQL Server offers all essential SQL Server tools to make you more productive than ever before!

SQL Studio Additional Features:
- Handy launch of utilities and services
- Storing all templates in a single repository
- Common data source list for all services and utilities
- Creating complicated tasks and scheduled tasks execution
- Ability to run external applications from scheduler
- Storing all task execution logs in one database
- Creating customized notifications with a variety of delivery options
- Ability to set visual interface style uniquely for all SQL Studio apps
- Fast access to EMS Technical Support Service

System:

- 300 megahertz (MHz) processor; 600 MHz or faster processor recommended
- Microsoft Windows 2000, Microsoft Windows 2000 Server, Microsoft Windows XP, Microsoft Windows Server 2003, Microsoft Windows Server 2008, Microsoft Windows Server 2008 R2, Microsoft Windows Server 2012, Microsoft Windows Server 2012 R2, Microsoft Windows Vista, Microsoft Windows 7, Microsoft Windows 8/8.1
- 64 MB RAM or more; 128 MB or more recommended
- 140MB of available HD space for program installation
- Super VGA (800x600) or higher-resolution video adapter and monitor; Super VGA (1024x768) or higher-resolution recommended
- Microsoft Mouse or compatible pointing device
- Microsoft Data Access Components (MDAC) or SQL Server Native Client
- Possibility to connect to any local or remote SQL Server


=*---------------------------------------------------------------------------------*=

( صور )











=*---------------------------------------------------------------------------------*=

يتبع ...
 
التعديل الأخير:

Black General

مُراقب عام أقسام الفحص والإنمي
rankrankrankrankrankrank
طاقم الإدارة
إنضم
15 مارس 2013
المشاركات
3,636
الإعجابات
4,204
النقاط
113
الإقامة
JO
( Microsoft DeployR for SQL Server Enterprise Edition )



( Information )

Gain real-time insights across your transactional and analytical data with a scalable database platform that has everything Microsoft DeployR is an integration technology for deploying R analytics inside web,desktop,mobile, and dashboard applications as well as backend ystems.DeployR turns your R scripts into analytics web services, so R code can be easily executed by applications running on a secure server.Using analytics web services, DeployR also solves key integration problems faced by those adopting R-based analytics alongside existing IT infrastructure.These services make it easy for application developers to collaborate with data scientists to integrate R analytics into their applications without any R programming knowledge.

DeployR is available in two editions:
DeployR Open and DeployR Enterprise. DeployR Open is a free, open source solution that is ideal for prototyping, building, and deploying non-critical business applications.DeployR Enterprise scales for business-critical applications and offers support for production-grade workloads, as well as seamless integration with popular enterprise security solutions such as single sign-on (SSO), Lightweight Directory Access Protocol (LDAP), Active Directory, or Pluggable Authentication Modules (PAM).



System:

- SQL R Server
- Java Runtime Environment


=*---------------------------------------------------------------------------------*=

( صور )



=*---------------------------------------------------------------------------------*=

يتبع ...
 
التعديل الأخير:

Black General

مُراقب عام أقسام الفحص والإنمي
rankrankrankrankrankrank
طاقم الإدارة
إنضم
15 مارس 2013
المشاركات
3,636
الإعجابات
4,204
النقاط
113
الإقامة
JO
( Microsoft Mouse Pro Sql Server )



( Information )

DbMouse is database-oriented data management console working with Microsoft SQL Server. It offers modern and effective tools for effective work with database. Although it is very simple to use, even for beginners, it offers powerful features for advanced users.
It supports features to create simple application layer.

Here are some key features of "DbMouse":
- View or edit your data. Use easy-to-use quick filters Explore master/detail relations
- Quick search between tables, view, procedures, functions and columns. Generate SQL scripts from database objects
- Design SELECT, UPDATE, DELET and INSERT queries
- Trace SQL server commication and find performance leaks effectively
- Visualise points, polygons, and lines on map. Use Open Street Map, Goole Maps, Bing maps
- Import and export to various formats - CSV, HTML, TXT, MS Excel


=*---------------------------------------------------------------------------------*=

( صور )





=*---------------------------------------------------------------------------------*=

يتبع ...
 
التعديل الأخير:

Black General

مُراقب عام أقسام الفحص والإنمي
rankrankrankrankrankrank
طاقم الإدارة
إنضم
15 مارس 2013
المشاركات
3,636
الإعجابات
4,204
النقاط
113
الإقامة
JO
( MS SQL Maestro )



( Information )

MS SQL Maestro is the premier GUI admin tool for Microsoft SQL Server and MSDE management, control and development.The application also provides you with a powerful set of tools to edit and execute SQL scripts, build visual diagrams for numeric data, compose OLAP cubes, and much more.
Easy installation and intuitive interface in combination with support of all the SQL Server latest features make it an irreplaceable tool for MS SQL Server on the web or at your local desktop.

Here are some key features of "MS SQL Maestro":
- Support for all Microsoft SQL Server versions from 7.0 to 2016
- Support for Microsoft Azure SQL Database 11 and 12
- Easy database object management
- Database Designer
- Comfortable access to SQL server security features
- Data management: editing, grouping, sorting and filtering abilities
- Handy SQL Editor with code folding and multi-threading
- Visual Query Builder with support for subqueries and UNIONS
- Data export/import to/from the most popular formats
- Powerful BLOB Viewer/Editor


=*---------------------------------------------------------------------------------*=

( صور )











=*---------------------------------------------------------------------------------*=

يتبع ...
 
التعديل الأخير:

Black General

مُراقب عام أقسام الفحص والإنمي
rankrankrankrankrankrank
طاقم الإدارة
إنضم
15 مارس 2013
المشاركات
3,636
الإعجابات
4,204
النقاط
113
الإقامة
JO
( SQL Assistant )



( Information )

SQL Assistant easily integrates with many widely used database editors and database management and development environments including native tools that come with your database systems. It provides assistance with code typing, automatic word completion and database object and attributes browsing.
The SoftTree SQL Assistant application can be used with both very small and very large database systems.
It provides functions for quick entry of common SQL constructs and code snippets. It also provides integrated and fully interactive SQL code assistance system for instant help with SQL command syntax and options available in specific database versions, code syntax checker, spell checker and a number of other vital coding tools.


Here are some key features of "SoftTree SQL Assistant":
- Doubles SQL developer productivity
- Improves code quality and accuracy
- Provides advanced SQL code intellisense features, including support for databases, objects, parameters, script variables, syntax elements and much more...
- Provides interactive SQL reference and SQL code assistance systems
- Provides advanced SQL code formatters and beautifiers; SQL syntax validation, code structure views for fast code navigation, and more...
- Provides integrated real-time code syntax and spell checker
- Supports 8 major database systems: Oracle, SQL Server, DB2, MySQL, PostgreSQL, Sybase ASE, Sybase ASA, MS Access, and their SQL dialects
- Integrates with many SQL and non-SQL editors
- Can be easily installed without interrupting any existing processes and used immediately


=*---------------------------------------------------------------------------------*=

( صور )





=*---------------------------------------------------------------------------------*=

يتبع ...
 
التعديل الأخير:

Black General

مُراقب عام أقسام الفحص والإنمي
rankrankrankrankrankrank
طاقم الإدارة
إنضم
15 مارس 2013
المشاركات
3,636
الإعجابات
4,204
النقاط
113
الإقامة
JO
( *** تحميل *** )

تحميل جميع النسخ رابط واحد:

هنا

=*---------------------------------------------------------------------------------*=

( Microsoft SQL Server 6.5 )



3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

=*---------------------------------------------------------------------------------*=

( Microsoft SQL Server 7.0 )



3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

=*---------------------------------------------------------------------------------*=

( Microsoft SQL Server 2000 )



Microsoft SQL Server 2000 Developer (x32)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server 2000 Enterprise (x32)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server 2000 Personal (x32)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server 2000 SP4 (x32)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server 2000 Standard (x32)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server 2000 Workgroup (x32)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

=*---------------------------------------------------------------------------------*=

( Microsoft SQL Server 2005 )



Microsoft SQL Server 2005 (x64)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server 2005 (x32)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server 2005 Enterprise

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

=*---------------------------------------------------------------------------------*=

( Microsoft SQL Server 2008 )



Microsoft SQL Server 2008 Developer SP4 (x32 - x64)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server 2008 Enterprise SP4 (x32 - x64)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server 2008 Standard SP4 (x32 - x64)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

=*---------------------------------------------------------------------------------*=

( *** Key *** )

Microsoft SQL Server 2008 Enterprise

JD8Y6-HQG69-P9H84-XDTPG-34MBB

Microsoft SQL Server 2008 Developer

PTTFM-X467G-P7RH2-3Q6CG-4DMYB

Microsoft SQL Server 2008 Standard

FXHQY-JQF42-68VVV-PYVVR-RY3BB

=*---------------------------------------------------------------------------------*=

( Microsoft SQL Server 2012 )



Microsoft SQL Server 2012 Business Intelligence SP3 (x32)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server 2012 Business Intelligence SP3 (x64)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server 2012 Developer SP3 (x32)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server 2012 Developer SP3 (x64)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server 2012 Enterprise Core SP3 (x32)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server 2012 Enterprise Core SP3 (x64)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server 2012 Enterprise SP3 (x32)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server 2012 Enterprise SP3 (x64)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server 2012 Standard SP3 (x32)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server 2012 Standard SP3 (x64)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server 2012 Web SP3 (x32)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server 2012 Web SP3 (x64)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

=*---------------------------------------------------------------------------------*=

( *** Key *** )

MICROSOFT SQL SERVER 2012 DEVELOPER

YQWTX-G8T4R-QW4XX-BVH62-GP68Y

MICROSOFT SQL SERVER 2012 ENTERPRISE SERVER/CAL EDITION

748RB-X4T6B-MRM7V-RTVFF-CHC8H

MICROSOFT SQL SERVER 2012 STANDARD

YFC4R-BRRWB-TVP9Y-6WJQ9-MCJQ7

MICROSOFT SQL SERVER 2012 WEB

FB3W8-YRXDP-G8F8F-C46KG-Q998F

MICROSOFT SQL SERVER 2012 ENTERPRISE CORE

FH666-Y346V-7XFQ3-V69JM-RHW28

MICROSOFT SQL SERVER 2012 BUSINESS INTELLIGENCE

HRV7T-DVTM4-V6XG8-P36T4-MRYT6

=*---------------------------------------------------------------------------------*=

( Microsoft SQL Server 2014 )



Microsoft SQL Server 2014 Business Intelligence SP2 (x32)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server 2014 Business Intelligence SP2 (x64)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server 2014 Developer SP2 (x32)‏

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server 2014 Developer SP2 (x64)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server 2014 Enterprise Core SP2 (x32)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server 2014 Enterprise Core SP2 (x64)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server 2014 Enterprise SP2 (x32)‏

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server 2014 Enterprise SP2 (x64)‏

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server 2014 Standard SP2 (x32)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server 2014 Standard SP2 (x64)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server 2014 Web SP2 (x32)‏

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server 2014 Web SP2 (x64)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

=*---------------------------------------------------------------------------------*=

( *** Key *** )

Microsoft SQL Server 2014 Enterprise Edition

27HMJ-GH7P9-X2TTB-WPHQC-RG79R

Microsoft SQL Server 2014 Enterprise Core Edition

TJYBJ-8YGH6-QK2JJ-M9DFB-D7M9D

Microsoft SQL Server 2014 Business Intelligence

GJPF4-7PTW4-BB9JH-BVP6M-WFTMJ

Microsoft SQL Server 2014 Standard Edition

P7FRV-Y6X6Y-Y8C6Q-TB4QR-DMTTK

Microsoft SQL Server 2014 Developer Edition

82YJF-9RP6B-YQV9M-VXQFR-YJBGX

Microsoft SQL Server 2014 Web Edition

J9MBB-R8PMP-R8WTW-8JJRD-C6GGW

=*---------------------------------------------------------------------------------*=

( Microsoft SQL Server 2016 )



Microsoft SQL Server Developer 2016 SP2 (x64)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server Enterprise 2016 SP2 (x64)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server Enterprise Core 2016 SP2 (x64)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server Standard 2016 SP2 (x64)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server Web 2016 SP2 (x64)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

=*---------------------------------------------------------------------------------*=

( *** Key *** )

Microsoft SQL Server 2016 Web

BXJTY-X3GNH-WHTHG-8V3XK

Microsoft SQL Server 2016 Standard

B9GQY-GBG4J-282NY-QRG4X

Microsoft SQL Server 2016 Enterprise Core

TBR8B-BXC4Y-298NV-PYTBY

Microsoft SQL Server 2016 Enterprise

MDCJV-3YX8N-WG89M-KV443

Microsoft SQL Server 2016 Developer

22222-00000-00000-00000

=*---------------------------------------------------------------------------------*=

( Microsoft SQL Server 2017 )



Microsoft SQL Server Enterprise 2017 (x64)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server Enterprise Core 2017 (x64)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server Express 2017 (x64)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server Express With Advanced Service 2017 (x64)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server Localdb 2017 (x64)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server Management Studio 2017 (x64)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server Standard 2017 (x64)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

Microsoft SQL Server Web 2017 (x64)

3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

=*---------------------------------------------------------------------------------*=

( *** Key *** )

SQL Server 2017 Web

WV79P-7K6YG-T7QFN-M3WHF-37BXC

SQL Server 2017 Standard

PHDV4-3VJWD-N7JVP-FGPKY-XBV89

SQL Server 2017 Enterprise Core

6GPYM-VHN83-PHDM2-Q9T2R-KBV83

SQL Server 2017 Enterprise

TDKQD-PKV44-PJT4N-TCJG2-3YJ6B

=*---------------------------------------------------------------------------------*=

( EMS SQL Management Studio for SQL Server )



K-Bagi | 3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

=*---------------------------------------------------------------------------------*=

( Microsoft DeployR for SQL Server Enterprise Edition )



K-Bagi | 3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

=*---------------------------------------------------------------------------------*=

( Microsoft Mouse Pro Sql Server )



K-Bagi | 3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

=*---------------------------------------------------------------------------------*=

( MS SQL Maestro )



K-Bagi | 3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

=*---------------------------------------------------------------------------------*=

( SQL Assistant )



K-Bagi | 3rbup | 4bigbox | File-Upload | Racaty | Samaup | Top4Top | UsersCloud

=*---------------------------------------------------------------------------------*=

إهدآء لكل من يسآهم في نجآح هذا الموقع المتميز

في الختآم أشكر الجميع

وأتمنى أن يعجبكم الموضوع , وتستفيدون منه ,
 
التعديل الأخير:

Black General

مُراقب عام أقسام الفحص والإنمي
rankrankrankrankrankrank
طاقم الإدارة
إنضم
15 مارس 2013
المشاركات
3,636
الإعجابات
4,204
النقاط
113
الإقامة
JO
محجوز اضافة محتوى جديد
 

Black General

مُراقب عام أقسام الفحص والإنمي
rankrankrankrankrankrank
طاقم الإدارة
إنضم
15 مارس 2013
المشاركات
3,636
الإعجابات
4,204
النقاط
113
الإقامة
JO
محجوز اضافة رابط جديد
 

White Hat Elite

.:: مُشرف النقطة العامة ::.
rankrankrankrank
إنضم
31 أغسطس 2011
المشاركات
1,248
الإعجابات
1,473
النقاط
133
الإقامة
egypt
وعليكم السﻻم ورحمه الله وبركاته

موضوع فوق الممتاز الصحراحه ومتعوب فيه

اقتراح باضافه تحميل عن طريق تورينت


بارك الله فيك
 
إنضم
16 يناير 2012
المشاركات
292
الإعجابات
176
النقاط
43
السلام عليكم ورحمة الله وبركاته

كل عام انت بخير
يعجز اللسان عن شكرك ومجهودك الجبار وكل ما تقدمه في الديف من إفادة للاّّ خريين


جزاك الله خيرا بارك الله فيك وجعله في ميزان حسناتك اّميين

تحياتي لشخصك الكريم وشكرا على ابداعك اللا متناهي

:42:
 

الأعضاء النشطين حاليآ الذين يشاهدون هذا الموضوع (1 عضو و 1 ضيف)

خيارات الاستايل

نوع الخط
مودك
اخفاء السايدر بار OFF
توسيط المنتدى OFF
فصل الأقسام OFF
الأقسام الفرعية OFF
عرض المشاركات
حجم الخط
معلومات العضو OFF
إخفاء التوقيع OFF

إرجاع خيارات الإستايل