Browse by Tags

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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