Kategori arşivi: SQL Server

Parallel Data Warehouse Kullanıma Hazır!

Kurumların en kritik veri ambarı ihtiyaçlarını karşılamak üzere tasarlanan SQL Server 2008 R2 Parallel Data Warehouse (PDW); çok geniş kapsamlı paralel işleme (MMP) mimarisi sayesinde düşük maliyetle en üst performansı sunmanın yanı sıra veri ambarınızı onlarca – yüzlerce Terabyte’tan bir Petabyte’a kadar çıkarmanıza olanak veriyor.

link

Parallel Data Warehouse Kullanıma Hazır!

Parallel Data Warehouse Kullanıma Hazır!

Kurumların en kritik veri ambarı ihtiyaçlarını karşılamak üzere tasarlanan

SQL Server 2008 R2 Parallel Data Warehouse (PDW); çok geniş kapsamlı paralel işleme (MMP) mimarisi sayesinde düşük maliyetle en üst performansı sunmanın yanı sıra veri ambarınızı onlarca – yüzlerce Terabyte’tan bir Petabyte’a kadar çıkarmanıza olanak veriyor.

SQL Server Raporlama Hizmetleri (Reporting Services)

SQL Server Raporlama Hizmetleri (Reporting Services)

İş Zekâsı Çözümleri son yıllarda CIO’ların yatırım yapmayı düşündükleri çözüm alanlarının başında geliyor. Bu doğrultuda Microsoft SQL Server 2008 Raporlama Hizmetleri – Reporting Services (SSRS) ile kurumsal raporlama ihtiyaçlarına kolayca yanıt verebilmektedir.

Raporlama Hizmetleri’nin (Reporting Services) getirdiği temel faydaları şu şekilde özetlemek mümkündür:

Raporlama Hizmetleri SQL Server lisansı ile kullanılabilen bir motordur. Bu sayede iş zekâsı çözümünün uygun bir maliyetle elde edilmesine imkân vermektedir. Sunduğu arayüz sayesinde birleşik, tutarlı bir uygulama geliştirme modelinden de faydalanılıyor. Yine Raporlama Hizmetleri sayesinde son kullanıcılar, rapor üretebilmeleri için yetkilendirilebiliyor, böylece yönetim kolaylaştırılıp, kullanım yaygınlaştırılıyor.

SQL Server 2008 R2 Migration Guidance

We’ve collected a set of articles and resources to help you evaluate a move to SQL Server 2008 R2, plan and execute your migration of existing services, and manage the database engine. But lest we get ahead of ourselves, you could still be deciding whether an upgrade to SQL Server 2008 R2 is the right move for your organization. So we’ve also put together a set of articles and resources to help you understand the capabilities of SQL Server 2008 R2, including a free eBook from Microsoft Press.

For a limited time, you can download the 10-chapter eBook Introducing Microsoft SQL Server 2008 R2, by Ross Mistry and Stacia Misner. And be sure to read eWeek‘s review of SQL Server 2008 R2 to learn about the enhancements and new management capabilities.

There are many potential scenarios you may encounter during an upgrade where you’ll want to migrate a SQL Server installation. The TechNet Library article “Migrating to SQL Server 2008 R2” describes the migration process and provides how-to information on migrating specific services.

makalenin devamı için

Microsoft SQL Server 2008 Service Pack 2

Microsoft SQL Server 2008 Service Pack 2 (SP2) is now available for download. These packages may be used to upgrade any edition of SQL Server 2008. We remain committed to providing our customers with essential changes via Service packs. Service Pack 2 contains updates for SQL Server Utility, Data-Tier Application (DAC), as well as integration capability for Microsoft Reporting Services with the Microsoft SharePoint 2010 Technologies. Service Pack 2 introduces support for a maximum of 15,000 partitions in a database, and includes SQL Server 2008 SP1 Cumulative Update 1 to 8.  While keeping product changes contained, we have made significant investments to ease deployment and management of Service Packs. Microsoft SQL Server 2008 Service Pack 1 is not a prerequisite for installing SQL Server 2008 Service Pack 2.

For more information about SQL Server 2008 Service Pack 2, please visit our Release Notes.

