Browse by Tags

Tagged Content List
  • Blog Post: Big Data - A Microsoft Tools Approach

    (As with all of these types of posts, check the date of the latest update I’ve made here. Anything older than 6 months is probably out of date, given the speed with which we release new features into Windows and SQL Azure) I don’t normally like to discuss things in terms of tools. I find...
  • Blog Post: Using Perfmon with SQL Server – Part One

    I held a workshop on performance tuning in Portland, Oregon yesterday, and as part of that I mentioned a process I follow for automatically collecting Performance Monitor Counters for a system. I use this data to store a baseline and then subsequently to have a reference set of data to compare with....
  • Blog Post: Free Hyper-V Book

    I work with a gentleman here in the Pacific Northwest who joined the Microsoft Server team from VMWare, and he in turn has a good friend (John Kelbley) who wrote a book on Hyper-V that you can get for free –  you can get it here: http://www.netapp.com/hyperv
  • Blog Post: SQL Server Best Practices: Set a Fixed Memory Size

    SQL Server allows you to set a “bottom” and “top” range for memory that the Instance will use. The memory will dynamically expand and contract based on Instance need and system pressure. But this flexibility and ease of configuration can (not always, mind you) come at a cost. While there are some caveats...
  • Blog Post: Remember to include the Standard Deviation

    I do a lot of performance analysis on SQL Server Instances, and I normally start with a series of Performance Counters from both Windows and SQL Server. This gives me the ability to limit what I need to look at by seeing which Hardware and Windows components (and SQL Server-specific  features, such...
  • Blog Post: Book Review – Windows Server 2008 How To

    In the past couple of weeks I’ve posted some articles on how to tune a Windows system for SQL Server. Microsoft SQL Server DBA’s are a bit different than a DBA on, say, a mainframe, because we also have to know the operating system we run on pretty well. In fact, most of the DBA’s I work with can install...
  • Blog Post: How Microsoft Does IT

    One of my favorite ways to learn is through examples. If you’ll explain what something does and a little of how it works,and then give me an example to decompose, I usually come up to speed pretty quickly. I’ve been carrying a DVD (and CD’s before that) in my laptop bag for years from Microsoft (way...
  • Blog Post: Opening a Windows Perfmon File in Profiler – Part Two

    In a previous blog entry , I mentioned you could import a Windows Perfmon log into SQL Server Profiler. I received a note that someone was having a problem doing this, and when we looked over his situation, it turned out that he was using a Windows Perfmon binary log, a SQL Server 2008 trace file - and...
  • Blog Post: Using Perfmon Data in Profiler

    In SQL Server 2005 a great new feature was introduced into SQL Server Profiler – the ability to import Perfmon data. If you’re not familiar with one or both of those tools, SQL Server Profiler is a package included with SQL Server that can “watch” your system’s activities. You add these activities into...
  • Blog Post: SQL Server Best Practices: Disk Partition Alignment

    OK - this one is a little more involved than the other best practices I've posted here. In fact, I'm going to have to send you off to another document at the end of this post to explain the technical background and the exact steps you need to perform, but I still wanted to bring the topic up here for...
  • Blog Post: Should I stay or Should I Go?

    I'm writing this post on a bus headed towards the Seattle Convention Center, where the technical folks in the field meet once a year to hear from the product teams about all the new features coming in the future. I used to present at this conference (and in fact I still do), but today I'll be attending...
  • Blog Post: Windows 2008 and Replication

    I mentioned in a previous post that I would point out where SQL Server 2008 takes advantage of improvments in Windows 2008 (Check out the "Windows 2008" tag below for that). I just had to share something I got today from the replication team in an e-mail: "Windows Server 2008 includes a new networking...
  • Blog Post: Windows 2008 Terminal services and SQL SSMS

    One of our Principal Architects, Eddy Bell, shared a great writeup with me that I think is a great way to leverage Windows 2008 and SQL Server 2008. It answers a need that I've seen over and over again - the ability to connect to SQL Server Management Studio at the server, rather than running it locally...
Page 1 of 1 (13 items)