Browse by Tags

Tagged Content List
  • Blog Post: SQL Server 2008 Database Snapshots

    Here are some notes on “SQL Server 2008 Database Snapshots” 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 Database Compression

    Here are some notes on “SQL Server 2008 Database Compression” 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 Transactional Replication

    Here are some notes on “SQL Server 2008 Transactional Replication” 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...
  • Blog Post: SQL Server 2008 Failover Clustering

    Here are some notes on “SQL Server 2008 Failover Clustering” 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: Book Chapter on Improving SQL Server Performance

    I stumbled upon a great document on how to improve SQL Server performance. It's actually a chapther in a book on "Improving .NET Application Performance and Scalability" from a "Patterns and Practices" prescriptive guidance. Here's a summary of what it covers: SQL: Scale Up vs. Scale Out ...
  • Blog Post: 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...
  • Blog Post: SQL Server 2008 Change Tracking (CT) and Change Data Capture (CDC)

    Here are some notes on "SQL Server 2008 Change Tracking (CT) and Change Data Capture (CDC)" 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...
  • Blog Post: SQL Server 2008 Replication

    Here are some notes on “SQL Server 2008 Replication Overview” 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 Statistics

    Here are some notes on "SQL Server 2008 Statistics" 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 Resource Governor

    Here are some notes on “SQL Server 2008 Resource Governor” 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: Maintaining your MOSS 2007 SQL Databases

    If you're running Microsoft Office SharePoint Server 2007 (MOSS 2007), your're also running a SQL Server, hopefully the 2005 version to get the best performance. MOSS will be creating all your databases for your, so you might thing you should not worry about maintaining those databases, right? Not really...
  • Blog Post: SQL Server 2008 Transparent Data Encryption (TDE)

    Here are some notes on “SQL Server 2008 Transparent Data Encryption (TDE)” 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...
  • Blog Post: SNIA’s Storage Developers Conference 2012 is just a few weeks away

    The Storage Networking Industry Association (SNIA) is hosting the 9th Storage Developer Conference (SDC) in the Hyatt Regency in beautiful Santa Clara, CA (Silicon Valley) on the week of September 17th. As usual, Microsoft is underwriting the SMB/SMB2/SMB3 Plugfest, which is co-located with the SDC event...
  • Blog Post: SQL Server 2008 File-related Optimizations

    While attending training today, I learned some file-related optimizations for SQL Server 2008. Some of those will also apply to previous versions of SQL Server. 1) No performance gain in multiple log files There is a common misconception that having multiple log files per database would help performance...
  • Blog Post: SQL Server 2008 Indexing Best Practices

    Here are some additional notes on "SQL Server 2008 Indexing Best Practices" 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...
  • Blog Post: 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. ...
  • Blog Post: Steps to configure a basic MOSS 2007 farm

    I’m working on a step-by-step procedure to install Microsoft Office SharePoint Server 2007 Beta 2 (MOSS 2007), to allow my customer to create their environment by themselves. The main difficulty they have right now is the exact sequence to follow to get a basic infrastructure for team collaboration with...
  • Blog Post: File Server team sessions at TechEd 2012 North America available for streaming/download

    We had a great time showing Windows Server 2012 at TechEd North America and I wanted to share that the recording for our team’s sessions are now publicly available. That includes our sessions on SMB 3.0 and a number of demos, many of them using one of the Cluster-in-box configurations we were...
  • Blog Post: SQLIO, PowerShell and storage performance: measuring IOPs, throughput and latency for both local disks and SMB file shares

    1. Introduction I have been doing storage-related demos and publishing blogs with some storage performance numbers for a while, and I commonly get questions such as “How do you run these tests?” or “What tools do you use to generate IOs for your demos?”. While it’s...
  • Blog Post: 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 the list below in...
  • Blog Post: SQL Server 2008 New Date and Time Types

    Here are some notes on "SQL Server 2008 New Date and Time Types" 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...
  • Blog Post: SQL Server 2008 Database Checking

    Here are some notes on "SQL Server 2008 Database Checking" 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 Backup and Restore

    Here are some notes on "SQL Server 2008 Backup and Restore" 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: Proud to be a Microsoft Certified Master: Microsoft SQL Server 2008

    Earlier this year (or last fiscal year :-), I participated in a grueling three-week training and passed four exams (one of them a lab exam) to become one of just a dozen Microsoft Certified Masters on SQL Server 2008 worldwide. This was certainly the most demanding IT certification I ever attempted...
  • Blog Post: SQL Server 2008 Integration Services (SSIS)

    Here are some notes on “SQL Server 2008 Integration Services (SSIS)” 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...