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 Server … Continue reading SQL over SMB2 – One of the top 10 hidden gems in SQL Server 2008 R2
Blog
New white paper providing guidance for sizing NTFS volumes
A new white paper covering "NTFS CHKDSK Best Practices and Performance" was posted today at microsoft.com/downloads, covering the CHKDSK improvement in Windows 7 and Windows Server 2008 R2. This was first highlighted in a blog post by Claus Joergensen in the Filecab blog. Claus mentioned: "Today, Microsoft released a new white paper discussing best practices … Continue reading New white paper providing guidance for sizing NTFS volumes
Ranking the SMB rules in the File Services Best Practices Analyzer tool (BPA)
As you probably know, the File Services team provides a Best Practices Analyzer tool (BPA). It includes several rules for the configuration, operation, performance and security of the SMB, NFS, DFS-N, DFS-R and FSRM.I was recently looking at the pageview statistics for each of the rules for the SMB component and found how how the … Continue reading Ranking the SMB rules in the File Services Best Practices Analyzer tool (BPA)
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 … Continue reading Great SQL Server Storage advice from a team deploying SQL with LOB apps
New white paper: Windows Storage Server 2008 R2 Architecture and Deployment
A new white paper about Windows Storage Server 2008 R2 Architecture and Deployment (including the Microsoft iSCSI Software Target 3.3) has just been published. Here's an outline of this content: Introduction Windows Storage Server 2008 R2 Overview Comparing Windows Server Operating System Storage Offerings Comparing Windows Storage Server with Windows Server Identifying Windows Storage Server … Continue reading New white paper: Windows Storage Server 2008 R2 Architecture and Deployment
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 … Continue reading Simple SQL Server script to create a database and generate activity for a demo
Currently available hotfixes for SMB and SMB2 File Server components in Windows Server 2008 and Windows Server 2008 R2
If you’re installing a Windows Server 2008 or Windows Server 2008 R2 file server, we always recommend getting the latest hotfixes from Windows Update. That will include all security updates and updates that are considered important enough to be delivered to all Windows Server users. However, there is a class of hotfixes there not pushed … Continue reading Currently available hotfixes for SMB and SMB2 File Server components in Windows Server 2008 and Windows Server 2008 R2
Programming Windows Phone 7 by Charles Petzold – Download free PDF and start developing your WP7 Apps
I just discovered this interesting book on "Programming Windows Phone 7", by Charles Petzold (yes, that's the author of the famous "Programming Windows" series of books). This Microsoft Press title is available as a free PDF download and is over 1,000 pages long. Here's the table of contents: Part 1: The Basics Chapter 1: Hello, … Continue reading Programming Windows Phone 7 by Charles Petzold – Download free PDF and start developing your WP7 Apps
Lessons learned creating BingMatrix in ASP.NET and Azure (goals, http requests, threads, progress message and postbacks)
I have spent my last few weekends building an ASP.NET web application that sends multiple queries to Bing and displays the results in a table. I called it BingMatrix and you can read more about what it does and how it works in the blog post titled “BingMatrix – A Windows Azure application that provides … Continue reading Lessons learned creating BingMatrix in ASP.NET and Azure (goals, http requests, threads, progress message and postbacks)
BingMatrix – A Windows Azure application that provides a fun way to mine data from Bing
I wanted to share a little application I put together using Windows Azure. It uses Bing queries to find out how the popularity of a specific set of keywords on a specific set of sites. I actually created this for my own use while researching how frequently some registry keys are mentioned on Microsoft support, … Continue reading BingMatrix – A Windows Azure application that provides a fun way to mine data from Bing
Jose Barreto's Blog 