Browse by Tags

Tagged Content List
  • Blog Post: Building your schedule for TechEd 2014? Here are some Storage-related sessions!

    TechEd NorthAmerica 2014 is just a few weeks away and it’s a sold-out event now. If you’re attending and you haven’t yet started building your schedule, you can consider yourself officially late. :-) If you’re focused on Private Cloud Storage and High Availability, let me...
  • Blog Post: Compilation of my live tweets from SNIA’s SDC 2012 (Storage Developer Conference)

    Here is a compilation of my live tweets from SNIA’s SDC 2012 (Storage Developers Conference). You can also read those directly from twitter at http://twitter.com/josebarreto (in reverse order) Notes and disclaimers These tweets were typed during the talks and they include typos and my...
  • Blog Post: Moving your MOSS 2007 databases to a larger drive

    I was doing a small Proof-of-Concept with SharePoint Server 2007, using one server for the database (running SQL Server 2005) and another server for SharePoint Server. The problem is that the SysAdmin that installed SQL Server not only installed it on the C: drive but also let SQL creating new database...
  • Blog Post: SQL Server 2008 Database Mirroring

    Here are some notes on “SQL Server 2008 Database Mirroring” I took while attending an advanced class on SQL Server taught by Greg Low (from http://sqlblog.com/blogs/greg_low/ and http://www.sqldownunder.com/ ). Please note that, although these notes were taken during the class, I might have added...
  • Blog Post: SQL Server 2008 Service Broker

    Here are some notes on “SQL Server 2008 Service Broker” I took while attending an advanced class on SQL Server taught by Greg Low (from http://sqlblog.com/blogs/greg_low/ and http://www.sqldownunder.com/ ). Please note that, although these notes were taken during the class, I might have added some...
  • Blog Post: SQL Training Q&A - 8

    Q) If you set up a database with 3 files, will SQL Server fill the first file before using the other 2 or will it store data in all 3 files right from the beginning? Is it related to the initial size or the growth setting of the file? What if data is deleted? What if it’s three filegroups with one file...
  • Blog Post: Moving a content database from MOSS 2007 Beta 2 TR to RTM

    If you're upgrading your MOSS 2007 (Microsof Office SharePoint Server 2007) from Beta 2 TR to the final RTM release, you probably know you should be following the steps described at http://technet2.microsoft.com/Office/en-us/library/3df597d0-bad0-4c73-9c26-a10bb80449881033.mspx?mfr=true However, if...
  • Blog Post: SQL Server 2008 XML Indexing

    Here are some notes on "SQL Server 2008 XML Indexing" I took while attending an advanced class on SQL Server taught by Adam Machanic ( http://sqlblog.com/blogs/adam_machanic/default.aspx ). Please note that, although these notes were taken during the class, I might have added some of my own (mis)interpretation...
  • Blog Post: SQL Training Q&A - 7

    Q) I noticed in SQL Server Configuration Manager|Network Config|TCP/IP|Properties|IP Address that the SQL server instance grabbed it's own address from DHCP server. What is the advantage of the SQL server using it's own address? How would one make this static rather than dynamic? This TCP/IP configuration...
  • Blog Post: SQL Server 2008 and Unstructured Data

    SQL Server 2008 introduces two new options to store unstructured data, in addition to the current BLOB support we have in SQL Server 2005. IMAGE Back in SQL Server 2000 and SQL Server 7 days, we used the IMAGE data type to store binary large objects (a.k.a. BLOBs). Large, by the way, is defined...
  • Blog Post: 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'\\FSA\SQLDB\Sales.mdf' , SIZE = 2GB...
  • Blog Post: SQL Server 2008 Locking

    Here are some notes on "SQL Server 2008 Locking" I took while attending an advanced class on SQL Server taught by Kimberly Tripp ( http://sqlskills.com/AboutKimberlyLTripp.asp ). Please note that, although these notes were taken during the class, I might have added some of my own (mis)interpretation...
  • Blog Post: SQL Server 2008 Optimize for Ad Hoc Workloads

    SQL Server will create a plan for each batch you execute. If that plan is deemed to be "safe", it's stored in the plan cache for re-use. However, you use a lot of ad hoc queries only once, you will end up with a lot of cached plans that are really never re-used and just waste memory. Considering that...
  • Blog Post: Windows Server 2012 Scale-Out File Server for SQL Server 2012 - Step-by-step Installation

    Outline 1. Introduction 1.1. Overview 1.2. Hardware 1.3. Software 1.4. Notes and disclaimers 2. Install Windows Server 2012 2.1. Preparations 2.2. Install the OS 2.3. Rename the computer 2.4. Enable Remote Desktop 3. Configure the Hyper-V Host 3.1. Install the Hyper-V role to the server 3.2...
  • Blog Post: SQL Server 2008 Tempdb

    Here are some notes on “SQL Server 2008 Tempdb” I took while attending an advanced class on SQL Server taught by Greg Low (from http://sqlblog.com/blogs/greg_low/ and http://www.sqldownunder.com/ ). Please note that, although these notes were taken during the class, I might have added some of my own...
  • Blog Post: The Legend of the Single, Multi-Terabyte, Replicating SharePoint Database

    Documents in Databases The first time I tell anyone that SharePoint Server 2007 stores documents as blobs (binary objects) in the database, people stare at me for a few seconds and usually ask: "Really?" It takes a few moments to explain that this is actually a good thing and that SQL has no problem...
  • Blog Post: SQL Server 2008 Pages

    Here are some notes on "SQL Server 2008 Pages" I took while attending an advanced class on SQL Server taught by Paul Randal ( http://sqlskills.com/AboutPaulSRandal.asp ). Please note that, although these notes were taken during the class, I might have added some of my own (mis)interpretation :-)....
  • Blog Post: SQL Server 2008 Auditing

    Here are some notes on “SQL Server 2008 Auditing” I took while attending an advanced class on SQL Server taught by Greg Low (from http://sqlblog.com/blogs/greg_low/ and http://www.sqldownunder.com/ ). Please note that, although these notes were taken during the class, I might have added some of my...
  • Blog Post: SQL Server 2008 Fragmentation

    Here are some notes on "SQL Server 2008 Fragmentation" I took while attending an advanced class on SQL Server taught by Paul Randal http://sqlskills.com/AboutPaulSRandal.asp ). Please note that, although these notes were taken during the class, I might have added some of my own (mis)interpretation...
  • Blog Post: SQL Server 2008 Partitioning

    Here are some notes on "SQL Server 2008 Partitioning" I took while attending an advanced class on SQL Server taught by Kimberly Tripp ( http://sqlskills.com/AboutKimberlyLTripp.asp ). Please note that, although these notes were taken during the class, I might have added some of my own (mis)interpretation...
  • Blog Post: SQL Server 2008 Graphical Execution Plans

    I'm attending a SQL training and looking at indexing closely. One thing that becomes important is understanding how SQL executes queries. Understanding the graphical execution plans becomes extremely important. While looking for a good reference, I found it in books online: Graphical Execution Plan...
  • Blog Post: SQL Server Remote Blob Store (RBS) available as part of the Feature Pack RC0 for Microsoft SQL Server 2008

    As I mentioned in a previous blog post at http://blogs.technet.com/josebda/archive/2008/03/17/sql-server-2008-and-unstructured-data.aspx , SQL Server 2008 introduces new options to store unstructured data, in addition to the current BLOB support we have in SQL Server 2005. One of those options is...
  • Blog Post: SQL Server 2008 Storage

    Here are some notes on “SQL Server 2008 Storage” I took while attending an advanced class on SQL Server taught by Greg Low (from http://sqlblog.com/blogs/greg_low/ and http://www.sqldownunder.com/ ). Please note that, although these notes were taken during the class, I might have added some of my...
  • Blog Post: SQL Server 2008 Merge

    Here are some notes on "SQL Server 2008 Merge" I took while attending an advanced class on SQL Server taught by Paul Nielsen (from http://www.sqlserverbible.com/ ). Please note that, although these notes were taken during the class, I might have added some of my own (mis)interpretation :-). Always...
  • Blog Post: SQL Server 2008 Data Compression

    SQL Server 2008 introduced a new feature to compress data stored in tables, indexes and indexed views. It basically uses a few different techniques to save space when storing data. You can set compression to NONE, ROW or PAGE (page includes ROW-level compression). There are a lot of small details...