Windows Server 2012 and SMB 3.0 demos at TechEd showcase File Server with multiple storage configurations and technologies

1. Introduction We recently had our TechEd North America event and all sessìon slides and recordings are now publicly available (links are provided below). We’re also getting ready to deliver our TechEd Europe talks this week. With hundreds of talks to attend and/or review, it will probably be a few weeks or maybe months before…


Windows Server 2012 Beta Scale-Out File Server for SQL Server 2012 – Step-by-step Installation

IMPORTANT: This blog post is now obsolete. For the latest version of this content, please visit:http://blogs.technet.com/b/josebda/archive/2012/08/23/windows-server-2012-scale-out-file-server-for-sql-server-2012-step-by-step-installation.aspx     1. Introduction 1.1. Overview In this document, I am sharing all the steps I used to create a Windows Server 2012 Beta demo, so you can experiment with some of the new technologies yourself. You only need…

8

SNIA’s Storage Developer Conference – SDC 2011 content (slides and videos) now available for download, including SMB 2.2 details

The Storage Networking Industry Association (SNIA) hosted the 8th Storage Developer Conference (SDC) in the Hyatt Regency in beautiful Santa Clara, CA (Silicon Valley) earlier this year. As usual, Microsoft was the underwriter of the CIFS/SMB/SMB2 PlugFest, which was co-located with the SDC event. For developers working with storage-related technologies, this event gathers a unique…


TechEd 2011 demo install step-by-step (Hyper-V, AD, DNS, iSCSI Target, File Server Cluster, SQL Server over SMB2)

1. Introduction 1.1. Overview As I explained in a previous blog post, I delivered a presentation this week as part of the Microsoft TechEd 2011 event. The presentation was titled “Windows Server 2008 R2 File Services Consolidation – Technology Update”. It included two demos that showed several Windows Server 2008 R2 features and also a…

4

SQL over SMB2 – One of the top 10 hidden gems in SQL Server 2008 R2

Introduction  The SQL CAT team has posted a blog last year about the “Top 10 hidden gems in SQL Server 2008 R2”, which included the support for placing SQL database files on an SMB network file share. This works even better if you use the SMB2 version of the protocol, which is included in Windows…

1

Great SQL Server Storage advice from a team deploying SQL with LOB apps

During an internal conference this week I came across a group at Microsoft Services that works directly with customers that are deploying SQL Server to support line-of-business applications like like SAP and JD Edwards. They pointed me to their recent blog (started in September 2010) which already produced excellent technical and business content. Out of…

1

Simple SQL Server script to create a database and generate activity for a demo

I am doing a little demo this week and it includes a simple SQL Server script to generate activity on the network while I demo SMB2 durability. First, the database is created: USE [Master]GO CREATE DATABASE [Sales] ON  PRIMARY ( NAME = N’Sales’, FILENAME = N’\FSASQLDBSales.mdf’ ,   SIZE = 2GB , MAXSIZE = 8GB, FILEGROWTH = 1GB…

2

SQL Server 2008 R2 Enterprise Evaluation November CTP available for MSDN/TechNet Subscribers

Great news following a very busy week for SQL Server with the PASS Community Summit: The new SQL Server 2008 R2 November CTP is now available for MSDN and TechNet subscribers.This download is expected to be available as a general download in a couple of days. Title: SQL Server 2008 R2 Enterprise Evaluation November CTP (x86,…


Scary SQL Server stuff: tombstones, phantoms, blobs, ghosts and zombies

This post mixes the spirit of Halloween and the passion for SQL Server 🙂   Have you noticed how SQL Server has a number of things that seem right out of a horror movie? As a test of your SQL Server expertise and for a fun Halloween trivia game, try to describe the items in…