Resources For IT Professionals
Get this Tag RSS feed
Popular Tags

Browse by Tags

 >  TechNet Articles  >  All Tags  >  SQL Server 2008 R2
Tagged Content List

  • Wiki Page: SharePoint - Best Practices de performance : Limiter l'allocation mémoire de SQL Server (fr-FR)

    J'ai vu p lusieurs fois des développeurs se plaindre des performances de leur environnement de développement SharePoint. Comme ils ont une installation "standalone" de SharePoint sur leur machine virtuelle de développement, ils se plaignent toujours que leur machine est trop lente....
    on21 Sep 2013

  • Wiki Page: SharePoint Performance Best Practices: Limit SQL Server Memory Allocation

    Many times I have seen developers complaining about their SharePoint development environment performance. Since they have SharePoint standalone installation on their development Virtual Machine they always complain their machine is too slow. This is not only the case with development environment...
    on21 Sep 2013

  • Wiki Page: SharePoint 2010: Ten Points to Pay Attention to for a Good Infrastructure

    SharePoint 2010: Ten points to have a great infrastructure #1 Limit your SQL When you install SharePoint 2010 on a complete mode with a SQL SERVER 2008R2, there is an option on the properties of the server, that you can limit the RAM usage. If you don’t limit the usage, it will use 2.1 petabytes...
    on18 Sep 2013

  • Wiki Page: SharePoint 2010: SharePoint Server 2010 için SQL Server kurulum - bölüm 2 (tr-TR)

    Merhabalar BTGonulluleri, size bu makalede, SharePoint Server senaryoları ile SharePoint Server için SQL Server nasıl kurulur ondan bahis edeceğim. SharePoint Server 2.Bölum Parti 1 -, Senaryolar: Senaryo 1: Bu senaryo ’da SharePoint Server ve SharePoint server’in lazım olan bütün sunucuları...
    on18 Sep 2013

  • Wiki Page: SharePoint 2010: SQL Script to Backup Project Server Databases

    Backing up a Project Server database can be easier by using a procedure that includes all the database that you want to include. I drop that backup files on a share drive that is isolated from the server. Be sure the Share has write permissions for the SQL Process: USE MASTER BACKUP...
    on18 Sep 2013

  • Wiki Page: SharePoint 2010: Configure SQL Management Studio Express to Talk to Default Sharepoint Instance

    Download Download and install Microsoft SQL Server Management Studio Express Download and install Microsoft SQL Server 2005 Express Edition Toolkit Configure Configure the built-in SQL instance for remote management by SQL Server Management Studio Express Open the "SQL server...
    on18 Sep 2013

  • Wiki Page: Multiple Versions of MySQL 2005 and MySQL 2008 Redistributable on Windows 7 Ultimate Machines in a Domain Environment

    The Corporate Sales and Marketing team was trying out some Microsoft Visual Studio's trialware. Troubleshooting MySQL 2005 and MySQL 2008 redistributable in a Domain environment. The Graphics Design Team and Market Team, somehow got involved to ensure that everything met Market and Sales...
    on17 Sep 2013

  • Wiki Page: How to Create Query Shortcuts in SQL Server Management Studio

    You can create shortcuts for frequently used queries in Management Studio, some of the shortcuts are predefined, like pressing "Ctrl + 1" will execute "sp_who". You can create shortcuts for your own queries or change the existing shortcuts. To create a new shortcut, go...
    on17 Sep 2013

  • Wiki Page: Troubleshooting: SharePoint Configuration Wizard Error Trying to Connect to SQL Server

    Table of Contents Introduction Resolution Introduction We are installing a new Sharepoint environment , we need to execute Sharepoint Products Configuration Wizard. When open Specify Configuration Database Setting When we click on next we received this error: Cannot connect...
    on17 Sep 2013

  • Wiki Page: SSIS: Flat File Source - Datetime Column Format Issue & Solution

    Table of Contents 1.0 Introduction 2.0 Problem Definition 3.0 How does it work 4.0 Solution 1.0 Introduction Flat files as Source are widely used in SQL Server Integration Services Tool. This article will discuss about one common issue with Flat File Date time Columns. (Details can be found...
    on12 Sep 2013

  • Wiki Page: Duplicate1:Querying SQL Server Metadata Information

    Returning metadata information about SQL Server objects is a common task. For example, you may want to list all of the tables in a database, or find the stored procedures that reference a certain table or column. This kind of information is available through catalog views and functions, but it can...
    on5 Sep 2013

  • Wiki Page: Duplicate:Querying SQL Server Metadata Information

    Returning metadata information about SQL Server objects is a common task. For example, you may want to list all of the tables in a database, or find the stored procedures that reference a certain table or column. This kind of information is available through catalog views and functions, but it can...
    on5 Sep 2013

  • Wiki Page: The Ghost in theTransactional Replication Topology

    In the course of administering a transactional replication architecture a number of error conditions can occur. Some of these errors are related to synchronization and can be remedied via the issuance of a reinitialization command or stopping and starting the replication agents. Others are not so straightforward...
    on4 Sep 2013

  • Wiki Page: گام به گام مهاجرت DHCP Server از ویندوز سرور 2003 به ویندوز سرور 2008 (fa-IR)

    مقاله زیر در پاسخ به سوالاتی که در زمینه مهاجرت سرویس DHCP از ویندوز 2003 به ویندوز 2008 خواهد بود . ما قصد داریم به صورت گام به گام عملیات انتقال و مهاجرت سرویس DHCP از ویندوز سرور 2003 به 2008 را برای شما مرور نماییم اطلاعات اولیه : ما از یک سرور ویندوز 2003 نسخه R2 استفاده می کنیم ...
    on2 Sep 2013

  • Wiki Page: Database Engine Fixed Server and Fixed Database Roles

    Fixed server roles and fixed database roles are assigned specific permissions by SQL Server. The permissions of the fixed roles cannot be changed. Fixed server and fixed database roles are provided for convenience and backward compatibility. Beginning with SQL Server 2005, a more granular permission...
    on1 Sep 2013

  • Wiki Page: [VIDEO] Inteligencia de Negocios con PowerView (es-ES)

    Este es un video generado por Eduardo Castro MVP en Sql Server. Se presenta las principales herramientas de inteligencias de negocios que Microsoft provee, así como las capacidades de autoservicio de inteligencias de negocio por medio de PowerView y Power Pivot. Puedes consultar más recursos...
    on24 Aug 2013

  • Wiki Page: [VIDEO] Introducción a Seguridad en SQL Server 2008 R2 (es-ES)

    Este es un video generado por Eduardo Castro MVP en Sql Server. Se presentan las principales funcionalidades de Seguridad que provee Sql Server 2008 R2 y sus principales mejoras desde la versión 2005. Agenda Introducción Sql Server 2005 Security Recap Security in Sql Server 2008 R2 Demo Compliance...
    on24 Aug 2013

  • Wiki Page: Data Source View

    Overview In SQL Server Analysis Services (SSAS), a data source view is a diagram of one or more relational data sources for the SSAS database. Developers use components from the data source view to construct the SSAS database's objects (e.g. dimensions and measure groups ). SSAS uses the data...
    on30 Jul 2013

  • Wiki Page: Troubleshooting PowerPivot Data Refresh

    Applies to: SQL Server 2008 R2 and SQL Server 2012 This article consists of troubleshooting tips and techniques for working through PowerPivot data refresh problems in SharePoint. Table of Contents Where to get information about data refresh failures What to check for first Data Refresh Errors...
    on30 Jul 2013

  • Wiki Page: Accessing SQL Server Databases from PHP

    The Microsoft Drivers for PHP for SQL Server are Microsoft-supported extensions of PHP 5 that provide data access to all editions of SQL Server, beginning with SQL Server 2005. The Microsoft Drivers for PHP for SQL Server include two PHP extensions for accessing data in SQL Server: a procedural interface...
    on9 Jul 2013

  • Wiki Page: Reporting Services Samples on CodePlex (SQL Server Reporting Services SSRS)

    Table of Contents Troubleshooting AdventureWorks sample reports Embedded Reporting The CodePlex home page for all SQL Server Reporting Services (SSRS) samples is SQL Server Reporting Services Product Samples . All of the samples are in one download package. If you are interested only in the...
    on28 May 2013

  • Wiki Page: Rules Of Thumb for SQL Server Sizing for Microsoft Dynamics CRM 2011

    SQL Server sizing is critical for good CRM Performance. Maybe you are standing up a new environment and wanting to ensure that your SQL environment will handle your estimated load of data and users, or maybe you have an existing CRM deployment and you want to enhance it to improve performance. ...
    on28 May 2013

  • Wiki Page: SQL Server Express: Troubleshoot Installation

    This article contains information on common problems that occur during the installation of SQL Server Express, why they occur and how to resolve them. If you have encountered and resolved a problem that is not listed, or have information to contribute to the resolutions already listed, please edit...
    on14 May 2013

  • Wiki Page: Effective Database Engine Permissions

    This topic describes how to determine who has permissions to various objects in the SQL Server Database Engine. SQL Server implements two permission systems for the Database Engine. An older system of fixed roles has preconfigured permissions. Beginning with SQL Server 2005 a more flexible and precise...
    on9 May 2013

  • Wiki Page: Microsoft SQL Server 2008 SP2 リリース ノート (ja-JP)

    表示言語を変更するには、ここをクリックしてください 。 このリリース ノートでは、慎重で緊密にモニターされています。 何でも編集は 評価して次がすぐ受け入れたり , 改良したり , 元 へ 戻したりすることがあります。これが wiki であるので、コミュニティメンバーは、このリリースノートを 追加 または改良されている可能性があります。 元 の公式リリースノートを読むために、 ここをクリックしてください 。 このリリース ノートでは、SQL Server 2008 のインストールやトラブルシューティングを行う前に知っておく必要がある、既知の問題について説明しています...
    on8 May 2013
Page 1 of 3 (65 items) 123
Can't find it? Write it!

Post an Article