Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server   (RSS)

SQL Server Remote Blob Store (RBS) available as part of the Feature Pack RC0 for Microsoft SQL Server 2008

As I mentioned in a previous blog post at http://blogs.technet.com/josebda/archive/2008/03/17/sql-server-2008-and-unstructured-data.aspx , SQL Server 2008 introduces new options to store unstructured data, in addition to the current BLOB support we have Read More...
Posted Tuesday, July 29, 2008 7:20 AM by josebda | 1 Comments
Filed under: ,

SQL Server 2008 and Unstructured Data

SQL Server 2008 introduces two new options to store unstructured data, in addition to the current BLOB support we have in SQL Server 2005. IMAGE Back in SQL Server 2000 and SQL Server 7 days, we used the IMAGE data type to store binary large objects (a.k.a. Read More...
Posted Monday, March 17, 2008 12:20 PM by josebda | 3 Comments
Filed under: ,

The Legend of the Single, Multi-Terabyte, Replicating SharePoint Database

Documents in Databases The first time I tell anyone that SharePoint Server 2007 stores documents as blobs (binary objects) in the database, people stare at me for a few seconds and usually ask: "Really?" It takes a few moments to explain that this is Read More...
Posted Thursday, October 25, 2007 9:20 PM by josebda | 1 Comments

Configuring SQL Server 2005 Database Mirroring (includes 8-minute demonstration)

SQL Server 2005 Database Mirroring is a high availability feature that maintains a duplicate copy of a database (close by or across the globe), keeps it up to date (synchronously or asynchronously) and can even provide automatic failover. There are other Read More...
Posted Friday, August 10, 2007 11:26 AM by josebda | 1 Comments
Filed under: ,

Misleading error 1418 message in SQL Server Database Mirroring

While setting up a four-server database mirroring environment (one domain controller, two partner SQL Servers, one witness SQL Server), I ran across a misleading error message. The whole process for setting up a database mirror is fairly easy, if you Read More...
Posted Monday, June 11, 2007 3:01 PM by josebda | 1 Comments
Filed under:

Moving a content database from MOSS 2007 Beta 2 TR to RTM

If you're upgrading your MOSS 2007 (Microsof Office SharePoint Server 2007) from Beta 2 TR to the final RTM release, you probably know you should be following the steps described at http://technet2.microsoft.com/Office/en-us/library/3df597d0-bad0-4c73-9c26-a10bb80449881033.mspx?mfr=true Read More...
Posted Tuesday, December 05, 2006 5:27 PM by josebda | 0 Comments
Filed under: ,

Moving your MOSS 2007 databases to a larger drive

I was doing a small Proof-of-Concept with SharePoint Server 2007, using one server for the database (running SQL Server 2005) and another server for SharePoint Server. The problem is that the SysAdmin that installed SQL Server not only installed it on Read More...
Posted Tuesday, September 05, 2006 3:17 PM by josebda | 0 Comments
Filed under: ,

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: ,

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: ,
More Posts Next page »
 
Page view tracker