GD Bloggers

This is the blog site for Microsoft Global Delivery Communities focused in sharing the technical knowledge about devices, apps and cloud.
Tags

Browse by Tags

TechNet Blogs » GD Bloggers » All Tags » sql server
Related Posts

  • Blog Post: Moving SharePoint Databases to Another Server (Without Reconfiguring SharePoint)

    Ahmad Shahin
    Introduction Moving / Migrating Microsoft SharePoint Server Databases from one server to another might be difficult as you need to reconfigure all the related DB(s) to point at the new server. This might be acceptable if we are talking about the SharePoint Content Databases, but how about the below...
    on 10 Jun 2014

  • Blog Post: Walkthrough Microsoft SQL Server 2012 Upgrade Advisor

    Ahmad Shahin
    Introduction Migrating Microsoft SQL Server from an older version can be considered as an issue if you didn’t consider the variances between both versions (especially if your Database uses some deprecated features), so how can we detect all these changes between SQL Server versions? One way...
    on 20 Mar 2014

  • Blog Post: What to Consider When Creating SQL Server Database Migration Plan?

    Ahmad Shahin
    Introduction SQL Server Migration is the process of stirring a previous implementation of SQL Server to a newer version, different location (or both) due to a strategic decision (such as SQL Server Consolidation). In this post I’m trying to highlight some of the important aspects that we need...
    on 15 Dec 2013

  • Blog Post: Merge Replication Step by Step

    Mohamed El Ashmawi
    Normal 0 false false false EN-US X-NONE AR-SA ...
    on 6 Jan 2011

  • Blog Post: Creating an Active/Active SQL Cluster using Hyper-V: Part1 Virtualized Storage

    Mohamed M Malek
    Introduction In this series of posts I will walk you through the processes of creating an Active/Active SQL server cluster using Hyper-V and Microsoft iSCSI target software for virtualized SAN. The target is to create first a storage server hosted on a normal Windows 2008 R2 server. Then connect to this...
    on 10 Apr 2012

  • Blog Post: Creating a SQL Server alias using the SQL Server Client Network Utility

    Yousef Omar
    Many think that you have to install the SQL Server client tools to be able to create a SQL Server alias on a client machine. You can do this without installing SQL Server client tools. Windows ships with the SQL Server Client Network Utility. This is all what you need to create an alias. Click run and...
    on 22 Jan 2013

  • Blog Post: SQL Consolidation Planning and recommended practices

    Issa Ayyash
    What is SQL server consolidation it can be defined simply as reduce the number of physical SQL servers, by migrating/moving different SQL databases running on different servers into one high performance server machine. Early in the process of a consolidation project, you will create a profile...
    on 24 Sep 2012

  • Blog Post: Prepare SharePoint Farm – Part 1 Prepare Windows Cluster

    Issa Ayyash
    This part demonstrate how to configure windows cluster for two server, to be used as SQL Cluster. Before you start · You need to have two network adapters on each node, one Public and one Private(for heartbeat communication). · Shared storage (like SAN storage) should be present...
    on 28 May 2012

  • Blog Post: SQL Server Tips & Tricks: Create Bulk Queries

    Mohamed El Ashmawi
    Sometimes you need to build bulk query to select, update or insert data to SQL tables. The selected, updated or inserted data is dynamic and is selected based on data in many tables. An example of this is the following requirement: For each row in a table that belongs to a GUID related to...
    on 10 Apr 2011

  • Blog Post: Cannot Login to SQL Server using administrator account

    Ahmed Nagy
    After installing SQL server on a machine, it happens that you connect or disconnect that machine to domain. WHen you do this, the administrator account can no longer access the database engine. The below steps allow you to regain access to the SQL server... Stop SQL Service: on the command line...
    on 2 Dec 2011

  • Blog Post: What is Microsoft StreamInsight?

    Ahmad Shahin
    Introduction AS I was attending on of the sessions I found an Interesting Microsoft Tool called "Microsoft StreamInsight", so I decided to write this post to provide more information about it and provide general guidelines on it. What is Microsoft StreamInsight? Microsoft StreamInsight™...
    on 30 Jan 2013

  • Blog Post: SQL Server Tips & Tricks: Create Bulk Queries 2

    Mohamed El Ashmawi
    In my previous post, I mentioned that sometimes you need to create dynamic queries for SQL servers and that one of the options is to write queries that dynamically creates the needed queries for you. Although this might seem unclear when describing in words, an example could clarify this point more...
    on 8 May 2011

  • Blog Post: Migration to Fast Search for SharePoint 2010 - General Considerations

    Ahmad Shahin
    I’m currently working on an engagement where the customer is looking for upgrading his current SharePoint 2010 Enterprise Search to Fast Search for SharePoint 2010, but I was wondering if there are any issues that need to be considered during this process. In this post I will highlight some of...
    on 6 May 2012

  • Blog Post: Creating an Active/Active SQL Cluster using Hyper-V: Part4 Configuration Revisited

    Mohamed M Malek
    In part 1 of this series I showed you how to configure the virtual storage required for the cluster. In part 2 of this series I showed you how to configure two SQL instances on the created windows cluster. In part 3 I showed you how to configure these two SQL instances into an Active/Active configuration...
    on 4 Dec 2013

  • Blog Post: Why DPM 2010 and SQL are Better Together?

    Maged Ezzat
    Non-Microsoft backup solutions tend to take generic backup functionality and adapt it to support-specific applications. In contrast, Microsoft created DPM 2010 to leverage fully supported Microsoft technologies in order to provide near-continuous data protection including Windows Server hosts running...
    on 3 Dec 2010

  • Blog Post: Extracting NPS / RADIUS Accounting & Logging Information to SQL Server

    Ahmad Shahin
    Introduction In this post I would like to go through quick steps to configure Network Access Protection to extract data to SQL Server, and describe the minimum settings needed to accomplish this task. This post has been written to reference the following technologies: SQL Server 2008 R2 Microsoft...
    on 26 May 2012

  • Blog Post: SQL Server Cluster Upgrade: Tips for minmizing upgrade downtime and using rolling upgrade

    Ahmed Nagy
    When upgrading to another version of SQL Server, you usually choose one of the following methods... In-Place upgrade: you install the new version of SQL server on the top of an existing installation Side-by-side upgrade: You prepare a new environment (H/W) and move all databases to this new...
    on 14 May 2012

  • Blog Post: SQL Server 2012 Cluster Upgrade error 11004

    Ahmed Nagy
    While upgrading from previous SQL Server versions (2005, 2008 or 2008 R2) to new SQL Server 2012, during setup, you might encounter the following error: "Failed to copy registry settings for SQL Server Network Interfaces from machine 'Cluster Node X' to machine 'LocalMachine'. Error 11004" When...
    on 28 Mar 2012

  • Blog Post: A Crash Course in Optimizing SQL Server for SharePoint

    Yousef Omar
    Do not enable auto-create statistics on a SQL Server that is supporting SharePoint Server To ensure optimal performance, it is recommend that you set max degree of parallelism (MAXDOP) to 1 To improve ease of maintenance, configure SQL Server connection aliases for each database server in your...
    on 2 Dec 2011

  • Blog Post: Useful References – SSRS Logging, Monitoring and Troubleshooting

    Ahmad Shahin
    As I was recently working on SQL Server Reporting Services (SSRS) I complied a list of references that can be used as a quick guidance for SSRS Logging, Monitoring & Troubleshooting. This list includes links and quick description on each link to act as an Index. Hope you will find it useful:  ...
    on 12 Jun 2013

  • Blog Post: Tips & Tricks: SQL Server Mail Configuration

    Mohamed El Ashmawi
    After configuring SQL Server database mail and testing it successfully, you could find maintenance plans unable to send e-mails although you have set the recipients correctly. This is generally due to the setting for the default profile for database mail. Generally, you need to do the following...
    on 22 Feb 2011

  • Blog Post: Creating an Active/Active SQL Cluster using Hyper-V: Part3 the Active/Active Configuration

    Mohamed M Malek
    In part 1 of this series I showed you how to configure the virtual storage required for the cluster. In part 2 of this series I showed you how to configure two SQL instances on the created windows cluster. In this part I will show you how to configure these two SQL instances into an Active/Active configuration...
    on 12 Apr 2012

  • Blog Post: Creating an Active/Active SQL Cluster using Hyper-V: Part2 the Clustered Instances

    Mohamed M Malek
    In part 1 of this series I showed you how to configure the virtual storage required for the cluster. In this part I will show you how to create the SQL cluster as an Active/Passive cluster and in the next part I will show how to convert it to an Active/Active cluster. Introduction In this series of posts...
    on 10 Apr 2012

  • Blog Post: How to configure SQL Database mail to send emails using Office 365 (Exchange Online): A walkthrough

    Mohamed M Malek
    Introduction SQL Server has a feature called database mail. This feature allows the database server to send emails to any external entity using SMTP server. The problem happens if you have installed an on-premise SQL server and an online (Office 365) Exchange server in the cloud. How can you use this...
    on 25 Feb 2013

  • Blog Post: Error after SQL Server 2012 installation: Login Failure for "SQL Server Integration Services 11.0" SSIS service

    Ahmed Nagy
    When you install SQL Server 2012 and you try to connect to SSIS services, you cannot due to that the SSIS service not running. When you manually try to start the SSIS service the service may fail due to login failure of the service account. By Default, SQL Server 2012 tries to use and create the account...
    on 23 Mar 2012