What’s New:

  • 15K partitioning Improvement. Introduced support for a maximum of 15,000 partitions in tables and indexes in Microsoft SQL Server 2008 Service Pack 2 in the Enterprise, Developer and Evaluation Editions. For details on how this support can be enabled and disabled, along with recommended operation paramaters, see the white paper Support for 15000 Partitions.
  • Reporting Services in SharePoint Integrated Mode. SQL Server 2008 SP2 provides updates for Reporting Services integration with SharePoint products. SQL Server 2008 SP2 report servers can integrate with SharePoint 2010 products. SQL Server 2008 SP2 also provides a new add-in to support the integration of SQL Server 2008 R2 report servers with SharePoint 2007 products. For more information see the “What’s New in SharePoint Integration and SQL Server 2008 Service Pack 2 (SP2)” section in What’s New (Reporting Services).
  • SQL Server 2008 R2 Application and Multi-Server Management Compatibility with SQL Server 2008.
    • SQL Server 2008 Instance Management.With SP2 applied, an instance of the SQL Server 2008 Database Engine can be enrolled with a SQL Server 2008 R2 Utility Control Point as a managed instance of SQL Server. For more information, see Overview of SQL Server Utility in SQL Server 2008 R2 Books Online.
    • Data-tier Application (DAC) Support.Instances of the SQL Server 2008 Database Engine support all DAC operations delivered in SQL Server 2008 R2 after SP2 has been applied. You can deploy, upgrade, register, extract, and delete DACs. SP2 does not upgrade the SQL Server 2008 client tools to support DACs. You must use the SQL Server 2008 R2 client tools, such as SQL Server Management Studio, to perform DAC operations. A data-tier application is an entity that contains all of the database objects and instance objects used by an application. A DAC provides a single unit for authoring, deploying, and managing the data-tier objects. For more information, see Designing and Implementing Data-tier Applications.

https://www.microsoft.com/downloads/en/details.aspx?FamilyID=8fbfc1de-d25e-4790-88b5-7dda1f1d4e17&displaylang=en

Memory Supported by the Editions of SQL Server

The following table specifies the maximum memory support for each edition of SQL Server 2008 R2.

SQL Server editionMaximum memory supported
DatacenterOperating system maximum
Enterprise2 TB
DeveloperOperating system maximum
Standard64 GB
Web64 GB
Workgroup4 GB (64-bit), OS maximum (32-bit)
Express1 GB
Express with Tools1 GB
Express with Advanced Services1 GB

4 GB for Reporting Services

Microsoft SQL Server 2008 R2 Best Practices Analyzer

Brief Description
This is the download page for the SQL Server 2008 R2 Best Practices Analyzer. It works with SQL Server 2008 and SQL Server 2008 R2.
Overview
The Microsoft SQL Server 2008 R2 BPA is a diagnostic tool that performs the following functions:
•    Gathers information about a Server and a Microsoft SQL Server 2008 or 2008 R2 instance installed on that Server
•    Determines if the configurations are set according to the recommended best practices
•    Reports on all configurations, indicating settings that differ from recommendations
•    Indicates potential problems in the installed instance of SQL Server
•    Recommends solutions to potential problems
https://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=0fd439d7-4bff-4df7-a52f-9a1be8725591

Understanding roles in SQL Server security

Predefined database roles
You may need to create your own, but you have access to several predefined database roles:

  • db_owner: Members have full access.
  • db_accessadmin: Members can manage Windows groups and SQL Server logins.
  • db_datareader: Members can read all data.
  • db_datawriter: Members can add, delete, or modify data in the tables.
  • db_ddladmin: Members can run dynamic-link library (DLL) statements.
  • db_securityadmin: Members can modify role membership and manage permissions.
  • db_bckupoperator: Members can back up the database.
  • db_denydatareader: Members can’t view data within the database.
  • db_denydatawriter: Members can’t change or delete data in tables or views.

Fixed roles
The fixed server roles are applied serverwide, and there are several predefined server roles:

  • SysAdmin: Any member can perform any action on the server.
  • ServerAdmin: Any member can set configuration options on the server.
  • SetupAdmin: Any member can manage linked servers and SQL Server startup options and tasks.
  • Security Admin: Any member can manage server security.
  • ProcessAdmin: Any member can kill processes running on SQL Server.
  • DbCreator: Any member can create, alter, drop, and restore databases.
  • DiskAdmin: Any member can manage SQL Server disk files.
  • BulkAdmin: Any member can run the bulk insert command.