Welcome to TechNet Blogs Sign in | Join | Help

July 2006 - Posts

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 Read More...
Posted Monday, July 31, 2006 10:17 PM by josebda | 3 Comments
Filed under: ,

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 Read More...
Posted Saturday, July 29, 2006 10:30 PM by josebda | 1 Comments
Filed under: ,

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 Read More...
Posted Saturday, July 29, 2006 10:24 PM by josebda | 1 Comments
Filed under:

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, Read More...
Posted Friday, July 28, 2006 5:57 PM by josebda | 0 Comments
Filed under: ,

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 Exam 70–447: Read More...
Posted Thursday, July 27, 2006 4:47 PM by josebda | 0 Comments
Filed under:

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 Read More...
Posted Monday, July 24, 2006 5:14 PM by josebda | 0 Comments
Filed under: ,

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 Read More...
Posted Monday, July 24, 2006 5:02 PM by josebda | 0 Comments
Filed under: ,

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 Read More...
Posted Monday, July 24, 2006 6:01 AM by josebda | 0 Comments
Filed under: ,

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. Read More...
Posted Sunday, July 23, 2006 10:03 PM by josebda | 0 Comments
Filed under: ,

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 Read More...
Posted Sunday, July 23, 2006 9:55 PM by josebda | 0 Comments
Filed under: ,

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? Read More...
Posted Sunday, July 23, 2006 9:43 PM by josebda | 0 Comments
Filed under: ,

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 Read More...
Posted Sunday, July 23, 2006 9:26 PM by josebda | 0 Comments
Filed under: ,

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/prodinfo/features/compare-features.mspx Read More...
Posted Sunday, July 23, 2006 9:12 PM by josebda | 0 Comments
Filed under: ,
 
Page view tracker