Blog - Title

July, 2006

  • 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...
  • 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...
  • Processess running on a MOSS 2007 Beta 2 box

    I configured a Microsoft Office SharePoint Server 2007 Beta 2 (MOSS 2007) server and I was trying to better understand the processes that run on it. I used two computers, one running all WSS/MOSS services and the other running AD and SQL. The WSS/MOSS...
  • 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...
  • Two more exams...

    I am happy to share that I used the free exam offering during an internal Microsoft conference and passed two of the new SQL Server 2005 exams released last February: Exam 70–431: TS: Microsoft SQL Server 2005 - Implementation and Maintenance ...
  • SQL Training Q&A - 1

    Q) For the SQL Server 2005 training, should we use SQL Server Standard or SQL Server Enterprise? There are a few differences between what's available in each version of SQL Server 2005. You can find a nice comparision at: http://www.microsoft.com...
  • SQL Training Q&A - 4

    Q) How do you know if an instance of SQL Server 2005 has been upgraded to SP1 and what do you do to assure all SQL Server Services are shut down prior to installing the service pack? I attempted to install SP1 and got some lock violations and kept shutting...
  • 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...
  • SQL Training Q&A - 3

    Q) I specified the SQL Server service to run under LocalSystem, but noticed a domain user account is recommended. Can you talk more about best practices? Does the service run as its own user in its own group? Does it belong in the Administrators group...
  • SQL Training Q&A - 2

    Q) When installing SQL Server 2005, do people just accept the collation defaults? Is collation a big decision? This setting will define, for instance, if SQL will consider lowercase different from uppercase or if characters will accents will be considered...
  • SQL Training Q&A - 6

    Q) Is there a good reason for having more than just a single (default) instance of SQL Server on a server? Does there have to be a default instance or can you just have named instances? Can you later change which instance of SQL Server is the default...
  • Tips for Excel Services Beta 2

    I just wanted to share some things that I learned while implementing a proof of concept on Microsoft Office SharePoint Services (MOSS) 2007 beta 2 and more specifically regarding the Excel Services feature. First of all, if you got the beta for MOSS...
  • SQL Training Q&A - 5

    Q) In connectionstrings I often see server=localhost. Where is this "localhost" name coming from? Is it in a file somewhere? Is it true that the server must be using TCP/IP for this to work? I also see server=. and server=(local) in connection strings...