GD Bloggers

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

Browse by Tags

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

    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...
  • Blog Post: Walkthrough Microsoft SQL Server 2012 Upgrade Advisor

    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...
  • Blog Post: What to Consider When Creating SQL Server Database Migration Plan?

    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...
  • Blog Post: Merge Replication Step by Step

    Normal 0 false false false EN-US X-NONE AR-SA ...
  • Blog Post: Creating an Active/Active SQL Cluster using Hyper-V: Part1 Virtualized Storage

    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...
  • Blog Post: Creating a SQL Server alias using the SQL Server Client Network Utility

    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...
  • Blog Post: SQL Consolidation Planning and recommended practices

    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...
  • Blog Post: Prepare SharePoint Farm – Part 1 Prepare Windows Cluster

    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...
  • Blog Post: SQL Server Tips & Tricks: Create Bulk Queries

    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...
  • Blog Post: Cannot Login to SQL Server using administrator account

    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...
  • Blog Post: What is Microsoft StreamInsight?

    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™...
  • Blog Post: SQL Server Tips & Tricks: Create Bulk Queries 2

    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...
  • Blog Post: Migration to Fast Search for SharePoint 2010 - General Considerations

    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...
  • Blog Post: Creating an Active/Active SQL Cluster using Hyper-V: Part4 Configuration Revisited

    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...
  • Blog Post: Why DPM 2010 and SQL are Better Together?

    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...
  • Blog Post: Extracting NPS / RADIUS Accounting & Logging Information to SQL Server

    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...
  • Blog Post: SQL Server Cluster Upgrade: Tips for minmizing upgrade downtime and using rolling upgrade

    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...
  • Blog Post: SQL Server 2012 Cluster Upgrade error 11004

    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...
  • Blog Post: A Crash Course in Optimizing SQL Server for SharePoint

    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...
  • Blog Post: Useful References – SSRS Logging, Monitoring and Troubleshooting

    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:  ...
  • Blog Post: Tips & Tricks: SQL Server Mail Configuration

    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...
  • Blog Post: Creating an Active/Active SQL Cluster using Hyper-V: Part3 the Active/Active Configuration

    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...
  • Blog Post: Creating an Active/Active SQL Cluster using Hyper-V: Part2 the Clustered Instances

    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...
  • Blog Post: How to configure SQL Database mail to send emails using Office 365 (Exchange Online): A walkthrough

    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...
  • Blog Post: Error after SQL Server 2012 installation: Login Failure for "SQL Server Integration Services 11.0" SSIS service

    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...